Oracle Fusion · Data dictionary
HZ_CUST_PROFILE_AMTS_F
Trading CommunityUsed in 1 subject areas22 reporting columns
Trading Community (Parties) (HZ).
Primary key: CUST_ACCT_PROFILE_AMT_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE (Oracle's HZ_CUST_PROFILE_AMTS_PK)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AUTO_REC_MIN_RECEIPT_AMOUNT | ● | Auto rec min receipt amount. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| CUST_ACCT_PROFILE_AMT_ID | PK | ○ | Identifier for the customer account profile amount. |
| EFFECTIVE_START_DATE | PK | ○ | Start date of the effective-dated record. |
| INTEREST_FIXED_AMOUNT | ● | Interest fixed amount. | |
| INTEREST_RATE | ● | Interest rate. | |
| INTEREST_SCHEDULE_ID | ● | Identifier for the interest schedule. | |
| INTEREST_TYPE | ● | Type of interest. | |
| MAX_INTEREST_CHARGE | ● | Max interest charge. | |
| MIN_DUNNING_AMOUNT | ● | Min dunning amount. | |
| MIN_DUNNING_INVOICE_AMOUNT | ● | Min dunning invoice amount. | |
| MIN_FC_BALANCE_AMOUNT | ● | Min fc balance amount. | |
| MIN_FC_BALANCE_OVERDUE_TYPE | ● | Type of min fc balance overdue. | |
| MIN_FC_BALANCE_PERCENT | ● | Min fc balance percentage. | |
| MIN_FC_INVOICE_AMOUNT | ● | Min fc invoice amount. | |
| MIN_FC_INVOICE_OVERDUE_TYPE | ● | Type of min fc invoice overdue. | |
| MIN_FC_INVOICE_PERCENT | ● | Min fc invoice percentage. | |
| MIN_INTEREST_CHARGE | ● | Min interest charge. | |
| MIN_STATEMENT_AMOUNT | ● | Min statement amount. | |
| OVERALL_CREDIT_LIMIT | ● | Overall credit limit. | |
| PENALTY_FIXED_AMOUNT | ● | Penalty fixed amount. | |
| PENALTY_RATE | ● | Penalty rate. | |
| PENALTY_TYPE | ● | Type of penalty. | |
| TRX_CREDIT_LIMIT | ● | Transaction credit limit. |
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_CUST_PROFILE_AMTS_F.
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.
Need the extract + dbt staging for HZ_CUST_PROFILE_AMTS_F?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table