Fusion Reference
Customers (TCA)
The trading community model — parties, customer accounts, and sites — that order and receivables records resolve to
6 tables
Extraction map
The BICC extract data store (PVO) reaching each of this module’s tables — the bulk path out of the SaaS database. Full details, OTBI subject areas, and provenance links live on each table page.
| Table | BICC extract data store (PVO) |
|---|---|
| HZ_CUST_ACCOUNTS | CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.CustomerAccountExtractPVO |
| HZ_CUST_ACCT_SITES_ALL | CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.CustomerAccountSiteExtractPVO |
| HZ_CUST_SITE_USES_ALL | CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.CustomerAcctSiteUseExtractPVO |
| HZ_LOCATIONS | CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.LocationExtractPVO |
| HZ_PARTIES | CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.PartyExtractPVO |
| HZ_PARTY_SITES | CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.PartySiteExtractPVO |
Tables
Master · 6
- HZ_CUST_ACCOUNTSThe customer account — the commercial (selling) relationship layered on a party; one party can carry several accounts, each with its own account number, status, and typeProduct: HZmaster
- HZ_CUST_ACCT_SITES_ALLCustomer account sites — an account's use of a party site (address); the layer order and invoice addresses hang off, with bill-to/ship-to/market purpose flagsProduct: HZmaster
- HZ_CUST_SITE_USES_ALLSite uses — the business purposes (bill-to, ship-to, statements) assigned to each customer account site; the bottom TCA layer, and the id AR transactions actually point atProduct: HZmaster
- HZ_LOCATIONSThe location master — the physical postal address itself (street, city, postal code, country, coordinates), shared by every party and account site that points at itProduct: HZmaster
- HZ_PARTIESThe party master — one row per person, organization, or group in the trading community, with the party number, type, status, and a denormalized identifying address and primary contact point; the top of the four-layer customer modelProduct: HZmaster
- HZ_PARTY_SITESParty sites — the link between a party and a location, carrying the site number, name, addressee, and mailstop; one party can have many sites and one location can serve many partiesProduct: HZmaster