Oracle Fusion · Data dictionary
HZ_CUSTOMER_PROFILES_F
Trading CommunityUsed in 1 subject areas47 reporting columns
Trading Community (Parties) (HZ).
Primary key: CUST_ACCOUNT_PROFILE_ID, EFFECTIVE_START_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNT_STATUS | ● | Status of the account. | |
| AUTO_REC_INCL_DISPUTED_FLAG | ● | Indicator (Y/N) for the auto rec incl disputed. | |
| B2B_TP_CODE | ● | Code identifying the b2b tp. | |
| CHARGE_BEGIN_DATE | ● | Charge begin date. | |
| CHARGE_ON_FINANCE_CHARGE_FLAG | ● | Indicator (Y/N) for the charge on finance charge. | |
| COLLECTOR_ID | ● | Identifier for the collector. | |
| CONS_BILL_LEVEL | ● | Cons bill level. | |
| CONS_INV_FLAG | ● | Indicator (Y/N) for the cons inventory. | |
| CONS_INV_TYPE | ● | Type of cons inventory. | |
| CREDIT_BALANCE_STATEMENTS | ● | Credit balance statements. | |
| CREDIT_CHECKING | ● | Credit checking. | |
| CREDIT_CLASSIFICATION | ● | Credit classification. | |
| CREDIT_CURRENCY_CODE | ● | Currency code for the credit. | |
| CREDIT_HOLD | ● | Credit hold. | |
| CREDIT_LIMIT | ● | Credit limit. | |
| CREDIT_RATING | ● | Credit rating. | |
| CUST_ACCOUNT_PROFILE_ID | PK | ○ | Identifier for the customer account profile. |
| DISCOUNT_GRACE_DAYS | ● | Discount grace days. | |
| DISCOUNT_TERMS | ● | Discount terms. | |
| DUNNING_LETTERS | ● | Dunning letters. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | PK | ● | Start date of the effective-dated record. |
| EXCHANGE_RATE_TYPE | ● | Type of exchange rate. | |
| HOLD_CHARGED_INVOICES_FLAG | ● | Indicator (Y/N) for the hold charged invoices. | |
| INTEREST_CALCULATION_PERIOD | ● | Interest calculation period. | |
| INTEREST_CHARGES | ● | Interest charges. | |
| INTEREST_PERIOD_DAYS | ● | Interest period days. | |
| LATE_CHARGE_CALCULATION_TRX | ● | Late charge calculation transaction. | |
| LATE_CHARGE_TERM_ID | ● | Identifier for the late charge term. | |
| LATE_CHARGE_TYPE | ● | Type of late charge. | |
| LOCKBOX_MATCHING_OPTION | ● | Lockbox matching option. | |
| MATCH_BY_AUTOUPDATE_FLAG | ● | Indicator (Y/N) for the match by autoupdate. | |
| MULTIPLE_INTEREST_RATES_FLAG | ● | Indicator (Y/N) for the multiple interest rates. | |
| OFFSET_DAYS | ● | Offset days. | |
| OVERRIDE_TERMS | ● | Override terms. | |
| PAYMENT_GRACE_DAYS | ● | Payment grace days. | |
| PERCENT_COLLECTABLE | ● | Percent collectable. | |
| PREF_CONTACT_METHOD | ● | Pref contact method. | |
| PRINTING_OPTION_CODE | ● | Code identifying the printing option. | |
| RISK_CODE | ● | Code identifying the risk. | |
| SEND_STATEMENTS | ● | Send statements. | |
| STANDARD_TERMS | ● | Standard terms. | |
| TOLERANCE | ● | Tolerance. | |
| TXN_DELIVERY_METHOD | ● | Transaction delivery method. | |
| XML_CB_FLAG | ● | Indicator (Y/N) for the xml cb. | |
| XML_CM_FLAG | ● | Indicator (Y/N) for the xml cm. | |
| XML_DM_FLAG | ● | Indicator (Y/N) for the xml dm. | |
| XML_INV_FLAG | ● | Indicator (Y/N) for the xml inventory. |
1 report 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_CUSTOMER_PROFILES_F.
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
Need the extract + dbt staging for HZ_CUSTOMER_PROFILES_F?
We ship parameterized SQL, BICC config, and dbt models you own.