TSF Delv

In Scope

Technical: TSF_DELV | ID: OR-STO-TSF_DELV-TSF_DELV

This table will contain Transfer Delivery 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

Field Definitions(5)

Rules & Considerations(36)

validation

constraint

Sample Load Data(4)

_scenario	IDRPK	STATUSR	STORE_IDR	SOURCE_IDR	SOURCE_TYPER	ASN_ID	IMPORT_ID	FREIGHT_ID	RECEIPT_NO	CREATE_DATE	CREATE_USER	UPDATE_DATE	UPDATE_USER	CARRIER_CODE	CARRIER_TYPE	EXPECTED_DATE	LICENSE_PLATE	RECEIVED_DATE	RECEIVED_USER	CARRIER_ENTITY	DISPLAY_CARTON	SOURCE_ADDRESS	BOL_EXTERNAL_ID	ADHOC_DOCUMENT_ID	FISCAL_DOC_NUMBER	FISCAL_DOC_REF_ID	FISCAL_DOC_REQUEST_ID
Example values from field definitions	1	1	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAMPLE	2026-01-01	SAMPLE	SAMP	1	2026-01-01	SAMPLE	2026-01-01	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	1	SAMPLE	1	1
default	3	1	1000000003	1000000003	3	ALT-TSF_DELV-002	ALT-TSF_DELV-002	ALT-TSF_DELV-002	TSF Delv-002-ALT	2026-01-03	TSF Delv-002-ALT	2026-01-03	2026-01-02-ALT	ALT-	1	2026-01-03	TSF Delv-002-ALT	2026-01-03	TSF Delv-002-ALT	TSF Delv-002-ALT	Y	TSF Delv-002-ALT	ALT-TSF_DELV-002	—	TSF Delv-002-ALT	1000000003	1000000003
default	5	2	1000000005	1000000005	5	EDGE-TSF_DELV-003	EDGE-TSF_DELV-003	EDGE-TSF_DELV-003	TSF Delv-003-EDGE	2026-01-05	TSF Delv-003-EDGE	2026-01-05	2026-01-03-EDGE	EDGE	0	2026-01-05	TSF Delv-003-EDGE	2026-01-05	TSF Delv-003-EDGE	TSF Delv-003-EDGE	Y	TSF Delv-003-EDGE	EDGE-TSF_DELV-003	—	TSF Delv-003-EDGE	1000000005	1000000005

Example values from field definitions

IDRPK: 1
STATUSR: 1
STORE_IDR: 1
SOURCE_IDR: 1
SOURCE_TYPER: 1
ASN_ID: SAMPLE
IMPORT_ID: SAMPLE
FREIGHT_ID: SAMPLE
RECEIPT_NO: SAMPLE
CREATE_DATE: 2026-01-01
CREATE_USER: SAMPLE
UPDATE_DATE: 2026-01-01
UPDATE_USER: SAMPLE
CARRIER_CODE: SAMP
CARRIER_TYPE: 1
EXPECTED_DATE: 2026-01-01
LICENSE_PLATE: SAMPLE
RECEIVED_DATE: 2026-01-01
RECEIVED_USER: SAMPLE
CARRIER_ENTITY: SAMPLE
DISPLAY_CARTON: S
SOURCE_ADDRESS: SAMPLE
BOL_EXTERNAL_ID: SAMPLE
ADHOC_DOCUMENT_ID: 1
FISCAL_DOC_NUMBER: SAMPLE
FISCAL_DOC_REF_ID: 1
FISCAL_DOC_REQUEST_ID: 1

default

IDRPK: 3
STATUSR: 1
STORE_IDR: 1000000003
SOURCE_IDR: 1000000003
SOURCE_TYPER: 3
ASN_ID: ALT-TSF_DELV-002
IMPORT_ID: ALT-TSF_DELV-002
FREIGHT_ID: ALT-TSF_DELV-002
RECEIPT_NO: TSF Delv-002-ALT
CREATE_DATE: 2026-01-03
CREATE_USER: TSF Delv-002-ALT
UPDATE_DATE: 2026-01-03
UPDATE_USER: 2026-01-02-ALT
CARRIER_CODE: ALT-
CARRIER_TYPE: 1
EXPECTED_DATE: 2026-01-03
LICENSE_PLATE: TSF Delv-002-ALT
RECEIVED_DATE: 2026-01-03
RECEIVED_USER: TSF Delv-002-ALT
CARRIER_ENTITY: TSF Delv-002-ALT
DISPLAY_CARTON: Y
SOURCE_ADDRESS: TSF Delv-002-ALT
BOL_EXTERNAL_ID: ALT-TSF_DELV-002
ADHOC_DOCUMENT_ID: —
FISCAL_DOC_NUMBER: TSF Delv-002-ALT
FISCAL_DOC_REF_ID: 1000000003
FISCAL_DOC_REQUEST_ID: 1000000003

default

IDRPK: 5
STATUSR: 2
STORE_IDR: 1000000005
SOURCE_IDR: 1000000005
SOURCE_TYPER: 5
ASN_ID: EDGE-TSF_DELV-003
IMPORT_ID: EDGE-TSF_DELV-003
FREIGHT_ID: EDGE-TSF_DELV-003
RECEIPT_NO: TSF Delv-003-EDGE
CREATE_DATE: 2026-01-05
CREATE_USER: TSF Delv-003-EDGE
UPDATE_DATE: 2026-01-05
UPDATE_USER: 2026-01-03-EDGE
CARRIER_CODE: EDGE
CARRIER_TYPE: 0
EXPECTED_DATE: 2026-01-05
LICENSE_PLATE: TSF Delv-003-EDGE
RECEIVED_DATE: 2026-01-05
RECEIVED_USER: TSF Delv-003-EDGE
CARRIER_ENTITY: TSF Delv-003-EDGE
DISPLAY_CARTON: Y
SOURCE_ADDRESS: TSF Delv-003-EDGE
BOL_EXTERNAL_ID: EDGE-TSF_DELV-003
ADHOC_DOCUMENT_ID: —
FISCAL_DOC_NUMBER: TSF Delv-003-EDGE
FISCAL_DOC_REF_ID: 1000000005
FISCAL_DOC_REQUEST_ID: 1000000005

Rule Validation Summary

Source Rule Count: 52
Governed Rule Count: 36