Svc Repl Roq Gtt
Out of ScopeTechnical: SVC_REPL_ROQ_GTT | ID: OR-MFCS-SVC_REPL_ROQ_GTT
Supports Oracle Retail Svc Repl Roq Gtt processing in SVC_REPL_ROQ_GTT.
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
- SVC_REPL_ROQ_GTT
Field Definitions(168)
Rules & Considerations(13)
Sample Load Data(4)
| _scenario | I_HI | I_TI | I_ASO | I_ESO | O_ASO | O_ESO | I_DATE | I_DEPT | I_ITEM | I_LOCN | I_BUYER | I_CLASS | I_DAY_1 | I_DAY_2 | I_DAY_3 | I_DAY_4 | I_DAY_5 | I_DAY_6 | I_DAY_7 | I_DUE_IND | O_DUE_IND | O_RTV_QTY | THREAD_ID | I_ALLOC_NO | I_INCR_PCT | I_ORDER_NO | I_PACK_IND | I_PHASE_ID | I_REPL_IND | I_SUBCLASS | O_ON_ORDER | I_DOMAIN_ID | I_LOCN_TYPE | I_MAX_STOCK | I_MIN_STOCK | I_PHASE_END | I_REPL_PACK | I_SEASON_ID | I_SOURCE_WH | I_STOCK_CAT | I_UNIT_COST | I_UOM_CLASS | O_ORDER_QTY | I_ALL_ORDERS | I_DEMO_STOCK | I_ITEM_LEVEL | I_PRES_STOCK | I_SO_DUE_IND | I_SO_TO_DATE | I_STORE_NEED | I_STORE_TYPE | I_TRAN_LEVEL | O_LOST_SALES | I_DELIV_CYCLE | I_ITEM_PARENT | I_ORDER_POINT | I_PHASE_START | I_REPL_METHOD | I_UNIT_RETAIL | O_ORDER_POINT | O_SS_FORECAST | O_SS_ON_ORDER | I_OPTIMIZE_IND | I_REVIEW_CYCLE | I_SO_FROM_DATE | I_SO_ORDER_ROQ | I_STANDARD_UOM | I_SUB_ITEM_LOC | I_WH_LEAD_TIME | O_ALLOC_IN_QTY | O_ISD_FORECAST | O_SAFETY_STOCK | O_TSF_RESV_QTY | O_TSH_FORECAST | I_ACTIVATE_DATE | I_PHYSICAL_LOCN | I_POOL_SUPPLIER | I_REPL_PACK_QTY | I_SERVICE_LEVEL | I_SUB_STOCK_IND | O_ALLOC_OUT_QTY | O_CUSTOMER_RESV | O_NET_INVENTORY | O_PACK_COMP_EXP | O_PACK_COMP_SOH | O_STOCK_ON_HAND | I_CONTAINER_ITEM | I_LEAD_LINKED_WH | I_STORE_ORD_MULT | I_SUPP_LEAD_TIME | I_SUPP_PACK_SIZE | I_TSF_PO_LINK_NO | O_CO_TSF_OUT_QTY | O_IN_TRANSIT_QTY | O_PACK_COMP_RESV | O_REVIEW_STD_DEV | I_DEACTIVATE_DATE | I_INNER_PACK_SIZE | I_MAX_SCALE_VALUE | I_MAX_SUPPLY_DAYS | I_MIN_SUPPLY_DAYS | I_NON_SCALING_IND | I_ORD_TEMP_SEQ_NO | I_REPL_ORDER_CTRL | I_SO_NO_FROM_DATE | I_SO_WF_NEED_DATE | I_SUB_ITEM_MASTER | I_TRUE_START_DATE | I_UOM_CONV_FACTOR | O_SS_ALLOC_IN_QTY | I_INV_SELLING_DAYS | I_ITEM_GRANDPARENT | I_LAST_REVIEW_DATE | I_NEXT_REVIEW_DATE | I_PICKUP_LEAD_TIME | I_REVIEW_LEAD_TIME | I_SUB_FORECAST_IND | I_SUP_DEPT_LVL_ORD | O_NON_SELLABLE_QTY | O_PACK_COMP_INTRAN | O_SS_ALLOC_OUT_QTY | O_SS_NET_INVENTORY | O_SS_PACK_COMP_EXP | O_TSF_EXPECTED_QTY | I_ADD_LEAD_TIME_IND | I_DEPOSIT_ITEM_TYPE | I_LOST_SALES_FACTOR | I_ORIGIN_COUNTRY_ID | I_ROUND_TO_CASE_PCT | I_STORE_USER_ACCESS | O_CURR_OLT_FORECAST | O_NEXT_OLT_FORECAST | O_ORDER_UP_TO_POINT | I_CURR_DELIVERY_DATE | I_DAYS_ADDED_TO_COLT | I_DAYS_ADDED_TO_NOLT | I_DRC_STORE_ORD_MULT | I_DUE_ORD_SERV_BASIS | I_LAST_DELIVERY_DATE | I_NEXT_DELIVERY_DATE | I_ROUND_TO_INNER_PCT | I_SERVICE_LEVEL_TYPE | I_SOURCE_PHYSICAL_WH | I_TERMINAL_STOCK_QTY | I_WH_DELIVERY_POLICY | O_CUSTOMER_BACKORDER | O_NO_ROUND_ORDER_QTY | I_DUE_ORD_PROCESS_IND | I_LAST_RUN_OF_THE_DAY | I_ROUND_TO_PALLET_PCT | I_SUP_DELIVERY_POLICY | I_TIME_SUPPLY_HORIZON | O_PACK_COMP_CUST_BACK | O_PACK_COMP_CUST_RESV | O_SS_TSF_EXPECTED_QTY | I_CURR_ORDER_LEAD_TIME | I_NEXT_ORDER_LEAD_TIME | I_REJECT_STORE_ORD_IND | I_REPL_RESULTS_ALL_IND | I_SO_WF_NOT_AFTER_DATE | O_REVIEW_TIME_FORECAST | I_ADDITIONAL_DEMAND_QTY | I_PRIMARY_REPL_SUPPLIER | O_IN_PROGRESS_SALES_QTY | O_PACK_COMP_NON_SELLABLE | O_MAX_SUPPLY_DAYS_FORECAST | O_MIN_SUPPLY_DAYS_FORECAST | I_INCLUDE_ADDITIONAL_DEMAND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 | 1001 | Svc Repl Roq Gtt-001 | 1 | 0001 | 1101 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | Svc Repl Roq Gtt-001 | Y | 11.0000 | 1000000001 | 2 | 11.0000 | 2 | Svc Repl Roq Gtt-001 | 100001 | Svc Repl Roq Gtt-001 | 1111 | 11.0000 | 100001 | Svc Repl Roq Gtt-001 | 11.0000 | 11.0000 | 2026-01-06 | Svc Repl Roq Gtt-001 | 100001 | 9001 | Cross | 11.0000 | Svc Repl Roq Gtt-001 | 11.0000 | N | 11.0000 | 1 | 11.0000 | Svc Repl Roq Gtt-001 | 2026-01-01 | 11.0000 | F | 1 | 11.0000 | Svc Repl Roq Gtt-001 | Svc Repl Roq Gtt-001 | 11.0000 | 2026-01-06 | Svc Repl Roq Gtt-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | Svc Repl Roq Gtt-001 | Svc Repl Roq Gtt-001 | 2026-01-01 | 11.0000 | Svc Repl Roq Gtt-001 | 1 | 0001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 | 1 | 1 | 11.0000 | 11.00 | Svc Repl Roq Gtt-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | Svc Repl Roq Gtt-001 | 9001 | Svc Repl Roq Gtt-001 | 0001 | 11.0000 | 2 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 | 11.0000 | 11.0000 | 001 | 001 | Svc Repl Roq Gtt-001 | 2 | table | 2026-01-01 | 2026-01-01 | Svc Repl Roq Gtt-001 | 2026-01-01 | 11.0000 | 11.0000 | 001 | Svc Repl Roq Gtt-001 | 2026-01-01 | 2026-01-01 | 0001 | 0001 | Y | Svc Repl Roq Gtt-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | Svc Repl Roq Gtt-001 | Svc Repl Roq Gtt-001 | 11.00 | STD-SVC_REPL-001 | 11.0000 | RES | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 | 001 | 001 | used | C | 2026-01-01 | 2026-01-01 | 11.0000 | Svc Repl Roq Gtt-001 | 9001 | 11.0000 | Svc Repl Roq Gtt-001 | 11.0000 | 11.0000 | Y | Svc Repl Roq Gtt-001 | 11.0000 | Svc Repl Roq Gtt-001 | 001 | 11.0000 | 11.0000 | 11.0000 | 00001 | 00001 | Svc Repl Roq Gtt-001 | Svc Repl Roq Gtt-001 | 2026-01-01 | 11.0000 | 11.0000 | 1 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | Svc Repl Roq Gtt-001 |
default
- I_HI
- 11.0000
- I_TI
- 11.0000
- I_ASO
- 11.0000
- I_ESO
- 11.0000
- O_ASO
- 11.0000
- O_ESO
- 11.0000
- I_DATE
- 2026-01-01
- I_DEPT
- 1001
- I_ITEM
- Svc Repl Roq Gtt-001
- I_LOCN
- 1
- I_BUYER
- 0001
- I_CLASS
- 1101
- I_DAY_1
- 1
- I_DAY_2
- 1
- I_DAY_3
- 1
- I_DAY_4
- 1
- I_DAY_5
- 1
- I_DAY_6
- 1
- I_DAY_7
- 1
- I_DUE_IND
- Svc Repl Roq Gtt-001
- O_DUE_IND
- Y
- O_RTV_QTY
- 11.0000
- THREAD_ID
- 1000000001
- I_ALLOC_NO
- 2
- I_INCR_PCT
- 11.0000
- I_ORDER_NO
- 2
- I_PACK_IND
- Svc Repl Roq Gtt-001
- I_PHASE_ID
- 100001
- I_REPL_IND
- Svc Repl Roq Gtt-001
- I_SUBCLASS
- 1111
- O_ON_ORDER
- 11.0000
- I_DOMAIN_ID
- 100001
- I_LOCN_TYPE
- Svc Repl Roq Gtt-001
- I_MAX_STOCK
- 11.0000
- I_MIN_STOCK
- 11.0000
- I_PHASE_END
- 2026-01-06
- I_REPL_PACK
- Svc Repl Roq Gtt-001
- I_SEASON_ID
- 100001
- I_SOURCE_WH
- 9001
- I_STOCK_CAT
- Cross
- I_UNIT_COST
- 11.0000
- I_UOM_CLASS
- Svc Repl Roq Gtt-001
- O_ORDER_QTY
- 11.0000
- I_ALL_ORDERS
- N
- I_DEMO_STOCK
- 11.0000
- I_ITEM_LEVEL
- 1
- I_PRES_STOCK
- 11.0000
- I_SO_DUE_IND
- Svc Repl Roq Gtt-001
- I_SO_TO_DATE
- 2026-01-01
- I_STORE_NEED
- 11.0000
- I_STORE_TYPE
- F
- I_TRAN_LEVEL
- 1
- O_LOST_SALES
- 11.0000
- I_DELIV_CYCLE
- Svc Repl Roq Gtt-001
- I_ITEM_PARENT
- Svc Repl Roq Gtt-001
- I_ORDER_POINT
- 11.0000
- I_PHASE_START
- 2026-01-06
- I_REPL_METHOD
- Svc Repl Roq Gtt-001
- I_UNIT_RETAIL
- 11.0000
- O_ORDER_POINT
- 11.0000
- O_SS_FORECAST
- 11.0000
- O_SS_ON_ORDER
- 11.0000
- I_OPTIMIZE_IND
- Svc Repl Roq Gtt-001
- I_REVIEW_CYCLE
- Svc Repl Roq Gtt-001
- I_SO_FROM_DATE
- 2026-01-01
- I_SO_ORDER_ROQ
- 11.0000
- I_STANDARD_UOM
- Svc Repl Roq Gtt-001
- I_SUB_ITEM_LOC
- 1
- I_WH_LEAD_TIME
- 0001
- O_ALLOC_IN_QTY
- 11.0000
- O_ISD_FORECAST
- 11.0000
- O_SAFETY_STOCK
- 11.0000
- O_TSF_RESV_QTY
- 11.0000
- O_TSH_FORECAST
- 11.0000
- I_ACTIVATE_DATE
- 2026-01-01
- I_PHYSICAL_LOCN
- 1
- I_POOL_SUPPLIER
- 1
- I_REPL_PACK_QTY
- 11.0000
- I_SERVICE_LEVEL
- 11.00
- I_SUB_STOCK_IND
- Svc Repl Roq Gtt-001
- O_ALLOC_OUT_QTY
- 11.0000
- O_CUSTOMER_RESV
- 11.0000
- O_NET_INVENTORY
- 11.0000
- O_PACK_COMP_EXP
- 11.0000
- O_PACK_COMP_SOH
- 11.0000
- O_STOCK_ON_HAND
- 11.0000
- I_CONTAINER_ITEM
- Svc Repl Roq Gtt-001
- I_LEAD_LINKED_WH
- 9001
- I_STORE_ORD_MULT
- Svc Repl Roq Gtt-001
- I_SUPP_LEAD_TIME
- 0001
- I_SUPP_PACK_SIZE
- 11.0000
- I_TSF_PO_LINK_NO
- 2
- O_CO_TSF_OUT_QTY
- 11.0000
- O_IN_TRANSIT_QTY
- 11.0000
- O_PACK_COMP_RESV
- 11.0000
- O_REVIEW_STD_DEV
- 11.0000
- I_DEACTIVATE_DATE
- 2026-01-01
- I_INNER_PACK_SIZE
- 11.0000
- I_MAX_SCALE_VALUE
- 11.0000
- I_MAX_SUPPLY_DAYS
- 001
- I_MIN_SUPPLY_DAYS
- 001
- I_NON_SCALING_IND
- Svc Repl Roq Gtt-001
- I_ORD_TEMP_SEQ_NO
- 2
- I_REPL_ORDER_CTRL
- table
- I_SO_NO_FROM_DATE
- 2026-01-01
- I_SO_WF_NEED_DATE
- 2026-01-01
- I_SUB_ITEM_MASTER
- Svc Repl Roq Gtt-001
- I_TRUE_START_DATE
- 2026-01-01
- I_UOM_CONV_FACTOR
- 11.0000
- O_SS_ALLOC_IN_QTY
- 11.0000
- I_INV_SELLING_DAYS
- 001
- I_ITEM_GRANDPARENT
- Svc Repl Roq Gtt-001
- I_LAST_REVIEW_DATE
- 2026-01-01
- I_NEXT_REVIEW_DATE
- 2026-01-01
- I_PICKUP_LEAD_TIME
- 0001
- I_REVIEW_LEAD_TIME
- 0001
- I_SUB_FORECAST_IND
- Y
- I_SUP_DEPT_LVL_ORD
- Svc Repl Roq Gtt-001
- O_NON_SELLABLE_QTY
- 11.0000
- O_PACK_COMP_INTRAN
- 11.0000
- O_SS_ALLOC_OUT_QTY
- 11.0000
- O_SS_NET_INVENTORY
- 11.0000
- O_SS_PACK_COMP_EXP
- 11.0000
- O_TSF_EXPECTED_QTY
- 11.0000
- I_ADD_LEAD_TIME_IND
- Svc Repl Roq Gtt-001
- I_DEPOSIT_ITEM_TYPE
- Svc Repl Roq Gtt-001
- I_LOST_SALES_FACTOR
- 11.00
- I_ORIGIN_COUNTRY_ID
- STD-SVC_REPL-001
- I_ROUND_TO_CASE_PCT
- 11.0000
- I_STORE_USER_ACCESS
- RES
- O_CURR_OLT_FORECAST
- 11.0000
- O_NEXT_OLT_FORECAST
- 11.0000
- O_ORDER_UP_TO_POINT
- 11.0000
- I_CURR_DELIVERY_DATE
- 2026-01-01
- I_DAYS_ADDED_TO_COLT
- 001
- I_DAYS_ADDED_TO_NOLT
- 001
- I_DRC_STORE_ORD_MULT
- used
- I_DUE_ORD_SERV_BASIS
- C
- I_LAST_DELIVERY_DATE
- 2026-01-01
- I_NEXT_DELIVERY_DATE
- 2026-01-01
- I_ROUND_TO_INNER_PCT
- 11.0000
- I_SERVICE_LEVEL_TYPE
- Svc Repl Roq Gtt-001
- I_SOURCE_PHYSICAL_WH
- 9001
- I_TERMINAL_STOCK_QTY
- 11.0000
- I_WH_DELIVERY_POLICY
- Svc Repl Roq Gtt-001
- O_CUSTOMER_BACKORDER
- 11.0000
- O_NO_ROUND_ORDER_QTY
- 11.0000
- I_DUE_ORD_PROCESS_IND
- Y
- I_LAST_RUN_OF_THE_DAY
- Svc Repl Roq Gtt-001
- I_ROUND_TO_PALLET_PCT
- 11.0000
- I_SUP_DELIVERY_POLICY
- Svc Repl Roq Gtt-001
- I_TIME_SUPPLY_HORIZON
- 001
- O_PACK_COMP_CUST_BACK
- 11.0000
- O_PACK_COMP_CUST_RESV
- 11.0000
- O_SS_TSF_EXPECTED_QTY
- 11.0000
- I_CURR_ORDER_LEAD_TIME
- 00001
- I_NEXT_ORDER_LEAD_TIME
- 00001
- I_REJECT_STORE_ORD_IND
- Svc Repl Roq Gtt-001
- I_REPL_RESULTS_ALL_IND
- Svc Repl Roq Gtt-001
- I_SO_WF_NOT_AFTER_DATE
- 2026-01-01
- O_REVIEW_TIME_FORECAST
- 11.0000
- I_ADDITIONAL_DEMAND_QTY
- 11.0000
- I_PRIMARY_REPL_SUPPLIER
- 1
- O_IN_PROGRESS_SALES_QTY
- 11.0000
- O_PACK_COMP_NON_SELLABLE
- 11.0000
- O_MAX_SUPPLY_DAYS_FORECAST
- 11.0000
- O_MIN_SUPPLY_DAYS_FORECAST
- 11.0000
- I_INCLUDE_ADDITIONAL_DEMAND
- Svc Repl Roq Gtt-001