IM Oi Invoice Report
In ScopeTechnical: IM_OI_INVOICE_REPORT | ID: OR-IM-IM_OI_INVOICE_REPORT-IM_OI_INVOICE_REPORT
Stores data for Invoices Report on ReIM OI dashboard.
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_OI_INVOICE_REPORT
Field Definitions(5)
Rules & Considerations(22)
Sample Load Data(4)
| _scenario | USER_IDR | SESSION_IDR | ITEMS | DOC_ID | DOC_DATE | DUE_DATE | LOCATION | LOC_TYPE | ORDER_NO | PRIORITY | SUPPLIER | EXT_DOC_ID | TOTAL_COST | SYSTEM_CURR | INVOICE_CURR | QTY_DISC_IND | TAX_DISC_IND | COST_DISC_IND | SUPPLIER_SITE_ID | CASH_DISCOUNT_IND | SUPPLIER_SITE_NAME | TOTAL_COST_SY_CURR |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | 2026-01-01 | 2026-01-01 | 1 | S | 1 | 1 | 1 | SAMPLE | 1.0000 | SAM | SAM | S | S | S | 1 | S | SAMPLE | 1.0000 |
| default | ALT-IM_OI-002 | 1000000003 | 3 | 1000000003 | 2026-01-03 | 2026-01-03 | 3 | I | 4 | 3 | 3 | ALT-IM_OI-002 | 12.5000 | IM | IM | I | I | I | 1000000003 | I | IM Oi Invoice Report Secondary | 12.5000 |
| default | EDGE-IM_OI-003 | 1000000005 | 5 | 1000000005 | 2026-01-05 | 2026-01-05 | 5 | I | 6 | 5 | 5 | EDGE-IM_OI-003 | 14.0000 | IM | IM | I | I | I | 1000000005 | I | IM Oi Invoice Report Core | 14.0000 |
Example values from field definitions
- USER_IDR
- SAMPLE
- SESSION_IDR
- 1
- ITEMS
- 1
- DOC_ID
- 1
- DOC_DATE
- 2026-01-01
- DUE_DATE
- 2026-01-01
- LOCATION
- 1
- LOC_TYPE
- S
- ORDER_NO
- 1
- PRIORITY
- 1
- SUPPLIER
- 1
- EXT_DOC_ID
- SAMPLE
- TOTAL_COST
- 1.0000
- SYSTEM_CURR
- SAM
- INVOICE_CURR
- SAM
- QTY_DISC_IND
- S
- TAX_DISC_IND
- S
- COST_DISC_IND
- S
- SUPPLIER_SITE_ID
- 1
- CASH_DISCOUNT_IND
- S
- SUPPLIER_SITE_NAME
- SAMPLE
- TOTAL_COST_SY_CURR
- 1.0000
default
- USER_IDR
- ALT-IM_OI-002
- SESSION_IDR
- 1000000003
- ITEMS
- 3
- DOC_ID
- 1000000003
- DOC_DATE
- 2026-01-03
- DUE_DATE
- 2026-01-03
- LOCATION
- 3
- LOC_TYPE
- I
- ORDER_NO
- 4
- PRIORITY
- 3
- SUPPLIER
- 3
- EXT_DOC_ID
- ALT-IM_OI-002
- TOTAL_COST
- 12.5000
- SYSTEM_CURR
- IM
- INVOICE_CURR
- IM
- QTY_DISC_IND
- I
- TAX_DISC_IND
- I
- COST_DISC_IND
- I
- SUPPLIER_SITE_ID
- 1000000003
- CASH_DISCOUNT_IND
- I
- SUPPLIER_SITE_NAME
- IM Oi Invoice Report Secondary
- TOTAL_COST_SY_CURR
- 12.5000
default
- USER_IDR
- EDGE-IM_OI-003
- SESSION_IDR
- 1000000005
- ITEMS
- 5
- DOC_ID
- 1000000005
- DOC_DATE
- 2026-01-05
- DUE_DATE
- 2026-01-05
- LOCATION
- 5
- LOC_TYPE
- I
- ORDER_NO
- 6
- PRIORITY
- 5
- SUPPLIER
- 5
- EXT_DOC_ID
- EDGE-IM_OI-003
- TOTAL_COST
- 14.0000
- SYSTEM_CURR
- IM
- INVOICE_CURR
- IM
- QTY_DISC_IND
- I
- TAX_DISC_IND
- I
- COST_DISC_IND
- I
- SUPPLIER_SITE_ID
- 1000000005
- CASH_DISCOUNT_IND
- I
- SUPPLIER_SITE_NAME
- IM Oi Invoice Report Core
- TOTAL_COST_SY_CURR
- 14.0000
Rule Validation Summary
- Source Rule Count
- 28
- Governed Rule Count
- 22