Oracle Fusion/Financials/Customers

HZ_CUST_ACCT_SITES_ALL

Links a customer account to one of its party's sites, making that address usable for that specific account.

Key Columns

CUST_ACCT_SITE_IDCUST_ACCOUNT_IDPARTY_SITE_ID

Parent Table

HZ_CUST_ACCOUNTS

Customer account — the transactable 'customer' entity AR and Order Management actually bill and ship to, layered on top of a TCA party.

Child Tables

HZ_CUST_SITE_USES_ALL

The business-purpose assignment of an account site (Bill-To, Ship-To, etc.) — what AR and Order Management actually reference when defaulting an address onto a transaction.

Common Joins

HZ_CUST_ACCOUNTSvia CUST_ACCOUNT_ID

The customer account this site assignment belongs to.

HZ_CUST_SITE_USES_ALLvia CUST_ACCT_SITE_ID

The specific business-purpose use (Bill-To, Ship-To) of this account site.

Used In

AROrder Management

Customer / Trading Community data model

Oracle Fusion models customers through Trading Community Architecture (TCA): a HZ_PARTIES record is the underlying person or organization, which becomes a transactable customer once a HZ_CUST_ACCOUNTS row exists against it. Addresses live on HZ_PARTY_SITES at the party level, and are assigned to a specific account (HZ_CUST_ACCT_SITES_ALL) with a business purpose like Bill-To or Ship-To (HZ_CUST_SITE_USES_ALL) — those site-use records are what AR and Order Management actually default onto a transaction.