RMS Oi Inv Ana Open Order
In ScopeTechnical: RMS_OI_INV_ANA_OPEN_ORDER | ID: OR-MFCS-RMS_OI_INV_ANA_OPEN_ORDER
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
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_INV_ANA_OPEN_ORDER
Field Definitions(11)
Rules & Considerations(3)
Sequencing
Reconciliation
Sample Load Data(4)
| _scenario | ORDER_NO | SUP_NAME | ORDER_TYPE | SESSION_ID | QTY_ORDERED | WF_ORDER_NO | OTB_EOW_DATE | QTY_RECEIVED | SUPPLIER_SITE | NOT_AFTER_DATE | NOT_BEFORE_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2 | RMS Oi Inv Ana Open Order Primary | RMS Oi Inv Ana Open Order-001 | 1000000001 | 11.0000 | 2 | 2026-01-01 | 11.0000 | 1 | 2026-01-01 | 2026-01-01 |
default
- ORDER_NO
- 2
- SUP_NAME
- RMS Oi Inv Ana Open Order Primary
- ORDER_TYPE
- RMS Oi Inv Ana Open Order-001
- SESSION_ID
- 1000000001
- QTY_ORDERED
- 11.0000
- WF_ORDER_NO
- 2
- OTB_EOW_DATE
- 2026-01-01
- QTY_RECEIVED
- 11.0000
- SUPPLIER_SITE
- 1
- NOT_AFTER_DATE
- 2026-01-01
- NOT_BEFORE_DATE
- 2026-01-01