Item Location Traits
In ScopeTechnical: 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(33)
Rules & Considerations(41)
Sample Load Data(4)
| _scenario | LOCR | ITEMRPK | CREATE_IDR | FIXED_TARE_UOMRPK | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | NATL_BRAND_COMP_ITEMRPK | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | SAMP | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | S | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | 1 | SAMPLE | S | S | S | S | S | SAMPLE | SAMPLE | 1.0000 | S | SAMPLE | SAMPLE | S | SAMPLE | 1.0000 | S | SAMPLE | 1 | 1 |
Example values from field definitions
- LOCR
- 1
- ITEMRPK
- SAMPLE
- CREATE_IDR
- SAMPLE
- FIXED_TARE_UOMRPK
- SAMP
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- NATL_BRAND_COMP_ITEMRPK
- SAMPLE
- WIC_IND
- S
- 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
- FOOD_STAMP_IND
- S
- REFUNDABLE_IND
- S
- RETURNABLE_IND
- S
- 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
- 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
Rule Validation Summary
- Source Rule Count
- 77
- Governed Rule Count
- 41