RMS Oi Inventory Ana Inventory (GTT)
Out of ScopeTechnical: RMS_OI_INV_ANA_INV_GTT | ID: OR-FND-RMS_OI_INV_ANA_INV_GTT-RMS_OI_INV_ANA_INV_GTT
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
Classification
- Object Type
- gtt
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_INV_ANA_INV_GTT
Field Definitions(5)
Rules & Considerations(37)
Sample Load Data(4)
| _scenario | LOC | ITEM | RTV_QTY | AVAIL_QTY | ITEM_DESC | AGG_DIFF_1 | AGG_DIFF_2 | AGG_DIFF_3 | AGG_DIFF_4 | CO_INBOUND | SESSION_ID | ITEM_PARENT | UNIT_RETAIL | ON_ORDER_QTY | ALC_ITEM_TYPE | ALLOC_INBOUND | CUSTOMER_RESV | PACK_COMP_EXP | PACK_COMP_SOH | STOCK_ON_HAND | ALLOC_OUTBOUND | FORECAST_SALES | IN_TRANSIT_QTY | PACK_COMP_RESV | PL_TSF_INBOUND | SALES_HIST_QTY | GROUPING_LOC_ID | NON_SELLABLE_QTY | PACK_COMP_INTRAN | TSF_EXPECTED_QTY | TSF_RESERVED_QTY | GROUPING_LOC_NAME | CUSTOMER_BACKORDER | FORECAST_SALES_HIST | PACK_COMP_CUST_BACK | PACK_COMP_CUST_RESV | PACK_COMP_NON_SELLABLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | 1 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 |
| default | 3 | RMS Oi Inv Ana Inv Gtt-00 | 12.5000 | 12.5000 | RMS Oi Inv Ana Inv Gtt-002-ALT | RMS Oi Inv | RMS Oi Inv | RMS Oi Inv | RMS Oi Inv | 12.5000 | 1000000003 | RMS Oi Inv Ana Inv Gtt-00 | 12.5000 | 12.5000 | RMS Oi Inv Ana | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | ALT-RMS_OI-002 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | RMS Oi Inv Ana Inv Gtt Secondary | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 |
| default | 5 | RMS Oi Inv Ana Inv Gtt-00 | 14.0000 | 14.0000 | RMS Oi Inv Ana Inv Gtt-003-EDGE | RMS Oi Inv | RMS Oi Inv | RMS Oi Inv | RMS Oi Inv | 14.0000 | 1000000005 | RMS Oi Inv Ana Inv Gtt-00 | 14.0000 | 14.0000 | RMS Oi Inv Ana | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | EDGE-RMS_OI-003 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | RMS Oi Inv Ana Inv Gtt Core | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- LOC
- 1
- ITEM
- SAMPLE
- RTV_QTY
- 1.0000
- AVAIL_QTY
- 1.0000
- ITEM_DESC
- SAMPLE
- AGG_DIFF_1
- SAMPLE
- AGG_DIFF_2
- SAMPLE
- AGG_DIFF_3
- SAMPLE
- AGG_DIFF_4
- SAMPLE
- CO_INBOUND
- 1.0000
- SESSION_ID
- 1
- ITEM_PARENT
- SAMPLE
- UNIT_RETAIL
- 1.0000
- ON_ORDER_QTY
- 1.0000
- ALC_ITEM_TYPE
- SAMPLE
- ALLOC_INBOUND
- 1.0000
- CUSTOMER_RESV
- 1.0000
- PACK_COMP_EXP
- 1.0000
- PACK_COMP_SOH
- 1.0000
- STOCK_ON_HAND
- 1.0000
- ALLOC_OUTBOUND
- 1.0000
- FORECAST_SALES
- 1.0000
- IN_TRANSIT_QTY
- 1.0000
- PACK_COMP_RESV
- 1.0000
- PL_TSF_INBOUND
- 1.0000
- SALES_HIST_QTY
- 1.0000
- GROUPING_LOC_ID
- SAMPLE
- NON_SELLABLE_QTY
- 1.0000
- PACK_COMP_INTRAN
- 1.0000
- TSF_EXPECTED_QTY
- 1.0000
- TSF_RESERVED_QTY
- 1.0000
- GROUPING_LOC_NAME
- SAMPLE
- CUSTOMER_BACKORDER
- 1.0000
- FORECAST_SALES_HIST
- 1.0000
- PACK_COMP_CUST_BACK
- 1.0000
- PACK_COMP_CUST_RESV
- 1.0000
- PACK_COMP_NON_SELLABLE
- 1.0000
default
- LOC
- 3
- ITEM
- RMS Oi Inv Ana Inv Gtt-00
- RTV_QTY
- 12.5000
- AVAIL_QTY
- 12.5000
- ITEM_DESC
- RMS Oi Inv Ana Inv Gtt-002-ALT
- AGG_DIFF_1
- RMS Oi Inv
- AGG_DIFF_2
- RMS Oi Inv
- AGG_DIFF_3
- RMS Oi Inv
- AGG_DIFF_4
- RMS Oi Inv
- CO_INBOUND
- 12.5000
- SESSION_ID
- 1000000003
- ITEM_PARENT
- RMS Oi Inv Ana Inv Gtt-00
- UNIT_RETAIL
- 12.5000
- ON_ORDER_QTY
- 12.5000
- ALC_ITEM_TYPE
- RMS Oi Inv Ana
- ALLOC_INBOUND
- 12.5000
- CUSTOMER_RESV
- 12.5000
- PACK_COMP_EXP
- 12.5000
- PACK_COMP_SOH
- 12.5000
- STOCK_ON_HAND
- 12.5000
- ALLOC_OUTBOUND
- 12.5000
- FORECAST_SALES
- 12.5000
- IN_TRANSIT_QTY
- 12.5000
- PACK_COMP_RESV
- 12.5000
- PL_TSF_INBOUND
- 12.5000
- SALES_HIST_QTY
- 12.5000
- GROUPING_LOC_ID
- ALT-RMS_OI-002
- NON_SELLABLE_QTY
- 12.5000
- PACK_COMP_INTRAN
- 12.5000
- TSF_EXPECTED_QTY
- 12.5000
- TSF_RESERVED_QTY
- 12.5000
- GROUPING_LOC_NAME
- RMS Oi Inv Ana Inv Gtt Secondary
- CUSTOMER_BACKORDER
- 12.5000
- FORECAST_SALES_HIST
- 12.5000
- PACK_COMP_CUST_BACK
- 12.5000
- PACK_COMP_CUST_RESV
- 12.5000
- PACK_COMP_NON_SELLABLE
- 12.5000
default
- LOC
- 5
- ITEM
- RMS Oi Inv Ana Inv Gtt-00
- RTV_QTY
- 14.0000
- AVAIL_QTY
- 14.0000
- ITEM_DESC
- RMS Oi Inv Ana Inv Gtt-003-EDGE
- AGG_DIFF_1
- RMS Oi Inv
- AGG_DIFF_2
- RMS Oi Inv
- AGG_DIFF_3
- RMS Oi Inv
- AGG_DIFF_4
- RMS Oi Inv
- CO_INBOUND
- 14.0000
- SESSION_ID
- 1000000005
- ITEM_PARENT
- RMS Oi Inv Ana Inv Gtt-00
- UNIT_RETAIL
- 14.0000
- ON_ORDER_QTY
- 14.0000
- ALC_ITEM_TYPE
- RMS Oi Inv Ana
- ALLOC_INBOUND
- 14.0000
- CUSTOMER_RESV
- 14.0000
- PACK_COMP_EXP
- 14.0000
- PACK_COMP_SOH
- 14.0000
- STOCK_ON_HAND
- 14.0000
- ALLOC_OUTBOUND
- 14.0000
- FORECAST_SALES
- 14.0000
- IN_TRANSIT_QTY
- 14.0000
- PACK_COMP_RESV
- 14.0000
- PL_TSF_INBOUND
- 14.0000
- SALES_HIST_QTY
- 14.0000
- GROUPING_LOC_ID
- EDGE-RMS_OI-003
- NON_SELLABLE_QTY
- 14.0000
- PACK_COMP_INTRAN
- 14.0000
- TSF_EXPECTED_QTY
- 14.0000
- TSF_RESERVED_QTY
- 14.0000
- GROUPING_LOC_NAME
- RMS Oi Inv Ana Inv Gtt Core
- CUSTOMER_BACKORDER
- 14.0000
- FORECAST_SALES_HIST
- 14.0000
- PACK_COMP_CUST_BACK
- 14.0000
- PACK_COMP_CUST_RESV
- 14.0000
- PACK_COMP_NON_SELLABLE
- 14.0000
Rule Validation Summary
- Source Rule Count
- 40
- Governed Rule Count
- 37