TSF Delv Carton
In ScopeTechnical: TSF_DELV_CARTON | ID: OR-STO-TSF_DELV_CARTON-TSF_DELV_CARTON
This table will contain transfer delivery carton record.
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
- TSF_DELV_CARTON
Field Definitions(5)
Rules & Considerations(41)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | STORE_IDR | TSF_DELV_IDR | COPIED | STATUS | ADJUSTED | IMPORT_ID | DISCREPANT | CREATE_DATE | CREATE_USER | EXTERNAL_ID | SERIAL_CODE | UPDATE_DATE | UPDATE_USER | REFERENCE_ID | RECEIVED_DATE | RECEIVED_USER | DAMAGED_REASON | MISDIRECTED_ID | 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 | S | SAMPLE | S | 2026-01-01 | SAMPLE | SAMPLE | 1 | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | 1 | S | S | SAMPLE | S | S | 1 |
| default | 3 | 1000000003 | 1000000003 | N | 2 | N | ALT-TSF_DELV-002 | N | 2026-01-03 | TSF Delv Carton-002-ALT | ALT-TSF_DELV-002 | 3 | 2026-01-03 | 2026-01-02-ALT | ALT-TSF_DELV-002 | 2026-01-03 | TSF Delv Carton-002-ALT | TSF Delv Carton-002-ALT | 1000000003 | N | N | TSF Delv Carton-002-ALT | N | N | 3 |
| default | 5 | 1000000005 | 1000000005 | N | 3 | N | EDGE-TSF_DELV-003 | N | 2026-01-05 | TSF Delv Carton-003-EDGE | EDGE-TSF_DELV-003 | 5 | 2026-01-05 | 2026-01-03-EDGE | — | 2026-01-05 | TSF Delv Carton-003-EDGE | TSF Delv Carton-003-EDGE | 1000000005 | N | N | TSF Delv Carton-003-EDGE | N | N | 5 |
Example values from field definitions
- IDRPK
- 1
- STORE_IDR
- 1
- TSF_DELV_IDR
- 1
- COPIED
- S
- STATUS
- 1
- ADJUSTED
- S
- IMPORT_ID
- SAMPLE
- DISCREPANT
- S
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- EXTERNAL_ID
- SAMPLE
- SERIAL_CODE
- 1
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- REFERENCE_ID
- SAMPLE
- RECEIVED_DATE
- 2026-01-01
- RECEIVED_USER
- SAMPLE
- DAMAGED_REASON
- SAMPLE
- MISDIRECTED_ID
- 1
- EXTERNAL_CREATE
- S
- QUALITY_CONTROL
- S
- TRACKING_NUMBER
- SAMPLE
- DAMAGE_REMAINING
- S
- RECEIVE_AT_SHOP_FLOOR
- S
- CUSTOMER_ORDER_RELATED
- 1
default
- IDRPK
- 3
- STORE_IDR
- 1000000003
- TSF_DELV_IDR
- 1000000003
- COPIED
- N
- STATUS
- 2
- ADJUSTED
- N
- IMPORT_ID
- ALT-TSF_DELV-002
- DISCREPANT
- N
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- TSF Delv Carton-002-ALT
- EXTERNAL_ID
- ALT-TSF_DELV-002
- SERIAL_CODE
- 3
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- REFERENCE_ID
- ALT-TSF_DELV-002
- RECEIVED_DATE
- 2026-01-03
- RECEIVED_USER
- TSF Delv Carton-002-ALT
- DAMAGED_REASON
- TSF Delv Carton-002-ALT
- MISDIRECTED_ID
- 1000000003
- EXTERNAL_CREATE
- N
- QUALITY_CONTROL
- N
- TRACKING_NUMBER
- TSF Delv Carton-002-ALT
- DAMAGE_REMAINING
- N
- RECEIVE_AT_SHOP_FLOOR
- N
- CUSTOMER_ORDER_RELATED
- 3
default
- IDRPK
- 5
- STORE_IDR
- 1000000005
- TSF_DELV_IDR
- 1000000005
- COPIED
- N
- STATUS
- 3
- ADJUSTED
- N
- IMPORT_ID
- EDGE-TSF_DELV-003
- DISCREPANT
- N
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- TSF Delv Carton-003-EDGE
- EXTERNAL_ID
- EDGE-TSF_DELV-003
- SERIAL_CODE
- 5
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- REFERENCE_ID
- —
- RECEIVED_DATE
- 2026-01-05
- RECEIVED_USER
- TSF Delv Carton-003-EDGE
- DAMAGED_REASON
- TSF Delv Carton-003-EDGE
- MISDIRECTED_ID
- 1000000005
- EXTERNAL_CREATE
- N
- QUALITY_CONTROL
- N
- TRACKING_NUMBER
- TSF Delv Carton-003-EDGE
- DAMAGE_REMAINING
- N
- RECEIVE_AT_SHOP_FLOOR
- N
- CUSTOMER_ORDER_RELATED
- 5
Rule Validation Summary
- Source Rule Count
- 67
- Governed Rule Count
- 41