RMS Oi Inventory Order Errors
In ScopeTechnical: RMS_OI_INV_ORD_ERRORS | ID: OR-FND-RMS_OI_INV_ORD_ERRORS-RMS_OI_INVENTORY_ORDER_ERRORS
Stores data for the Inventory Analyst Order Errors Detail Report.
See how this object fits into Foundation Data
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
- RMS_OI_INV_ORD_ERRORS
Field Definitions(5)
Rules & Considerations(25)
Sample Load Data(4)
| _scenario | DEPT | STATUS | PO_TYPE | ORDER_NO | DEPT_NAME | ORDER_TYPE | SESSION_ID | TOTAL_COST | TOTAL_UNITS | WF_ORDER_NO | COMMENT_DESC | MASTER_PO_NO | OTB_EOW_DATE | PO_TYPE_DESC | TOTAL_RETAIL | CURRENCY_CODE | ERROR_MESSAGE | SUPPLIER_SITE | NOT_AFTER_DATE | RECEIVED_UNITS | NOT_BEFORE_DATE | IMPORT_ORDER_IND | MULTIPLE_UOM_IND | OUTSTANDING_COST | RECEIVED_PERCENT | OUTSTANDING_UNITS | PO_LAST_UPDATE_ID | OUTSTANDING_RETAIL | PO_LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | S | SAMP | 1 | SAMPLE | SAM | 1 | 1.0000 | 1.0000 | 1 | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1.0000 | SAM | SAMPLE | 1 | 2026-01-01 | 1.0000 | 2026-01-01 | S | S | 1.0000 | 1.0000000000 | 1.0000 | SAMPLE | 1.0000 | 2026-01-01 |
| default | 1003 | P | RMS | 4 | Footwear | RMS | 1000000003 | 12.5000 | 12.5000 | 4 | RMS Oi Inv Ord Errors-002-ALT | 4 | 2026-01-03 | RMS Oi Inv Ord Errors-002-ALT | 12.5000 | ALT | RMS Oi Inv Ord Errors-002-ALT | 3 | 2026-01-03 | 12.5000 | 2026-01-03 | R | N | 12.5000 | 12.5000000000 | 12.5000 | ALT-RMS_OI-002 | 12.5000 | 2026-01-03 |
| default | 1005 | A | RMS | 6 | Beauty | RMS | 1000000005 | 14.0000 | 14.0000 | 6 | RMS Oi Inv Ord Errors-003-EDGE | 6 | 2026-01-05 | RMS Oi Inv Ord Errors-003-EDGE | 14.0000 | EDG | RMS Oi Inv Ord Errors-003-EDGE | 5 | 2026-01-05 | 14.0000 | 2026-01-05 | R | N | 14.0000 | 14.0000000000 | 14.0000 | EDGE-RMS_OI-003 | 14.0000 | 2026-01-05 |
Example values from field definitions
- DEPT
- 1
- STATUS
- S
- PO_TYPE
- SAMP
- ORDER_NO
- 1
- DEPT_NAME
- SAMPLE
- ORDER_TYPE
- SAM
- SESSION_ID
- 1
- TOTAL_COST
- 1.0000
- TOTAL_UNITS
- 1.0000
- WF_ORDER_NO
- 1
- COMMENT_DESC
- SAMPLE
- MASTER_PO_NO
- 1
- OTB_EOW_DATE
- 2026-01-01
- PO_TYPE_DESC
- SAMPLE
- TOTAL_RETAIL
- 1.0000
- CURRENCY_CODE
- SAM
- ERROR_MESSAGE
- SAMPLE
- SUPPLIER_SITE
- 1
- NOT_AFTER_DATE
- 2026-01-01
- RECEIVED_UNITS
- 1.0000
- NOT_BEFORE_DATE
- 2026-01-01
- IMPORT_ORDER_IND
- S
- MULTIPLE_UOM_IND
- S
- OUTSTANDING_COST
- 1.0000
- RECEIVED_PERCENT
- 1.0000000000
- OUTSTANDING_UNITS
- 1.0000
- PO_LAST_UPDATE_ID
- SAMPLE
- OUTSTANDING_RETAIL
- 1.0000
- PO_LAST_UPDATE_DATETIME
- 2026-01-01
default
- DEPT
- 1003
- STATUS
- P
- PO_TYPE
- RMS
- ORDER_NO
- 4
- DEPT_NAME
- Footwear
- ORDER_TYPE
- RMS
- SESSION_ID
- 1000000003
- TOTAL_COST
- 12.5000
- TOTAL_UNITS
- 12.5000
- WF_ORDER_NO
- 4
- COMMENT_DESC
- RMS Oi Inv Ord Errors-002-ALT
- MASTER_PO_NO
- 4
- OTB_EOW_DATE
- 2026-01-03
- PO_TYPE_DESC
- RMS Oi Inv Ord Errors-002-ALT
- TOTAL_RETAIL
- 12.5000
- CURRENCY_CODE
- ALT
- ERROR_MESSAGE
- RMS Oi Inv Ord Errors-002-ALT
- SUPPLIER_SITE
- 3
- NOT_AFTER_DATE
- 2026-01-03
- RECEIVED_UNITS
- 12.5000
- NOT_BEFORE_DATE
- 2026-01-03
- IMPORT_ORDER_IND
- R
- MULTIPLE_UOM_IND
- N
- OUTSTANDING_COST
- 12.5000
- RECEIVED_PERCENT
- 12.5000000000
- OUTSTANDING_UNITS
- 12.5000
- PO_LAST_UPDATE_ID
- ALT-RMS_OI-002
- OUTSTANDING_RETAIL
- 12.5000
- PO_LAST_UPDATE_DATETIME
- 2026-01-03
default
- DEPT
- 1005
- STATUS
- A
- PO_TYPE
- RMS
- ORDER_NO
- 6
- DEPT_NAME
- Beauty
- ORDER_TYPE
- RMS
- SESSION_ID
- 1000000005
- TOTAL_COST
- 14.0000
- TOTAL_UNITS
- 14.0000
- WF_ORDER_NO
- 6
- COMMENT_DESC
- RMS Oi Inv Ord Errors-003-EDGE
- MASTER_PO_NO
- 6
- OTB_EOW_DATE
- 2026-01-05
- PO_TYPE_DESC
- RMS Oi Inv Ord Errors-003-EDGE
- TOTAL_RETAIL
- 14.0000
- CURRENCY_CODE
- EDG
- ERROR_MESSAGE
- RMS Oi Inv Ord Errors-003-EDGE
- SUPPLIER_SITE
- 5
- NOT_AFTER_DATE
- 2026-01-05
- RECEIVED_UNITS
- 14.0000
- NOT_BEFORE_DATE
- 2026-01-05
- IMPORT_ORDER_IND
- R
- MULTIPLE_UOM_IND
- N
- OUTSTANDING_COST
- 14.0000
- RECEIVED_PERCENT
- 14.0000000000
- OUTSTANDING_UNITS
- 14.0000
- PO_LAST_UPDATE_ID
- EDGE-RMS_OI-003
- OUTSTANDING_RETAIL
- 14.0000
- PO_LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 29
- Governed Rule Count
- 25