Dc Product
In ScopeTechnical: DC_PRODUCT | ID: OR-ITM-DC_PRODUCT-DC_PRODUCT
This table is a staging table for data conversion and will hold style item data of ITEM_MASTER 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_PRODUCT
Field Definitions(34)
Rules & Considerations(34)
Sample Load Data(4)
| _scenario | ITEM | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | COMMENTS | ITEM_DESC | WASTE_PCT | BRAND_NAME | SHORT_DESC | WASTE_TYPE | ITEM_PARENT | PACKAGE_UOM | FORECAST_IND | PACKAGE_SIZE | STANDARD_UOM | AIP_CASE_TYPE | HANDLING_TEMP | CONTAINER_ITEM | PERISHABLE_IND | STORE_ORD_MULT | MERCHANDISE_IND | UOM_CONV_FACTOR | CATCH_WEIGHT_IND | DEFAULT_WASTE_PCT | DEPOSIT_ITEM_TYPE | RETAIL_LABEL_TYPE | COST_ZONE_GROUP_ID | RETAIL_LABEL_VALUE | ITEM_DESC_SECONDARY | PRIMARY_PRODUCT_IND | HANDLING_SENSITIVITY | PRODUCT_CLASSIFICATION | DEPOSIT_IN_PRICE_PER_UOM |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMP | S | 1.0000 | SAMP | SAMPLE | SAMPLE | SAMPLE | S | S | S | 1.0000000000 | S | 1.0000 | SAMPLE | SAMPLE | 1 | 1.0000 | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE |
Example values from field definitions
- ITEM
- SAMPLE
- DIFF_1
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DIFF_4
- SAMPLE
- COMMENTS
- SAMPLE
- ITEM_DESC
- SAMPLE
- WASTE_PCT
- 1.0000
- BRAND_NAME
- SAMPLE
- SHORT_DESC
- SAMPLE
- WASTE_TYPE
- SAMPLE
- ITEM_PARENT
- SAMPLE
- PACKAGE_UOM
- SAMP
- FORECAST_IND
- S
- PACKAGE_SIZE
- 1.0000
- STANDARD_UOM
- SAMP
- AIP_CASE_TYPE
- SAMPLE
- HANDLING_TEMP
- SAMPLE
- CONTAINER_ITEM
- SAMPLE
- PERISHABLE_IND
- S
- STORE_ORD_MULT
- S
- MERCHANDISE_IND
- S
- UOM_CONV_FACTOR
- 1.0000000000
- CATCH_WEIGHT_IND
- S
- DEFAULT_WASTE_PCT
- 1.0000
- DEPOSIT_ITEM_TYPE
- SAMPLE
- RETAIL_LABEL_TYPE
- SAMPLE
- COST_ZONE_GROUP_ID
- 1
- RETAIL_LABEL_VALUE
- 1.0000
- ITEM_DESC_SECONDARY
- SAMPLE
- PRIMARY_PRODUCT_IND
- S
- HANDLING_SENSITIVITY
- SAMPLE
- PRODUCT_CLASSIFICATION
- SAMPLE
- DEPOSIT_IN_PRICE_PER_UOM
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 44
- Governed Rule Count
- 34