Ordhead Rev

In Scope

Technical: ORDHEAD_REV | ID: OR-MFCS-ORDHEAD_REV

This table will hold EDI order revision and version information that relates to the NOT_BEFORE_DATE and NOT_AFTER_DATE columns on ORDHEAD. Dates on orders submitted to suppliers from Oracle Retail will…

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

Target Structure

Load Approach: Table
Target Objects: ORDHEAD_REV

Field Definitions(63)

Rules & Considerations(158)

Sample Load Data(4)

_scenario	TERMSR	QC_INDR	REV_NORPK	STATUSR	ORDER_NOR	ORIG_INDR	REV_DATER	EDI_PO_INDR	NAD_STATUSR	NBD_STATUSR	ORIGIN_TYPER	PRE_MARK_INDR	WRITTEN_DATER	CURRENCY_CODER	SUPP_ADD_SEQ_NOR	IMPORT_ORDER_INDR	PO_ACK_RECVD_INDR	INCLUDE_ON_ORDER_INDR	DEPT	AGENT	BUYER	FACTORY	PO_TYPE	LOCATION	LOC_TYPE	SUPPLIER	PICKUP_NO	PROMOTION	CLOSE_DATE	ORDER_TYPE	PICKUP_LOC	PUD_STATUS	CONTRACT_NO	LADING_PORT	PICKUP_DATE	REJECT_CODE	SHIP_METHOD	APP_DATETIME	COMMENT_DESC	EDI_SENT_IND	OTB_EOW_DATE	BACKHAUL_TYPE	EXCHANGE_RATE	FOB_TRANS_RES	FREIGHT_TERMS	PURCHASE_TYPE	DISCHARGE_PORT	FOB_TITLE_PASS	NOT_AFTER_DATE	PAYMENT_METHOD	NOT_BEFORE_DATE	SHIP_PAY_METHOD	SPLIT_REF_ORDNO	VENDOR_ORDER_NO	LATEST_SHIP_DATE	ORIG_APPROVAL_ID	IMPORT_COUNTRY_ID	BACKHAUL_ALLOWANCE	EARLIEST_SHIP_DATE	FOB_TRANS_RES_DESC	ORIG_APPROVAL_DATE	FOB_TITLE_PASS_DESC	FREIGHT_CONTRACT_NO
default	Ordhead Rev-001	Y	000002	ACTIVE	2	0	2026-01-01	Y	0	0	Ordhead Rev-001	Ordhead Rev-001	2026-01-01	STD-ORDHEAD_RE-001	0002	Ordhead Rev-001	Ordhead Rev-001	on	1001	Ordhead Rev-001	0001	Ordhead Rev-001	Ordhead Rev-001	1	Store	1	Ordhead Rev-001	1	2026-01-01	B	Ordhead Rev-001	0	000002	Ordhead Rev-001	2026-01-01	STD-ORDHEAD_RE-001	Ordhead Rev-001	2026-01-01	Ordhead Rev-001	Ordhead Rev-001	2026-01-01	Ordhead Rev-001	11.0000	Ordhead Rev-001	Ordhead Rev-001	Ordhead Rev-001	Ordhead Rev-001	Ordhead Rev-001	2026-01-01	Ordhead Rev-001	2026-01-01	CC	1	Ordhead Rev-001	2026-01-01	STD-ORDHEAD_RE-001	STD-ORDHEAD_RE-001	11.0000	2026-01-01	Ordhead Rev-001	2026-01-01	Ordhead Rev-001	Ordhead Rev-001

default

TERMSR: Ordhead Rev-001
QC_INDR: Y
REV_NORPK: 000002
STATUSR: ACTIVE
ORDER_NOR: 2
ORIG_INDR: 0
REV_DATER: 2026-01-01
EDI_PO_INDR: Y
NAD_STATUSR: 0
NBD_STATUSR: 0
ORIGIN_TYPER: Ordhead Rev-001
PRE_MARK_INDR: Ordhead Rev-001
WRITTEN_DATER: 2026-01-01
CURRENCY_CODER: STD-ORDHEAD_RE-001
SUPP_ADD_SEQ_NOR: 0002
IMPORT_ORDER_INDR: Ordhead Rev-001
PO_ACK_RECVD_INDR: Ordhead Rev-001
INCLUDE_ON_ORDER_INDR: on
DEPT: 1001
AGENT: Ordhead Rev-001
BUYER: 0001
FACTORY: Ordhead Rev-001
PO_TYPE: Ordhead Rev-001
LOCATION: 1
LOC_TYPE: Store
SUPPLIER: 1
PICKUP_NO: Ordhead Rev-001
PROMOTION: 1
CLOSE_DATE: 2026-01-01
ORDER_TYPE: B
PICKUP_LOC: Ordhead Rev-001
PUD_STATUS: 0
CONTRACT_NO: 000002
LADING_PORT: Ordhead Rev-001
PICKUP_DATE: 2026-01-01
REJECT_CODE: STD-ORDHEAD_RE-001
SHIP_METHOD: Ordhead Rev-001
APP_DATETIME: 2026-01-01
COMMENT_DESC: Ordhead Rev-001
EDI_SENT_IND: Ordhead Rev-001
OTB_EOW_DATE: 2026-01-01
BACKHAUL_TYPE: Ordhead Rev-001
EXCHANGE_RATE: 11.0000
FOB_TRANS_RES: Ordhead Rev-001
FREIGHT_TERMS: Ordhead Rev-001
PURCHASE_TYPE: Ordhead Rev-001
DISCHARGE_PORT: Ordhead Rev-001
FOB_TITLE_PASS: Ordhead Rev-001
NOT_AFTER_DATE: 2026-01-01
PAYMENT_METHOD: Ordhead Rev-001
NOT_BEFORE_DATE: 2026-01-01
SHIP_PAY_METHOD: CC
SPLIT_REF_ORDNO: 1
VENDOR_ORDER_NO: Ordhead Rev-001
LATEST_SHIP_DATE: 2026-01-01
ORIG_APPROVAL_ID: STD-ORDHEAD_RE-001
IMPORT_COUNTRY_ID: STD-ORDHEAD_RE-001
BACKHAUL_ALLOWANCE: 11.0000
EARLIEST_SHIP_DATE: 2026-01-01
FOB_TRANS_RES_DESC: Ordhead Rev-001
ORIG_APPROVAL_DATE: 2026-01-01
FOB_TITLE_PASS_DESC: Ordhead Rev-001
FREIGHT_CONTRACT_NO: Ordhead Rev-001

All objects