RMS Oi Unexpected Inventory
In ScopeTechnical: RMS_OI_UNEXPECTED_INV | ID: OR-FND-RMS_OI_UNEXPECTED_INV-RMS_OI_UNEXPECTED_INVENTORY
Stores the information for the Unexpected Inventory 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_UNEXPECTED_INV
Field Definitions(5)
Rules & Considerations(20)
Sample Load Data(4)
| _scenario | LOC | DEPT | ITEM | CLASS | STATUS | LOC_NAME | LOC_TYPE | SUBCLASS | DEPT_NAME | ITEM_DESC | CLASS_NAME | RANGED_IND | SESSION_ID | ITEM_PARENT | RESERVED_QTY | STOCK_ON_HAND | SUBCLASS_NAME | UNEXPECTED_QTY | ITEM_PARENT_DESC | NON_SELLABLE_QTY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | S | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | S | 1 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | 1.0000 | SAMPLE | 1.0000 |
| default | 3 | 1003 | RMS Oi Unexpected Inv-002 | 1103 | P | RMS Oi Unexpected Inv Secondary | RMS Oi Unexpected Inv-002-ALT | 1113 | Footwear | RMS Oi Unexpected Inv-002-ALT | Womenswear | R | 1000000003 | RMS Oi Unexpected Inv-002 | 12.5000 | 12.5000 | Fashion Range | 12.5000 | RMS Oi Unexpected Inv-002-ALT | 12.5000 |
| default | 5 | 1005 | RMS Oi Unexpected Inv-003 | 1105 | A | RMS Oi Unexpected Inv Core | RMS Oi Unexpected Inv-003-EDGE | 1115 | Beauty | RMS Oi Unexpected Inv-003-EDGE | Kidswear | R | 1000000005 | RMS Oi Unexpected Inv-003 | 14.0000 | 14.0000 | Value Range | 14.0000 | RMS Oi Unexpected Inv-003-EDGE | 14.0000 |
Example values from field definitions
- LOC
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- STATUS
- S
- LOC_NAME
- SAMPLE
- LOC_TYPE
- SAMPLE
- SUBCLASS
- 1
- DEPT_NAME
- SAMPLE
- ITEM_DESC
- SAMPLE
- CLASS_NAME
- SAMPLE
- RANGED_IND
- S
- SESSION_ID
- 1
- ITEM_PARENT
- SAMPLE
- RESERVED_QTY
- 1.0000
- STOCK_ON_HAND
- 1.0000
- SUBCLASS_NAME
- SAMPLE
- UNEXPECTED_QTY
- 1.0000
- ITEM_PARENT_DESC
- SAMPLE
- NON_SELLABLE_QTY
- 1.0000
default
- LOC
- 3
- DEPT
- 1003
- ITEM
- RMS Oi Unexpected Inv-002
- CLASS
- 1103
- STATUS
- P
- LOC_NAME
- RMS Oi Unexpected Inv Secondary
- LOC_TYPE
- RMS Oi Unexpected Inv-002-ALT
- SUBCLASS
- 1113
- DEPT_NAME
- Footwear
- ITEM_DESC
- RMS Oi Unexpected Inv-002-ALT
- CLASS_NAME
- Womenswear
- RANGED_IND
- R
- SESSION_ID
- 1000000003
- ITEM_PARENT
- RMS Oi Unexpected Inv-002
- RESERVED_QTY
- 12.5000
- STOCK_ON_HAND
- 12.5000
- SUBCLASS_NAME
- Fashion Range
- UNEXPECTED_QTY
- 12.5000
- ITEM_PARENT_DESC
- RMS Oi Unexpected Inv-002-ALT
- NON_SELLABLE_QTY
- 12.5000
default
- LOC
- 5
- DEPT
- 1005
- ITEM
- RMS Oi Unexpected Inv-003
- CLASS
- 1105
- STATUS
- A
- LOC_NAME
- RMS Oi Unexpected Inv Core
- LOC_TYPE
- RMS Oi Unexpected Inv-003-EDGE
- SUBCLASS
- 1115
- DEPT_NAME
- Beauty
- ITEM_DESC
- RMS Oi Unexpected Inv-003-EDGE
- CLASS_NAME
- Kidswear
- RANGED_IND
- R
- SESSION_ID
- 1000000005
- ITEM_PARENT
- RMS Oi Unexpected Inv-003
- RESERVED_QTY
- 14.0000
- STOCK_ON_HAND
- 14.0000
- SUBCLASS_NAME
- Value Range
- UNEXPECTED_QTY
- 14.0000
- ITEM_PARENT_DESC
- RMS Oi Unexpected Inv-003-EDGE
- NON_SELLABLE_QTY
- 14.0000
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 20