Transfer Stock Allocated To The Locations
In ScopeTechnical: TSF_ALLOCATION | ID: OR-STO-TSF_ALLOCATION-TSF_ALLOCATION
Stores transfer stock allocated to the locations.
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_ALLOCATION
Field Definitions(5)
Rules & Considerations(29)
constraint
validation
Sample Load Data(4)
| _scenario | ITEM_IDRPK | STORE_IDRPK | EXTERNAL_IDRPK | STATUS | IMPORT_ID | SOURCE_ID | CONTEXT_ID | SOURCE_TYPE | CONTEXT_VALUE | DELIVERY_DATE | CONTEXT_TYPE_ID | DELIVERY_SLOT_ID | QUANTITY_DAMAGED | QUANTITY_EXPECTED | QUANTITY_RECEIVED | DISTRIBUTION_PARENT_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | 2026-01-01 | SAMPLE | 1 | 1.0000 | 1.0000 | 1.0000 | SAMPLE |
| default | ALT-TSF_ALLOCA-002 | 1000000003 | 1000000003 | 2 | ALT-TSF_ALLOCA-002 | 1000000003 | 1000000003 | 3 | TSF Allocation-002-ALT | 2026-01-03 | — | 1000000003 | 12.5000 | 12.5000 | 12.5000 | ALT-TSF_ALLOCA-002 |
| default | EDGE-TSF_ALLOCA-003 | 1000000005 | 1000000005 | 3 | EDGE-TSF_ALLOCA-003 | 1000000005 | 1000000005 | 5 | TSF Allocation-003-EDGE | 2026-01-05 | — | 1000000005 | 14.0000 | 14.0000 | 14.0000 | EDGE-TSF_ALLOCA-003 |
Example values from field definitions
- ITEM_IDRPK
- SAMPLE
- STORE_IDRPK
- 1
- EXTERNAL_IDRPK
- 1
- STATUS
- 1
- IMPORT_ID
- SAMPLE
- SOURCE_ID
- 1
- CONTEXT_ID
- 1
- SOURCE_TYPE
- 1
- CONTEXT_VALUE
- SAMPLE
- DELIVERY_DATE
- 2026-01-01
- CONTEXT_TYPE_ID
- SAMPLE
- DELIVERY_SLOT_ID
- 1
- QUANTITY_DAMAGED
- 1.0000
- QUANTITY_EXPECTED
- 1.0000
- QUANTITY_RECEIVED
- 1.0000
- DISTRIBUTION_PARENT_ID
- SAMPLE
default
- ITEM_IDRPK
- ALT-TSF_ALLOCA-002
- STORE_IDRPK
- 1000000003
- EXTERNAL_IDRPK
- 1000000003
- STATUS
- 2
- IMPORT_ID
- ALT-TSF_ALLOCA-002
- SOURCE_ID
- 1000000003
- CONTEXT_ID
- 1000000003
- SOURCE_TYPE
- 3
- CONTEXT_VALUE
- TSF Allocation-002-ALT
- DELIVERY_DATE
- 2026-01-03
- CONTEXT_TYPE_ID
- —
- DELIVERY_SLOT_ID
- 1000000003
- QUANTITY_DAMAGED
- 12.5000
- QUANTITY_EXPECTED
- 12.5000
- QUANTITY_RECEIVED
- 12.5000
- DISTRIBUTION_PARENT_ID
- ALT-TSF_ALLOCA-002
default
- ITEM_IDRPK
- EDGE-TSF_ALLOCA-003
- STORE_IDRPK
- 1000000005
- EXTERNAL_IDRPK
- 1000000005
- STATUS
- 3
- IMPORT_ID
- EDGE-TSF_ALLOCA-003
- SOURCE_ID
- 1000000005
- CONTEXT_ID
- 1000000005
- SOURCE_TYPE
- 5
- CONTEXT_VALUE
- TSF Allocation-003-EDGE
- DELIVERY_DATE
- 2026-01-05
- CONTEXT_TYPE_ID
- —
- DELIVERY_SLOT_ID
- 1000000005
- QUANTITY_DAMAGED
- 14.0000
- QUANTITY_EXPECTED
- 14.0000
- QUANTITY_RECEIVED
- 14.0000
- DISTRIBUTION_PARENT_ID
- EDGE-TSF_ALLOCA-003
Rule Validation Summary
- Source Rule Count
- 33
- Governed Rule Count
- 29