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
Joins (inferred from key columns): COLLECTOR_ID → AR_COLLECTORS
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.
Problems that run through this table