RMS Oi Buyer Orders To Approve

In Scope

Technical: RMS_OI_BUYER_ORDERS_TO_APPROVE | ID: OR-MFCS-RMS_OI_BUYER_ORDERS_TO_APPROVE

This table is used to display unapproved orders in the the Buyer Dashboard.

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_BUYER_ORDERS_TO_APPROVE

Field Definitions(25)

Rules & Considerations(8)

Sample Load Data(4)

_scenario	ORDER_NOR	CREATE_IDR	SESSION_IDR	CURRENCY_CODER	DEPT	STATUS	PO_TYPE	SUPPLIER	SUP_NAME	DEPT_NAME	TOTAL_COST	STATUS_DESC	TOTAL_UNITS	COMMENT_DESC	MASTER_PO_NO	OTB_EOW_DATE	PO_TYPE_DESC	TOTAL_RETAIL	WRITTEN_DATE	MARKUP_PERCENT	NOT_AFTER_DATE	NOT_BEFORE_DATE	MULTIPLE_UOM_IND	PO_LAST_UPDATE_ID	PO_LAST_UPDATE_DATETIME
default	2	MIG_USER	1000000001	STD-RMS_OI-001	1001	ACTIVE	RMS Oi Buyer Orders To Approve-001	1	RMS Oi Buyer Orders To Approve Primary	Apparel	1	ACTIVE	1	RMS Oi Buyer Orders To Approve-001	2	2026-01-01	RMS Oi Buyer Orders To Approve-001	1	2026-01-01	1	2026-01-01	2026-01-01	N	STD-RMS_OI-001	2026-01-01

default

ORDER_NOR: 2
CREATE_IDR: MIG_USER
SESSION_IDR: 1000000001
CURRENCY_CODER: STD-RMS_OI-001
DEPT: 1001
STATUS: ACTIVE
PO_TYPE: RMS Oi Buyer Orders To Approve-001
SUPPLIER: 1
SUP_NAME: RMS Oi Buyer Orders To Approve Primary
DEPT_NAME: Apparel
TOTAL_COST: 1
STATUS_DESC: ACTIVE
TOTAL_UNITS: 1
COMMENT_DESC: RMS Oi Buyer Orders To Approve-001
MASTER_PO_NO: 2
OTB_EOW_DATE: 2026-01-01
PO_TYPE_DESC: RMS Oi Buyer Orders To Approve-001
TOTAL_RETAIL: 1
WRITTEN_DATE: 2026-01-01
MARKUP_PERCENT: 1
NOT_AFTER_DATE: 2026-01-01
NOT_BEFORE_DATE: 2026-01-01
MULTIPLE_UOM_IND: N
PO_LAST_UPDATE_ID: STD-RMS_OI-001
PO_LAST_UPDATE_DATETIME: 2026-01-01

RMS Oi Buyer Orders To Approve | undefined | Oracle Retail