(word完整版)Oracle-EBS-R12-客户表结构.doc

(word完整版)OracleEBSR12客户表结构
(word完整版)OracleEBSR12客户表结构
(word完整版)OracleEBSR12客户表结构

R12客户表结构
客户表/联系人/PARTY关联HZ_PARTIES客户账户表HZ_CUST_ACCOUNTS例子：SELECThp.party_number—-客户注册标识,hp。party_name-—组织名/客户,hp.known_as——别名，hp.organization_name_phonetic—-名称拼音,acc。account_number-—帐号,flv_sale。meaningsales_channel_code-—销售渠道,acc。account_name—-账记说明,flv_customer。meaningcustomer_class_code——分类,acc.orig_system_reference——参考,flv_status。meaningstatus——状态，flv_type.meaningcustomer_type—-账户类型,acc。attribute_category--上下文,acc。attribute1——注册，acc.attribute2—-人员推广，acc。attribute3——特殊要求，acc.Attribute4-—发货单是否打印价格,acc.Attribute5——所属利润FROMhz_partieshp，hz_cust_accountsacc，fnd_lookup_valuesflv_sale——销售渠道,fnd_lookup_valuesflv_customer--分类,fnd_lookup_valuesflv_status—-状态,fnd_lookup_valuesflv_type——账户类型WHEREhp。party_id=acc。party_idANDacc。sales_channel_code=flv_sale。lookup_codeANDflv_sale。lookup_type=’SALES_CHANNEL’ANDflv_sale.LANGUAGE=userenv（’LANG'）ANDacc.customer_class_code=flv_customer。lookup_codeANDflv_customer。lookup_type=’CUSTOMERCLASS'ANDflv_customer。LANGUAGE=userenv('LANG')ANDacc。status=flv_status.lookup_codeANDflv_status.lookup_type=’HZ_CPUI_REGISTRY_STATUS'ANDflv_status.LANGUAGE=userenv（'LANG’)ANDacc.customer_type=flv_type。lookup_codeANDflv_type。lookup_type='CUSTOMER_TYPE'ANDflv_type。LANGUAGE=userenv('LANG’）ANDhp.party_id=hz_parties。party_id;帐户配置文件HZ_CUSTOMER_PROFILES字段cust_account_role_id-—oe_order_headers。sold_to_contract_idcust_account_idsite_use_id—-客户头的该字段为空--客户地点层为hz_cust_site_uses_all.site_use_id配置文件金额HZ_CUST_PROFILE_AMTS--客户头层/客户地点层关联：hz_customer_profiles.cust_account_profile_id客户联系人HZ_CUST_ACCOUNT_ROLES——客户头层/地点层cust_account_idcust_acct_site_id--头层该字段为空party_id--类型为PARTY_RELATIONSHIP的PARTY_IDrole_type--CONTACT以头层的联系人为例SELECThp_per.*FROMhz_cust_account_rolesrol,hz_partieshp_rel，hz_relationshipsrel,hz_partieshp_perWHERErol.party_id=hp_rel。party_idANDhp_rel。party_id=rel.party_idANDrel.object_type=’PERSON'ANDrel.relationship_code=’CONTACT'ANDrel。object_id=hp_per。party_idANDrol。cust_acct_site_