TSF
In ScopeTechnical: TSF | ID: OR-STO-TSF-TSF
Stores the transfer document which captures the request for a transfer to a store, warehouse, or finisher.
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
Field Definitions(5)
Rules & Considerations(41)
Sample Load Data(4)
| _scenario | IDRPK | SOURCE_IDR | SOURCE_TYPER | DESTINATION_TYPER | STATUS | IMPORT_ID | CLOSE_DATE | CLOSE_USER | CONTEXT_ID | CREATE_DATE | CREATE_USER | EXTERNAL_ID | ORIGIN_TYPE | REJECT_DATE | REJECT_USER | UPDATE_DATE | UPDATE_USER | REQUEST_DATE | REQUEST_USER | APPROVAL_DATE | APPROVAL_USER | CONTEXT_VALUE | DISTRO_NUMBER | USE_AVAILABLE | DESTINATION_ID | NOT_AFTER_DATE | CONTEXT_TYPE_ID | AUTHORIZATION_CODE | FUL_ORD_EXTERNAL_ID | CUST_ORD_EXTERNAL_ID | ALLOW_PARTIAL_DELIVERY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | SAMPLE | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | SAMPLE | SAMPLE | 1 | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | S | 1 | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S |
| default | 3 | 1000000003 | 3 | 3 | 3 | ALT-TSF-002 | 2026-01-03 | TSF-002-ALT | 1000000003 | 2026-01-03 | TSF-002-ALT | ALT-TSF-002 | 3 | 2026-01-03 | TSF-002-ALT | 2026-01-03 | 2026-01-02-ALT | 2026-01-03 | TSF-002-ALT | 2026-01-03 | TSF-002-ALT | TSF-002-ALT | TSF-002-ALT | Y | 1000000003 | 2026-01-03 | — | ALT-TSF-002 | ALT-TSF-002 | ALT-TSF-002 | T |
| default | 5 | 1000000005 | 5 | 5 | 5 | EDGE-TSF-003 | 2026-01-05 | TSF-003-EDGE | 1000000005 | 2026-01-05 | TSF-003-EDGE | EDGE-TSF-003 | 5 | 2026-01-05 | TSF-003-EDGE | 2026-01-05 | 2026-01-03-EDGE | 2026-01-05 | TSF-003-EDGE | 2026-01-05 | TSF-003-EDGE | TSF-003-EDGE | TSF-003-EDGE | Y | 1000000005 | 2026-01-05 | — | EDGE-TSF-003 | EDGE-TSF-003 | EDGE-TSF-003 | T |
Example values from field definitions
- IDRPK
- 1
- SOURCE_IDR
- 1
- SOURCE_TYPER
- 1
- DESTINATION_TYPER
- 1
- STATUS
- 1
- IMPORT_ID
- SAMPLE
- CLOSE_DATE
- 2026-01-01
- CLOSE_USER
- SAMPLE
- CONTEXT_ID
- 1
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- EXTERNAL_ID
- SAMPLE
- ORIGIN_TYPE
- 1
- REJECT_DATE
- 2026-01-01
- REJECT_USER
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- REQUEST_DATE
- 2026-01-01
- REQUEST_USER
- SAMPLE
- APPROVAL_DATE
- 2026-01-01
- APPROVAL_USER
- SAMPLE
- CONTEXT_VALUE
- SAMPLE
- DISTRO_NUMBER
- SAMPLE
- USE_AVAILABLE
- S
- DESTINATION_ID
- 1
- NOT_AFTER_DATE
- 2026-01-01
- CONTEXT_TYPE_ID
- SAMPLE
- AUTHORIZATION_CODE
- SAMPLE
- FUL_ORD_EXTERNAL_ID
- SAMPLE
- CUST_ORD_EXTERNAL_ID
- SAMPLE
- ALLOW_PARTIAL_DELIVERY
- S
default
- IDRPK
- 3
- SOURCE_IDR
- 1000000003
- SOURCE_TYPER
- 3
- DESTINATION_TYPER
- 3
- STATUS
- 3
- IMPORT_ID
- ALT-TSF-002
- CLOSE_DATE
- 2026-01-03
- CLOSE_USER
- TSF-002-ALT
- CONTEXT_ID
- 1000000003
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- TSF-002-ALT
- EXTERNAL_ID
- ALT-TSF-002
- ORIGIN_TYPE
- 3
- REJECT_DATE
- 2026-01-03
- REJECT_USER
- TSF-002-ALT
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- REQUEST_DATE
- 2026-01-03
- REQUEST_USER
- TSF-002-ALT
- APPROVAL_DATE
- 2026-01-03
- APPROVAL_USER
- TSF-002-ALT
- CONTEXT_VALUE
- TSF-002-ALT
- DISTRO_NUMBER
- TSF-002-ALT
- USE_AVAILABLE
- Y
- DESTINATION_ID
- 1000000003
- NOT_AFTER_DATE
- 2026-01-03
- CONTEXT_TYPE_ID
- —
- AUTHORIZATION_CODE
- ALT-TSF-002
- FUL_ORD_EXTERNAL_ID
- ALT-TSF-002
- CUST_ORD_EXTERNAL_ID
- ALT-TSF-002
- ALLOW_PARTIAL_DELIVERY
- T
default
- IDRPK
- 5
- SOURCE_IDR
- 1000000005
- SOURCE_TYPER
- 5
- DESTINATION_TYPER
- 5
- STATUS
- 5
- IMPORT_ID
- EDGE-TSF-003
- CLOSE_DATE
- 2026-01-05
- CLOSE_USER
- TSF-003-EDGE
- CONTEXT_ID
- 1000000005
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- TSF-003-EDGE
- EXTERNAL_ID
- EDGE-TSF-003
- ORIGIN_TYPE
- 5
- REJECT_DATE
- 2026-01-05
- REJECT_USER
- TSF-003-EDGE
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- REQUEST_DATE
- 2026-01-05
- REQUEST_USER
- TSF-003-EDGE
- APPROVAL_DATE
- 2026-01-05
- APPROVAL_USER
- TSF-003-EDGE
- CONTEXT_VALUE
- TSF-003-EDGE
- DISTRO_NUMBER
- TSF-003-EDGE
- USE_AVAILABLE
- Y
- DESTINATION_ID
- 1000000005
- NOT_AFTER_DATE
- 2026-01-05
- CONTEXT_TYPE_ID
- —
- AUTHORIZATION_CODE
- EDGE-TSF-003
- FUL_ORD_EXTERNAL_ID
- EDGE-TSF-003
- CUST_ORD_EXTERNAL_ID
- EDGE-TSF-003
- ALLOW_PARTIAL_DELIVERY
- T
Rule Validation Summary
- Source Rule Count
- 58
- Governed Rule Count
- 41