Wf Billing Sales
In ScopeTechnical: WF_BILLING_SALES | ID: OR-MFCS-WF_BILLING_SALES
This is a staging table to capture billing information when franchise orders are shipped.
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_SALES
Field Definitions(21)
Rules & Considerations(20)
Sample Load Data(4)
| _scenario | IDRPK | DEPTRPK | ITEMRPK | CLASSR | SUBCLASSR | VAT_CODEPK | ORDER_DATER | WF_ORDER_NORPK | CUSTOMER_LOCRPK | EXTRACTED_INDR | SHIPMENT_DATER | UOM_TYPE | VAT_RATE | ORDER_QTY | UOM_VALUE | FREIGHT_COST | CUSTOMER_COST | OTHER_CHARGES | EXTRACTED_DATE | CUST_ORD_REF_NO | UOM_TAX_VALUE_PER_UNIT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1001 | Wf Billing Sales-001 | 1101 | 1111 | STD-WF_BILLING-001 | 2026-01-01 | 2 | 1 | N | 2026-01-01 | Wf Billing Sales-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 | Wf Billing Sales-001 | 11.0000 |
default
- IDRPK
- 1
- DEPTRPK
- 1001
- ITEMRPK
- Wf Billing Sales-001
- CLASSR
- 1101
- SUBCLASSR
- 1111
- VAT_CODEPK
- STD-WF_BILLING-001
- ORDER_DATER
- 2026-01-01
- WF_ORDER_NORPK
- 2
- CUSTOMER_LOCRPK
- 1
- EXTRACTED_INDR
- N
- SHIPMENT_DATER
- 2026-01-01
- UOM_TYPE
- Wf Billing Sales-001
- VAT_RATE
- 11.0000
- ORDER_QTY
- 11.0000
- UOM_VALUE
- 11.0000
- FREIGHT_COST
- 11.0000
- CUSTOMER_COST
- 11.0000
- OTHER_CHARGES
- 11.0000
- EXTRACTED_DATE
- 2026-01-01
- CUST_ORD_REF_NO
- Wf Billing Sales-001
- UOM_TAX_VALUE_PER_UNIT
- 11.0000