Wf Billing Returns
In ScopeTechnical: WF_BILLING_RETURNS | ID: OR-FND-WF_BILLING_RETURNS-WF_BILLING_RETURNS
This is a staging table to capture billing information when franchise returns are received.
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_BILLING_RETURNS
Field Definitions(5)
Rules & Considerations(44)
constraint
validation
Sample Load Data(4)
| _scenario | RMA_NOR | RETURN_DATER | CUSTOMER_LOCR | ID | DEPT | ITEM | CLASS | SUBCLASS | UOM_TYPE | VAT_CODE | VAT_RATE | UOM_VALUE | WF_ORDER_NO | RETURNED_QTY | EXTRACTED_IND | EXTRACTED_DATE | RESTOCKING_FEE | CUST_ORD_REF_NO | RETURN_UNIT_COST | UOM_TAX_VALUE_PER_UNIT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 2026-01-01 | 1 | 1 | 1 | SAMPLE | 1 | 1 | SAMP | SAMPLE | 1.0000000000 | 1.0000000000 | 1 | 1.0000 | S | 2026-01-01 | 1.0000 | SAMPLE | 1.0000 | 1.0000000000 |
| default | 4 | 2026-01-03 | 3 | 3 | 1003 | Wf Billing Returns-002-AL | 1103 | 1113 | Wf B | ALT-WF | 12.5000000000 | 12.5000000000 | 4 | 12.5000 | N | 2026-01-03 | 12.5000 | Wf Billing Returns-0 | 12.5000 | 12.5000000000 |
| default | 6 | 2026-01-05 | 5 | 5 | 1005 | Wf Billing Returns-003-ED | 1105 | 1115 | Wf B | EDGE-W | 14.0000000000 | 14.0000000000 | 6 | 14.0000 | N | 2026-01-05 | 14.0000 | Wf Billing Returns-0 | 14.0000 | 14.0000000000 |
Example values from field definitions
- RMA_NOR
- 1
- RETURN_DATER
- 2026-01-01
- CUSTOMER_LOCR
- 1
- ID
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- SUBCLASS
- 1
- UOM_TYPE
- SAMP
- VAT_CODE
- SAMPLE
- VAT_RATE
- 1.0000000000
- UOM_VALUE
- 1.0000000000
- WF_ORDER_NO
- 1
- RETURNED_QTY
- 1.0000
- EXTRACTED_IND
- S
- EXTRACTED_DATE
- 2026-01-01
- RESTOCKING_FEE
- 1.0000
- CUST_ORD_REF_NO
- SAMPLE
- RETURN_UNIT_COST
- 1.0000
- UOM_TAX_VALUE_PER_UNIT
- 1.0000000000
default
- RMA_NOR
- 4
- RETURN_DATER
- 2026-01-03
- CUSTOMER_LOCR
- 3
- ID
- 3
- DEPT
- 1003
- ITEM
- Wf Billing Returns-002-AL
- CLASS
- 1103
- SUBCLASS
- 1113
- UOM_TYPE
- Wf B
- VAT_CODE
- ALT-WF
- VAT_RATE
- 12.5000000000
- UOM_VALUE
- 12.5000000000
- WF_ORDER_NO
- 4
- RETURNED_QTY
- 12.5000
- EXTRACTED_IND
- N
- EXTRACTED_DATE
- 2026-01-03
- RESTOCKING_FEE
- 12.5000
- CUST_ORD_REF_NO
- Wf Billing Returns-0
- RETURN_UNIT_COST
- 12.5000
- UOM_TAX_VALUE_PER_UNIT
- 12.5000000000
default
- RMA_NOR
- 6
- RETURN_DATER
- 2026-01-05
- CUSTOMER_LOCR
- 5
- ID
- 5
- DEPT
- 1005
- ITEM
- Wf Billing Returns-003-ED
- CLASS
- 1105
- SUBCLASS
- 1115
- UOM_TYPE
- Wf B
- VAT_CODE
- EDGE-W
- VAT_RATE
- 14.0000000000
- UOM_VALUE
- 14.0000000000
- WF_ORDER_NO
- 6
- RETURNED_QTY
- 14.0000
- EXTRACTED_IND
- N
- EXTRACTED_DATE
- 2026-01-05
- RESTOCKING_FEE
- 14.0000
- CUST_ORD_REF_NO
- Wf Billing Returns-0
- RETURN_UNIT_COST
- 14.0000
- UOM_TAX_VALUE_PER_UNIT
- 14.0000000000
Rule Validation Summary
- Source Rule Count
- 57
- Governed Rule Count
- 44