EBS 客户表结构



客户表/联系人/PARTY关联
HZ_PARTIES

客户账户表
HZ_CUST_ACCOUNTS

SELECT hp.party_number --客户注册标识
, hp.party_name --组织名/客户
, hp.known_as --别名
, hp.organization_name_phonetic --名称拼音
, acc.account_number --帐号
, flv_sale.meaning sales_channel_code --销售渠道
, acc.account_name --账记说明
, flv_customer.meaning customer_class_code --分类
, acc.orig_system_reference --参考
, flv_status.meaning status --状态
, flv_type.meaning customer_type --账户类型
, acc.attribute_category --上下文
, acc.attribute1 --注册
, acc.attribute2 --人员推广
, acc.attribute3 --特殊要求
, acc.Attribute4 --发货单是否打印价格
, acc.Attribute5 --所属利润
FROM hz_parties hp
, hz_cust_accounts acc
, fnd_lookup_values flv_sale --销售渠道
, fnd_lookup_values flv_customer --分类
, fnd_lookup_values flv_status --状态
, fnd_lookup_values flv_type --账户类型
WHERE hp.party_id = acc.party_id
AND acc.sales_channel_code = flv_sale.lookup_code
AND flv_sale.lookup_type = 'SALES_CHANNEL'
AND flv_sale.LANGUAGE = userenv('LANG')
AND acc.customer_class_code = flv_customer.lookup_code
AND flv_customer.lookup_type = 'CUSTOMER CLASS'
AND flv_customer.LANGUAGE = userenv('LANG')
AND acc.status = flv_status.lookup_code
AND flv_status.lookup_type = 'HZ_CPUI_REGISTRY_STATUS'
AND flv_status.LANGUAGE = userenv('LANG')
AND acc.customer_type = flv_type.lookup_code
AND flv_type.lookup_type = 'CUSTOMER_TYP