DSD Carton
In ScopeTechnical: DSD_CARTON | ID: OR-STO-DSD_CARTON-DSD_CARTON
Stores one row for each carton that a direct delivery contains.
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_CARTON
Field Definitions(5)
Rules & Considerations(33)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | DSD_IDR | STATUSR | ADJUSTED | STORE_ID | IMPORT_ID | CREATE_DATE | CREATE_USER | EXTERNAL_ID | SERIAL_CODE | UPDATE_DATE | UPDATE_USER | RECEIVE_DATE | RECEIVE_USER | REFERENCE_ID | UIN_REQUIRED | DAMAGED_REASON | EXTERNAL_CREATE | QUALITY_CONTROL | TRACKING_NUMBER | DAMAGE_REMAINING | RECEIVE_AT_SHOP_FLOOR | CUSTOMER_ORDER_RELATED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | S | 1 | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | 1 | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | S | SAMPLE | S | S | SAMPLE | S | S | 1 |
| default | 3 | 1000000003 | 2 | Y | 1000000003 | ALT-DSD_CARTON-002 | 2026-01-03 | DSD Carton-002-ALT | ALT-DSD_CARTON-002 | 3 | 2026-01-03 | 2026-01-02-ALT | 2026-01-03 | DSD Carton-002-ALT | ALT-DSD_CARTON-002 | N | DSD Carton-002-ALT | Y | N | DSD Carton-002-ALT | N | N | 3 |
| default | 5 | 1000000005 | 3 | N | 1000000005 | EDGE-DSD_CARTON-003 | 2026-01-05 | DSD Carton-003-EDGE | EDGE-DSD_CARTON-003 | 5 | 2026-01-05 | 2026-01-03-EDGE | 2026-01-05 | DSD Carton-003-EDGE | — | N | DSD Carton-003-EDGE | N | N | DSD Carton-003-EDGE | N | N | 5 |
Example values from field definitions
- IDRPK
- 1
- DSD_IDR
- 1
- STATUSR
- 1
- ADJUSTED
- S
- STORE_ID
- 1
- IMPORT_ID
- SAMPLE
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- EXTERNAL_ID
- SAMPLE
- SERIAL_CODE
- 1
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- RECEIVE_DATE
- 2026-01-01
- RECEIVE_USER
- SAMPLE
- REFERENCE_ID
- SAMPLE
- UIN_REQUIRED
- S
- DAMAGED_REASON
- SAMPLE
- EXTERNAL_CREATE
- S
- QUALITY_CONTROL
- S
- TRACKING_NUMBER
- SAMPLE
- DAMAGE_REMAINING
- S
- RECEIVE_AT_SHOP_FLOOR
- S
- CUSTOMER_ORDER_RELATED
- 1
default
- IDRPK
- 3
- DSD_IDR
- 1000000003
- STATUSR
- 2
- ADJUSTED
- Y
- STORE_ID
- 1000000003
- IMPORT_ID
- ALT-DSD_CARTON-002
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- DSD Carton-002-ALT
- EXTERNAL_ID
- ALT-DSD_CARTON-002
- SERIAL_CODE
- 3
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- RECEIVE_DATE
- 2026-01-03
- RECEIVE_USER
- DSD Carton-002-ALT
- REFERENCE_ID
- ALT-DSD_CARTON-002
- UIN_REQUIRED
- N
- DAMAGED_REASON
- DSD Carton-002-ALT
- EXTERNAL_CREATE
- Y
- QUALITY_CONTROL
- N
- TRACKING_NUMBER
- DSD Carton-002-ALT
- DAMAGE_REMAINING
- N
- RECEIVE_AT_SHOP_FLOOR
- N
- CUSTOMER_ORDER_RELATED
- 3
default
- IDRPK
- 5
- DSD_IDR
- 1000000005
- STATUSR
- 3
- ADJUSTED
- N
- STORE_ID
- 1000000005
- IMPORT_ID
- EDGE-DSD_CARTON-003
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- DSD Carton-003-EDGE
- EXTERNAL_ID
- EDGE-DSD_CARTON-003
- SERIAL_CODE
- 5
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- RECEIVE_DATE
- 2026-01-05
- RECEIVE_USER
- DSD Carton-003-EDGE
- REFERENCE_ID
- —
- UIN_REQUIRED
- N
- DAMAGED_REASON
- DSD Carton-003-EDGE
- EXTERNAL_CREATE
- N
- QUALITY_CONTROL
- N
- TRACKING_NUMBER
- DSD Carton-003-EDGE
- DAMAGE_REMAINING
- N
- RECEIVE_AT_SHOP_FLOOR
- N
- CUSTOMER_ORDER_RELATED
- 5
Rule Validation Summary
- Source Rule Count
- 52
- Governed Rule Count
- 33