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(20)
Rules & Considerations(37)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | DEPTRPK | ITEMRPK | CLASSR | RMA_NORPK | SUBCLASSR | VAT_CODERPK | RETURN_DATER | WF_ORDER_NORPK | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | 2026-01-01 | 1 | 1 | 1.0000 | S | SAMP | 1.0000000000 | 1.0000000000 | 2026-01-01 | 1.0000 | SAMPLE | 1.0000 | 1.0000000000 |
Example values from field definitions
- IDRPK
- 1
- DEPTRPK
- 1
- ITEMRPK
- SAMPLE
- CLASSR
- 1
- RMA_NORPK
- 1
- SUBCLASSR
- 1
- VAT_CODERPK
- SAMPLE
- RETURN_DATER
- 2026-01-01
- WF_ORDER_NORPK
- 1
- CUSTOMER_LOCRPK
- 1
- RETURNED_QTYR
- 1.0000
- EXTRACTED_INDR
- S
- UOM_TYPE
- SAMP
- VAT_RATE
- 1.0000000000
- UOM_VALUE
- 1.0000000000
- 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
Rule Validation Summary
- Source Rule Count
- 50
- Governed Rule Count
- 37