Line Level Details For Franchise Returns
In ScopeTechnical: WF_RETURN_DETAIL | ID: OR-FND-WF_RETURN_DETAIL-WF_RETURN_DETAIL
Stores the line level details for franchise returns.
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_RETURN_DETAIL
Field Definitions(5)
Rules & Considerations(26)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMRPK | RMA_NORPK | RETURNED_QTYR | CREATE_ID | WF_ORDER_NO | RESTOCK_TYPE | CANCEL_REASON | RETURN_REASON | LAST_UPDATE_ID | CREATE_DATETIME | RETURN_UNIT_COST | UNIT_RESTOCK_FEE | LAST_UPDATE_DATETIME | NET_RETURN_UNIT_COST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | SAMPLE | 1 | S | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 |
| default | Wf Return Detail-002-ALT | 4 | 12.5000 | MDM_USER | 4 | V | Wf Ret | Wf Ret | MDM_USER | 2026-01-03 | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 |
| default | Wf Return Detail-003-EDGE | 6 | 14.0000 | BATCH_USER | 6 | V | Wf Ret | Wf Ret | BATCH_USER | 2026-01-05 | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- RMA_NORPK
- 1
- RETURNED_QTYR
- 1.0000
- CREATE_ID
- SAMPLE
- WF_ORDER_NO
- 1
- RESTOCK_TYPE
- S
- CANCEL_REASON
- SAMPLE
- RETURN_REASON
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- RETURN_UNIT_COST
- 1.0000
- UNIT_RESTOCK_FEE
- 1.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
- NET_RETURN_UNIT_COST
- 1.0000
default
- ITEMRPK
- Wf Return Detail-002-ALT
- RMA_NORPK
- 4
- RETURNED_QTYR
- 12.5000
- CREATE_ID
- MDM_USER
- WF_ORDER_NO
- 4
- RESTOCK_TYPE
- V
- CANCEL_REASON
- Wf Ret
- RETURN_REASON
- Wf Ret
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- RETURN_UNIT_COST
- 12.5000
- UNIT_RESTOCK_FEE
- 12.5000
- LAST_UPDATE_DATETIME
- 2026-01-03
- NET_RETURN_UNIT_COST
- 12.5000
default
- ITEMRPK
- Wf Return Detail-003-EDGE
- RMA_NORPK
- 6
- RETURNED_QTYR
- 14.0000
- CREATE_ID
- BATCH_USER
- WF_ORDER_NO
- 6
- RESTOCK_TYPE
- V
- CANCEL_REASON
- Wf Ret
- RETURN_REASON
- Wf Ret
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- RETURN_UNIT_COST
- 14.0000
- UNIT_RESTOCK_FEE
- 14.0000
- LAST_UPDATE_DATETIME
- 2026-01-05
- NET_RETURN_UNIT_COST
- 14.0000
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 26