RMS Oi Unexpected Inventory (GTT)
Out of ScopeTechnical: RMS_OI_UNEXPECTED_INV_GTT | ID: OR-FND-RMS_OI_UNEXPECTED_INV_GTT-RMS_OI_UNEXPECTED_INV_GTT
This temporary helper table holds 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
- gtt
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_UNEXPECTED_INV_GTT
Field Definitions(5)
Rules & Considerations(14)
Sample Load Data(4)
| _scenario | LOC | ITEM | STATUS | LOC_NAME | LOC_TYPE | ITEM_DESC | RANGED_IND | SESSION_ID | ITEM_PARENT | RESERVED_QTY | STOCK_ON_HAND | UNEXPECTED_QTY | ITEM_PARENT_DESC | NON_SELLABLE_QTY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE | S | 1 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 |
| default | 3 | RMS Oi Unexpected Inv Gtt | P | RMS Oi Unexpected Inv Gtt Secondary | RMS Oi Unexpected Inv Gtt-002-ALT | RMS Oi Unexpected Inv Gtt-002-ALT | R | 1000000003 | RMS Oi Unexpected Inv Gtt | 12.5000 | 12.5000 | 12.5000 | RMS Oi Unexpected Inv Gtt-002-ALT | 12.5000 |
| default | 5 | RMS Oi Unexpected Inv Gtt | A | RMS Oi Unexpected Inv Gtt Core | RMS Oi Unexpected Inv Gtt-003-EDGE | RMS Oi Unexpected Inv Gtt-003-EDGE | R | 1000000005 | RMS Oi Unexpected Inv Gtt | 14.0000 | 14.0000 | 14.0000 | RMS Oi Unexpected Inv Gtt-003-EDGE | 14.0000 |
Example values from field definitions
- LOC
- 1
- ITEM
- SAMPLE
- STATUS
- S
- LOC_NAME
- SAMPLE
- LOC_TYPE
- SAMPLE
- ITEM_DESC
- SAMPLE
- RANGED_IND
- S
- SESSION_ID
- 1
- ITEM_PARENT
- SAMPLE
- RESERVED_QTY
- 1.0000
- STOCK_ON_HAND
- 1.0000
- UNEXPECTED_QTY
- 1.0000
- ITEM_PARENT_DESC
- SAMPLE
- NON_SELLABLE_QTY
- 1.0000
default
- LOC
- 3
- ITEM
- RMS Oi Unexpected Inv Gtt
- STATUS
- P
- LOC_NAME
- RMS Oi Unexpected Inv Gtt Secondary
- LOC_TYPE
- RMS Oi Unexpected Inv Gtt-002-ALT
- ITEM_DESC
- RMS Oi Unexpected Inv Gtt-002-ALT
- RANGED_IND
- R
- SESSION_ID
- 1000000003
- ITEM_PARENT
- RMS Oi Unexpected Inv Gtt
- RESERVED_QTY
- 12.5000
- STOCK_ON_HAND
- 12.5000
- UNEXPECTED_QTY
- 12.5000
- ITEM_PARENT_DESC
- RMS Oi Unexpected Inv Gtt-002-ALT
- NON_SELLABLE_QTY
- 12.5000
default
- LOC
- 5
- ITEM
- RMS Oi Unexpected Inv Gtt
- STATUS
- A
- LOC_NAME
- RMS Oi Unexpected Inv Gtt Core
- LOC_TYPE
- RMS Oi Unexpected Inv Gtt-003-EDGE
- ITEM_DESC
- RMS Oi Unexpected Inv Gtt-003-EDGE
- RANGED_IND
- R
- SESSION_ID
- 1000000005
- ITEM_PARENT
- RMS Oi Unexpected Inv Gtt
- RESERVED_QTY
- 14.0000
- STOCK_ON_HAND
- 14.0000
- UNEXPECTED_QTY
- 14.0000
- ITEM_PARENT_DESC
- RMS Oi Unexpected Inv Gtt-003-EDGE
- NON_SELLABLE_QTY
- 14.0000
Rule Validation Summary
- Source Rule Count
- 17
- Governed Rule Count
- 14