Wf Order Header
In ScopeTechnical: WF_ORDER_HEAD | ID: OR-FND-WF_ORDER_HEAD-WF_ORDER_HEADER
Stores the Header level details of a Franchise order.
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
- WF_ORDER_HEAD
Field Definitions(5)
Rules & Considerations(34)
validation
constraint
Sample Load Data(4)
| _scenario | STATUSR | ORDER_TYPER | WF_ORDER_NORPK | CURRENCY_CODER | FREIGHT | COMMENTS | CREATE_ID | APPROVAL_DATE | CANCEL_REASON | EXCHANGE_RATE | OTHER_CHARGES | LAST_UPDATE_ID | CREATE_DATETIME | CUST_ORD_REF_NO | BILL_TO_ADDR_TYPE | EXCHANGE_RATE_IND | DEFAULT_BILL_TO_LOC | ALL_LOCATION_BILLING | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | S | S | 1 | SAM | 1.0000 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 1.0000000000 | 1.0000 | SAMPLE | 2026-01-01 | SAMPLE | SA | S | 1 | S | 2026-01-01 |
| default | A | E | 4 | ALT | 12.5000 | Wf Order Head-002-ALT | MDM_USER | 2026-01-03 | Wf Ord | 12.5000000000 | 12.5000 | MDM_USER | 2026-01-03 | Wf Order Head-002-AL | Wf | P | 3 | Y | 2026-01-03 |
| default | P | A | 6 | EDG | 14.0000 | Wf Order Head-003-EDGE | BATCH_USER | 2026-01-05 | Wf Ord | 14.0000000000 | 14.0000 | BATCH_USER | 2026-01-05 | Wf Order Head-003-ED | Wf | L | 5 | Y | 2026-01-05 |
Example values from field definitions
- STATUSR
- S
- ORDER_TYPER
- S
- WF_ORDER_NORPK
- 1
- CURRENCY_CODER
- SAM
- FREIGHT
- 1.0000
- COMMENTS
- SAMPLE
- CREATE_ID
- SAMPLE
- APPROVAL_DATE
- 2026-01-01
- CANCEL_REASON
- SAMPLE
- EXCHANGE_RATE
- 1.0000000000
- OTHER_CHARGES
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- CUST_ORD_REF_NO
- SAMPLE
- BILL_TO_ADDR_TYPE
- SA
- EXCHANGE_RATE_IND
- S
- DEFAULT_BILL_TO_LOC
- 1
- ALL_LOCATION_BILLING
- S
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- STATUSR
- A
- ORDER_TYPER
- E
- WF_ORDER_NORPK
- 4
- CURRENCY_CODER
- ALT
- FREIGHT
- 12.5000
- COMMENTS
- Wf Order Head-002-ALT
- CREATE_ID
- MDM_USER
- APPROVAL_DATE
- 2026-01-03
- CANCEL_REASON
- Wf Ord
- EXCHANGE_RATE
- 12.5000000000
- OTHER_CHARGES
- 12.5000
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- CUST_ORD_REF_NO
- Wf Order Head-002-AL
- BILL_TO_ADDR_TYPE
- Wf
- EXCHANGE_RATE_IND
- P
- DEFAULT_BILL_TO_LOC
- 3
- ALL_LOCATION_BILLING
- Y
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- STATUSR
- P
- ORDER_TYPER
- A
- WF_ORDER_NORPK
- 6
- CURRENCY_CODER
- EDG
- FREIGHT
- 14.0000
- COMMENTS
- Wf Order Head-003-EDGE
- CREATE_ID
- BATCH_USER
- APPROVAL_DATE
- 2026-01-05
- CANCEL_REASON
- Wf Ord
- EXCHANGE_RATE
- 14.0000000000
- OTHER_CHARGES
- 14.0000
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- CUST_ORD_REF_NO
- Wf Order Head-003-ED
- BILL_TO_ADDR_TYPE
- Wf
- EXCHANGE_RATE_IND
- L
- DEFAULT_BILL_TO_LOC
- 5
- ALL_LOCATION_BILLING
- Y
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 42
- Governed Rule Count
- 34