Tsfhead

In Scope

Technical: TSFHEAD | ID: OR-INV-TSFHEAD-TSFHEAD

Stores one row for each transfer that has been created in the system. This information is held until the transfer is completed and has been held longer than the transfer...

See how this object fits into Inventory Management

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: TSFHEAD

Field Definitions(5)

Rules & Considerations(56)

constraint

validation

Sample Load Data(4)

_scenario	TSF_NORPK	DEPT	MRT_NO	RMA_NO	STATUS	TO_LOC	FROM_LOC	ORDER_NO	TSF_TYPE	CREATE_ID	CLOSE_DATE	EXT_REF_NO	ORDCUST_NO	APPROVAL_ID	CREATE_DATE	EXP_DC_DATE	RESTOCK_PCT	TO_LOC_TYPE	WF_ORDER_NO	COMMENT_DESC	CONTEXT_TYPE	FREIGHT_CODE	ROUTING_CODE	WF_NEED_DATE	APPROVAL_DATE	CONTEXT_VALUE	DELIVERY_DATE	FROM_LOC_TYPE	TSF_PARENT_NO	INVENTORY_TYPE	LAST_UPDATE_ID	NOT_AFTER_DATE	CREATE_DATETIME	EXP_DC_EOW_DATE	DELIVERY_SLOT_ID	STORE_REVIEW_STATUS	LAST_UPDATE_DATETIME	REPL_TSF_APPROVE_IND
Example values from field definitions	1	1	1	1	S	1	1	1	SAMPLE	SAMPLE	2026-01-01	SAMPLE	1	SAMPLE	2026-01-01	2026-01-01	1.0000	S	1	SAMPLE	SAMPLE	S	S	2026-01-01	2026-01-01	SAMPLE	2026-01-01	S	1	SAMPLE	SAMPLE	2026-01-01	2026-01-01	2026-01-01	SAMPLE	SAMPLE	2026-01-01	S
default	4	1003	4	4	B	3	3	4	CO	MDM_USER	2026-01-03	Tsfhead-002-AL	4	ALT-TSFHEAD-002	2026-01-03	2026-01-03	12.5000	E	4	Tsfhead-002-ALT	create	N	A	2026-01-03	2026-01-03	Tsfhead-002-ALT	2026-01-03	T	4	Tsfhea	APP_USER_ID	2026-01-03	2026-01-03	2026-01-03	ALT-TSFHEAD-002	PENDIN	2026-01-03	T
default	6	1005	6	6	A	5	5	6	RV	BATCH_USER	2026-01-05	Tsfhead-003-ED	6	EDGE-TSFHEAD-003	2026-01-05	2026-01-05	14.0000	S	6	Tsfhead-003-EDGE	Two	N	E	2026-01-05	2026-01-05	Tsfhead-003-EDGE	2026-01-05	T	6	Tsfhea	USERENV	2026-01-05	2026-01-05	2026-01-05	EDGE-TSFHEAD-00	ACTIVE	2026-01-05	T

Example values from field definitions

TSF_NORPK: 1
DEPT: 1
MRT_NO: 1
RMA_NO: 1
STATUS: S
TO_LOC: 1
FROM_LOC: 1
ORDER_NO: 1
TSF_TYPE: SAMPLE
CREATE_ID: SAMPLE
CLOSE_DATE: 2026-01-01
EXT_REF_NO: SAMPLE
ORDCUST_NO: 1
APPROVAL_ID: SAMPLE
CREATE_DATE: 2026-01-01
EXP_DC_DATE: 2026-01-01
RESTOCK_PCT: 1.0000
TO_LOC_TYPE: S
WF_ORDER_NO: 1
COMMENT_DESC: SAMPLE
CONTEXT_TYPE: SAMPLE
FREIGHT_CODE: S
ROUTING_CODE: S
WF_NEED_DATE: 2026-01-01
APPROVAL_DATE: 2026-01-01
CONTEXT_VALUE: SAMPLE
DELIVERY_DATE: 2026-01-01
FROM_LOC_TYPE: S
TSF_PARENT_NO: 1
INVENTORY_TYPE: SAMPLE
LAST_UPDATE_ID: SAMPLE
NOT_AFTER_DATE: 2026-01-01
CREATE_DATETIME: 2026-01-01
EXP_DC_EOW_DATE: 2026-01-01
DELIVERY_SLOT_ID: SAMPLE
STORE_REVIEW_STATUS: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01
REPL_TSF_APPROVE_IND: S

default

TSF_NORPK: 4
DEPT: 1003
MRT_NO: 4
RMA_NO: 4
STATUS: B
TO_LOC: 3
FROM_LOC: 3
ORDER_NO: 4
TSF_TYPE: CO
CREATE_ID: MDM_USER
CLOSE_DATE: 2026-01-03
EXT_REF_NO: Tsfhead-002-AL
ORDCUST_NO: 4
APPROVAL_ID: ALT-TSFHEAD-002
CREATE_DATE: 2026-01-03
EXP_DC_DATE: 2026-01-03
RESTOCK_PCT: 12.5000
TO_LOC_TYPE: E
WF_ORDER_NO: 4
COMMENT_DESC: Tsfhead-002-ALT
CONTEXT_TYPE: create
FREIGHT_CODE: N
ROUTING_CODE: A
WF_NEED_DATE: 2026-01-03
APPROVAL_DATE: 2026-01-03
CONTEXT_VALUE: Tsfhead-002-ALT
DELIVERY_DATE: 2026-01-03
FROM_LOC_TYPE: T
TSF_PARENT_NO: 4
INVENTORY_TYPE: Tsfhea
LAST_UPDATE_ID: APP_USER_ID
NOT_AFTER_DATE: 2026-01-03
CREATE_DATETIME: 2026-01-03
EXP_DC_EOW_DATE: 2026-01-03
DELIVERY_SLOT_ID: ALT-TSFHEAD-002
STORE_REVIEW_STATUS: PENDIN
LAST_UPDATE_DATETIME: 2026-01-03
REPL_TSF_APPROVE_IND: T