RMS Oi Inv Ord Errors

In Scope

Technical: RMS_OI_INV_ORD_ERRORS | ID: OR-MFCS-RMS_OI_INV_ORD_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

Target Structure

Load Approach
Table
Target Objects
RMS_OI_INV_ORD_ERRORS

Field Definitions(29)

Rules & Considerations(4)

Validation

Sequencing

Sample Load Data(4)

default

DEPT
1001
STATUS
ACTIVE
PO_TYPE
RMS Oi Inv Ord Errors-001
ORDER_NO
2
DEPT_NAME
Apparel
ORDER_TYPE
RMS Oi Inv Ord Errors-001
SESSION_ID
1000000001
TOTAL_COST
11.0000
TOTAL_UNITS
11.0000
WF_ORDER_NO
2
COMMENT_DESC
RMS Oi Inv Ord Errors-001
MASTER_PO_NO
2
OTB_EOW_DATE
2026-01-01
PO_TYPE_DESC
RMS Oi Inv Ord Errors-001
TOTAL_RETAIL
11.0000
CURRENCY_CODE
STD-RMS_OI-001
ERROR_MESSAGE
RMS Oi Inv Ord Errors-001
SUPPLIER_SITE
1
NOT_AFTER_DATE
2026-01-01
RECEIVED_UNITS
11.0000
NOT_BEFORE_DATE
2026-01-01
IMPORT_ORDER_IND
RMS Oi Inv Ord Errors-001
MULTIPLE_UOM_IND
N
OUTSTANDING_COST
11.0000
RECEIVED_PERCENT
11.0000
OUTSTANDING_UNITS
11.0000
PO_LAST_UPDATE_ID
STD-RMS_OI-001
OUTSTANDING_RETAIL
11.0000
PO_LAST_UPDATE_DATETIME
2026-01-01
RMS Oi Inv Ord Errors | undefined | Oracle Retail