EBS Reference
Customers (TCA)
The trading community model — parties, customer accounts, and sites — that order and receivables records resolve to
6 tables
Tables
Master · 6
- HZ_CUST_ACCOUNTSThe customer account — the commercial relationship layered over a party, and the id order headers actually carry as SOLD_TO_ORG_ID; one party, many accountsSchema: ARmaster
- HZ_CUST_ACCT_SITES_ALLCustomer account sites — one row binding an account to a party site (address) within one operating unit, with the bill-to/ship-to capability flagsSchema: ARmaster
- HZ_CUST_SITE_USES_ALLSite business purposes — one row per use (ship-to, bill-to, statements…) of an account site per operating unit; the SITE_USE_ID here is what order headers carry as SHIP_TO_ORG_ID and INVOICE_TO_ORG_IDSchema: ARmaster
- HZ_LOCATIONSThe physical address master — pure address rows with no party context; one location can serve many parties, customer sites, and supplier sitesSchema: ARmaster
- HZ_PARTIESThe trading-community party master — one row per person, organization, or group before any commercial context; customers AND suppliers resolve back to a party hereSchema: ARmaster
- HZ_PARTY_SITESParty sites — the reusable link from a party to a location, carrying the site number and the identifying-address flag; both customer account sites and supplier sites resolve their address through hereSchema: ARmaster