Item Location Traits

In Scope

Technical: ITEM_LOC_TRAITS | ID: OR-ITM-ITEM_LOC_TRAITS-ITEM_LOCATION_TRAITS

Stores one row of attributes for each item/location combination in the system. Rows on this table are not required.

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

Field Definitions(5)

Rules & Considerations(45)

constraint

validation

Sample Load Data(4)

_scenario	LOCRPK	ITEMRPK	WIC_IND	CREATE_ID	RACK_SIZE	LAUNCH_DATE	REPORT_CODE	DEPOSIT_CODE	IB_SHELF_LIFE	RETURN_POLICY	STOP_SALE_IND	BACK_ORDER_IND	FIXED_TARE_UOM	FOOD_STAMP_IND	LAST_UPDATE_ID	REFUNDABLE_IND	RETURNABLE_IND	CREATE_DATETIME	ELECT_MTK_CLUBS	QTY_KEY_OPTIONS	FIXED_TARE_VALUE	FULL_PALLET_ITEM	STORAGE_LOCATION	MANUAL_PRICE_ENTRY	REWARD_ELIGIBLE_IND	ALT_STORAGE_LOCATION	LAST_UPDATE_DATETIME	NATL_BRAND_COMP_ITEM	PROPORTIONAL_TARE_PCT	STORE_REORDERABLE_IND	IN_STORE_MARKET_BASKET	REQ_SHELF_LIFE_ON_RECEIPT	REQ_SHELF_LIFE_ON_SELECTION
Example values from field definitions	1	SAMPLE	S	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE	1	SAMPLE	S	S	SAMP	S	SAMPLE	S	S	2026-01-01	SAMPLE	SAMPLE	1.0000	S	SAMPLE	SAMPLE	S	SAMPLE	2026-01-01	SAMPLE	1.0000	S	SAMPLE	1	1
default	3	Item Loc Traits-002-ALT	I	C LIENT_INFO	it	2026-01-03	it	ALT-IT	3	Item L	I	I	Item	I	MDM_USER	I	I	2026-01-03	Item L	P	12.5000	I	Item Lo	P	I	Item Lo	2026-01-03	Item Loc Traits-002-ALT	12.5000	I	it	3	3
default	5	Item Loc Traits-003-EDGE	I	USE RENV	it	2026-01-05	it	EDGE-I	5	Item L	I	I	Item	I	BATCH_USER	I	I	2026-01-05	Item L	O	14.0000	I	Item Lo	O	I	Item Lo	2026-01-05	Item Loc Traits-003-EDGE	14.0000	I	it	5	5

Example values from field definitions

LOCRPK: 1
ITEMRPK: SAMPLE
WIC_IND: S
CREATE_ID: SAMPLE
RACK_SIZE: SAMPLE
LAUNCH_DATE: 2026-01-01
REPORT_CODE: SAMPLE
DEPOSIT_CODE: SAMPLE
IB_SHELF_LIFE: 1
RETURN_POLICY: SAMPLE
STOP_SALE_IND: S
BACK_ORDER_IND: S
FIXED_TARE_UOM: SAMP
FOOD_STAMP_IND: S
LAST_UPDATE_ID: SAMPLE
REFUNDABLE_IND: S
RETURNABLE_IND: S
CREATE_DATETIME: 2026-01-01
ELECT_MTK_CLUBS: SAMPLE
QTY_KEY_OPTIONS: SAMPLE
FIXED_TARE_VALUE: 1.0000
FULL_PALLET_ITEM: S
STORAGE_LOCATION: SAMPLE
MANUAL_PRICE_ENTRY: SAMPLE
REWARD_ELIGIBLE_IND: S
ALT_STORAGE_LOCATION: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01
NATL_BRAND_COMP_ITEM: SAMPLE
PROPORTIONAL_TARE_PCT: 1.0000
STORE_REORDERABLE_IND: S
IN_STORE_MARKET_BASKET: SAMPLE
REQ_SHELF_LIFE_ON_RECEIPT: 1
REQ_SHELF_LIFE_ON_SELECTION: 1

default

LOCRPK: 3
ITEMRPK: Item Loc Traits-002-ALT
WIC_IND: I
CREATE_ID: C LIENT_INFO
RACK_SIZE: it
LAUNCH_DATE: 2026-01-03
REPORT_CODE: it
DEPOSIT_CODE: ALT-IT
IB_SHELF_LIFE: 3
RETURN_POLICY: Item L
STOP_SALE_IND: I
BACK_ORDER_IND: I
FIXED_TARE_UOM: Item
FOOD_STAMP_IND: I
LAST_UPDATE_ID: MDM_USER
REFUNDABLE_IND: I
RETURNABLE_IND: I
CREATE_DATETIME: 2026-01-03
ELECT_MTK_CLUBS: Item L
QTY_KEY_OPTIONS: P
FIXED_TARE_VALUE: 12.5000
FULL_PALLET_ITEM: I
STORAGE_LOCATION: Item Lo
MANUAL_PRICE_ENTRY: P
REWARD_ELIGIBLE_IND: I
ALT_STORAGE_LOCATION: Item Lo
LAST_UPDATE_DATETIME: 2026-01-03
NATL_BRAND_COMP_ITEM: Item Loc Traits-002-ALT
PROPORTIONAL_TARE_PCT: 12.5000
STORE_REORDERABLE_IND: I
IN_STORE_MARKET_BASKET: it
REQ_SHELF_LIFE_ON_RECEIPT: 3
REQ_SHELF_LIFE_ON_SELECTION: 3

default

LOCRPK: 5
ITEMRPK: Item Loc Traits-003-EDGE
WIC_IND: I
CREATE_ID: USE RENV
RACK_SIZE: it
LAUNCH_DATE: 2026-01-05
REPORT_CODE: it
DEPOSIT_CODE: EDGE-I
IB_SHELF_LIFE: 5
RETURN_POLICY: Item L
STOP_SALE_IND: I
BACK_ORDER_IND: I
FIXED_TARE_UOM: Item
FOOD_STAMP_IND: I
LAST_UPDATE_ID: BATCH_USER
REFUNDABLE_IND: I
RETURNABLE_IND: I
CREATE_DATETIME: 2026-01-05
ELECT_MTK_CLUBS: Item L
QTY_KEY_OPTIONS: O
FIXED_TARE_VALUE: 14.0000
FULL_PALLET_ITEM: I
STORAGE_LOCATION: Item Lo
MANUAL_PRICE_ENTRY: O
REWARD_ELIGIBLE_IND: I
ALT_STORAGE_LOCATION: Item Lo
LAST_UPDATE_DATETIME: 2026-01-05
NATL_BRAND_COMP_ITEM: Item Loc Traits-003-EDGE
PROPORTIONAL_TARE_PCT: 14.0000
STORE_REORDERABLE_IND: I
IN_STORE_MARKET_BASKET: it
REQ_SHELF_LIFE_ON_RECEIPT: 5
REQ_SHELF_LIFE_ON_SELECTION: 5

Rule Validation Summary

Source Rule Count: 81
Governed Rule Count: 45