Item Loc Traits
In ScopeTechnical: 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)
| _scenario | LOCR | ITEMRPK | CREATE_IDR | FIXED_TARE_UOMPK | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | NATL_BRAND_COMP_ITEMPK | WIC_IND | RACK_SIZE | LAUNCH_DATE | REPORT_CODE | DEPOSIT_CODE | IB_SHELF_LIFE | RETURN_POLICY | STOP_SALE_IND | BACK_ORDER_IND | FOOD_STAMP_IND | REFUNDABLE_IND | RETURNABLE_IND | ELECT_MTK_CLUBS | QTY_KEY_OPTIONS | FIXED_TARE_VALUE | FULL_PALLET_ITEM | STORAGE_LOCATION | MANUAL_PRICE_ENTRY | REWARD_ELIGIBLE_IND | ALT_STORAGE_LOCATION | PROPORTIONAL_TARE_PCT | STORE_REORDERABLE_IND | IN_STORE_MARKET_BASKET | REQ_SHELF_LIFE_ON_RECEIPT | REQ_SHELF_LIFE_ON_SELECTION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | Item Loc Traits-001 | USERENV | Item Loc Traits-001 | MIG_USER | 2026-01-01 | 2026-01-01 | Item Loc Traits-001 | Item Loc Traits-001 | it | 2026-01-01 | it | STD-ITEM_LOC-001 | 0001 | Item Loc Traits-001 | Item Loc Traits-001 | Item Loc Traits-001 | Item Loc Traits-001 | Item Loc Traits-001 | Item Loc Traits-001 | Item Loc Traits-001 | R | 11.0000 | Item Loc Traits-001 | Item Loc Traits-001 | R | Item Loc Traits-001 | Item Loc Traits-001 | 11.0000 | Item Loc Traits-001 | it | 0001 | 0001 |
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