Wf Order Detail
In ScopeTechnical: WF_ORDER_DETAIL | ID: OR-FND-WF_ORDER_DETAIL-WF_ORDER_DETAIL
Stores the line level details of a franchise orders.
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_DETAIL
Field Definitions(5)
Rules & Considerations(39)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMR | WF_ORDER_NORPK | SOURCE_LOC_IDR | SOURCE_LOC_TYPER | WF_ORDER_LINE_NORPK | TEMPL_ID | CALC_TYPE | CREATE_ID | NEED_DATE | FIXED_COST | MARGIN_PCT | TEMPL_DESC | CUSTOMER_LOC | CANCEL_REASON | CUSTOMER_COST | REQUESTED_QTY | LAST_UPDATE_ID | NOT_AFTER_DATE | CREATE_DATETIME | ACQUISITION_COST | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | SA | 1 | 1 | S | SAMPLE | 2026-01-01 | 1.0000 | 1.0000 | SAMPLE | 1 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | 2026-01-01 | 2026-01-01 | 1.0000 | 2026-01-01 |
| default | Wf Order Detail-002-ALT | 4 | 1000000003 | WH | 4 | 1000000003 | U | MDM_USER | 2026-01-03 | 12.5000 | 12.5000 | Wf Order Detail-002-ALT | 3 | Wf Ord | 12.5000 | 12.5000 | MDM_USER | 2026-01-03 | 2026-01-03 | 12.5000 | 2026-01-03 |
| default | Wf Order Detail-003-EDGE | 6 | 1000000005 | SU | 6 | 1000000005 | R | BATCH_USER | 2026-01-05 | 14.0000 | 14.0000 | Wf Order Detail-003-EDGE | 5 | Wf Ord | 14.0000 | 14.0000 | BATCH_USER | 2026-01-05 | 2026-01-05 | 14.0000 | 2026-01-05 |
Example values from field definitions
- ITEMR
- SAMPLE
- WF_ORDER_NORPK
- 1
- SOURCE_LOC_IDR
- 1
- SOURCE_LOC_TYPER
- SA
- WF_ORDER_LINE_NORPK
- 1
- TEMPL_ID
- 1
- CALC_TYPE
- S
- CREATE_ID
- SAMPLE
- NEED_DATE
- 2026-01-01
- FIXED_COST
- 1.0000
- MARGIN_PCT
- 1.0000
- TEMPL_DESC
- SAMPLE
- CUSTOMER_LOC
- 1
- CANCEL_REASON
- SAMPLE
- CUSTOMER_COST
- 1.0000
- REQUESTED_QTY
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- NOT_AFTER_DATE
- 2026-01-01
- CREATE_DATETIME
- 2026-01-01
- ACQUISITION_COST
- 1.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- ITEMR
- Wf Order Detail-002-ALT
- WF_ORDER_NORPK
- 4
- SOURCE_LOC_IDR
- 1000000003
- SOURCE_LOC_TYPER
- WH
- WF_ORDER_LINE_NORPK
- 4
- TEMPL_ID
- 1000000003
- CALC_TYPE
- U
- CREATE_ID
- MDM_USER
- NEED_DATE
- 2026-01-03
- FIXED_COST
- 12.5000
- MARGIN_PCT
- 12.5000
- TEMPL_DESC
- Wf Order Detail-002-ALT
- CUSTOMER_LOC
- 3
- CANCEL_REASON
- Wf Ord
- CUSTOMER_COST
- 12.5000
- REQUESTED_QTY
- 12.5000
- LAST_UPDATE_ID
- MDM_USER
- NOT_AFTER_DATE
- 2026-01-03
- CREATE_DATETIME
- 2026-01-03
- ACQUISITION_COST
- 12.5000
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- ITEMR
- Wf Order Detail-003-EDGE
- WF_ORDER_NORPK
- 6
- SOURCE_LOC_IDR
- 1000000005
- SOURCE_LOC_TYPER
- SU
- WF_ORDER_LINE_NORPK
- 6
- TEMPL_ID
- 1000000005
- CALC_TYPE
- R
- CREATE_ID
- BATCH_USER
- NEED_DATE
- 2026-01-05
- FIXED_COST
- 14.0000
- MARGIN_PCT
- 14.0000
- TEMPL_DESC
- Wf Order Detail-003-EDGE
- CUSTOMER_LOC
- 5
- CANCEL_REASON
- Wf Ord
- CUSTOMER_COST
- 14.0000
- REQUESTED_QTY
- 14.0000
- LAST_UPDATE_ID
- BATCH_USER
- NOT_AFTER_DATE
- 2026-01-05
- CREATE_DATETIME
- 2026-01-05
- ACQUISITION_COST
- 14.0000
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 44
- Governed Rule Count
- 39