Item Location Ranging (Service Layer)

In Scope

Technical: SVC_ITEM_LOC_RANGING | ID: OR-ITM-SVC_ITEM_LOC_RANGING-ITEM_LOCATION_RANGING_SERVICE_LAYER

This is the parameter table used the by RMS asynchronous item location ranging functionality. It serves as an interface between an initiating transaction and the asynchronous transaction that ranges the...

See how this object fits into Item Management

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: SVC_ITEM_LOC_RANGING

Field Definitions(5)

Rules & Considerations(108)

constraint

validation

Sample Load Data(4)

_scenario	RMS_ASYNC_IDRPK	HI	TI	LOC	DEPT	ITEM	CLASS	DIFF_1	DIFF_2	DIFF_3	DIFF_4	COST_UOM	LOC_TYPE	PACK_IND	RFID_IND	SUBCLASS	UIN_TYPE	CREATE_ID	ITEM_DESC	PACK_TYPE	SOURCE_WH	UIN_LABEL	HIER_LEVEL	ITEM_LEVEL	LIKE_STORE	RANGED_IND	SHORT_DESC	TRAN_LEVEL	WASTE_TYPE	COSTING_LOC	EXT_UIN_IND	ITEM_PARENT	ITEM_STATUS	MULTI_UNITS	SELLING_UOM	TAXABLE_IND	CAPTURE_TIME	MEAS_OF_EACH	PRIMARY_SUPP	SELLABLE_IND	UOM_OF_PRICE	CURRENCY_CODE	MEAS_OF_PRICE	ORDERABLE_IND	PRIMARY_CNTRY	PURCHASE_RATE	PURCHASE_TYPE	SOURCE_METHOD	UNIT_COST_LOC	UNIT_COST_SUP	HIER_NUM_VALUE	LAST_UPDATE_ID	LOC_GROUP_TYPE	PROMOTABLE_IND	STORE_ORD_MULT	CREATE_DATETIME	DAILY_WASTE_PCT	HIER_CHAR_VALUE	ITEM_LOC_STATUS	LOCAL_ITEM_DESC	LOC_GROUP_VALUE	PRICING_CONTROL	PRIMARY_VARIANT	RECEIVE_AS_TYPE	STORE_PRICE_IND	UNIT_RETAIL_LOC	COSTING_LOC_TYPE	ITEM_GRANDPARENT	LOCAL_SHORT_DESC	CALCULATION_BASIS	MULTI_SELLING_UOM	MULTI_UNIT_RETAIL	PRIMARY_COST_PACK	SUPP_CURRENCY_CODE	DEFAULT_TO_CHILDREN	LAST_UPDATE_DATETIME	INBOUND_HANDLING_DAYS	MFG_SUG_RETAIL_EXCL_TAX	MFG_SUG_RETAIL_INCL_TAX	SELLING_UNIT_RETAIL_LOC	SELLING_PHASE_START_DATE	MIN_UNITS_FOR_SELL_DATE_RESET	UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND	UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND	UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND
Example values from field definitions	1	1.0000	1.0000	1	1	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMP	S	S	S	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	1	1	S	SAMPLE	1	SAMPLE	1	S	SAMPLE	S	1.0000	SAMP	S	SAMPLE	1.0000	1	S	SAMP	SAM	1.0000	S	SAM	1.0000	1	S	1.0000	1.0000	1	SAMPLE	SAMPLE	S	S	2026-01-01	1.0000	SAMPLE	S	SAMPLE	SAMPLE	S	SAMPLE	S	S	1.0000	S	SAMPLE	SAMPLE	S	SAMP	1.0000	SAMPLE	SAM	S	2026-01-01	1	1.0000	1.0000	1.0000	2026-01-01	1.0000	S	S	S
default	1000000003	12.5000	12.5000	3	1003	Svc Item Loc Ranging-002-	1103	Svc Item L	Svc Item L	Svc Item L	Svc Item L	Svc	w	S	N	1113	Svc It	MDM_USER	Svc Item Loc Ranging-002-ALT	V	9003	Svc It	Svc It	3	1003	S	Svc Item Loc Ranging-002-ALT	3	SP	3	S	Svc Item Loc Ranging-002-	S	12.5000	Svc	N	Svc It	12.5000	3	S	Svc	ALT	12.5000	S	Svc	12.5000	1	S	12.5000	12.5000	3	MDM_USER	Svc It	Y	S	2026-01-03	12.5000	Svc It	I	Svc Item Loc Ranging-002-ALT	Svc Item L	N	Svc Item Loc Ranging-002-	S	S	12.5000	S	Svc Item Loc Ranging-002-	Svc Item Loc Ranging-002-ALT	P	Svc	12.5000	Svc Item Loc Ranging-002-	ALT	S	2026-01-03	3	12.5000	12.5000	12.5000	2026-01-03	12.5000	2	2	2
default	1000000005	14.0000	14.0000	5	1005	Svc Item Loc Ranging-003-	1105	Svc Item L	Svc Item L	Svc Item L	Svc Item L	Svc	s	S	N	1115	Svc It	BATCH_USER	Svc Item Loc Ranging-003-EDGE	V	9005	Svc It	Svc It	5	1005	S	Svc Item Loc Ranging-003-EDGE	5	SP	5	S	Svc Item Loc Ranging-003-	A	14.0000	Svc	Y	Svc It	14.0000	5	S	Svc	EDG	14.0000	S	Svc	14.0000	2	S	14.0000	14.0000	5	BATCH_USER	Svc It	Y	S	2026-01-05	14.0000	Svc It	C	Svc Item Loc Ranging-003-EDGE	Svc Item L	N	Svc Item Loc Ranging-003-	S	S	14.0000	S	Svc Item Loc Ranging-003-	Svc Item Loc Ranging-003-EDGE	C	Svc	14.0000	Svc Item Loc Ranging-003-	EDG	S	2026-01-05	5	14.0000	14.0000	14.0000	2026-01-05	14.0000	2	2	2

Example values from field definitions

RMS_ASYNC_IDRPK: 1
HI: 1.0000
TI: 1.0000
LOC: 1
DEPT: 1
ITEM: SAMPLE
CLASS: 1
DIFF_1: SAMPLE
DIFF_2: SAMPLE
DIFF_3: SAMPLE
DIFF_4: SAMPLE
COST_UOM: SAMP
LOC_TYPE: S
PACK_IND: S
RFID_IND: S
SUBCLASS: 1
UIN_TYPE: SAMPLE
CREATE_ID: SAMPLE
ITEM_DESC: SAMPLE
PACK_TYPE: SAMPLE
SOURCE_WH: 1
UIN_LABEL: SAMPLE
HIER_LEVEL: SAMPLE
ITEM_LEVEL: 1
LIKE_STORE: 1
RANGED_IND: S
SHORT_DESC: SAMPLE
TRAN_LEVEL: 1
WASTE_TYPE: SAMPLE
COSTING_LOC: 1
EXT_UIN_IND: S
ITEM_PARENT: SAMPLE
ITEM_STATUS: S
MULTI_UNITS: 1.0000
SELLING_UOM: SAMP
TAXABLE_IND: S
CAPTURE_TIME: SAMPLE
MEAS_OF_EACH: 1.0000
PRIMARY_SUPP: 1
SELLABLE_IND: S
UOM_OF_PRICE: SAMP
CURRENCY_CODE: SAM
MEAS_OF_PRICE: 1.0000
ORDERABLE_IND: S
PRIMARY_CNTRY: SAM
PURCHASE_RATE: 1.0000
PURCHASE_TYPE: 1
SOURCE_METHOD: S
UNIT_COST_LOC: 1.0000
UNIT_COST_SUP: 1.0000
HIER_NUM_VALUE: 1
LAST_UPDATE_ID: SAMPLE
LOC_GROUP_TYPE: SAMPLE
PROMOTABLE_IND: S
STORE_ORD_MULT: S
CREATE_DATETIME: 2026-01-01
DAILY_WASTE_PCT: 1.0000
HIER_CHAR_VALUE: SAMPLE
ITEM_LOC_STATUS: S
LOCAL_ITEM_DESC: SAMPLE
LOC_GROUP_VALUE: SAMPLE
PRICING_CONTROL: S
PRIMARY_VARIANT: SAMPLE
RECEIVE_AS_TYPE: S
STORE_PRICE_IND: S
UNIT_RETAIL_LOC: 1.0000
COSTING_LOC_TYPE: S
ITEM_GRANDPARENT: SAMPLE
LOCAL_SHORT_DESC: SAMPLE
CALCULATION_BASIS: S
MULTI_SELLING_UOM: SAMP
MULTI_UNIT_RETAIL: 1.0000
PRIMARY_COST_PACK: SAMPLE
SUPP_CURRENCY_CODE: SAM
DEFAULT_TO_CHILDREN: S
LAST_UPDATE_DATETIME: 2026-01-01
INBOUND_HANDLING_DAYS: 1
MFG_SUG_RETAIL_EXCL_TAX: 1.0000
MFG_SUG_RETAIL_INCL_TAX: 1.0000
SELLING_UNIT_RETAIL_LOC: 1.0000
SELLING_PHASE_START_DATE: 2026-01-01
MIN_UNITS_FOR_SELL_DATE_RESET: 1.0000
UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND: S
UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND: S
UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND: S

default

RMS_ASYNC_IDRPK: 1000000003
HI: 12.5000
TI: 12.5000
LOC: 3
DEPT: 1003
ITEM: Svc Item Loc Ranging-002-
CLASS: 1103
DIFF_1: Svc Item L
DIFF_2: Svc Item L
DIFF_3: Svc Item L
DIFF_4: Svc Item L
COST_UOM: Svc
LOC_TYPE: w
PACK_IND: S
RFID_IND: N
SUBCLASS: 1113
UIN_TYPE: Svc It
CREATE_ID: MDM_USER
ITEM_DESC: Svc Item Loc Ranging-002-ALT
PACK_TYPE: V
SOURCE_WH: 9003
UIN_LABEL: Svc It
HIER_LEVEL: Svc It
ITEM_LEVEL: 3
LIKE_STORE: 1003
RANGED_IND: S
SHORT_DESC: Svc Item Loc Ranging-002-ALT
TRAN_LEVEL: 3
WASTE_TYPE: SP
COSTING_LOC: 3
EXT_UIN_IND: S
ITEM_PARENT: Svc Item Loc Ranging-002-
ITEM_STATUS: S
MULTI_UNITS: 12.5000
SELLING_UOM: Svc
TAXABLE_IND: N
CAPTURE_TIME: Svc It
MEAS_OF_EACH: 12.5000
PRIMARY_SUPP: 3
SELLABLE_IND: S
UOM_OF_PRICE: Svc
CURRENCY_CODE: ALT
MEAS_OF_PRICE: 12.5000
ORDERABLE_IND: S
PRIMARY_CNTRY: Svc
PURCHASE_RATE: 12.5000
PURCHASE_TYPE: 1
SOURCE_METHOD: S
UNIT_COST_LOC: 12.5000
UNIT_COST_SUP: 12.5000
HIER_NUM_VALUE: 3
LAST_UPDATE_ID: MDM_USER
LOC_GROUP_TYPE: Svc It
PROMOTABLE_IND: Y
STORE_ORD_MULT: S
CREATE_DATETIME: 2026-01-03
DAILY_WASTE_PCT: 12.5000
HIER_CHAR_VALUE: Svc It
ITEM_LOC_STATUS: I
LOCAL_ITEM_DESC: Svc Item Loc Ranging-002-ALT
LOC_GROUP_VALUE: Svc Item L
PRICING_CONTROL: N
PRIMARY_VARIANT: Svc Item Loc Ranging-002-
RECEIVE_AS_TYPE: S
STORE_PRICE_IND: S
UNIT_RETAIL_LOC: 12.5000
COSTING_LOC_TYPE: S
ITEM_GRANDPARENT: Svc Item Loc Ranging-002-
LOCAL_SHORT_DESC: Svc Item Loc Ranging-002-ALT
CALCULATION_BASIS: P
MULTI_SELLING_UOM: Svc
MULTI_UNIT_RETAIL: 12.5000
PRIMARY_COST_PACK: Svc Item Loc Ranging-002-
SUPP_CURRENCY_CODE: ALT
DEFAULT_TO_CHILDREN: S
LAST_UPDATE_DATETIME: 2026-01-03
INBOUND_HANDLING_DAYS: 3
MFG_SUG_RETAIL_EXCL_TAX: 12.5000
MFG_SUG_RETAIL_INCL_TAX: 12.5000
SELLING_UNIT_RETAIL_LOC: 12.5000
SELLING_PHASE_START_DATE: 2026-01-03
MIN_UNITS_FOR_SELL_DATE_RESET: 12.5000
UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND: 2
UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND: 2
UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND: 2