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(26)
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 |
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
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 26