Oracle Fusion · Data dictionary
CMR_AP_INVOICE_DTLS
SharedUsed in 2 subject areas16 reporting columns
Channel Management / Rebates (CMR).
Likely primary key: CMR_AP_INVOICE_DIST_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTING_DATE | ● | Accounting date. | |
| CMR_AP_INVOICE_DIST_ID | PK? | ● | Identifier for the cmr payables invoice distribution. |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| INCLUSIVE_FLAG | ● | Indicator (Y/N) for the inclusive. | |
| INVOICE_AMT | ● | Invoice amount. | |
| INVOICE_BASE_AMOUNT | ● | Invoice base amount. | |
| INVOICE_DISTRIBUTION_TYPE | ● | Type of invoice distribution. | |
| INVOICE_LINE_NUMBER | ● | Invoice line number. | |
| INVOICE_LINE_TYPE | ● | Type of invoice line. | |
| INVOICE_NUMBER | ● | Invoice number. | |
| INVOICE_QTY | ● | Invoice quantity. | |
| INVOICE_SOURCE | ● | Invoice source. | |
| INVOICE_TYPE | ● | Type of invoice. | |
| LE_TIMEZONE_CODE | ● | Code identifying the legal entity timezone. | |
| TAX_POINT_BASIS | ● | Tax point basis. | |
| UNIT_OF_MEASURE | ● | Unit of measure. |
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.
- Costing - Cost Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
Need the extract + dbt staging for CMR_AP_INVOICE_DTLS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table