Posupld Thead (Service Layer GTT)

Out of Scope

Technical: SVC_POSUPLD_THEAD_GTT | ID: OR-FND-SVC_POSUPLD_THEAD_GTT-SVC_POSUPLD_THEAD_GTT

Staging table to hold the THEAD lines from the posupld input file.

See how this object fits into Foundation Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: gtt

Target Structure

Load Approach: Table
Target Objects: SVC_POSUPLD_THEAD_GTT

Field Definitions(5)

Rules & Considerations(54)

constraint

validation

Sample Load Data(4)

_scenario	RUN_SEQR	CHUNK_IDR	SALES_THEAD_IDR	SALES_PROCESS_IDR	DAY	DEPT	CLASS	STORE	REV_NO	UOM_QTY	PACK_IND	SUBCLASS	ERROR_MSG	ITEM_TYPE	RETURN_WH	SALES_QTY	TRAN_DATE	TRAN_TYPE	WASTE_PCT	GTAX_VALUE	ITEM_LEVEL	ITEM_VALUE	ORIG_STORE	SALES_SIGN	TRAN_LEVEL	WASTE_TYPE	ITEM_SEQ_NO	POS_TRAN_ID	SALES_VALUE	SELLING_UOM	TRAN_SEQ_NO	DROPSHIP_IND	INVENTORY_ID	FULFILL_LOC_ID	ILS_UPDATE_LOC	NO_INV_RET_IND	CATCHWEIGHT_IND	RESA_SALES_TYPE	ACTUALWEIGHT_QTY	CONSIGNMENT_RATE	FULFILL_LOC_TYPE	FULFILL_ORDER_NO	SALESPROCESS_LOC	CUSTOMER_ORDER_NO	SUBTRANS_TYPE_IND	LAST_MODIFIED_DATE	RETURN_DISPOSITION	STANDARD_UNIT_RETAIL	CONSIGNMENT_UNIT_COST	INVENTORY_IDENTIFIER_TYPE
Example values from field definitions	1	1	1	1	1	SAMP	SAMP	1	1	1	S	SAMP	SAMPLE	SAM	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	S	S	SAMPLE	1	1	SAMPLE	SAMP	1	S	SAMPLE	SAMPLE	1	S	S	S	SAMPLE	SAMPLE	SA	SAMPLE	1	SAMPLE	S	SAMPLE	SAMPLE	1.000000	SAMPLE	SAMPLE
default	3	1000000003	1000000003	1000000003	3	Svc	Svc	1003	4	3	S	Svc	Svc Posupld Thead Gtt-002-ALT	Svc	Svc Posupl	Svc Posupld	2026-01-02-ALT	S	Svc Posupld	Svc Posupld Thead Gt	S	Svc Posupld Thead Gtt-002	Svc Posupl	S	S	Svc Po	4	1000000003	Svc Posupld Thead Gt	Svc	4	S	ALT-SVC_POSUPL-002	ALT-SVC_PO	3	S	S	S	Svc Posupld	Svc Posupld	Sv	Svc Posupld Thead Gtt-002-ALT	3	Svc Posupld Thead Gtt-002-ALT	S	2026-01-02-ALT	Svc Posupl	12.500000	Svc Posupld Thead Gt	L
default	5	1000000005	1000000005	1000000005	5	Svc	Svc	1005	6	5	S	Svc	Svc Posupld Thead Gtt-003-EDGE	Svc	Svc Posupl	Svc Posupld	2026-01-03-EDG	S	Svc Posupld	Svc Posupld Thead Gt	S	Svc Posupld Thead Gtt-003	Svc Posupl	S	S	Svc Po	6	1000000005	Svc Posupld Thead Gt	Svc	6	S	EDGE-SVC_POSUPL-003	EDGE-SVC_P	5	S	S	S	Svc Posupld	Svc Posupld	Sv	Svc Posupld Thead Gtt-003-EDGE	5	Svc Posupld Thead Gtt-003-EDGE	S	2026-01-03-EDG	Svc Posupl	14.000000	Svc Posupld Thead Gt	E

Example values from field definitions

RUN_SEQR: 1
CHUNK_IDR: 1
SALES_THEAD_IDR: 1
SALES_PROCESS_IDR: 1
DAY: 1
DEPT: SAMP
CLASS: SAMP
STORE: 1
REV_NO: 1
UOM_QTY: 1
PACK_IND: S
SUBCLASS: SAMP
ERROR_MSG: SAMPLE
ITEM_TYPE: SAM
RETURN_WH: SAMPLE
SALES_QTY: SAMPLE
TRAN_DATE: SAMPLE
TRAN_TYPE: S
WASTE_PCT: SAMPLE
GTAX_VALUE: SAMPLE
ITEM_LEVEL: S
ITEM_VALUE: SAMPLE
ORIG_STORE: SAMPLE
SALES_SIGN: S
TRAN_LEVEL: S
WASTE_TYPE: SAMPLE
ITEM_SEQ_NO: 1
POS_TRAN_ID: 1
SALES_VALUE: SAMPLE
SELLING_UOM: SAMP
TRAN_SEQ_NO: 1
DROPSHIP_IND: S
INVENTORY_ID: SAMPLE
FULFILL_LOC_ID: SAMPLE
ILS_UPDATE_LOC: 1
NO_INV_RET_IND: S
CATCHWEIGHT_IND: S
RESA_SALES_TYPE: S
ACTUALWEIGHT_QTY: SAMPLE
CONSIGNMENT_RATE: SAMPLE
FULFILL_LOC_TYPE: SA
FULFILL_ORDER_NO: SAMPLE
SALESPROCESS_LOC: 1
CUSTOMER_ORDER_NO: SAMPLE
SUBTRANS_TYPE_IND: S
LAST_MODIFIED_DATE: SAMPLE
RETURN_DISPOSITION: SAMPLE
STANDARD_UNIT_RETAIL: 1.000000
CONSIGNMENT_UNIT_COST: SAMPLE
INVENTORY_IDENTIFIER_TYPE: SAMPLE

default

RUN_SEQR: 3
CHUNK_IDR: 1000000003
SALES_THEAD_IDR: 1000000003
SALES_PROCESS_IDR: 1000000003
DAY: 3
DEPT: Svc
CLASS: Svc
STORE: 1003
REV_NO: 4
UOM_QTY: 3
PACK_IND: S
SUBCLASS: Svc
ERROR_MSG: Svc Posupld Thead Gtt-002-ALT
ITEM_TYPE: Svc
RETURN_WH: Svc Posupl
SALES_QTY: Svc Posupld
TRAN_DATE: 2026-01-02-ALT
TRAN_TYPE: S
WASTE_PCT: Svc Posupld
GTAX_VALUE: Svc Posupld Thead Gt
ITEM_LEVEL: S
ITEM_VALUE: Svc Posupld Thead Gtt-002
ORIG_STORE: Svc Posupl
SALES_SIGN: S
TRAN_LEVEL: S
WASTE_TYPE: Svc Po
ITEM_SEQ_NO: 4
POS_TRAN_ID: 1000000003
SALES_VALUE: Svc Posupld Thead Gt
SELLING_UOM: Svc
TRAN_SEQ_NO: 4
DROPSHIP_IND: S
INVENTORY_ID: ALT-SVC_POSUPL-002
FULFILL_LOC_ID: ALT-SVC_PO
ILS_UPDATE_LOC: 3
NO_INV_RET_IND: S
CATCHWEIGHT_IND: S
RESA_SALES_TYPE: S
ACTUALWEIGHT_QTY: Svc Posupld
CONSIGNMENT_RATE: Svc Posupld
FULFILL_LOC_TYPE: Sv
FULFILL_ORDER_NO: Svc Posupld Thead Gtt-002-ALT
SALESPROCESS_LOC: 3
CUSTOMER_ORDER_NO: Svc Posupld Thead Gtt-002-ALT
SUBTRANS_TYPE_IND: S
LAST_MODIFIED_DATE: 2026-01-02-ALT
RETURN_DISPOSITION: Svc Posupl
STANDARD_UNIT_RETAIL: 12.500000
CONSIGNMENT_UNIT_COST: Svc Posupld Thead Gt
INVENTORY_IDENTIFIER_TYPE: L