Wf Order Detail
In ScopeTechnical: WF_ORDER_DETAIL | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- WF_ORDER_DETAIL
Field Definitions(21)
Rules & Considerations(22)
Sample Load Data(4)
| _scenario | ITEMRPK | TEMPL_IDPK | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Wf Order Detail-001 | 1000000001 | MIG_USER | 2026-01-01 | 2 | 1 | 11.0000 | 1000000001 | MIG_USER | 2026-01-01 | 2026-01-01 | ST | 2 | 2026-01-01 | M | 11.0000 | 11.0000 | Wf Order Detail-001 | Wf Order Detail-001 | 11.0000 | 11.0000 |
default
- ITEMRPK
- Wf Order Detail-001
- TEMPL_IDPK
- 1000000001
- CREATE_IDR
- MIG_USER
- NEED_DATER
- 2026-01-01
- WF_ORDER_NORPK
- 2
- CUSTOMER_LOCRPK
- 1
- REQUESTED_QTYR
- 11.0000
- SOURCE_LOC_IDR
- 1000000001
- LAST_UPDATE_IDR
- MIG_USER
- NOT_AFTER_DATER
- 2026-01-01
- CREATE_DATETIMER
- 2026-01-01
- SOURCE_LOC_TYPER
- ST
- WF_ORDER_LINE_NOR
- 2
- LAST_UPDATE_DATETIMER
- 2026-01-01
- CALC_TYPE
- M
- FIXED_COST
- 11.0000
- MARGIN_PCT
- 11.0000
- TEMPL_DESC
- Wf Order Detail-001
- CANCEL_REASON
- Wf Order Detail-001
- CUSTOMER_COST
- 11.0000
- ACQUISITION_COST
- 11.0000