IM Invoice Detail
In ScopeTechnical: IM_INVOICE_DETAIL | ID: OR-IM-IM_INVOICE_DETAIL-IM_INVOICE_DETAIL
Stores invoice matching data for IM invoice detail in Oracle Retail Invoice Matching. Used to support operational processing, integration, and reporting within the Oracle Retail application landscape.
See how this object fits into Invoice Matching
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- IM_INVOICE_DETAIL
Field Definitions(5)
Rules & Considerations(37)
validation
constraint
Sample Load Data(4)
| _scenario | QTYR | ITEMRPK | DOC_IDRPK | UNIT_COSTR | RESOLUTION_ADJUSTED_UNIT_COSTR | STATUS | UNIT_MRP | CREATED_BY | QTY_MATCHED | UNIT_RETAIL | COST_MATCHED | UNIT_FREIGHT | CREATION_DATE | LAST_UPDATED_BY | LAST_UPDATE_DATE | OBJECT_VERSION_ID | ADJUSTMENT_PENDING | TAX_DISCREPANCY_IND | RESOLUTION_ADJUSTED_QTY | QTY_VARIANCE_WITHIN_TOLERANCE | COST_VARIANCE_WITHIN_TOLERANCE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | SAMPLE | 1 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | SAMPLE | S | 1.0000 | S | 1.0000 | 2026-01-01 | SAMPLE | 2026-01-01 | 1 | S | S | 1.0000 | 1.0000 | 1.0000 |
| default | 12.5000 | IM Invoice Detail-002-ALT | 1000000003 | 12.5000 | 12.5000 | pmtch | 12.5000 | APP_USER_ID | I | 12.5000 | I | 12.5000 | 2026-01-03 | APP_USER_ID | 2026-01-03 | 1000000003 | I | I | 12.5000 | 12.5000 | 12.5000 |
| default | 14.0000 | IM Invoice Detail-003-EDG | 1000000005 | 14.0000 | 14.0000 | unmtch | 14.0000 | USERENV | I | 14.0000 | I | 14.0000 | 2026-01-05 | USERENV | 2026-01-05 | 1000000005 | I | I | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- QTYR
- 1.0000
- ITEMRPK
- SAMPLE
- DOC_IDRPK
- 1
- UNIT_COSTR
- 1.0000
- RESOLUTION_ADJUSTED_UNIT_COSTR
- 1.0000
- STATUS
- SAMPLE
- UNIT_MRP
- 1.0000
- CREATED_BY
- SAMPLE
- QTY_MATCHED
- S
- UNIT_RETAIL
- 1.0000
- COST_MATCHED
- S
- UNIT_FREIGHT
- 1.0000
- CREATION_DATE
- 2026-01-01
- LAST_UPDATED_BY
- SAMPLE
- LAST_UPDATE_DATE
- 2026-01-01
- OBJECT_VERSION_ID
- 1
- ADJUSTMENT_PENDING
- S
- TAX_DISCREPANCY_IND
- S
- RESOLUTION_ADJUSTED_QTY
- 1.0000
- QTY_VARIANCE_WITHIN_TOLERANCE
- 1.0000
- COST_VARIANCE_WITHIN_TOLERANCE
- 1.0000
default
- QTYR
- 12.5000
- ITEMRPK
- IM Invoice Detail-002-ALT
- DOC_IDRPK
- 1000000003
- UNIT_COSTR
- 12.5000
- RESOLUTION_ADJUSTED_UNIT_COSTR
- 12.5000
- STATUS
- pmtch
- UNIT_MRP
- 12.5000
- CREATED_BY
- APP_USER_ID
- QTY_MATCHED
- I
- UNIT_RETAIL
- 12.5000
- COST_MATCHED
- I
- UNIT_FREIGHT
- 12.5000
- CREATION_DATE
- 2026-01-03
- LAST_UPDATED_BY
- APP_USER_ID
- LAST_UPDATE_DATE
- 2026-01-03
- OBJECT_VERSION_ID
- 1000000003
- ADJUSTMENT_PENDING
- I
- TAX_DISCREPANCY_IND
- I
- RESOLUTION_ADJUSTED_QTY
- 12.5000
- QTY_VARIANCE_WITHIN_TOLERANCE
- 12.5000
- COST_VARIANCE_WITHIN_TOLERANCE
- 12.5000
default
- QTYR
- 14.0000
- ITEMRPK
- IM Invoice Detail-003-EDG
- DOC_IDRPK
- 1000000005
- UNIT_COSTR
- 14.0000
- RESOLUTION_ADJUSTED_UNIT_COSTR
- 14.0000
- STATUS
- unmtch
- UNIT_MRP
- 14.0000
- CREATED_BY
- USERENV
- QTY_MATCHED
- I
- UNIT_RETAIL
- 14.0000
- COST_MATCHED
- I
- UNIT_FREIGHT
- 14.0000
- CREATION_DATE
- 2026-01-05
- LAST_UPDATED_BY
- USERENV
- LAST_UPDATE_DATE
- 2026-01-05
- OBJECT_VERSION_ID
- 1000000005
- ADJUSTMENT_PENDING
- I
- TAX_DISCREPANCY_IND
- I
- RESOLUTION_ADJUSTED_QTY
- 14.0000
- QTY_VARIANCE_WITHIN_TOLERANCE
- 14.0000
- COST_VARIANCE_WITHIN_TOLERANCE
- 14.0000
Rule Validation Summary
- Source Rule Count
- 55
- Governed Rule Count
- 37