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(21)
Rules & Considerations(35)
Sample Load Data(4)
| _scenario | ITEMRPK | TEMPL_IDRPK | CREATE_IDR | NEED_DATER | WF_ORDER_NORPK | CUSTOMER_LOCRPK | REQUESTED_QTYR | SOURCE_LOC_IDR | LAST_UPDATE_IDR | NOT_AFTER_DATER | CREATE_DATETIMER | SOURCE_LOC_TYPER | WF_ORDER_LINE_NOR | LAST_UPDATE_DATETIMER | CALC_TYPE | FIXED_COST | MARGIN_PCT | TEMPL_DESC | CANCEL_REASON | CUSTOMER_COST | ACQUISITION_COST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | 2026-01-01 | 1 | 1 | 1.0000 | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | SA | 1 | 2026-01-01 | S | 1.0000 | 1.0000 | SAMPLE | SAMPLE | 1.0000 | 1.0000 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- TEMPL_IDRPK
- 1
- CREATE_IDR
- SAMPLE
- NEED_DATER
- 2026-01-01
- WF_ORDER_NORPK
- 1
- CUSTOMER_LOCRPK
- 1
- REQUESTED_QTYR
- 1.0000
- SOURCE_LOC_IDR
- 1
- LAST_UPDATE_IDR
- SAMPLE
- NOT_AFTER_DATER
- 2026-01-01
- CREATE_DATETIMER
- 2026-01-01
- SOURCE_LOC_TYPER
- SA
- WF_ORDER_LINE_NOR
- 1
- LAST_UPDATE_DATETIMER
- 2026-01-01
- CALC_TYPE
- S
- FIXED_COST
- 1.0000
- MARGIN_PCT
- 1.0000
- TEMPL_DESC
- SAMPLE
- CANCEL_REASON
- SAMPLE
- CUSTOMER_COST
- 1.0000
- ACQUISITION_COST
- 1.0000
Rule Validation Summary
- Source Rule Count
- 40
- Governed Rule Count
- 35