Wf Billing Returns
In ScopeTechnical: WF_BILLING_RETURNS | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- WF_BILLING_RETURNS
Field Definitions(20)
Rules & Considerations(21)
Sample Load Data(4)
| _scenario | IDRPK | DEPTRPK | ITEMRPK | CLASSR | RMA_NORPK | SUBCLASSR | VAT_CODEPK | RETURN_DATER | WF_ORDER_NOPK | CUSTOMER_LOCRPK | RETURNED_QTYR | EXTRACTED_INDR | UOM_TYPE | VAT_RATE | UOM_VALUE | EXTRACTED_DATE | RESTOCKING_FEE | CUST_ORD_REF_NO | RETURN_UNIT_COST | UOM_TAX_VALUE_PER_UNIT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1001 | Wf Billing Returns-001 | 1101 | 2 | 1111 | STD-WF_BILLING-001 | 2026-01-01 | 2 | 1 | 11.0000 | N | Wf Billing Returns-001 | 11.0000 | 11.0000 | 2026-01-01 | 11.0000 | Wf Billing Returns-001 | 11.0000 | 11.0000 |
default
- IDRPK
- 1
- DEPTRPK
- 1001
- ITEMRPK
- Wf Billing Returns-001
- CLASSR
- 1101
- RMA_NORPK
- 2
- SUBCLASSR
- 1111
- VAT_CODEPK
- STD-WF_BILLING-001
- RETURN_DATER
- 2026-01-01
- WF_ORDER_NOPK
- 2
- CUSTOMER_LOCRPK
- 1
- RETURNED_QTYR
- 11.0000
- EXTRACTED_INDR
- N
- UOM_TYPE
- Wf Billing Returns-001
- VAT_RATE
- 11.0000
- UOM_VALUE
- 11.0000
- EXTRACTED_DATE
- 2026-01-01
- RESTOCKING_FEE
- 11.0000
- CUST_ORD_REF_NO
- Wf Billing Returns-001
- RETURN_UNIT_COST
- 11.0000
- UOM_TAX_VALUE_PER_UNIT
- 11.0000