Replenishment Roq (Service Layer GTT)

Out of Scope

Technical: SVC_REPL_ROQ_GTT | ID: OR-FND-SVC_REPL_ROQ_GTT-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

Classification

Object Type
gtt

Target Structure

Load Approach
Table
Target Objects
SVC_REPL_ROQ_GTT

Field Definitions(5)

Rules & Considerations(152)

Sample Load Data(4)

Example values from field definitions

I_HI
1.0000
I_TI
1.0000
I_ASO
1.0000
I_ESO
1.0000
O_ASO
1.0000
O_ESO
1.0000
I_DATE
2026-01-01
I_DEPT
1
I_ITEM
SAMPLE
I_LOCN
1
I_BUYER
1
I_CLASS
1
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
S
O_DUE_IND
S
O_RTV_QTY
1.0000
THREAD_ID
1
I_ALLOC_NO
1
I_INCR_PCT
1.0000
I_ORDER_NO
1
I_PACK_IND
S
I_PHASE_ID
1
I_REPL_IND
S
I_SUBCLASS
1
O_ON_ORDER
1.0000
I_DOMAIN_ID
1
I_LOCN_TYPE
SAMPLE
I_MAX_STOCK
1.0000
I_MIN_STOCK
1.0000
I_PHASE_END
2026-01-01
I_REPL_PACK
SAMPLE
I_SEASON_ID
1
I_SOURCE_WH
1
I_STOCK_CAT
SAMPLE
I_UNIT_COST
1.0000
I_UOM_CLASS
SAMPLE
O_ORDER_QTY
1.0000
I_ALL_ORDERS
S
I_DEMO_STOCK
1.0000
I_ITEM_LEVEL
1
I_PRES_STOCK
1.0000
I_SO_DUE_IND
S
I_SO_TO_DATE
2026-01-01
I_STORE_NEED
1.0000
I_STORE_TYPE
SAMPLE
I_TRAN_LEVEL
1
O_LOST_SALES
1.0000
I_DELIV_CYCLE
SAMPLE
I_ITEM_PARENT
SAMPLE
I_ORDER_POINT
1.0000
I_PHASE_START
2026-01-01
I_REPL_METHOD
SAMPLE
I_UNIT_RETAIL
1.0000
O_ORDER_POINT
1.0000
O_SS_FORECAST
1.0000
O_SS_ON_ORDER
1.0000
I_OPTIMIZE_IND
S
I_REVIEW_CYCLE
SAMPLE
I_SO_FROM_DATE
2026-01-01
I_SO_ORDER_ROQ
1.0000
I_STANDARD_UOM
SAMP
I_SUB_ITEM_LOC
1
I_WH_LEAD_TIME
1
O_ALLOC_IN_QTY
1.0000
O_ISD_FORECAST
1.0000
O_SAFETY_STOCK
1.0000
O_TSF_RESV_QTY
1.0000
O_TSH_FORECAST
1.0000
I_ACTIVATE_DATE
2026-01-01
I_PHYSICAL_LOCN
1
I_POOL_SUPPLIER
1
I_REPL_PACK_QTY
1.0000
I_SERVICE_LEVEL
1.00
I_SUB_STOCK_IND
S
O_ALLOC_OUT_QTY
1.0000
O_CUSTOMER_RESV
1.0000
O_NET_INVENTORY
1.0000
O_PACK_COMP_EXP
1.0000
O_PACK_COMP_SOH
1.0000
O_STOCK_ON_HAND
1.0000
I_CONTAINER_ITEM
SAMPLE
I_LEAD_LINKED_WH
1
I_STORE_ORD_MULT
S
I_SUPP_LEAD_TIME
1
I_SUPP_PACK_SIZE
1.0000
I_TSF_PO_LINK_NO
1
O_CO_TSF_OUT_QTY
1.0000
O_IN_TRANSIT_QTY
1.0000
O_PACK_COMP_RESV
1.0000
O_REVIEW_STD_DEV
1.0000
I_DEACTIVATE_DATE
2026-01-01
I_INNER_PACK_SIZE
1.0000
I_MAX_SCALE_VALUE
1.0000
I_MAX_SUPPLY_DAYS
1
I_MIN_SUPPLY_DAYS
1
I_NON_SCALING_IND
S
I_ORD_TEMP_SEQ_NO
1
I_REPL_ORDER_CTRL
SAMPLE
I_SO_NO_FROM_DATE
2026-01-01
I_SO_WF_NEED_DATE
2026-01-01
I_SUB_ITEM_MASTER
SAMPLE
I_TRUE_START_DATE
2026-01-01
I_UOM_CONV_FACTOR
1.0000000000
O_SS_ALLOC_IN_QTY
1.0000
I_INV_SELLING_DAYS
1
I_ITEM_GRANDPARENT
SAMPLE
I_LAST_REVIEW_DATE
2026-01-01
I_NEXT_REVIEW_DATE
2026-01-01
I_PICKUP_LEAD_TIME
1
I_REVIEW_LEAD_TIME
1
I_SUB_FORECAST_IND
S
I_SUP_DEPT_LVL_ORD
SAMPLE
O_NON_SELLABLE_QTY
1.0000
O_PACK_COMP_INTRAN
1.0000
O_SS_ALLOC_OUT_QTY
1.0000
O_SS_NET_INVENTORY
1.0000
O_SS_PACK_COMP_EXP
1.0000
O_TSF_EXPECTED_QTY
1.0000
I_ADD_LEAD_TIME_IND
S
I_DEPOSIT_ITEM_TYPE
SAMPLE
I_LOST_SALES_FACTOR
1.00
I_ORIGIN_COUNTRY_ID
SAM
I_ROUND_TO_CASE_PCT
1.0000
I_STORE_USER_ACCESS
SAMPLE
O_CURR_OLT_FORECAST
1.0000
O_NEXT_OLT_FORECAST
1.0000
O_ORDER_UP_TO_POINT
1.0000
I_CURR_DELIVERY_DATE
2026-01-01
I_DAYS_ADDED_TO_COLT
1
I_DAYS_ADDED_TO_NOLT
1
I_DRC_STORE_ORD_MULT
S
I_DUE_ORD_SERV_BASIS
SAMPLE
I_LAST_DELIVERY_DATE
2026-01-01
I_NEXT_DELIVERY_DATE
2026-01-01
I_ROUND_TO_INNER_PCT
1.0000
I_SERVICE_LEVEL_TYPE
SA
I_SOURCE_PHYSICAL_WH
1
I_TERMINAL_STOCK_QTY
1.0000
I_WH_DELIVERY_POLICY
SAMPLE
O_CUSTOMER_BACKORDER
1.0000
O_NO_ROUND_ORDER_QTY
1.0000
I_DUE_ORD_PROCESS_IND
S
I_LAST_RUN_OF_THE_DAY
S
I_ROUND_TO_PALLET_PCT
1.0000
I_SUP_DELIVERY_POLICY
SAMPLE
I_TIME_SUPPLY_HORIZON
1
O_PACK_COMP_CUST_BACK
1.0000
O_PACK_COMP_CUST_RESV
1.0000
O_SS_TSF_EXPECTED_QTY
1.0000
I_CURR_ORDER_LEAD_TIME
1
I_NEXT_ORDER_LEAD_TIME
1
I_REJECT_STORE_ORD_IND
S
I_REPL_RESULTS_ALL_IND
S
I_SO_WF_NOT_AFTER_DATE
2026-01-01
O_REVIEW_TIME_FORECAST
1.0000
I_ADDITIONAL_DEMAND_QTY
1.0000
I_PRIMARY_REPL_SUPPLIER
1
O_IN_PROGRESS_SALES_QTY
1.0000
O_PACK_COMP_NON_SELLABLE
1.0000
O_MAX_SUPPLY_DAYS_FORECAST
1.0000
O_MIN_SUPPLY_DAYS_FORECAST
1.0000
I_INCLUDE_ADDITIONAL_DEMAND
S

default

I_HI
12.5000
I_TI
12.5000
I_ASO
12.5000
I_ESO
12.5000
O_ASO
12.5000
O_ESO
12.5000
I_DATE
2026-01-03
I_DEPT
1003
I_ITEM
Svc Repl Roq Gtt-002-ALT
I_LOCN
3
I_BUYER
3
I_CLASS
1103
I_DAY_1
3
I_DAY_2
3
I_DAY_3
3
I_DAY_4
3
I_DAY_5
3
I_DAY_6
3
I_DAY_7
3
I_DUE_IND
S
O_DUE_IND
N
O_RTV_QTY
12.5000
THREAD_ID
1000000003
I_ALLOC_NO
4
I_INCR_PCT
12.5000
I_ORDER_NO
4
I_PACK_IND
S
I_PHASE_ID
100003
I_REPL_IND
S
I_SUBCLASS
1113
O_ON_ORDER
12.5000
I_DOMAIN_ID
100003
I_LOCN_TYPE
Svc Re
I_MAX_STOCK
12.5000
I_MIN_STOCK
12.5000
I_PHASE_END
2026-02-09
I_REPL_PACK
Svc Repl Roq Gtt-002-ALT
I_SEASON_ID
100003
I_SOURCE_WH
9003
I_STOCK_CAT
L
I_UNIT_COST
12.5000
I_UOM_CLASS
Svc Re
O_ORDER_QTY
12.5000
I_ALL_ORDERS
N
I_DEMO_STOCK
12.5000
I_ITEM_LEVEL
3
I_PRES_STOCK
12.5000
I_SO_DUE_IND
S
I_SO_TO_DATE
2026-01-03
I_STORE_NEED
12.5000
I_STORE_TYPE
C
I_TRAN_LEVEL
3
O_LOST_SALES
12.5000
I_DELIV_CYCLE
Svc Re
I_ITEM_PARENT
Svc Repl Roq Gtt-002-ALT
I_ORDER_POINT
12.5000
I_PHASE_START
2026-02-09
I_REPL_METHOD
Svc Re
I_UNIT_RETAIL
12.5000
O_ORDER_POINT
12.5000
O_SS_FORECAST
12.5000
O_SS_ON_ORDER
12.5000
I_OPTIMIZE_IND
S
I_REVIEW_CYCLE
Svc Re
I_SO_FROM_DATE
2026-01-03
I_SO_ORDER_ROQ
12.5000
I_STANDARD_UOM
Svc
I_SUB_ITEM_LOC
3
I_WH_LEAD_TIME
3
O_ALLOC_IN_QTY
12.5000
O_ISD_FORECAST
12.5000
O_SAFETY_STOCK
12.5000
O_TSF_RESV_QTY
12.5000
O_TSH_FORECAST
12.5000
I_ACTIVATE_DATE
2026-01-03
I_PHYSICAL_LOCN
3
I_POOL_SUPPLIER
3
I_REPL_PACK_QTY
12.5000
I_SERVICE_LEVEL
12.50
I_SUB_STOCK_IND
S
O_ALLOC_OUT_QTY
12.5000
O_CUSTOMER_RESV
12.5000
O_NET_INVENTORY
12.5000
O_PACK_COMP_EXP
12.5000
O_PACK_COMP_SOH
12.5000
O_STOCK_ON_HAND
12.5000
I_CONTAINER_ITEM
Svc Repl Roq Gtt-002-ALT
I_LEAD_LINKED_WH
9003
I_STORE_ORD_MULT
S
I_SUPP_LEAD_TIME
3
I_SUPP_PACK_SIZE
12.5000
I_TSF_PO_LINK_NO
4
O_CO_TSF_OUT_QTY
12.5000
O_IN_TRANSIT_QTY
12.5000
O_PACK_COMP_RESV
12.5000
O_REVIEW_STD_DEV
12.5000
I_DEACTIVATE_DATE
2026-01-03
I_INNER_PACK_SIZE
12.5000
I_MAX_SCALE_VALUE
12.5000
I_MAX_SUPPLY_DAYS
3
I_MIN_SUPPLY_DAYS
3
I_NON_SCALING_IND
S
I_ORD_TEMP_SEQ_NO
4
I_REPL_ORDER_CTRL
Semi
I_SO_NO_FROM_DATE
2026-01-03
I_SO_WF_NEED_DATE
2026-01-03
I_SUB_ITEM_MASTER
Svc Repl Roq Gtt-002-ALT
I_TRUE_START_DATE
2026-01-03
I_UOM_CONV_FACTOR
12.5000000000
O_SS_ALLOC_IN_QTY
12.5000
I_INV_SELLING_DAYS
3
I_ITEM_GRANDPARENT
Svc Repl Roq Gtt-002-ALT
I_LAST_REVIEW_DATE
2026-01-03
I_NEXT_REVIEW_DATE
2026-01-03
I_PICKUP_LEAD_TIME
3
I_REVIEW_LEAD_TIME
3
I_SUB_FORECAST_IND
N
I_SUP_DEPT_LVL_ORD
Svc Re
O_NON_SELLABLE_QTY
12.5000
O_PACK_COMP_INTRAN
12.5000
O_SS_ALLOC_OUT_QTY
12.5000
O_SS_NET_INVENTORY
12.5000
O_SS_PACK_COMP_EXP
12.5000
O_TSF_EXPECTED_QTY
12.5000
I_ADD_LEAD_TIME_IND
S
I_DEPOSIT_ITEM_TYPE
Svc Re
I_LOST_SALES_FACTOR
12.50
I_ORIGIN_COUNTRY_ID
ALT
I_ROUND_TO_CASE_PCT
12.5000
I_STORE_USER_ACCESS
REV
O_CURR_OLT_FORECAST
12.5000
O_NEXT_OLT_FORECAST
12.5000
O_ORDER_UP_TO_POINT
12.5000
I_CURR_DELIVERY_DATE
2026-01-03
I_DAYS_ADDED_TO_COLT
3
I_DAYS_ADDED_TO_NOLT
3
I_DRC_STORE_ORD_MULT
u
I_DUE_ORD_SERV_BASIS
U
I_LAST_DELIVERY_DATE
2026-01-03
I_NEXT_DELIVERY_DATE
2026-01-03
I_ROUND_TO_INNER_PCT
12.5000
I_SERVICE_LEVEL_TYPE
Sv
I_SOURCE_PHYSICAL_WH
9003
I_TERMINAL_STOCK_QTY
12.5000
I_WH_DELIVERY_POLICY
Svc Re
O_CUSTOMER_BACKORDER
12.5000
O_NO_ROUND_ORDER_QTY
12.5000
I_DUE_ORD_PROCESS_IND
N
I_LAST_RUN_OF_THE_DAY
S
I_ROUND_TO_PALLET_PCT
12.5000
I_SUP_DELIVERY_POLICY
Svc Re
I_TIME_SUPPLY_HORIZON
3
O_PACK_COMP_CUST_BACK
12.5000
O_PACK_COMP_CUST_RESV
12.5000
O_SS_TSF_EXPECTED_QTY
12.5000
I_CURR_ORDER_LEAD_TIME
3
I_NEXT_ORDER_LEAD_TIME
3
I_REJECT_STORE_ORD_IND
S
I_REPL_RESULTS_ALL_IND
S
I_SO_WF_NOT_AFTER_DATE
2026-01-03
O_REVIEW_TIME_FORECAST
12.5000
I_ADDITIONAL_DEMAND_QTY
12.5000
I_PRIMARY_REPL_SUPPLIER
3
O_IN_PROGRESS_SALES_QTY
12.5000
O_PACK_COMP_NON_SELLABLE
12.5000
O_MAX_SUPPLY_DAYS_FORECAST
12.5000
O_MIN_SUPPLY_DAYS_FORECAST
12.5000
I_INCLUDE_ADDITIONAL_DEMAND
S

default

I_HI
14.0000
I_TI
14.0000
I_ASO
14.0000
I_ESO
14.0000
O_ASO
14.0000
O_ESO
14.0000
I_DATE
2026-01-05
I_DEPT
1005
I_ITEM
Svc Repl Roq Gtt-003-EDGE
I_LOCN
5
I_BUYER
5
I_CLASS
1105
I_DAY_1
5
I_DAY_2
5
I_DAY_3
5
I_DAY_4
5
I_DAY_5
5
I_DAY_6
5
I_DAY_7
5
I_DUE_IND
S
O_DUE_IND
Y
O_RTV_QTY
14.0000
THREAD_ID
1000000005
I_ALLOC_NO
6
I_INCR_PCT
14.0000
I_ORDER_NO
6
I_PACK_IND
S
I_PHASE_ID
100005
I_REPL_IND
S
I_SUBCLASS
1115
O_ON_ORDER
14.0000
I_DOMAIN_ID
100005
I_LOCN_TYPE
Svc Re
I_MAX_STOCK
14.0000
I_MIN_STOCK
14.0000
I_PHASE_END
2026-03-12
I_REPL_PACK
Svc Repl Roq Gtt-003-EDGE
I_SEASON_ID
100005
I_SOURCE_WH
9005
I_STOCK_CAT
Cross
I_UNIT_COST
14.0000
I_UOM_CLASS
Svc Re
O_ORDER_QTY
14.0000
I_ALL_ORDERS
N
I_DEMO_STOCK
14.0000
I_ITEM_LEVEL
5
I_PRES_STOCK
14.0000
I_SO_DUE_IND
S
I_SO_TO_DATE
2026-01-05
I_STORE_NEED
14.0000
I_STORE_TYPE
F
I_TRAN_LEVEL
5
O_LOST_SALES
14.0000
I_DELIV_CYCLE
Svc Re
I_ITEM_PARENT
Svc Repl Roq Gtt-003-EDGE
I_ORDER_POINT
14.0000
I_PHASE_START
2026-03-12
I_REPL_METHOD
Svc Re
I_UNIT_RETAIL
14.0000
O_ORDER_POINT
14.0000
O_SS_FORECAST
14.0000
O_SS_ON_ORDER
14.0000
I_OPTIMIZE_IND
S
I_REVIEW_CYCLE
Svc Re
I_SO_FROM_DATE
2026-01-05
I_SO_ORDER_ROQ
14.0000
I_STANDARD_UOM
Svc
I_SUB_ITEM_LOC
5
I_WH_LEAD_TIME
5
O_ALLOC_IN_QTY
14.0000
O_ISD_FORECAST
14.0000
O_SAFETY_STOCK
14.0000
O_TSF_RESV_QTY
14.0000
O_TSH_FORECAST
14.0000
I_ACTIVATE_DATE
2026-01-05
I_PHYSICAL_LOCN
5
I_POOL_SUPPLIER
5
I_REPL_PACK_QTY
14.0000
I_SERVICE_LEVEL
14.00
I_SUB_STOCK_IND
S
O_ALLOC_OUT_QTY
14.0000
O_CUSTOMER_RESV
14.0000
O_NET_INVENTORY
14.0000
O_PACK_COMP_EXP
14.0000
O_PACK_COMP_SOH
14.0000
O_STOCK_ON_HAND
14.0000
I_CONTAINER_ITEM
Svc Repl Roq Gtt-003-EDGE
I_LEAD_LINKED_WH
9005
I_STORE_ORD_MULT
S
I_SUPP_LEAD_TIME
5
I_SUPP_PACK_SIZE
14.0000
I_TSF_PO_LINK_NO
6
O_CO_TSF_OUT_QTY
14.0000
O_IN_TRANSIT_QTY
14.0000
O_PACK_COMP_RESV
14.0000
O_REVIEW_STD_DEV
14.0000
I_DEACTIVATE_DATE
2026-01-05
I_INNER_PACK_SIZE
14.0000
I_MAX_SCALE_VALUE
14.0000
I_MAX_SUPPLY_DAYS
5
I_MIN_SUPPLY_DAYS
5
I_NON_SCALING_IND
S
I_ORD_TEMP_SEQ_NO
6
I_REPL_ORDER_CTRL
create
I_SO_NO_FROM_DATE
2026-01-05
I_SO_WF_NEED_DATE
2026-01-05
I_SUB_ITEM_MASTER
Svc Repl Roq Gtt-003-EDGE
I_TRUE_START_DATE
2026-01-05
I_UOM_CONV_FACTOR
14.0000000000
O_SS_ALLOC_IN_QTY
14.0000
I_INV_SELLING_DAYS
5
I_ITEM_GRANDPARENT
Svc Repl Roq Gtt-003-EDGE
I_LAST_REVIEW_DATE
2026-01-05
I_NEXT_REVIEW_DATE
2026-01-05
I_PICKUP_LEAD_TIME
5
I_REVIEW_LEAD_TIME
5
I_SUB_FORECAST_IND
Y
I_SUP_DEPT_LVL_ORD
Svc Re
O_NON_SELLABLE_QTY
14.0000
O_PACK_COMP_INTRAN
14.0000
O_SS_ALLOC_OUT_QTY
14.0000
O_SS_NET_INVENTORY
14.0000
O_SS_PACK_COMP_EXP
14.0000
O_TSF_EXPECTED_QTY
14.0000
I_ADD_LEAD_TIME_IND
S
I_DEPOSIT_ITEM_TYPE
Svc Re
I_LOST_SALES_FACTOR
14.00
I_ORIGIN_COUNTRY_ID
EDG
I_ROUND_TO_CASE_PCT
14.0000
I_STORE_USER_ACCESS
APRV
O_CURR_OLT_FORECAST
14.0000
O_NEXT_OLT_FORECAST
14.0000
O_ORDER_UP_TO_POINT
14.0000
I_CURR_DELIVERY_DATE
2026-01-05
I_DAYS_ADDED_TO_COLT
5
I_DAYS_ADDED_TO_NOLT
5
I_DRC_STORE_ORD_MULT
u
I_DUE_ORD_SERV_BASIS
C
I_LAST_DELIVERY_DATE
2026-01-05
I_NEXT_DELIVERY_DATE
2026-01-05
I_ROUND_TO_INNER_PCT
14.0000
I_SERVICE_LEVEL_TYPE
Sv
I_SOURCE_PHYSICAL_WH
9005
I_TERMINAL_STOCK_QTY
14.0000
I_WH_DELIVERY_POLICY
Svc Re
O_CUSTOMER_BACKORDER
14.0000
O_NO_ROUND_ORDER_QTY
14.0000
I_DUE_ORD_PROCESS_IND
Y
I_LAST_RUN_OF_THE_DAY
S
I_ROUND_TO_PALLET_PCT
14.0000
I_SUP_DELIVERY_POLICY
Svc Re
I_TIME_SUPPLY_HORIZON
5
O_PACK_COMP_CUST_BACK
14.0000
O_PACK_COMP_CUST_RESV
14.0000
O_SS_TSF_EXPECTED_QTY
14.0000
I_CURR_ORDER_LEAD_TIME
5
I_NEXT_ORDER_LEAD_TIME
5
I_REJECT_STORE_ORD_IND
S
I_REPL_RESULTS_ALL_IND
S
I_SO_WF_NOT_AFTER_DATE
2026-01-05
O_REVIEW_TIME_FORECAST
14.0000
I_ADDITIONAL_DEMAND_QTY
14.0000
I_PRIMARY_REPL_SUPPLIER
5
O_IN_PROGRESS_SALES_QTY
14.0000
O_PACK_COMP_NON_SELLABLE
14.0000
O_MAX_SUPPLY_DAYS_FORECAST
14.0000
O_MIN_SUPPLY_DAYS_FORECAST
14.0000
I_INCLUDE_ADDITIONAL_DEMAND
S

Rule Validation Summary

Source Rule Count
165
Governed Rule Count
152