DSD Line Item

In Scope

Technical: DSD_LINE_ITEM | ID: OR-STO-DSD_LINE_ITEM-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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: DSD_LINE_ITEM

Field Definitions(5)

Rules & Considerations(33)

constraint

validation

Sample Load Data(4)

_scenario	IDRPK	DSD_IDR	ITEM_IDR	DSD_CARTON_IDR	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	OVERRIDE_UNIT_COST_CURRENC	OVERRIDE_UNIT_COST_CURRENCY
Example values from field definitions	1	1	SAMPLE	1	1	1.00	SAMPLE	1.0000	1.0000	1.0000	1.0000	1	1.0000	1.0000	SAM	SAMPLE	SAMPLE	1.0000	SAMPLE	1.0000	1.0000	SAM	SAM
default	3	1000000003	ALT-DSD_LINE-002	1000000003	1000000003	12.50	ALT-DSD_LINE-002	12.5000	12.5000	12.5000	12.5000	1000000003	12.5000	12.5000	DSD	ALT-DSD_LINE-002	ALT-DSD_LINE-002	12.5000	DSD Line Item-002-ALT	12.5000	12.5000	DSD	—
default	5	1000000005	EDGE-DSD_LINE-003	1000000005	1000000005	14.00	EDGE-DSD_LINE-003	14.0000	14.0000	14.0000	14.0000	1000000005	14.0000	14.0000	DSD	EDGE-DSD_LINE-003	EDGE-DSD_LINE-003	14.0000	DSD Line Item-003-EDGE	14.0000	14.0000	DSD	—

Example values from field definitions

IDRPK: 1
DSD_IDR: 1
ITEM_IDR: SAMPLE
DSD_CARTON_IDR: 1
STORE_ID: 1
CASE_SIZE: 1.00
CUST_ORDER_ID: SAMPLE
UNIT_COST_VALUE: 1.0000
PREVIOUS_DAMAGED: 1.0000
QUANTITY_DAMAGED: 1.0000
PREVIOUS_RECEIVED: 1.0000
PURCHASE_ORDER_ID: 1
QUANTITY_EXPECTED: 1.0000
QUANTITY_RECEIVED: 1.0000
UNIT_COST_CURRENCY: SAM
FUL_ORD_EXTERNAL_ID: SAMPLE
PURCHASE_ORDER_EXT_ID: SAMPLE
QUANTITY_DAMAGED_OVER: 1.0000
VENDOR_PRODUCT_NUMBER: SAMPLE
QUANTITY_RECEIVED_OVER: 1.0000
OVERRIDE_UNIT_COST_VALUE: 1.0000
OVERRIDE_UNIT_COST_CURRENC: SAM
OVERRIDE_UNIT_COST_CURRENCY: SAM

default

IDRPK: 3
DSD_IDR: 1000000003
ITEM_IDR: ALT-DSD_LINE-002
DSD_CARTON_IDR: 1000000003
STORE_ID: 1000000003
CASE_SIZE: 12.50
CUST_ORDER_ID: ALT-DSD_LINE-002
UNIT_COST_VALUE: 12.5000
PREVIOUS_DAMAGED: 12.5000
QUANTITY_DAMAGED: 12.5000
PREVIOUS_RECEIVED: 12.5000
PURCHASE_ORDER_ID: 1000000003
QUANTITY_EXPECTED: 12.5000
QUANTITY_RECEIVED: 12.5000
UNIT_COST_CURRENCY: DSD
FUL_ORD_EXTERNAL_ID: ALT-DSD_LINE-002
PURCHASE_ORDER_EXT_ID: ALT-DSD_LINE-002
QUANTITY_DAMAGED_OVER: 12.5000
VENDOR_PRODUCT_NUMBER: DSD Line Item-002-ALT
QUANTITY_RECEIVED_OVER: 12.5000
OVERRIDE_UNIT_COST_VALUE: 12.5000
OVERRIDE_UNIT_COST_CURRENC: DSD
OVERRIDE_UNIT_COST_CURRENCY: —

default

IDRPK: 5
DSD_IDR: 1000000005
ITEM_IDR: EDGE-DSD_LINE-003
DSD_CARTON_IDR: 1000000005
STORE_ID: 1000000005
CASE_SIZE: 14.00
CUST_ORDER_ID: EDGE-DSD_LINE-003
UNIT_COST_VALUE: 14.0000
PREVIOUS_DAMAGED: 14.0000
QUANTITY_DAMAGED: 14.0000
PREVIOUS_RECEIVED: 14.0000
PURCHASE_ORDER_ID: 1000000005
QUANTITY_EXPECTED: 14.0000
QUANTITY_RECEIVED: 14.0000
UNIT_COST_CURRENCY: DSD
FUL_ORD_EXTERNAL_ID: EDGE-DSD_LINE-003
PURCHASE_ORDER_EXT_ID: EDGE-DSD_LINE-003
QUANTITY_DAMAGED_OVER: 14.0000
VENDOR_PRODUCT_NUMBER: DSD Line Item-003-EDGE
QUANTITY_RECEIVED_OVER: 14.0000
OVERRIDE_UNIT_COST_VALUE: 14.0000
OVERRIDE_UNIT_COST_CURRENC: DSD
OVERRIDE_UNIT_COST_CURRENCY: —

Rule Validation Summary

Source Rule Count: 40
Governed Rule Count: 33