Ordhead
In ScopeTechnical: ORDHEAD | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- ORDHEAD
Field Definitions(80)
Rules & Considerations(213)
Sample Load Data(4)
| _scenario | DEPTPK | BUYERPK | TERMSRPK | QC_INDR | STATUSR | PO_TYPEPK | ORDER_NORPK | ORIG_INDR | SUPPLIERRPK | CREATE_IDR | EDI_PO_INDR | ORDER_TYPER | CONTRACT_NOPK | WF_ORDER_NOPK | PRE_MARK_INDR | WRITTEN_DATER | CURRENCY_CODERPK | FREIGHT_TERMSPK | LAST_UPDATE_IDR | PARTNER_TYPE_1PK | PARTNER_TYPE_2PK | PARTNER_TYPE_3PK | CREATE_DATETIMER | SUPP_ADD_SEQ_NOR | IMPORT_ORDER_INDR | PO_ACK_RECVD_INDR | DELIVERY_SUPPLIERPK | EXCHANGE_RATE_INDR | IMPORT_COUNTRY_IDPK | TRIANGULATION_INDR | INCLUDE_ON_ORDER_INDR | LAST_UPDATE_DATETIMER | ITEM | AGENT | FACTORY | LOCATION | LOC_TYPE | PARTNER1 | PARTNER2 | PARTNER3 | IMPORT_ID | PICKUP_NO | PROMOTION | CLOSE_DATE | ORDCUST_NO | PICKUP_LOC | IMPORT_TYPE | LADING_PORT | PICKUP_DATE | REJECT_CODE | SHIP_METHOD | APP_DATETIME | COMMENT_DESC | EDI_SENT_IND | MASTER_PO_NO | OTB_EOW_DATE | BACKHAUL_TYPE | EXCHANGE_RATE | FOB_TRANS_RES | PURCHASE_TYPE | DISCHARGE_PORT | FOB_TITLE_PASS | NOT_AFTER_DATE | PAYMENT_METHOD | ROUTING_LOC_ID | NOT_BEFORE_DATE | SHIP_PAY_METHOD | SPLIT_REF_ORDNO | VENDOR_ORDER_NO | CLEARING_ZONE_ID | LAST_SENT_REV_NO | LATEST_SHIP_DATE | ORIG_APPROVAL_ID | BACKHAUL_ALLOWANCE | EARLIEST_SHIP_DATE | FOB_TRANS_RES_DESC | ORIG_APPROVAL_DATE | FOB_TITLE_PASS_DESC | FREIGHT_CONTRACT_NO | STORE_REVIEW_STATUS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | 0001 | Ordhead-001 | Y | ACTIVE | Ordhead-001 | 2 | 0 | 1 | USERENV | Y | B | 000002 | 2 | Ordhead-001 | 2026-01-01 | STD-ORDHEAD-001 | Ordhead-001 | USERENV | Ordhead-001 | Ordhead-001 | Ordhead-001 | 2026-01-01 | 0002 | Yes | Ordhead-001 | 1 | L | STD-ORDHEAD-001 | N | on | 2026-01-01 | Ordhead-001 | Ordhead-001 | Ordhead-001 | 1 | Store | Ordhead-001 | Ordhead-001 | Ordhead-001 | 1000000001 | Ordhead-001 | 1 | 2026-01-01 | 2 | Ordhead-001 | Ordhead-001 | Ordhead-001 | 2026-01-01 | STD-ORDHEAD-001 | Non | 2026-01-01 | Ordhead-001 | Ordhead-001 | 2 | 2026-01-01 | Ordhead-001 | 11.0000 | Ordhead-001 | Cost | Ordhead-001 | Ordhead-001 | 2026-01-01 | Ordhead-001 | STD-ORDHEAD-001 | 2026-01-01 | CC | 1 | Ordhead-001 | STD-ORDHEAD-001 | 000002 | 2026-01-01 | STD-ORDHEAD-001 | 11.0000 | 2026-01-01 | Ordhead-001 | 2026-01-01 | Ordhead-001 | Ordhead-001 | ACTIVE |
default
- DEPTPK
- 1001
- BUYERPK
- 0001
- TERMSRPK
- Ordhead-001
- QC_INDR
- Y
- STATUSR
- ACTIVE
- PO_TYPEPK
- Ordhead-001
- ORDER_NORPK
- 2
- ORIG_INDR
- 0
- SUPPLIERRPK
- 1
- CREATE_IDR
- USERENV
- EDI_PO_INDR
- Y
- ORDER_TYPER
- B
- CONTRACT_NOPK
- 000002
- WF_ORDER_NOPK
- 2
- PRE_MARK_INDR
- Ordhead-001
- WRITTEN_DATER
- 2026-01-01
- CURRENCY_CODERPK
- STD-ORDHEAD-001
- FREIGHT_TERMSPK
- Ordhead-001
- LAST_UPDATE_IDR
- USERENV
- PARTNER_TYPE_1PK
- Ordhead-001
- PARTNER_TYPE_2PK
- Ordhead-001
- PARTNER_TYPE_3PK
- Ordhead-001
- CREATE_DATETIMER
- 2026-01-01
- SUPP_ADD_SEQ_NOR
- 0002
- IMPORT_ORDER_INDR
- Yes
- PO_ACK_RECVD_INDR
- Ordhead-001
- DELIVERY_SUPPLIERPK
- 1
- EXCHANGE_RATE_INDR
- L
- IMPORT_COUNTRY_IDPK
- STD-ORDHEAD-001
- TRIANGULATION_INDR
- N
- INCLUDE_ON_ORDER_INDR
- on
- LAST_UPDATE_DATETIMER
- 2026-01-01
- ITEM
- Ordhead-001
- AGENT
- Ordhead-001
- FACTORY
- Ordhead-001
- LOCATION
- 1
- LOC_TYPE
- Store
- PARTNER1
- Ordhead-001
- PARTNER2
- Ordhead-001
- PARTNER3
- Ordhead-001
- IMPORT_ID
- 1000000001
- PICKUP_NO
- Ordhead-001
- PROMOTION
- 1
- CLOSE_DATE
- 2026-01-01
- ORDCUST_NO
- 2
- PICKUP_LOC
- Ordhead-001
- IMPORT_TYPE
- Ordhead-001
- LADING_PORT
- Ordhead-001
- PICKUP_DATE
- 2026-01-01
- REJECT_CODE
- STD-ORDHEAD-001
- SHIP_METHOD
- Non
- APP_DATETIME
- 2026-01-01
- COMMENT_DESC
- Ordhead-001
- EDI_SENT_IND
- Ordhead-001
- MASTER_PO_NO
- 2
- OTB_EOW_DATE
- 2026-01-01
- BACKHAUL_TYPE
- Ordhead-001
- EXCHANGE_RATE
- 11.0000
- FOB_TRANS_RES
- Ordhead-001
- PURCHASE_TYPE
- Cost
- DISCHARGE_PORT
- Ordhead-001
- FOB_TITLE_PASS
- Ordhead-001
- NOT_AFTER_DATE
- 2026-01-01
- PAYMENT_METHOD
- Ordhead-001
- ROUTING_LOC_ID
- STD-ORDHEAD-001
- NOT_BEFORE_DATE
- 2026-01-01
- SHIP_PAY_METHOD
- CC
- SPLIT_REF_ORDNO
- 1
- VENDOR_ORDER_NO
- Ordhead-001
- CLEARING_ZONE_ID
- STD-ORDHEAD-001
- LAST_SENT_REV_NO
- 000002
- LATEST_SHIP_DATE
- 2026-01-01
- ORIG_APPROVAL_ID
- STD-ORDHEAD-001
- BACKHAUL_ALLOWANCE
- 11.0000
- EARLIEST_SHIP_DATE
- 2026-01-01
- FOB_TRANS_RES_DESC
- Ordhead-001
- ORIG_APPROVAL_DATE
- 2026-01-01
- FOB_TITLE_PASS_DESC
- Ordhead-001
- FREIGHT_CONTRACT_NO
- Ordhead-001
- STORE_REVIEW_STATUS
- ACTIVE