Header Level Details Of Franchise Returns
In ScopeTechnical: WF_RETURN_HEAD | ID: OR-FND-WF_RETURN_HEAD-WF_RETURN_HEADER
Stores the header level details of 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_HEAD
Field Definitions(5)
Rules & Considerations(32)
constraint
validation
Sample Load Data(4)
| _scenario | RMA_NORPK | STATUSR | CUSTOMER_LOCR | RETURN_LOC_TYPER | COMMENTS | CREATE_ID | RETURN_TYPE | CANCEL_REASON | CURRENCY_CODE | RETURN_LOC_ID | RETURN_METHOD | LAST_UPDATE_ID | CREATE_DATETIME | CUST_RET_REF_NO | TOTAL_RETURN_AMT | TOTAL_RESTOCK_AMT | LAST_UPDATE_DATETIME | TOTAL_NET_RETURN_AMT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | S | 1 | S | SAMPLE | SAMPLE | S | SAMPLE | SAM | 1 | S | SAMPLE | 2026-01-01 | SAMPLE | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 |
| default | 4 | P | 3 | S | Wf Return Head-002-ALT | MDM_USER | A | Wf Ret | ALT | 1000000003 | D | MDM_USER | 2026-01-03 | Wf Return Head-002-A | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 |
| default | 6 | A | 5 | S | Wf Return Head-003-EDGE | BATCH_USER | E | Wf Ret | EDG | 1000000005 | D | BATCH_USER | 2026-01-05 | Wf Return Head-003-E | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 |
Example values from field definitions
- RMA_NORPK
- 1
- STATUSR
- S
- CUSTOMER_LOCR
- 1
- RETURN_LOC_TYPER
- S
- COMMENTS
- SAMPLE
- CREATE_ID
- SAMPLE
- RETURN_TYPE
- S
- CANCEL_REASON
- SAMPLE
- CURRENCY_CODE
- SAM
- RETURN_LOC_ID
- 1
- RETURN_METHOD
- S
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- CUST_RET_REF_NO
- SAMPLE
- TOTAL_RETURN_AMT
- 1.0000
- TOTAL_RESTOCK_AMT
- 1.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
- TOTAL_NET_RETURN_AMT
- 1.0000
default
- RMA_NORPK
- 4
- STATUSR
- P
- CUSTOMER_LOCR
- 3
- RETURN_LOC_TYPER
- S
- COMMENTS
- Wf Return Head-002-ALT
- CREATE_ID
- MDM_USER
- RETURN_TYPE
- A
- CANCEL_REASON
- Wf Ret
- CURRENCY_CODE
- ALT
- RETURN_LOC_ID
- 1000000003
- RETURN_METHOD
- D
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- CUST_RET_REF_NO
- Wf Return Head-002-A
- TOTAL_RETURN_AMT
- 12.5000
- TOTAL_RESTOCK_AMT
- 12.5000
- LAST_UPDATE_DATETIME
- 2026-01-03
- TOTAL_NET_RETURN_AMT
- 12.5000
default
- RMA_NORPK
- 6
- STATUSR
- A
- CUSTOMER_LOCR
- 5
- RETURN_LOC_TYPER
- S
- COMMENTS
- Wf Return Head-003-EDGE
- CREATE_ID
- BATCH_USER
- RETURN_TYPE
- E
- CANCEL_REASON
- Wf Ret
- CURRENCY_CODE
- EDG
- RETURN_LOC_ID
- 1000000005
- RETURN_METHOD
- D
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- CUST_RET_REF_NO
- Wf Return Head-003-E
- TOTAL_RETURN_AMT
- 14.0000
- TOTAL_RESTOCK_AMT
- 14.0000
- LAST_UPDATE_DATETIME
- 2026-01-05
- TOTAL_NET_RETURN_AMT
- 14.0000
Rule Validation Summary
- Source Rule Count
- 38
- Governed Rule Count
- 32