Ordhead

In Scope

Technical: ORDHEAD | ID: OR-PUR-ORDHEAD-ORDHEAD

Stores one row for each order that has been placed by the company. Base information about each order header is held for as many months as in the retention months...

See how this object fits into Purchasing

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

Field Definitions(5)

Rules & Considerations(126)

constraint

validation

Sample Load Data(4)

_scenario	ORDER_NORPK	SUPPLIERR	ORDER_TYPER	DEPT	ITEM	AGENT	BUYER	TERMS	QC_IND	STATUS	FACTORY	PO_TYPE	LOCATION	LOC_TYPE	ORIG_IND	PARTNER1	PARTNER2	PARTNER3	CREATE_ID	IMPORT_ID	PICKUP_NO	PROMOTION	CLOSE_DATE	EDI_PO_IND	ORDCUST_NO	PICKUP_LOC	CONTRACT_NO	IMPORT_TYPE	LADING_PORT	PICKUP_DATE	REJECT_CODE	SHIP_METHOD	WF_ORDER_NO	APP_DATETIME	COMMENT_DESC	EDI_SENT_IND	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	LAST_UPDATE_ID	NOT_AFTER_DATE	PARTNER_TYPE_1	PARTNER_TYPE_2	PARTNER_TYPE_3	PAYMENT_METHOD	ROUTING_LOC_ID	CREATE_DATETIME	NOT_BEFORE_DATE	SHIP_PAY_METHOD	SPLIT_REF_ORDNO	SUPP_ADD_SEQ_NO	VENDOR_ORDER_NO	CLEARING_ZONE_ID	IMPORT_ORDER_IND	LAST_SENT_REV_NO	LATEST_SHIP_DATE	ORIG_APPROVAL_ID	PO_ACK_RECVD_IND	DELIVERY_SUPPLIER	EXCHANGE_RATE_IND	IMPORT_COUNTRY_ID	TRIANGULATION_IND	BACKHAUL_ALLOWANCE	EARLIEST_SHIP_DATE	FOB_TRANS_RES_DESC	ORIG_APPROVAL_DATE	FOB_TITLE_PASS_DESC	FREIGHT_CONTRACT_NO	STORE_REVIEW_STATUS	INCLUDE_ON_ORDER_IND	LAST_UPDATE_DATETIME
Example values from field definitions	1	1	SAM	1	SAMPLE	SAMPLE	1	SAMPLE	S	S	SAMPLE	SAMP	1	S	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	1	2026-01-01	S	1	SAMPLE	1	S	SAMPL	2026-01-01	SAMPLE	SAMPLE	1	2026-01-01	SAMPLE	S	1	2026-01-01	S	2026-01-01	SAMPLE	SAM	1.0000000000	SA	SAMPLE	SAMPLE	SAMPL	SA	SAMPLE	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPL	2026-01-01	2026-01-01	SA	1	1	SAMPLE	SAMPL	S	1	2026-01-01	SAMPLE	S	1	S	SAM	S	1.0000	2026-01-01	SAMPLE	2026-01-01	SAMPLE	SAMPLE	SAMPLE	S	2026-01-01
default	4	3	B	1003	Ordhead-002-ALT	Ordhead-00	3	Ordhead-002-ALT	N	P	Ordhead-00	Ordh	3	W	1	Ordhead-00	Ordhead-00	Ordhead-00	C LIENT_INFO	1000000003	Ordhead-002-ALT	3	2026-01-03	Y	4	Ordhead-002-ALT	4	O	Ordhe	2026-01-03	ALT-OR	Water	4	2026-01-03	Ordhead-002-ALT	O	4	2026-01-03	O	2026-01-03	Ordhea	ALT	12.5000000000	Or	Ordhead-002-ALT	Cost	Ordhe	Or	C LIENT_INFO	2026-01-03	Ordhea	Ordhea	Ordhea	Ordhea	ALT-O	2026-01-03	2026-01-03	CC	3	4	Ordhead-002-ALT	ALT-O	N	4	2026-01-03	ALT-ORDHEAD-002	O	3	P	ALT	N	12.5000	2026-01-03	Ordhead-002-ALT	2026-01-03	Ordhead-002-ALT	Ordhead-00	PENDIN	o	2026-01-03
default	6	5	B	1005	Ordhead-003-EDGE	Ordhead-00	5	Ordhead-003-EDG	Y	A	Ordhead-00	Ordh	5	S	2	Ordhead-00	Ordhead-00	Ordhead-00	USE RENV	1000000005	Ordhead-003-EDGE	5	2026-01-05	Y	6	Ordhead-003-EDGE	6	O	Ordhe	2026-01-05	EDGE-O	Non	6	2026-01-05	Ordhead-003-EDGE	O	6	2026-01-05	O	2026-01-05	Ordhea	EDG	14.0000000000	Or	Ordhead-003-EDGE	Cost	Ordhe	Or	USE RENV	2026-01-05	Ordhea	Ordhea	Ordhea	Ordhea	EDGE-	2026-01-05	2026-01-05	CC	5	6	Ordhead-003-EDG	EDGE-	Y	6	2026-01-05	EDGE-ORDHEAD-003	O	5	L	EDG	N	14.0000	2026-01-05	Ordhead-003-EDGE	2026-01-05	Ordhead-003-EDGE	Ordhead-00	ACTIVE	o	2026-01-05

Example values from field definitions

ORDER_NORPK: 1
SUPPLIERR: 1
ORDER_TYPER: SAM
DEPT: 1
ITEM: SAMPLE
AGENT: SAMPLE
BUYER: 1
TERMS: SAMPLE
QC_IND: S
STATUS: S
FACTORY: SAMPLE
PO_TYPE: SAMP
LOCATION: 1
LOC_TYPE: S
ORIG_IND: 1
PARTNER1: SAMPLE
PARTNER2: SAMPLE
PARTNER3: SAMPLE
CREATE_ID: SAMPLE
IMPORT_ID: 1
PICKUP_NO: SAMPLE
PROMOTION: 1
CLOSE_DATE: 2026-01-01
EDI_PO_IND: S
ORDCUST_NO: 1
PICKUP_LOC: SAMPLE
CONTRACT_NO: 1
IMPORT_TYPE: S
LADING_PORT: SAMPL
PICKUP_DATE: 2026-01-01
REJECT_CODE: SAMPLE
SHIP_METHOD: SAMPLE
WF_ORDER_NO: 1
APP_DATETIME: 2026-01-01
COMMENT_DESC: SAMPLE
EDI_SENT_IND: S
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
LAST_UPDATE_ID: SAMPLE
NOT_AFTER_DATE: 2026-01-01
PARTNER_TYPE_1: SAMPLE
PARTNER_TYPE_2: SAMPLE
PARTNER_TYPE_3: SAMPLE
PAYMENT_METHOD: SAMPLE
ROUTING_LOC_ID: SAMPL
CREATE_DATETIME: 2026-01-01
NOT_BEFORE_DATE: 2026-01-01
SHIP_PAY_METHOD: SA
SPLIT_REF_ORDNO: 1
SUPP_ADD_SEQ_NO: 1
VENDOR_ORDER_NO: SAMPLE
CLEARING_ZONE_ID: SAMPL
IMPORT_ORDER_IND: S
LAST_SENT_REV_NO: 1
LATEST_SHIP_DATE: 2026-01-01
ORIG_APPROVAL_ID: SAMPLE
PO_ACK_RECVD_IND: S
DELIVERY_SUPPLIER: 1
EXCHANGE_RATE_IND: S
IMPORT_COUNTRY_ID: SAM
TRIANGULATION_IND: S
BACKHAUL_ALLOWANCE: 1.0000
EARLIEST_SHIP_DATE: 2026-01-01
FOB_TRANS_RES_DESC: SAMPLE
ORIG_APPROVAL_DATE: 2026-01-01
FOB_TITLE_PASS_DESC: SAMPLE
FREIGHT_CONTRACT_NO: SAMPLE
STORE_REVIEW_STATUS: SAMPLE
INCLUDE_ON_ORDER_IND: S
LAST_UPDATE_DATETIME: 2026-01-01

default

ORDER_NORPK: 4
SUPPLIERR: 3
ORDER_TYPER: B
DEPT: 1003
ITEM: Ordhead-002-ALT
AGENT: Ordhead-00
BUYER: 3
TERMS: Ordhead-002-ALT
QC_IND: N
STATUS: P
FACTORY: Ordhead-00
PO_TYPE: Ordh
LOCATION: 3
LOC_TYPE: W
ORIG_IND: 1
PARTNER1: Ordhead-00
PARTNER2: Ordhead-00
PARTNER3: Ordhead-00
CREATE_ID: C LIENT_INFO
IMPORT_ID: 1000000003
PICKUP_NO: Ordhead-002-ALT
PROMOTION: 3
CLOSE_DATE: 2026-01-03
EDI_PO_IND: Y
ORDCUST_NO: 4
PICKUP_LOC: Ordhead-002-ALT
CONTRACT_NO: 4
IMPORT_TYPE: O
LADING_PORT: Ordhe
PICKUP_DATE: 2026-01-03
REJECT_CODE: ALT-OR
SHIP_METHOD: Water
WF_ORDER_NO: 4
APP_DATETIME: 2026-01-03
COMMENT_DESC: Ordhead-002-ALT
EDI_SENT_IND: O
MASTER_PO_NO: 4
OTB_EOW_DATE: 2026-01-03
PRE_MARK_IND: O
WRITTEN_DATE: 2026-01-03
BACKHAUL_TYPE: Ordhea
CURRENCY_CODE: ALT
EXCHANGE_RATE: 12.5000000000
FOB_TRANS_RES: Or
FREIGHT_TERMS: Ordhead-002-ALT
PURCHASE_TYPE: Cost
DISCHARGE_PORT: Ordhe
FOB_TITLE_PASS: Or
LAST_UPDATE_ID: C LIENT_INFO
NOT_AFTER_DATE: 2026-01-03
PARTNER_TYPE_1: Ordhea
PARTNER_TYPE_2: Ordhea
PARTNER_TYPE_3: Ordhea
PAYMENT_METHOD: Ordhea
ROUTING_LOC_ID: ALT-O
CREATE_DATETIME: 2026-01-03
NOT_BEFORE_DATE: 2026-01-03
SHIP_PAY_METHOD: CC
SPLIT_REF_ORDNO: 3
SUPP_ADD_SEQ_NO: 4
VENDOR_ORDER_NO: Ordhead-002-ALT
CLEARING_ZONE_ID: ALT-O
IMPORT_ORDER_IND: N
LAST_SENT_REV_NO: 4
LATEST_SHIP_DATE: 2026-01-03
ORIG_APPROVAL_ID: ALT-ORDHEAD-002
PO_ACK_RECVD_IND: O
DELIVERY_SUPPLIER: 3
EXCHANGE_RATE_IND: P
IMPORT_COUNTRY_ID: ALT
TRIANGULATION_IND: N
BACKHAUL_ALLOWANCE: 12.5000
EARLIEST_SHIP_DATE: 2026-01-03
FOB_TRANS_RES_DESC: Ordhead-002-ALT
ORIG_APPROVAL_DATE: 2026-01-03
FOB_TITLE_PASS_DESC: Ordhead-002-ALT
FREIGHT_CONTRACT_NO: Ordhead-00
STORE_REVIEW_STATUS: PENDIN
INCLUDE_ON_ORDER_IND: o
LAST_UPDATE_DATETIME: 2026-01-03