Ordhead Rev
In ScopeTechnical: ORDHEAD_REV | ID: OR-PUR-ORDHEAD_REV-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ORDHEAD_REV
Field Definitions(5)
Rules & Considerations(73)
Sample Load Data(4)
| _scenario | REV_NORPK | ORDER_NORPK | ORIGIN_TYPERPK | DEPT | AGENT | BUYER | TERMS | QC_IND | STATUS | FACTORY | PO_TYPE | LOCATION | LOC_TYPE | ORIG_IND | REV_DATE | SUPPLIER | PICKUP_NO | PROMOTION | CLOSE_DATE | EDI_PO_IND | NAD_STATUS | NBD_STATUS | 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 | 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 | PAYMENT_METHOD | NOT_BEFORE_DATE | SHIP_PAY_METHOD | SPLIT_REF_ORDNO | SUPP_ADD_SEQ_NO | VENDOR_ORDER_NO | IMPORT_ORDER_IND | LATEST_SHIP_DATE | ORIG_APPROVAL_ID | PO_ACK_RECVD_IND | IMPORT_COUNTRY_ID | BACKHAUL_ALLOWANCE | EARLIEST_SHIP_DATE | FOB_TRANS_RES_DESC | ORIG_APPROVAL_DATE | FOB_TITLE_PASS_DESC | FREIGHT_CONTRACT_NO | INCLUDE_ON_ORDER_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | S | 1 | SAMPLE | 1 | SAMPLE | S | S | SAMPLE | SAMP | 1 | S | 1 | 2026-01-01 | 1 | SAMPLE | 1 | 2026-01-01 | S | 1 | 1 | SAM | SAMPLE | 1 | 1 | SAMPL | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | S | 2026-01-01 | S | 2026-01-01 | SAMPLE | SAM | 1.0000000000 | SA | SAMPLE | SAMPLE | SAMPL | SA | 2026-01-01 | SAMPLE | 2026-01-01 | SA | 1 | 1 | SAMPLE | S | 2026-01-01 | SAMPLE | S | SAM | 1.0000 | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | S |
| default | 4 | 4 | O | 1003 | Ordhead Re | 3 | Ordhead Rev-002 | N | P | Ordhead Re | Ordh | 3 | W | 1 | 2026-01-03 | 3 | Ordhead Rev-002-ALT | 3 | 2026-01-03 | Y | 1 | 1 | B | Ordhead Rev-002-ALT | 1 | 4 | Ordhe | 2026-01-03 | ALT-OR | Ordhea | 2026-01-03 | Ordhead Rev-002-ALT | O | 2026-01-03 | O | 2026-01-03 | Ordhea | ALT | 12.5000000000 | Or | Ordhead Rev-002-ALT | Ordhea | Ordhe | Or | 2026-01-03 | Ordhea | 2026-01-03 | CC | 3 | 4 | Ordhead Rev-002 | O | 2026-01-03 | ALT-ORDHEAD_RE-002 | O | ALT | 12.5000 | 2026-01-03 | Ordhead Rev-002-ALT | 2026-01-03 | Ordhead Rev-002-ALT | Ordhead Re | o |
| default | 6 | 6 | O | 1005 | Ordhead Re | 5 | Ordhead Rev-003 | Y | A | Ordhead Re | Ordh | 5 | S | 2 | 2026-01-05 | 5 | Ordhead Rev-003-EDGE | 5 | 2026-01-05 | Y | 2 | 2 | B | Ordhead Rev-003-EDGE | 2 | 6 | Ordhe | 2026-01-05 | EDGE-O | Ordhea | 2026-01-05 | Ordhead Rev-003-EDGE | O | 2026-01-05 | O | 2026-01-05 | Ordhea | EDG | 14.0000000000 | Or | Ordhead Rev-003-EDGE | Ordhea | Ordhe | Or | 2026-01-05 | Ordhea | 2026-01-05 | CC | 5 | 6 | Ordhead Rev-003 | O | 2026-01-05 | EDGE-ORDHEAD_RE-003 | O | EDG | 14.0000 | 2026-01-05 | Ordhead Rev-003-EDGE | 2026-01-05 | Ordhead Rev-003-EDGE | Ordhead Re | o |
Example values from field definitions
- REV_NORPK
- 1
- ORDER_NORPK
- 1
- ORIGIN_TYPERPK
- S
- DEPT
- 1
- AGENT
- SAMPLE
- BUYER
- 1
- TERMS
- SAMPLE
- QC_IND
- S
- STATUS
- S
- FACTORY
- SAMPLE
- PO_TYPE
- SAMP
- LOCATION
- 1
- LOC_TYPE
- S
- ORIG_IND
- 1
- REV_DATE
- 2026-01-01
- SUPPLIER
- 1
- PICKUP_NO
- SAMPLE
- PROMOTION
- 1
- CLOSE_DATE
- 2026-01-01
- EDI_PO_IND
- S
- NAD_STATUS
- 1
- NBD_STATUS
- 1
- ORDER_TYPE
- SAM
- PICKUP_LOC
- SAMPLE
- PUD_STATUS
- 1
- CONTRACT_NO
- 1
- LADING_PORT
- SAMPL
- PICKUP_DATE
- 2026-01-01
- REJECT_CODE
- SAMPLE
- SHIP_METHOD
- SAMPLE
- APP_DATETIME
- 2026-01-01
- COMMENT_DESC
- SAMPLE
- EDI_SENT_IND
- S
- 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
- PAYMENT_METHOD
- SAMPLE
- NOT_BEFORE_DATE
- 2026-01-01
- SHIP_PAY_METHOD
- SA
- SPLIT_REF_ORDNO
- 1
- SUPP_ADD_SEQ_NO
- 1
- VENDOR_ORDER_NO
- SAMPLE
- IMPORT_ORDER_IND
- S
- LATEST_SHIP_DATE
- 2026-01-01
- ORIG_APPROVAL_ID
- SAMPLE
- PO_ACK_RECVD_IND
- S
- IMPORT_COUNTRY_ID
- SAM
- 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
- INCLUDE_ON_ORDER_IND
- S
default
- REV_NORPK
- 4
- ORDER_NORPK
- 4
- ORIGIN_TYPERPK
- O
- DEPT
- 1003
- AGENT
- Ordhead Re
- BUYER
- 3
- TERMS
- Ordhead Rev-002
- QC_IND
- N
- STATUS
- P
- FACTORY
- Ordhead Re
- PO_TYPE
- Ordh
- LOCATION
- 3
- LOC_TYPE
- W
- ORIG_IND
- 1
- REV_DATE
- 2026-01-03
- SUPPLIER
- 3
- PICKUP_NO
- Ordhead Rev-002-ALT
- PROMOTION
- 3
- CLOSE_DATE
- 2026-01-03
- EDI_PO_IND
- Y
- NAD_STATUS
- 1
- NBD_STATUS
- 1
- ORDER_TYPE
- B
- PICKUP_LOC
- Ordhead Rev-002-ALT
- PUD_STATUS
- 1
- CONTRACT_NO
- 4
- LADING_PORT
- Ordhe
- PICKUP_DATE
- 2026-01-03
- REJECT_CODE
- ALT-OR
- SHIP_METHOD
- Ordhea
- APP_DATETIME
- 2026-01-03
- COMMENT_DESC
- Ordhead Rev-002-ALT
- EDI_SENT_IND
- O
- 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 Rev-002-ALT
- PURCHASE_TYPE
- Ordhea
- DISCHARGE_PORT
- Ordhe
- FOB_TITLE_PASS
- Or
- NOT_AFTER_DATE
- 2026-01-03
- PAYMENT_METHOD
- Ordhea
- NOT_BEFORE_DATE
- 2026-01-03
- SHIP_PAY_METHOD
- CC
- SPLIT_REF_ORDNO
- 3
- SUPP_ADD_SEQ_NO
- 4
- VENDOR_ORDER_NO
- Ordhead Rev-002
- IMPORT_ORDER_IND
- O
- LATEST_SHIP_DATE
- 2026-01-03
- ORIG_APPROVAL_ID
- ALT-ORDHEAD_RE-002
- PO_ACK_RECVD_IND
- O
- IMPORT_COUNTRY_ID
- ALT
- BACKHAUL_ALLOWANCE
- 12.5000
- EARLIEST_SHIP_DATE
- 2026-01-03
- FOB_TRANS_RES_DESC
- Ordhead Rev-002-ALT
- ORIG_APPROVAL_DATE
- 2026-01-03
- FOB_TITLE_PASS_DESC
- Ordhead Rev-002-ALT
- FREIGHT_CONTRACT_NO
- Ordhead Re
- INCLUDE_ON_ORDER_IND
- o
default
- REV_NORPK
- 6
- ORDER_NORPK
- 6
- ORIGIN_TYPERPK
- O
- DEPT
- 1005
- AGENT
- Ordhead Re
- BUYER
- 5
- TERMS
- Ordhead Rev-003
- QC_IND
- Y
- STATUS
- A
- FACTORY
- Ordhead Re
- PO_TYPE
- Ordh
- LOCATION
- 5
- LOC_TYPE
- S
- ORIG_IND
- 2
- REV_DATE
- 2026-01-05
- SUPPLIER
- 5
- PICKUP_NO
- Ordhead Rev-003-EDGE
- PROMOTION
- 5
- CLOSE_DATE
- 2026-01-05
- EDI_PO_IND
- Y
- NAD_STATUS
- 2
- NBD_STATUS
- 2
- ORDER_TYPE
- B
- PICKUP_LOC
- Ordhead Rev-003-EDGE
- PUD_STATUS
- 2
- CONTRACT_NO
- 6
- LADING_PORT
- Ordhe
- PICKUP_DATE
- 2026-01-05
- REJECT_CODE
- EDGE-O
- SHIP_METHOD
- Ordhea
- APP_DATETIME
- 2026-01-05
- COMMENT_DESC
- Ordhead Rev-003-EDGE
- EDI_SENT_IND
- O
- OTB_EOW_DATE
- 2026-01-05
- PRE_MARK_IND
- O
- WRITTEN_DATE
- 2026-01-05
- BACKHAUL_TYPE
- Ordhea
- CURRENCY_CODE
- EDG
- EXCHANGE_RATE
- 14.0000000000
- FOB_TRANS_RES
- Or
- FREIGHT_TERMS
- Ordhead Rev-003-EDGE
- PURCHASE_TYPE
- Ordhea
- DISCHARGE_PORT
- Ordhe
- FOB_TITLE_PASS
- Or
- NOT_AFTER_DATE
- 2026-01-05
- PAYMENT_METHOD
- Ordhea
- NOT_BEFORE_DATE
- 2026-01-05
- SHIP_PAY_METHOD
- CC
- SPLIT_REF_ORDNO
- 5
- SUPP_ADD_SEQ_NO
- 6
- VENDOR_ORDER_NO
- Ordhead Rev-003
- IMPORT_ORDER_IND
- O
- LATEST_SHIP_DATE
- 2026-01-05
- ORIG_APPROVAL_ID
- EDGE-ORDHEAD_RE-003
- PO_ACK_RECVD_IND
- O
- IMPORT_COUNTRY_ID
- EDG
- BACKHAUL_ALLOWANCE
- 14.0000
- EARLIEST_SHIP_DATE
- 2026-01-05
- FOB_TRANS_RES_DESC
- Ordhead Rev-003-EDGE
- ORIG_APPROVAL_DATE
- 2026-01-05
- FOB_TITLE_PASS_DESC
- Ordhead Rev-003-EDGE
- FREIGHT_CONTRACT_NO
- Ordhead Re
- INCLUDE_ON_ORDER_IND
- o
Rule Validation Summary
- Source Rule Count
- 103
- Governed Rule Count
- 73