RMS Oi Buyer Orders To Approve
In ScopeTechnical: RMS_OI_BUYER_ORDERS_TO_APPROVE | ID: OR-FND-RMS_OI_BUYER_ORDERS_TO_APPROVE-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_BUYER_ORDERS_TO_APPROVE
Field Definitions(5)
Rules & Considerations(24)
constraint
validation
Sample Load Data(4)
| _scenario | ORDER_NOR | SESSION_IDR | DEPT | STATUS | PO_TYPE | SUPPLIER | SUP_NAME | CREATE_ID | DEPT_NAME | TOTAL_COST | STATUS_DESC | TOTAL_UNITS | COMMENT_DESC | MASTER_PO_NO | OTB_EOW_DATE | PO_TYPE_DESC | TOTAL_RETAIL | WRITTEN_DATE | CURRENCY_CODE | MARKUP_PERCENT | NOT_AFTER_DATE | NOT_BEFORE_DATE | MULTIPLE_UOM_IND | PO_LAST_UPDATE_ID | PO_LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | S | SAMP | 1 | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | SAM | 1 | 2026-01-01 | 2026-01-01 | S | SAMPLE | 2026-01-01 |
| default | 4 | 1000000003 | 1003 | P | RMS | 3 | RMS Oi Buyer Orders To Approve Secondary | MDM_USER | Footwear | 3 | PENDING-ALT | 3 | RMS Oi Buyer Orders To Approve-002-ALT | 4 | 2026-01-03 | RMS Oi Buyer Orders To Approve-002-ALT | 3 | 2026-01-03 | ALT | 3 | 2026-01-03 | 2026-01-03 | N | ALT-RMS_OI-002 | 2026-01-03 |
| default | 6 | 1000000005 | 1005 | A | RMS | 5 | RMS Oi Buyer Orders To Approve Core | BATCH_USER | Beauty | 5 | ACTIVE-EDGE | 5 | RMS Oi Buyer Orders To Approve-003-EDGE | 6 | 2026-01-05 | RMS Oi Buyer Orders To Approve-003-EDGE | 5 | 2026-01-05 | EDG | 5 | 2026-01-05 | 2026-01-05 | N | EDGE-RMS_OI-003 | 2026-01-05 |
Example values from field definitions
- ORDER_NOR
- 1
- SESSION_IDR
- 1
- DEPT
- 1
- STATUS
- S
- PO_TYPE
- SAMP
- SUPPLIER
- 1
- SUP_NAME
- SAMPLE
- CREATE_ID
- SAMPLE
- DEPT_NAME
- SAMPLE
- TOTAL_COST
- 1
- STATUS_DESC
- SAMPLE
- TOTAL_UNITS
- 1
- COMMENT_DESC
- SAMPLE
- MASTER_PO_NO
- 1
- OTB_EOW_DATE
- 2026-01-01
- PO_TYPE_DESC
- SAMPLE
- TOTAL_RETAIL
- 1
- WRITTEN_DATE
- 2026-01-01
- CURRENCY_CODE
- SAM
- MARKUP_PERCENT
- 1
- NOT_AFTER_DATE
- 2026-01-01
- NOT_BEFORE_DATE
- 2026-01-01
- MULTIPLE_UOM_IND
- S
- PO_LAST_UPDATE_ID
- SAMPLE
- PO_LAST_UPDATE_DATETIME
- 2026-01-01
default
- ORDER_NOR
- 4
- SESSION_IDR
- 1000000003
- DEPT
- 1003
- STATUS
- P
- PO_TYPE
- RMS
- SUPPLIER
- 3
- SUP_NAME
- RMS Oi Buyer Orders To Approve Secondary
- CREATE_ID
- MDM_USER
- DEPT_NAME
- Footwear
- TOTAL_COST
- 3
- STATUS_DESC
- PENDING-ALT
- TOTAL_UNITS
- 3
- COMMENT_DESC
- RMS Oi Buyer Orders To Approve-002-ALT
- MASTER_PO_NO
- 4
- OTB_EOW_DATE
- 2026-01-03
- PO_TYPE_DESC
- RMS Oi Buyer Orders To Approve-002-ALT
- TOTAL_RETAIL
- 3
- WRITTEN_DATE
- 2026-01-03
- CURRENCY_CODE
- ALT
- MARKUP_PERCENT
- 3
- NOT_AFTER_DATE
- 2026-01-03
- NOT_BEFORE_DATE
- 2026-01-03
- MULTIPLE_UOM_IND
- N
- PO_LAST_UPDATE_ID
- ALT-RMS_OI-002
- PO_LAST_UPDATE_DATETIME
- 2026-01-03
default
- ORDER_NOR
- 6
- SESSION_IDR
- 1000000005
- DEPT
- 1005
- STATUS
- A
- PO_TYPE
- RMS
- SUPPLIER
- 5
- SUP_NAME
- RMS Oi Buyer Orders To Approve Core
- CREATE_ID
- BATCH_USER
- DEPT_NAME
- Beauty
- TOTAL_COST
- 5
- STATUS_DESC
- ACTIVE-EDGE
- TOTAL_UNITS
- 5
- COMMENT_DESC
- RMS Oi Buyer Orders To Approve-003-EDGE
- MASTER_PO_NO
- 6
- OTB_EOW_DATE
- 2026-01-05
- PO_TYPE_DESC
- RMS Oi Buyer Orders To Approve-003-EDGE
- TOTAL_RETAIL
- 5
- WRITTEN_DATE
- 2026-01-05
- CURRENCY_CODE
- EDG
- MARKUP_PERCENT
- 5
- NOT_AFTER_DATE
- 2026-01-05
- NOT_BEFORE_DATE
- 2026-01-05
- MULTIPLE_UOM_IND
- N
- PO_LAST_UPDATE_ID
- EDGE-RMS_OI-003
- PO_LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 28
- Governed Rule Count
- 24