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_START_DATE
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. You can't join across them in OTBI, the owned conformed model joins them on shared 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