Transfer Delivery Line Item Records
In ScopeTechnical: TSF_DELV_LINE_ITEM | ID: OR-STO-TSF_DELV_LINE_ITEM-TSF_DELV_LINE_ITEM
Stores transfer delivery line item records.
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_LINE_ITEM
Field Definitions(5)
Rules & Considerations(33)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | TSF_DELV_IDR | TSF_DELV_CARTON_IDR | STORE_ID | CASE_SIZE | DOCUMENT_ID | DOCUMENT_DATE | DOCUMENT_TYPE | USE_AVAILABLE | PREVIOUS_DAMAGED | QUANTITY_DAMAGED | PREVIOUS_RECEIVED | QUANTITY_EXPECTED | QUANTITY_RECEIVED | FUL_ORD_EXTERNAL_ID | CUST_ORD_EXTERNAL_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | 1.00 | 1 | 2026-01-01 | 1 | S | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | SAMPLE |
| default | 3 | ALT-TSF_DELV-002 | 1000000003 | 1000000003 | 1000000003 | 12.50 | 1000000003 | 2026-01-03 | 3 | Y | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | ALT-TSF_DELV-002 | ALT-TSF_DELV-002 |
| default | 5 | EDGE-TSF_DELV-003 | 1000000005 | 1000000005 | 1000000005 | 14.00 | 1000000005 | 2026-01-05 | 5 | Y | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | EDGE-TSF_DELV-003 | EDGE-TSF_DELV-003 |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- TSF_DELV_IDR
- 1
- TSF_DELV_CARTON_IDR
- 1
- STORE_ID
- 1
- CASE_SIZE
- 1.00
- DOCUMENT_ID
- 1
- DOCUMENT_DATE
- 2026-01-01
- DOCUMENT_TYPE
- 1
- USE_AVAILABLE
- S
- PREVIOUS_DAMAGED
- 1.0000
- QUANTITY_DAMAGED
- 1.0000
- PREVIOUS_RECEIVED
- 1.0000
- QUANTITY_EXPECTED
- 1.0000
- QUANTITY_RECEIVED
- 1.0000
- FUL_ORD_EXTERNAL_ID
- SAMPLE
- CUST_ORD_EXTERNAL_ID
- SAMPLE
default
- IDRPK
- 3
- ITEM_IDR
- ALT-TSF_DELV-002
- TSF_DELV_IDR
- 1000000003
- TSF_DELV_CARTON_IDR
- 1000000003
- STORE_ID
- 1000000003
- CASE_SIZE
- 12.50
- DOCUMENT_ID
- 1000000003
- DOCUMENT_DATE
- 2026-01-03
- DOCUMENT_TYPE
- 3
- USE_AVAILABLE
- Y
- PREVIOUS_DAMAGED
- 12.5000
- QUANTITY_DAMAGED
- 12.5000
- PREVIOUS_RECEIVED
- 12.5000
- QUANTITY_EXPECTED
- 12.5000
- QUANTITY_RECEIVED
- 12.5000
- FUL_ORD_EXTERNAL_ID
- ALT-TSF_DELV-002
- CUST_ORD_EXTERNAL_ID
- ALT-TSF_DELV-002
default
- IDRPK
- 5
- ITEM_IDR
- EDGE-TSF_DELV-003
- TSF_DELV_IDR
- 1000000005
- TSF_DELV_CARTON_IDR
- 1000000005
- STORE_ID
- 1000000005
- CASE_SIZE
- 14.00
- DOCUMENT_ID
- 1000000005
- DOCUMENT_DATE
- 2026-01-05
- DOCUMENT_TYPE
- 5
- USE_AVAILABLE
- Y
- PREVIOUS_DAMAGED
- 14.0000
- QUANTITY_DAMAGED
- 14.0000
- PREVIOUS_RECEIVED
- 14.0000
- QUANTITY_EXPECTED
- 14.0000
- QUANTITY_RECEIVED
- 14.0000
- FUL_ORD_EXTERNAL_ID
- EDGE-TSF_DELV-003
- CUST_ORD_EXTERNAL_ID
- EDGE-TSF_DELV-003
Rule Validation Summary
- Source Rule Count
- 47
- Governed Rule Count
- 33