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.

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.

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.