CMR_PO_ACCRUAL_AMTS_RPT

SharedUsed in 1 subject areas26 reporting columns

Channel Management / Rebates (CMR).

Primary key: not yet catalogued for CMR_PO_ACCRUAL_AMTS_RPT — reference Oracle Tables & Views guide.

Columns

Column	In reports	Description (inferred)
ACCRUAL_AMT	●	Accrual amount.
ACCRUAL_QTY	●	Accrual quantity.
CREATED_BY	●	User who created the row.
CREATION_DATE	●	Date and time the row was created.
CURRENCY_CODE	●	Code identifying the currency.
CURRENCY_CONVERSION_DATE	●	Currency conversion date.
CURRENCY_CONVERSION_RATE	●	Currency conversion rate.
CURRENCY_CONVERSION_TYPE	●	Type of currency conversion.
FUNC_CURRENCY_CODE	●	Currency code for the func.
INVOICED_AMT	●	Invoiced amount.
INVOICED_QTY	●	Invoiced quantity.
INVOICE_AMT_FUNC_CURR	●	Invoice amount func currency.
INVOICE_VARIANCE_AMT	●	Invoice variance amount.
ITEM_DESCRIPTION	●	Description of the item.
LAST_UPDATED_BY	●	User who last updated the row.
LAST_UPDATE_DATE	●	Date and time the row was last updated (the incremental-extract key).
LINE_TYPE	●	Type of line.
PERIOD_END_DATE	●	Period end date.
PERIOD_NAME	●	Name of the period.
PERIOD_START_DATE	●	Period start date.
PO_AMOUNT	●	Purchase order amount.
PO_PRICE	●	Purchase order price.
PO_QUANTITY	●	Purchase order quantity.
RECEIVED_AMT	●	Received amount.
RECEIVED_QTY	●	Received quantity.
UOM_CODE	●	Code identifying the unit of measure.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

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 CMR_PO_ACCRUAL_AMTS_RPT?

We ship parameterized SQL, BICC config, and dbt models you own.