Oracle Fusion/Financials/Customers

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.

Key Columns

CUST_ACCOUNT_IDPARTY_IDACCOUNT_NUMBERSTATUS

Parent Table

HZ_PARTIES

Trading Community Architecture (TCA) party master — the underlying person or organization, independent of any role (customer, supplier, contact) it plays.

Child Tables

HZ_CUST_ACCT_SITES_ALL

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

Common Joins

HZ_PARTIESvia PARTY_ID

The underlying party (person or organization) this account represents.

HZ_CUST_ACCT_SITES_ALLvia CUST_ACCOUNT_ID

The account-level site assignments — where this account can be billed or shipped.

RA_CUSTOMER_TRX_ALLvia BILL_TO_CUSTOMER_ID = CUST_ACCOUNT_ID

AR transactions (invoices, credit memos) billed to this customer account.

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.