CMR_PURCHASE_ORDER_INFO_V

SharedUsed in 2 subject areas23 reporting columns

Channel Management / Rebates (CMR) — denormalized view.

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

Columns

Column	In reports	Description (inferred)
ACCRUE_ON_RECEIPT_FLAG	●	Indicator (Y/N) for the accrue on receipt.
CONV_FACTOR_TO_PRIMARY_UOM	●	Conv factor to primary unit of measure.
CURRENCY_CODE	●	Code identifying the currency.
DESTINATION_TYPE_CODE	●	Code identifying the destination type.
EVENT_DATE	●	Event date.
ITEM_DESCRIPTION	●	Description of the item.
MATCH_OPTION	●	Match option.
NEED_BY_DATE	●	Need by date.
NONRECOVERABLE_INCLUSIVE_TAX	●	Nonrecoverable inclusive tax.
NONRECOVERABLE_TAX	●	Nonrecoverable tax.
PO_CONVERSION_RATE	●	Purchase order conversion rate.
PO_SCHEDULE	●	Purchase order schedule.
PRICE	●	Price.
PROMISED_DATE	●	Promised date.
PTR_FLAG	●	Indicator (Y/N) for the ptr.
PURCHASE_BASIS	●	Purchase basis.
QUANTITY_ORDERED	●	Quantity ordered.
RECOVERABLE_INCLUSIVE_TAX	●	Recoverable inclusive tax.
RECOVERABLE_TAX	●	Recoverable tax.
SOURCE_DOCUMENT_LINE_NUMBER	●	Source document line number.
SOURCE_DOCUMENT_NUMBER	●	Source document number.
TAX_EXCLUSIVE_PRICE	●	Tax exclusive price.
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_PURCHASE_ORDER_INFO_V?

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