RMS Oi Overdue Shipment Return to Vendor
In ScopeTechnical: RMS_OI_OVERDUE_SHIP_RTV | ID: OR-FND-RMS_OI_OVERDUE_SHIP_RTV-RMS_OI_OVERDUE_SHIPMENT_RETURN_TO_VENDOR
Stores the information for the RTVs Pending Close Inventory Control 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_OVERDUE_SHIP_RTV
Field Definitions(5)
Rules & Considerations(9)
Sample Load Data(4)
| _scenario | RTV_QTY | FROM_LOC | SESSION_ID | CREATED_DATE | RTV_ORDER_NO | FROM_LOC_NAME | FROM_LOC_TYPE | MULTI_UOM_IND | SUPPLIER_SITE | NOT_AFTER_DATE | SUPPLIER_SITE_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | 1 | 1 | 2026-01-01 | 1 | SAMPLE | S | S | 1 | 2026-01-01 | SAMPLE |
| default | 12.5000 | 3 | 1000000003 | 2026-01-03 | 4 | RMS Oi Overdue Ship Rtv Secondary | R | R | 3 | 2026-01-03 | RMS Oi Overdue Ship Rtv Secondary |
| default | 14.0000 | 5 | 1000000005 | 2026-01-05 | 6 | RMS Oi Overdue Ship Rtv Core | R | R | 5 | 2026-01-05 | RMS Oi Overdue Ship Rtv Core |
Example values from field definitions
- RTV_QTY
- 1.0000
- FROM_LOC
- 1
- SESSION_ID
- 1
- CREATED_DATE
- 2026-01-01
- RTV_ORDER_NO
- 1
- FROM_LOC_NAME
- SAMPLE
- FROM_LOC_TYPE
- S
- MULTI_UOM_IND
- S
- SUPPLIER_SITE
- 1
- NOT_AFTER_DATE
- 2026-01-01
- SUPPLIER_SITE_NAME
- SAMPLE
default
- RTV_QTY
- 12.5000
- FROM_LOC
- 3
- SESSION_ID
- 1000000003
- CREATED_DATE
- 2026-01-03
- RTV_ORDER_NO
- 4
- FROM_LOC_NAME
- RMS Oi Overdue Ship Rtv Secondary
- FROM_LOC_TYPE
- R
- MULTI_UOM_IND
- R
- SUPPLIER_SITE
- 3
- NOT_AFTER_DATE
- 2026-01-03
- SUPPLIER_SITE_NAME
- RMS Oi Overdue Ship Rtv Secondary
default
- RTV_QTY
- 14.0000
- FROM_LOC
- 5
- SESSION_ID
- 1000000005
- CREATED_DATE
- 2026-01-05
- RTV_ORDER_NO
- 6
- FROM_LOC_NAME
- RMS Oi Overdue Ship Rtv Core
- FROM_LOC_TYPE
- R
- MULTI_UOM_IND
- R
- SUPPLIER_SITE
- 5
- NOT_AFTER_DATE
- 2026-01-05
- SUPPLIER_SITE_NAME
- RMS Oi Overdue Ship Rtv Core
Rule Validation Summary
- Source Rule Count
- 12
- Governed Rule Count
- 9