Ordhead (Service Layer)

In Scope

Technical: SVC_ORDHEAD | ID: OR-FND-SVC_ORDHEAD-ORDHEAD_SERVICE_LAYER

This is the staging table for PO Induction module which is used to temporarily hold data before it is uploaded in the ORDHEAD table.

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

Target Structure

Load Approach: Table
Target Objects: SVC_ORDHEAD

Field Definitions(5)

Rules & Considerations(70)

Sample Load Data(4)

_scenario	ROW_SEQRPK	CHUNK_IDR	PROCESS_IDRPK	DEPT	AGENT	BUYER	TERMS	ACTION	QC_IND	STATUS	FACTORY	FILE_ID	PO_TYPE	LOCATION	LOC_TYPE	ORDER_NO	ORIG_IND	PARTNER1	PARTNER2	PARTNER3	SUPPLIER	CREATE_ID	IMPORT_ID	PICKUP_NO	PROMOTION	CLOSE_DATE	EDI_PO_IND	EXT_REF_NO	ORDER_TYPE	PICKUP_LOC	CONTRACT_NO	IMPORT_TYPE	LADING_PORT	LAST_UPD_ID	NEXT_UPD_ID	PICKUP_DATE	REJECT_CODE	SHIP_METHOD	APP_DATETIME	COMMENT_DESC	MASTER_PO_NO	OTB_EOW_DATE	PRE_MARK_IND	WRITTEN_DATE	BACKHAUL_TYPE	CURRENCY_CODE	EXCHANGE_RATE	FOB_TRANS_RES	FREIGHT_TERMS	PURCHASE_TYPE	DISCHARGE_PORT	FOB_TITLE_PASS	NOT_AFTER_DATE	PARTNER_TYPE_1	PARTNER_TYPE_2	PARTNER_TYPE_3	PAYMENT_METHOD	PROCESS$STATUS	RE_APPROVE_IND	ROUTING_LOC_ID	CREATE_DATETIME	NOT_BEFORE_DATE	SHIP_PAY_METHOD	SUPP_ADD_SEQ_NO	VENDOR_ORDER_NO	CLEARING_ZONE_ID	IMPORT_ORDER_IND	LATEST_SHIP_DATE	IMPORT_COUNTRY_ID	LAST_UPD_DATETIME	BACKHAUL_ALLOWANCE	EARLIEST_SHIP_DATE	FOB_TRANS_RES_DESC	FOB_TITLE_PASS_DESC	FREIGHT_CONTRACT_NO	INCLUDE_ON_ORDER_IND
Example values from field definitions	1	1	1	1	SAMPLE	1	SAMPLE	SAMPLE	S	S	SAMPLE	SAMPLE	SAMP	1	S	1	1	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	1	SAMPLE	1	2026-01-01	S	1	SAM	SAMPLE	1	S	SAMPL	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE	2026-01-01	SAMPLE	1	2026-01-01	S	2026-01-01	SAMPLE	SAM	1.0000000000	SA	SAMPLE	SAMPLE	SAMPL	SA	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPL	2026-01-01	2026-01-01	SA	1	SAMPLE	SAMPL	S	2026-01-01	SAM	2026-01-01	1.0000	2026-01-01	SAMPLE	SAMPLE	SAMPLE	S
default	3	1000000003	1000000003	1003	Svc Ordhea	3	Svc Ordhead-002	Svc Ordhea	N	P	Svc Ordhea	ALT-SVC_ORDHEA-002	Svc	3	W	4	1	Svc Ordhea	Svc Ordhea	Svc Ordhea	3	USER	1000000003	Svc Ordhead-002-ALT	3	2026-01-03	N	4	ARB	Svc Ordhead-002-ALT	4	S	Svc O	USER	USER	2026-01-03	ALT-SV	Non	2026-01-03	Svc Ordhead-002-ALT	4	2026-01-03	S	2026-01-03	Svc Or	ALT	12.5000000000	Sv	Svc Ordhead-002-ALT	Cost	Svc O	Sv	2026-01-03	Svc Or	Svc Or	Svc Or	Svc Or	N	S	ALT-S	2026-01-03	2026-01-03	CF	4	Svc Ordhead-002	ALT-S	N	2026-01-03	ALT	2026-01-03	12.5000	2026-01-03	Svc Ordhead-002-ALT	Svc Ordhead-002-ALT	Svc Ordhea	o
default	5	1000000005	1000000005	1005	Svc Ordhea	5	Svc Ordhead-003	Svc Ordhea	Y	A	Svc Ordhea	EDGE-SVC_ORDHEA-003	Svc	5	S	6	2	Svc Ordhea	Svc Ordhea	Svc Ordhea	5	USER	1000000005	Svc Ordhead-003-EDGE	5	2026-01-05	Y	6	BRB	Svc Ordhead-003-EDGE	6	S	Svc O	USER	USER	2026-01-05	EDGE-S	Water	2026-01-05	Svc Ordhead-003-EDGE	6	2026-01-05	S	2026-01-05	Svc Or	EDG	14.0000000000	Sv	Svc Ordhead-003-EDGE	Cost	Svc O	Sv	2026-01-05	Svc Or	Svc Or	Svc Or	Svc Or	N	S	EDGE-	2026-01-05	2026-01-05	DF	6	Svc Ordhead-003	EDGE-	Y	2026-01-05	EDG	2026-01-05	14.0000	2026-01-05	Svc Ordhead-003-EDGE	Svc Ordhead-003-EDGE	Svc Ordhea	o

Example values from field definitions

ROW_SEQRPK: 1
CHUNK_IDR: 1
PROCESS_IDRPK: 1
DEPT: 1
AGENT: SAMPLE
BUYER: 1
TERMS: SAMPLE
ACTION: SAMPLE
QC_IND: S
STATUS: S
FACTORY: SAMPLE
FILE_ID: SAMPLE
PO_TYPE: SAMP
LOCATION: 1
LOC_TYPE: S
ORDER_NO: 1
ORIG_IND: 1
PARTNER1: SAMPLE
PARTNER2: SAMPLE
PARTNER3: SAMPLE
SUPPLIER: 1
CREATE_ID: SAMPLE
IMPORT_ID: 1
PICKUP_NO: SAMPLE
PROMOTION: 1
CLOSE_DATE: 2026-01-01
EDI_PO_IND: S
EXT_REF_NO: 1
ORDER_TYPE: SAM
PICKUP_LOC: SAMPLE
CONTRACT_NO: 1
IMPORT_TYPE: S
LADING_PORT: SAMPL
LAST_UPD_ID: SAMPLE
NEXT_UPD_ID: SAMPLE
PICKUP_DATE: 2026-01-01
REJECT_CODE: SAMPLE
SHIP_METHOD: SAMPLE
APP_DATETIME: 2026-01-01
COMMENT_DESC: SAMPLE
MASTER_PO_NO: 1
OTB_EOW_DATE: 2026-01-01
PRE_MARK_IND: S
WRITTEN_DATE: 2026-01-01
BACKHAUL_TYPE: SAMPLE
CURRENCY_CODE: SAM
EXCHANGE_RATE: 1.0000000000
FOB_TRANS_RES: SA
FREIGHT_TERMS: SAMPLE
PURCHASE_TYPE: SAMPLE
DISCHARGE_PORT: SAMPL
FOB_TITLE_PASS: SA
NOT_AFTER_DATE: 2026-01-01
PARTNER_TYPE_1: SAMPLE
PARTNER_TYPE_2: SAMPLE
PARTNER_TYPE_3: SAMPLE
PAYMENT_METHOD: SAMPLE
PROCESS$STATUS: SAMPLE
RE_APPROVE_IND: S
ROUTING_LOC_ID: SAMPL
CREATE_DATETIME: 2026-01-01
NOT_BEFORE_DATE: 2026-01-01
SHIP_PAY_METHOD: SA
SUPP_ADD_SEQ_NO: 1
VENDOR_ORDER_NO: SAMPLE
CLEARING_ZONE_ID: SAMPL
IMPORT_ORDER_IND: S
LATEST_SHIP_DATE: 2026-01-01
IMPORT_COUNTRY_ID: SAM
LAST_UPD_DATETIME: 2026-01-01
BACKHAUL_ALLOWANCE: 1.0000
EARLIEST_SHIP_DATE: 2026-01-01
FOB_TRANS_RES_DESC: SAMPLE
FOB_TITLE_PASS_DESC: SAMPLE
FREIGHT_CONTRACT_NO: SAMPLE
INCLUDE_ON_ORDER_IND: S

default

ROW_SEQRPK: 3
CHUNK_IDR: 1000000003
PROCESS_IDRPK: 1000000003
DEPT: 1003
AGENT: Svc Ordhea
BUYER: 3
TERMS: Svc Ordhead-002
ACTION: Svc Ordhea
QC_IND: N
STATUS: P
FACTORY: Svc Ordhea
FILE_ID: ALT-SVC_ORDHEA-002
PO_TYPE: Svc
LOCATION: 3
LOC_TYPE: W
ORDER_NO: 4
ORIG_IND: 1
PARTNER1: Svc Ordhea
PARTNER2: Svc Ordhea
PARTNER3: Svc Ordhea
SUPPLIER: 3
CREATE_ID: USER
IMPORT_ID: 1000000003
PICKUP_NO: Svc Ordhead-002-ALT
PROMOTION: 3
CLOSE_DATE: 2026-01-03
EDI_PO_IND: N
EXT_REF_NO: 4
ORDER_TYPE: ARB
PICKUP_LOC: Svc Ordhead-002-ALT
CONTRACT_NO: 4
IMPORT_TYPE: S
LADING_PORT: Svc O
LAST_UPD_ID: USER
NEXT_UPD_ID: USER
PICKUP_DATE: 2026-01-03
REJECT_CODE: ALT-SV
SHIP_METHOD: Non
APP_DATETIME: 2026-01-03
COMMENT_DESC: Svc Ordhead-002-ALT
MASTER_PO_NO: 4
OTB_EOW_DATE: 2026-01-03
PRE_MARK_IND: S
WRITTEN_DATE: 2026-01-03
BACKHAUL_TYPE: Svc Or
CURRENCY_CODE: ALT
EXCHANGE_RATE: 12.5000000000
FOB_TRANS_RES: Sv
FREIGHT_TERMS: Svc Ordhead-002-ALT
PURCHASE_TYPE: Cost
DISCHARGE_PORT: Svc O
FOB_TITLE_PASS: Sv
NOT_AFTER_DATE: 2026-01-03
PARTNER_TYPE_1: Svc Or
PARTNER_TYPE_2: Svc Or
PARTNER_TYPE_3: Svc Or
PAYMENT_METHOD: Svc Or
PROCESS$STATUS: N
RE_APPROVE_IND: S
ROUTING_LOC_ID: ALT-S
CREATE_DATETIME: 2026-01-03
NOT_BEFORE_DATE: 2026-01-03
SHIP_PAY_METHOD: CF
SUPP_ADD_SEQ_NO: 4
VENDOR_ORDER_NO: Svc Ordhead-002
CLEARING_ZONE_ID: ALT-S
IMPORT_ORDER_IND: N
LATEST_SHIP_DATE: 2026-01-03
IMPORT_COUNTRY_ID: ALT
LAST_UPD_DATETIME: 2026-01-03
BACKHAUL_ALLOWANCE: 12.5000
EARLIEST_SHIP_DATE: 2026-01-03
FOB_TRANS_RES_DESC: Svc Ordhead-002-ALT
FOB_TITLE_PASS_DESC: Svc Ordhead-002-ALT
FREIGHT_CONTRACT_NO: Svc Ordhea
INCLUDE_ON_ORDER_IND: o

default

ROW_SEQRPK: 5
CHUNK_IDR: 1000000005
PROCESS_IDRPK: 1000000005
DEPT: 1005
AGENT: Svc Ordhea
BUYER: 5
TERMS: Svc Ordhead-003
ACTION: Svc Ordhea
QC_IND: Y
STATUS: A
FACTORY: Svc Ordhea
FILE_ID: EDGE-SVC_ORDHEA-003
PO_TYPE: Svc
LOCATION: 5
LOC_TYPE: S
ORDER_NO: 6
ORIG_IND: 2
PARTNER1: Svc Ordhea
PARTNER2: Svc Ordhea
PARTNER3: Svc Ordhea
SUPPLIER: 5
CREATE_ID: USER
IMPORT_ID: 1000000005
PICKUP_NO: Svc Ordhead-003-EDGE
PROMOTION: 5
CLOSE_DATE: 2026-01-05
EDI_PO_IND: Y
EXT_REF_NO: 6
ORDER_TYPE: BRB
PICKUP_LOC: Svc Ordhead-003-EDGE
CONTRACT_NO: 6
IMPORT_TYPE: S
LADING_PORT: Svc O
LAST_UPD_ID: USER
NEXT_UPD_ID: USER
PICKUP_DATE: 2026-01-05
REJECT_CODE: EDGE-S
SHIP_METHOD: Water
APP_DATETIME: 2026-01-05
COMMENT_DESC: Svc Ordhead-003-EDGE
MASTER_PO_NO: 6
OTB_EOW_DATE: 2026-01-05
PRE_MARK_IND: S
WRITTEN_DATE: 2026-01-05
BACKHAUL_TYPE: Svc Or
CURRENCY_CODE: EDG
EXCHANGE_RATE: 14.0000000000
FOB_TRANS_RES: Sv
FREIGHT_TERMS: Svc Ordhead-003-EDGE
PURCHASE_TYPE: Cost
DISCHARGE_PORT: Svc O
FOB_TITLE_PASS: Sv
NOT_AFTER_DATE: 2026-01-05
PARTNER_TYPE_1: Svc Or
PARTNER_TYPE_2: Svc Or
PARTNER_TYPE_3: Svc Or
PAYMENT_METHOD: Svc Or
PROCESS$STATUS: N
RE_APPROVE_IND: S
ROUTING_LOC_ID: EDGE-
CREATE_DATETIME: 2026-01-05
NOT_BEFORE_DATE: 2026-01-05
SHIP_PAY_METHOD: DF
SUPP_ADD_SEQ_NO: 6
VENDOR_ORDER_NO: Svc Ordhead-003
CLEARING_ZONE_ID: EDGE-
IMPORT_ORDER_IND: Y
LATEST_SHIP_DATE: 2026-01-05
IMPORT_COUNTRY_ID: EDG
LAST_UPD_DATETIME: 2026-01-05
BACKHAUL_ALLOWANCE: 14.0000
EARLIEST_SHIP_DATE: 2026-01-05
FOB_TRANS_RES_DESC: Svc Ordhead-003-EDGE
FOB_TITLE_PASS_DESC: Svc Ordhead-003-EDGE
FREIGHT_CONTRACT_NO: Svc Ordhea
INCLUDE_ON_ORDER_IND: o

Rule Validation Summary

Source Rule Count: 87
Governed Rule Count: 70

All objects