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(29)
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 |
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
Rule Validation Summary
- Source Rule Count
- 29
- Governed Rule Count
- 25