TSF Shipment

In Scope

Technical: TSF_SHIP | ID: OR-STO-TSF_SHIP-TSF_SHIPMENT

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

Field Definitions(5)

Rules & Considerations(39)

Sample Load Data(4)

_scenario	IDRPK	STORE_IDR	DESTINATION_IDR	DESTINATION_TYPER	ASN	STATUS	IMPORT_ID	CONTEXT_ID	CREATE_DATE	CREATE_USER	SUBMIT_DATE	SUBMIT_USER	UPDATE_DATE	UPDATE_USER	CONTEXT_VALUE	DISPATCH_DATE	DISPATCH_USER	DISPLAY_CARTON	NOT_AFTER_DATE	SHIPMENT_BOL_ID	ADHOC_DOCUMENT_ID	FISCAL_DOC_NUMBER	FISCAL_DOC_REF_ID	FISCAL_DOC_STATUS	AUTHORIZATION_CODE	FISCAL_DOC_PRINT_URL	FISCAL_DOC_REQUEST_ID	FISCAL_DOC_REJECT_REASON
Example values from field definitions	1	1	1	1	SAMPLE	1	SAMPLE	1	2026-01-01	SAMPLE	2026-01-01	SAMPLE	2026-01-01	SAMPLE	SAMPLE	2026-01-01	SAMPLE	S	2026-01-01	1	1	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE
default	3	1000000003	1000000003	3	TSF Ship-002-ALT	2	ALT-TSF_SHIP-002	1000000003	2026-01-03	TSF Ship-002-ALT	2026-01-03	TSF Ship-002-ALT	2026-01-03	2026-01-02-ALT	TSF Ship-002-ALT	2026-01-03	TSF Ship-002-ALT	Y	2026-01-03	1000000003	1000000003	TSF Ship-002-ALT	1000000003	2	ALT-TSF_SHIP	TSF Ship-002-ALT	1000000003	TSF Ship-002-ALT
default	5	1000000005	1000000005	5	TSF Ship-003-EDGE	3	EDGE-TSF_SHIP-003	1000000005	2026-01-05	TSF Ship-003-EDGE	2026-01-05	TSF Ship-003-EDGE	2026-01-05	2026-01-03-EDGE	TSF Ship-003-EDGE	2026-01-05	TSF Ship-003-EDGE	Y	2026-01-05	1000000005	1000000005	TSF Ship-003-EDGE	1000000005	3	EDGE-TSF_SHI	TSF Ship-003-EDGE	1000000005	TSF Ship-003-EDGE

Example values from field definitions

IDRPK: 1
STORE_IDR: 1
DESTINATION_IDR: 1
DESTINATION_TYPER: 1
ASN: SAMPLE
STATUS: 1
IMPORT_ID: SAMPLE
CONTEXT_ID: 1
CREATE_DATE: 2026-01-01
CREATE_USER: SAMPLE
SUBMIT_DATE: 2026-01-01
SUBMIT_USER: SAMPLE
UPDATE_DATE: 2026-01-01
UPDATE_USER: SAMPLE
CONTEXT_VALUE: SAMPLE
DISPATCH_DATE: 2026-01-01
DISPATCH_USER: SAMPLE
DISPLAY_CARTON: S
NOT_AFTER_DATE: 2026-01-01
SHIPMENT_BOL_ID: 1
ADHOC_DOCUMENT_ID: 1
FISCAL_DOC_NUMBER: SAMPLE
FISCAL_DOC_REF_ID: 1
FISCAL_DOC_STATUS: SAMPLE
AUTHORIZATION_CODE: SAMPLE
FISCAL_DOC_PRINT_URL: SAMPLE
FISCAL_DOC_REQUEST_ID: 1
FISCAL_DOC_REJECT_REASON: SAMPLE

default

IDRPK: 3
STORE_IDR: 1000000003
DESTINATION_IDR: 1000000003
DESTINATION_TYPER: 3
ASN: TSF Ship-002-ALT
STATUS: 2
IMPORT_ID: ALT-TSF_SHIP-002
CONTEXT_ID: 1000000003
CREATE_DATE: 2026-01-03
CREATE_USER: TSF Ship-002-ALT
SUBMIT_DATE: 2026-01-03
SUBMIT_USER: TSF Ship-002-ALT
UPDATE_DATE: 2026-01-03
UPDATE_USER: 2026-01-02-ALT
CONTEXT_VALUE: TSF Ship-002-ALT
DISPATCH_DATE: 2026-01-03
DISPATCH_USER: TSF Ship-002-ALT
DISPLAY_CARTON: Y
NOT_AFTER_DATE: 2026-01-03
SHIPMENT_BOL_ID: 1000000003
ADHOC_DOCUMENT_ID: 1000000003
FISCAL_DOC_NUMBER: TSF Ship-002-ALT
FISCAL_DOC_REF_ID: 1000000003
FISCAL_DOC_STATUS: 2
AUTHORIZATION_CODE: ALT-TSF_SHIP
FISCAL_DOC_PRINT_URL: TSF Ship-002-ALT
FISCAL_DOC_REQUEST_ID: 1000000003
FISCAL_DOC_REJECT_REASON: TSF Ship-002-ALT

default

IDRPK: 5
STORE_IDR: 1000000005
DESTINATION_IDR: 1000000005
DESTINATION_TYPER: 5
ASN: TSF Ship-003-EDGE
STATUS: 3
IMPORT_ID: EDGE-TSF_SHIP-003
CONTEXT_ID: 1000000005
CREATE_DATE: 2026-01-05
CREATE_USER: TSF Ship-003-EDGE
SUBMIT_DATE: 2026-01-05
SUBMIT_USER: TSF Ship-003-EDGE
UPDATE_DATE: 2026-01-05
UPDATE_USER: 2026-01-03-EDGE
CONTEXT_VALUE: TSF Ship-003-EDGE
DISPATCH_DATE: 2026-01-05
DISPATCH_USER: TSF Ship-003-EDGE
DISPLAY_CARTON: Y
NOT_AFTER_DATE: 2026-01-05
SHIPMENT_BOL_ID: 1000000005
ADHOC_DOCUMENT_ID: 1000000005
FISCAL_DOC_NUMBER: TSF Ship-003-EDGE
FISCAL_DOC_REF_ID: 1000000005
FISCAL_DOC_STATUS: 3
AUTHORIZATION_CODE: EDGE-TSF_SHI
FISCAL_DOC_PRINT_URL: TSF Ship-003-EDGE
FISCAL_DOC_REQUEST_ID: 1000000005
FISCAL_DOC_REJECT_REASON: TSF Ship-003-EDGE

Rule Validation Summary

Source Rule Count: 57
Governed Rule Count: 39