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(76)

Rules & Considerations(69)

Sample Load Data(4)

_scenario	ROW_SEQR	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

Example values from field definitions

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

Rule Validation Summary

Source Rule Count: 86
Governed Rule Count: 69

All objects