DSD Line Item
In ScopeTechnical: DSD_LINE_ITEM | ID: OR-SIOCS-DSD_LINE_ITEM
the table holds one row for each item that is in the carton of a direct delivery.
See how this object fits into Store Operations
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
- DSD_LINE_ITEM
Field Definitions(22)
Rules & Considerations(54)
Sample Load Data(4)
| _scenario | IDRPK | DSD_IDRPK | ITEM_IDR | DSD_CARTON_IDR | OVERRIDE_UNIT_COST_CURRENCPK | STORE_ID | CASE_SIZE | CUST_ORDER_ID | UNIT_COST_VALUE | PREVIOUS_DAMAGED | QUANTITY_DAMAGED | PREVIOUS_RECEIVED | PURCHASE_ORDER_ID | QUANTITY_EXPECTED | QUANTITY_RECEIVED | UNIT_COST_CURRENCY | FUL_ORD_EXTERNAL_ID | PURCHASE_ORDER_EXT_ID | QUANTITY_DAMAGED_OVER | VENDOR_PRODUCT_NUMBER | QUANTITY_RECEIVED_OVER | OVERRIDE_UNIT_COST_VALUE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1000000001 | STD-DSD_LINE-001 | 1000000001 | DSD Line Item-001 | 1000000001 | 11.00 | STD-DSD_LINE-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 1000000001 | 11.0000 | 11.0000 | DSD Line Item-001 | STD-DSD_LINE-001 | STD-DSD_LINE-001 | 11.0000 | DSD Line Item-001 | 11.0000 | 11.0000 |
default
- IDRPK
- 1
- DSD_IDRPK
- 1000000001
- ITEM_IDR
- STD-DSD_LINE-001
- DSD_CARTON_IDR
- 1000000001
- OVERRIDE_UNIT_COST_CURRENCPK
- DSD Line Item-001
- STORE_ID
- 1000000001
- CASE_SIZE
- 11.00
- CUST_ORDER_ID
- STD-DSD_LINE-001
- UNIT_COST_VALUE
- 11.0000
- PREVIOUS_DAMAGED
- 11.0000
- QUANTITY_DAMAGED
- 11.0000
- PREVIOUS_RECEIVED
- 11.0000
- PURCHASE_ORDER_ID
- 1000000001
- QUANTITY_EXPECTED
- 11.0000
- QUANTITY_RECEIVED
- 11.0000
- UNIT_COST_CURRENCY
- DSD Line Item-001
- FUL_ORD_EXTERNAL_ID
- STD-DSD_LINE-001
- PURCHASE_ORDER_EXT_ID
- STD-DSD_LINE-001
- QUANTITY_DAMAGED_OVER
- 11.0000
- VENDOR_PRODUCT_NUMBER
- DSD Line Item-001
- QUANTITY_RECEIVED_OVER
- 11.0000
- OVERRIDE_UNIT_COST_VALUE
- 11.0000