Item Loc Traits

In Scope

Technical: ITEM_LOC_TRAITS | ID: OR-MFCS-ITEM_LOC_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

Target Structure

Load Approach
Table
Target Objects
ITEM_LOC_TRAITS

Field Definitions(33)

Rules & Considerations(36)

Sample Load Data(4)

default

LOCR
1
ITEMRPK
Item Loc Traits-001
CREATE_IDR
USERENV
FIXED_TARE_UOMPK
Item Loc Traits-001
LAST_UPDATE_IDR
MIG_USER
CREATE_DATETIMER
2026-01-01
LAST_UPDATE_DATETIMER
2026-01-01
NATL_BRAND_COMP_ITEMPK
Item Loc Traits-001
WIC_IND
Item Loc Traits-001
RACK_SIZE
it
LAUNCH_DATE
2026-01-01
REPORT_CODE
it
DEPOSIT_CODE
STD-ITEM_LOC-001
IB_SHELF_LIFE
0001
RETURN_POLICY
Item Loc Traits-001
STOP_SALE_IND
Item Loc Traits-001
BACK_ORDER_IND
Item Loc Traits-001
FOOD_STAMP_IND
Item Loc Traits-001
REFUNDABLE_IND
Item Loc Traits-001
RETURNABLE_IND
Item Loc Traits-001
ELECT_MTK_CLUBS
Item Loc Traits-001
QTY_KEY_OPTIONS
R
FIXED_TARE_VALUE
11.0000
FULL_PALLET_ITEM
Item Loc Traits-001
STORAGE_LOCATION
Item Loc Traits-001
MANUAL_PRICE_ENTRY
R
REWARD_ELIGIBLE_IND
Item Loc Traits-001
ALT_STORAGE_LOCATION
Item Loc Traits-001
PROPORTIONAL_TARE_PCT
11.0000
STORE_REORDERABLE_IND
Item Loc Traits-001
IN_STORE_MARKET_BASKET
it
REQ_SHELF_LIFE_ON_RECEIPT
0001
REQ_SHELF_LIFE_ON_SELECTION
0001