Dc Item Loc
In ScopeTechnical: DC_ITEM_LOC | ID: OR-MFCS-DC_ITEM_LOC
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
Target Structure
- Load Approach
- Table
- Target Objects
- DC_ITEM_LOC
Field Definitions(26)
Rules & Considerations(8)
Validation
Sequencing
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 11.0000 | 11.0000 | Dc Item Loc-001 | 1 | store | Dc Item Loc-001 | 9001 | Dc Item Loc-001 | Dc Item Loc-001 | 11.0000 | Dc Item Loc-001 | Dc Item Loc-001 | Dc Item Loc-001 | 11.0000 | Dc Item Loc-001 | 11.0000 | Dc Item Loc-001 | 11.0000 | Dc Item Loc-001 | Dc Item Loc-001 | Dc Item Loc-001 | Dc Item Loc-001 | 11.0000 | Dc Item Loc-001 | 11.0000 | 01 |
default
- HI
- 11.0000
- TI
- 11.0000
- ITEM
- Dc Item Loc-001
- LOCATION
- 1
- LOC_TYPE
- store
- UIN_TYPE
- Dc Item Loc-001
- SOURCE_WH
- 9001
- UIN_LABEL
- Dc Item Loc-001
- EXT_UIN_IND
- Dc Item Loc-001
- MULTI_UNITS
- 11.0000
- SELLING_UOM
- Dc Item Loc-001
- TAXABLE_IND
- Dc Item Loc-001
- CAPTURE_TIME
- Dc Item Loc-001
- MEAS_OF_EACH
- 11.0000
- UOM_OF_PRICE
- Dc Item Loc-001
- MEAS_OF_PRICE
- 11.0000
- SOURCE_METHOD
- Dc Item Loc-001
- AVERAGE_WEIGHT
- 11.0000
- STORE_ORD_MULT
- Dc Item Loc-001
- LOCAL_ITEM_DESC
- Dc Item Loc-001
- LOCAL_SHORT_DESC
- Dc Item Loc-001
- MULTI_SELLING_UOM
- Dc Item Loc-001
- MULTI_UNIT_RETAIL
- 11.0000
- PRIMARY_COST_PACK
- Dc Item Loc-001
- SELLING_UNIT_RETAIL
- 11.0000
- INBOUND_HANDLING_DAYS
- 01