Oracle Fusion · Data dictionary
CMR_ALL_TRANSACTIONS_V
SharedUsed in 1 subject areas47 reporting columns
Channel Management / Rebates (CMR), denormalized view.
Primary key: not yet catalogued for CMR_ALL_TRANSACTIONS_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCRUAL_CLR_REASON_DESC | ● | Description of the accrual clr reason. | |
| ACCRUAL_CLR_RULE_NAME | ● | Name of the accrual clr rule. | |
| ACCRUAL_INVOICE_QTY | ● | Accrual invoice quantity. | |
| ACCRUAL_RECEIVED_QTY | ● | Accrual received quantity. | |
| AP_ACCRUAL_AMT | ● | Payables accrual amount. | |
| ASN_NUMBER | ● | Advance shipment notice number. | |
| CMR_ACCRUAL_AMT | ● | Cmr accrual amount. | |
| CONSIGNED_FLAG | ● | Indicator (Y/N) for the consigned. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DESTINATION_TYPE_CODE | ● | Code identifying the destination type. | |
| FINAL_MATCH_FLAG | ● | Indicator (Y/N) for the final match. | |
| FOB_LOOKUP_CODE | ● | Lookup code for the fob. | |
| INCLUSIVE_FLAG | ● | Indicator (Y/N) for the inclusive. | |
| INVOICE_BASE_AMOUNT | ● | Invoice base amount. | |
| INVOICE_CURRENCY_CODE | ● | Currency code for the invoice. | |
| INVOICE_DISTRIBUTION_TYPE | ● | Type of invoice distribution. | |
| INVOICE_LINE_NUMBER | ● | Invoice line number. | |
| INVOICE_LINE_TYPE | ● | Type of invoice line. | |
| INVOICE_NUMBER | ● | Invoice number. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LCM_ASSOCIATION_PROCESSED_FLAG | ● | Indicator (Y/N) for the lcm association processed. | |
| LCM_ENABLED_FLAG | ● | Indicator (Y/N) for the lcm enabled. | |
| LE_TIMEZONE_CODE | ● | Code identifying the legal entity timezone. | |
| POSTED_FLAG | ● | Indicator (Y/N) for the posted. | |
| PRIMARY_QTY | ● | Primary quantity. | |
| PRIMARY_UOM_CODE | ● | Code identifying the primary unit of measure. | |
| RA_INVOICE_TRANSACTION_FLAG | ● | Indicator (Y/N) for the ra invoice transaction. | |
| RECEIPT_LINE_NUMBER | ● | Receipt line number. | |
| RECEIPT_NUMBER | ● | Receipt number. | |
| SECONDARY_QTY | ● | Secondary quantity. | |
| SECONDARY_UOM_CODE | ● | Code identifying the secondary unit of measure. | |
| SELF_ASSESSED_FLAG | ● | Indicator (Y/N) for the self assessed. | |
| SHIPMENT_LINE_NUMBER | ● | Shipment line number. | |
| SHIPMENT_NUMBER | ● | Shipment number. | |
| SOURCE_DOCUMENT_CODE | ● | Code identifying the source document. | |
| SOURCE_DOCUMENT_NUMBER | ● | Source document number. | |
| SOURCE_DOC_QTY | ● | Source doc quantity. | |
| SOURCE_DOC_UOM_CODE | ● | Code identifying the source doc unit of measure. | |
| TAX_POINT_BASIS | ● | Tax point basis. | |
| TRANSACTION_AMT | ● | Transaction amount. | |
| TRANSACTION_DATE | ● | Transaction date. | |
| TRANSACTION_ID | ● | Identifier for the transaction. | |
| TRANSACTION_QTY | ● | Transaction quantity. | |
| TRANSACTION_TYPE | ● | Type of transaction. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
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 CMR_ALL_TRANSACTIONS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table