Oracle Fusion · Data dictionary
HZ_CUST_ACCOUNTS
Trading CommunityUsed in 43 subject areas14 reporting columns
Trading Community (HZ), customer accounts (the sales-side relationship layered on HZ_PARTIES).
Primary key: CUST_ACCOUNT_ID
Joins (inferred from key columns): PARTY_ID → HZ_PARTIES
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNT_ESTABLISHED_DATE | ● | Account established date. | |
| ACCOUNT_NAME | ● | Name of the account. | |
| ACCOUNT_NUMBER | ● | Account number. | |
| ACCOUNT_TERMINATION_DATE | ● | Account termination date. | |
| AUTOPAY_FLAG | ● | Indicator (Y/N) for the autopay. | |
| COTERMINATE_DAY_MONTH | ● | Coterminate day month. | |
| CUSTOMER_CLASS_CODE | ● | Code identifying the customer class. | |
| CUSTOMER_TYPE | ● | Type of customer. | |
| CUST_ACCOUNT_ID | PK | ● | Identifier for the customer account. |
| HOLD_BILL_FLAG | ● | Indicator (Y/N) for the hold bill. | |
| ORIG_SYSTEM_REFERENCE | ● | Orig system reference. | |
| PARTY_ID | ● | Identifier for the party. | |
| STATUS | ● | Status. | |
| TAX_CODE | ● | Code identifying the tax. |
21 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to HZ_CUST_ACCOUNTS.
- AR Applied and Unapplied Receipts Register Report
- AR Customer Query Report
- AR Open Claim Summary and Detail Report
- AR Transaction Register Summary and Detail Report
- Cash Settlement Report
- Customer Statement of Open Balance Report
- Golden Tax Reconciliation Report
- Greece Customer Balance by Account Report
- Greece Notes Receivable - Post Dated Checks and Drafts Report
- Invoice Settlement Report
- Open Closed Claim Detail Report
- Receipt History Report
- SEPA Debit Authorization and Bank Detail Check Report
- SEPA Letter for Italy Customer
- Transaction Resolution Report
- Vietnam Receipt Voucher Report
- Bad Debt Provision Report
- Print Adjustments Report
- Receivables Aging by General Ledger Account Report
- Customer Account Status Report
- Generate Late Charges Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Costing - Cost Accounting Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Enterprise Contracts - Contracts Real Time
- Enterprise Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Installed Base - Customer Asset History Real Time
- Installed Base - Customer Asset Real Time
- Maintenance Management - Asset History Real Time
- Order Management - Fulfillment Lines Real Time
- Order Management - Order Headers Real Time
- Order Management - Order Holds Real Time
- Order Management - Order Lines Real Time
- Order Management - Price Adjustments Real Time
- Order Management - Process Instances Real Time
- Product Genealogy - Genealogy Instance Real Time
- Project Billing - Funding Real Time
- Project Billing - Invoices Real Time
- Project Billing - Revenue Real Time
- Project Control - Budgets Real Time
- Project Costing - Actual Costs Real Time
Need the extract + dbt staging for HZ_CUST_ACCOUNTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table