Table: PO_LOCATION_ASSOCIATIONS_ALL

来源:互联网 发布:淘宝老七家 编辑:程序博客网 时间:2024/06/06 04:05
PO_LOCATION_ASSOCIATIONS associates a location defined within an organization with an Oracle Receivables customer. For each organization, you need one row for each association you want to make between a location and a customer.
.

You define location associations using the Business Purposes region of the Customer Addresses window. You first pick the customer along with a customer site and then enter the location and organization that you want to create an association with.

This location is used to determine which customer and bill to/ship to site to be used in the ISO from the IPR destination Organization/Location.

NameReferenceLocation_idhr_locations_all.location_idCustomer_idhz_cust_accounts_all.cust_account_idAddress_idhz_cust_acct_sites_all.cust_acct_site_idsite_use_idhz_cust_site_uses_all.site_use_idOrganization_idorg_organization_definitions.organization_id

Please remind that there is a column named "org_id" in this table, and the primary key is "SITE_USE_ID, LOCATION_ID, ORG_ID", cause the customer site is security by OU. 

原创粉丝点击