Dc Item Location
In ScopeTechnical: DC_ITEM_LOC | ID: OR-ITM-DC_ITEM_LOC-DC_ITEM_LOCATION
This table is a staging table for data conversion and will hold data of item_loc table.
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
- DC_ITEM_LOC
Field Definitions(5)
Rules & Considerations(26)
Sample Load Data(4)
| _scenario | HI | TI | ITEM | LOCATION | LOC_TYPE | UIN_TYPE | SOURCE_WH | UIN_LABEL | EXT_UIN_IND | MULTI_UNITS | SELLING_UOM | TAXABLE_IND | CAPTURE_TIME | MEAS_OF_EACH | UOM_OF_PRICE | MEAS_OF_PRICE | SOURCE_METHOD | AVERAGE_WEIGHT | STORE_ORD_MULT | LOCAL_ITEM_DESC | LOCAL_SHORT_DESC | MULTI_SELLING_UOM | MULTI_UNIT_RETAIL | PRIMARY_COST_PACK | SELLING_UNIT_RETAIL | INBOUND_HANDLING_DAYS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | 1.0000 | SAMPLE | 1 | S | SAMPLE | 1 | SAMPLE | S | 1.0000 | SAMP | S | SAMPLE | 1.0000 | SAMP | 1.0000 | S | 1.0000 | S | SAMPLE | SAMPLE | SAMP | 1.0000 | SAMPLE | 1.0000 | 1 |
| default | 12.5000 | 12.5000 | Dc Item Loc-002-ALT | 3 | w | Dc Ite | 9003 | Dc Ite | D | 12.5000 | Dc I | D | Dc Ite | 12.5000 | Dc I | 12.5000 | D | 12.5000 | D | Dc Item Loc-002-ALT | Dc Item Loc-002-ALT | Dc I | 12.5000 | Dc Item Loc-002-ALT | 12.5000 | 3 |
| default | 14.0000 | 14.0000 | Dc Item Loc-003-EDGE | 5 | s | Dc Ite | 9005 | Dc Ite | D | 14.0000 | Dc I | D | Dc Ite | 14.0000 | Dc I | 14.0000 | D | 14.0000 | D | Dc Item Loc-003-EDGE | Dc Item Loc-003-EDGE | Dc I | 14.0000 | Dc Item Loc-003-EDGE | 14.0000 | 5 |
Example values from field definitions
- HI
- 1.0000
- TI
- 1.0000
- ITEM
- SAMPLE
- LOCATION
- 1
- LOC_TYPE
- S
- UIN_TYPE
- SAMPLE
- SOURCE_WH
- 1
- UIN_LABEL
- SAMPLE
- EXT_UIN_IND
- S
- MULTI_UNITS
- 1.0000
- SELLING_UOM
- SAMP
- TAXABLE_IND
- S
- CAPTURE_TIME
- SAMPLE
- MEAS_OF_EACH
- 1.0000
- UOM_OF_PRICE
- SAMP
- MEAS_OF_PRICE
- 1.0000
- SOURCE_METHOD
- S
- AVERAGE_WEIGHT
- 1.0000
- STORE_ORD_MULT
- S
- LOCAL_ITEM_DESC
- SAMPLE
- LOCAL_SHORT_DESC
- SAMPLE
- MULTI_SELLING_UOM
- SAMP
- MULTI_UNIT_RETAIL
- 1.0000
- PRIMARY_COST_PACK
- SAMPLE
- SELLING_UNIT_RETAIL
- 1.0000
- INBOUND_HANDLING_DAYS
- 1
default
- HI
- 12.5000
- TI
- 12.5000
- ITEM
- Dc Item Loc-002-ALT
- LOCATION
- 3
- LOC_TYPE
- w
- UIN_TYPE
- Dc Ite
- SOURCE_WH
- 9003
- UIN_LABEL
- Dc Ite
- EXT_UIN_IND
- D
- MULTI_UNITS
- 12.5000
- SELLING_UOM
- Dc I
- TAXABLE_IND
- D
- CAPTURE_TIME
- Dc Ite
- MEAS_OF_EACH
- 12.5000
- UOM_OF_PRICE
- Dc I
- MEAS_OF_PRICE
- 12.5000
- SOURCE_METHOD
- D
- AVERAGE_WEIGHT
- 12.5000
- STORE_ORD_MULT
- D
- LOCAL_ITEM_DESC
- Dc Item Loc-002-ALT
- LOCAL_SHORT_DESC
- Dc Item Loc-002-ALT
- MULTI_SELLING_UOM
- Dc I
- MULTI_UNIT_RETAIL
- 12.5000
- PRIMARY_COST_PACK
- Dc Item Loc-002-ALT
- SELLING_UNIT_RETAIL
- 12.5000
- INBOUND_HANDLING_DAYS
- 3
default
- HI
- 14.0000
- TI
- 14.0000
- ITEM
- Dc Item Loc-003-EDGE
- LOCATION
- 5
- LOC_TYPE
- s
- UIN_TYPE
- Dc Ite
- SOURCE_WH
- 9005
- UIN_LABEL
- Dc Ite
- EXT_UIN_IND
- D
- MULTI_UNITS
- 14.0000
- SELLING_UOM
- Dc I
- TAXABLE_IND
- D
- CAPTURE_TIME
- Dc Ite
- MEAS_OF_EACH
- 14.0000
- UOM_OF_PRICE
- Dc I
- MEAS_OF_PRICE
- 14.0000
- SOURCE_METHOD
- D
- AVERAGE_WEIGHT
- 14.0000
- STORE_ORD_MULT
- D
- LOCAL_ITEM_DESC
- Dc Item Loc-003-EDGE
- LOCAL_SHORT_DESC
- Dc Item Loc-003-EDGE
- MULTI_SELLING_UOM
- Dc I
- MULTI_UNIT_RETAIL
- 14.0000
- PRIMARY_COST_PACK
- Dc Item Loc-003-EDGE
- SELLING_UNIT_RETAIL
- 14.0000
- INBOUND_HANDLING_DAYS
- 5
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 26