Item Location
In ScopeTechnical: ITEM_LOC | ID: OR-ITM-ITEM_LOC-ITEM_LOCATION
Stores one row for each item stocked at each location within the company.
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
Field Definitions(5)
Sample Load Data(4)
| _scenario | LOCRPK | ITEMRPK | LOC_TYPER | HI | TI | STATUS | RPM_IND | RFID_IND | UIN_TYPE | CLEAR_IND | CREATE_ID | SOURCE_WH | UIN_LABEL | RANGED_IND | COSTING_LOC | EXT_UIN_IND | ITEM_PARENT | MULTI_UNITS | SELLING_UOM | TAXABLE_IND | UNIT_RETAIL | CAPTURE_TIME | MEAS_OF_EACH | PRIMARY_SUPP | PROMO_RETAIL | UOM_OF_PRICE | MEAS_OF_PRICE | PRIMARY_CNTRY | SOURCE_METHOD | LAST_UPDATE_ID | PROMOTABLE_IND | STORE_ORD_MULT | CREATE_DATETIME | DAILY_WASTE_PCT | LOCAL_ITEM_DESC | PRIMARY_VARIANT | RECEIVE_AS_TYPE | STORE_PRICE_IND | COSTING_LOC_TYPE | ITEM_GRANDPARENT | LOCAL_SHORT_DESC | MULTI_SELLING_UOM | MULTI_UNIT_RETAIL | PRIMARY_COST_PACK | PROMO_SELLING_UOM | STATUS_UPDATE_DATE | REGULAR_UNIT_RETAIL | SELLING_UNIT_RETAIL | LAST_UPDATE_DATETIME | PROMO_SELLING_RETAIL | INBOUND_HANDLING_DAYS | MFG_SUG_RETAIL_EXCL_TAX | MFG_SUG_RETAIL_INCL_TAX | SELLING_PHASE_START_DATE | REGULAR_SELLING_UNIT_RETAIL | 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 | SAMPLE | S | 1.0000 | 1.0000 | S | S | S | SAMPLE | S | SAMPLE | 1 | SAMPLE | S | 1 | S | SAMPLE | 1.0000 | SAMP | S | 1.0000 | SAMPLE | 1.0000 | 1 | 1.0000 | SAMP | 1.0000 | SAM | S | SAMPLE | S | S | 2026-01-01 | 1.0000 | SAMPLE | SAMPLE | S | S | S | SAMPLE | SAMPLE | SAMP | 1.0000 | SAMPLE | SAMP | 2026-01-01 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 1 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | S | S | S |
| default | 3 | Item Loc-002-ALT | w | 12.5000 | 12.5000 | I | I | N | Item L | N | C LIENT_INFO | 9003 | Item L | Y | 3 | N | Item Loc-002-ALT | 12.5000 | Item | N | 12.5000 | Item L | 12.5000 | 3 | 12.5000 | Item | 12.5000 | Ite | I | MDM_USER | e | I | 2026-01-03 | 12.5000 | Item Loc-002-ALT | Item Loc-002-ALT | P | N | I | Item Loc-002-ALT | Item Loc-002-ALT | Item | 12.5000 | Item Loc-002-ALT | Item | 2026-01-03 | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 | 3 | 12.5000 | 12.5000 | 2026-01-03 | — | 12.5000 | 2 | 2 | 2 |
| default | 5 | Item Loc-003-EDGE | s | 14.0000 | 14.0000 | C | I | N | Item L | Y | USE RENV | 9005 | Item L | Y | 5 | N | Item Loc-003-EDGE | 14.0000 | Item | Y | 14.0000 | Item L | 14.0000 | 5 | 14.0000 | Item | 14.0000 | Ite | I | BATCH_USER | u | I | 2026-01-05 | 14.0000 | Item Loc-003-EDGE | Item Loc-003-EDGE | W | N | I | Item Loc-003-EDGE | Item Loc-003-EDGE | Item | 14.0000 | Item Loc-003-EDGE | Item | 2026-01-05 | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 | 5 | 14.0000 | 14.0000 | 2026-01-05 | — | 14.0000 | 2 | 2 | 2 |
Example values from field definitions
- LOCRPK
- 1
- ITEMRPK
- SAMPLE
- LOC_TYPER
- S
- HI
- 1.0000
- TI
- 1.0000
- STATUS
- S
- RPM_IND
- S
- RFID_IND
- S
- UIN_TYPE
- SAMPLE
- CLEAR_IND
- S
- CREATE_ID
- SAMPLE
- SOURCE_WH
- 1
- UIN_LABEL
- SAMPLE
- RANGED_IND
- S
- COSTING_LOC
- 1
- EXT_UIN_IND
- S
- ITEM_PARENT
- SAMPLE
- MULTI_UNITS
- 1.0000
- SELLING_UOM
- SAMP
- TAXABLE_IND
- S
- UNIT_RETAIL
- 1.0000
- CAPTURE_TIME
- SAMPLE
- MEAS_OF_EACH
- 1.0000
- PRIMARY_SUPP
- 1
- PROMO_RETAIL
- 1.0000
- UOM_OF_PRICE
- SAMP
- MEAS_OF_PRICE
- 1.0000
- PRIMARY_CNTRY
- SAM
- SOURCE_METHOD
- S
- LAST_UPDATE_ID
- SAMPLE
- PROMOTABLE_IND
- S
- STORE_ORD_MULT
- S
- CREATE_DATETIME
- 2026-01-01
- DAILY_WASTE_PCT
- 1.0000
- LOCAL_ITEM_DESC
- SAMPLE
- PRIMARY_VARIANT
- SAMPLE
- RECEIVE_AS_TYPE
- S
- STORE_PRICE_IND
- S
- COSTING_LOC_TYPE
- S
- ITEM_GRANDPARENT
- SAMPLE
- LOCAL_SHORT_DESC
- SAMPLE
- MULTI_SELLING_UOM
- SAMP
- MULTI_UNIT_RETAIL
- 1.0000
- PRIMARY_COST_PACK
- SAMPLE
- PROMO_SELLING_UOM
- SAMP
- STATUS_UPDATE_DATE
- 2026-01-01
- REGULAR_UNIT_RETAIL
- 1.0000
- SELLING_UNIT_RETAIL
- 1.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
- PROMO_SELLING_RETAIL
- 1.0000
- INBOUND_HANDLING_DAYS
- 1
- MFG_SUG_RETAIL_EXCL_TAX
- 1.0000
- MFG_SUG_RETAIL_INCL_TAX
- 1.0000
- SELLING_PHASE_START_DATE
- 2026-01-01
- REGULAR_SELLING_UNIT_RETAIL
- 1.0000
- 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
- LOCRPK
- 3
- ITEMRPK
- Item Loc-002-ALT
- LOC_TYPER
- w
- HI
- 12.5000
- TI
- 12.5000
- STATUS
- I
- RPM_IND
- I
- RFID_IND
- N
- UIN_TYPE
- Item L
- CLEAR_IND
- N
- CREATE_ID
- C LIENT_INFO
- SOURCE_WH
- 9003
- UIN_LABEL
- Item L
- RANGED_IND
- Y
- COSTING_LOC
- 3
- EXT_UIN_IND
- N
- ITEM_PARENT
- Item Loc-002-ALT
- MULTI_UNITS
- 12.5000
- SELLING_UOM
- Item
- TAXABLE_IND
- N
- UNIT_RETAIL
- 12.5000
- CAPTURE_TIME
- Item L
- MEAS_OF_EACH
- 12.5000
- PRIMARY_SUPP
- 3
- PROMO_RETAIL
- 12.5000
- UOM_OF_PRICE
- Item
- MEAS_OF_PRICE
- 12.5000
- PRIMARY_CNTRY
- Ite
- SOURCE_METHOD
- I
- LAST_UPDATE_ID
- MDM_USER
- PROMOTABLE_IND
- e
- STORE_ORD_MULT
- I
- CREATE_DATETIME
- 2026-01-03
- DAILY_WASTE_PCT
- 12.5000
- LOCAL_ITEM_DESC
- Item Loc-002-ALT
- PRIMARY_VARIANT
- Item Loc-002-ALT
- RECEIVE_AS_TYPE
- P
- STORE_PRICE_IND
- N
- COSTING_LOC_TYPE
- I
- ITEM_GRANDPARENT
- Item Loc-002-ALT
- LOCAL_SHORT_DESC
- Item Loc-002-ALT
- MULTI_SELLING_UOM
- Item
- MULTI_UNIT_RETAIL
- 12.5000
- PRIMARY_COST_PACK
- Item Loc-002-ALT
- PROMO_SELLING_UOM
- Item
- STATUS_UPDATE_DATE
- 2026-01-03
- REGULAR_UNIT_RETAIL
- 12.5000
- SELLING_UNIT_RETAIL
- 12.5000
- LAST_UPDATE_DATETIME
- 2026-01-03
- PROMO_SELLING_RETAIL
- 12.5000
- INBOUND_HANDLING_DAYS
- 3
- MFG_SUG_RETAIL_EXCL_TAX
- 12.5000
- MFG_SUG_RETAIL_INCL_TAX
- 12.5000
- SELLING_PHASE_START_DATE
- 2026-01-03
- REGULAR_SELLING_UNIT_RETAIL
- —
- 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
default
- LOCRPK
- 5
- ITEMRPK
- Item Loc-003-EDGE
- LOC_TYPER
- s
- HI
- 14.0000
- TI
- 14.0000
- STATUS
- C
- RPM_IND
- I
- RFID_IND
- N
- UIN_TYPE
- Item L
- CLEAR_IND
- Y
- CREATE_ID
- USE RENV
- SOURCE_WH
- 9005
- UIN_LABEL
- Item L
- RANGED_IND
- Y
- COSTING_LOC
- 5
- EXT_UIN_IND
- N
- ITEM_PARENT
- Item Loc-003-EDGE
- MULTI_UNITS
- 14.0000
- SELLING_UOM
- Item
- TAXABLE_IND
- Y
- UNIT_RETAIL
- 14.0000
- CAPTURE_TIME
- Item L
- MEAS_OF_EACH
- 14.0000
- PRIMARY_SUPP
- 5
- PROMO_RETAIL
- 14.0000
- UOM_OF_PRICE
- Item
- MEAS_OF_PRICE
- 14.0000
- PRIMARY_CNTRY
- Ite
- SOURCE_METHOD
- I
- LAST_UPDATE_ID
- BATCH_USER
- PROMOTABLE_IND
- u
- STORE_ORD_MULT
- I
- CREATE_DATETIME
- 2026-01-05
- DAILY_WASTE_PCT
- 14.0000
- LOCAL_ITEM_DESC
- Item Loc-003-EDGE
- PRIMARY_VARIANT
- Item Loc-003-EDGE
- RECEIVE_AS_TYPE
- W
- STORE_PRICE_IND
- N
- COSTING_LOC_TYPE
- I
- ITEM_GRANDPARENT
- Item Loc-003-EDGE
- LOCAL_SHORT_DESC
- Item Loc-003-EDGE
- MULTI_SELLING_UOM
- Item
- MULTI_UNIT_RETAIL
- 14.0000
- PRIMARY_COST_PACK
- Item Loc-003-EDGE
- PROMO_SELLING_UOM
- Item
- STATUS_UPDATE_DATE
- 2026-01-05
- REGULAR_UNIT_RETAIL
- 14.0000
- SELLING_UNIT_RETAIL
- 14.0000
- LAST_UPDATE_DATETIME
- 2026-01-05
- PROMO_SELLING_RETAIL
- 14.0000
- INBOUND_HANDLING_DAYS
- 5
- MFG_SUG_RETAIL_EXCL_TAX
- 14.0000
- MFG_SUG_RETAIL_INCL_TAX
- 14.0000
- SELLING_PHASE_START_DATE
- 2026-01-05
- REGULAR_SELLING_UNIT_RETAIL
- —
- MIN_UNITS_FOR_SELL_DATE_RESET
- 14.0000
- 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
Rule Validation Summary
- Source Rule Count
- 157
- Governed Rule Count
- 81