Wf Billing Sales
In ScopeTechnical: WF_BILLING_SALES | ID: OR-FND-WF_BILLING_SALES-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- WF_BILLING_SALES
Field Definitions(5)
Rules & Considerations(41)
constraint
validation
Sample Load Data(4)
| _scenario | ORDER_DATER | WF_ORDER_NOR | CUSTOMER_LOCR | SHIPMENT_DATER | ID | DEPT | ITEM | CLASS | SUBCLASS | UOM_TYPE | VAT_CODE | VAT_RATE | ORDER_QTY | UOM_VALUE | FREIGHT_COST | CUSTOMER_COST | EXTRACTED_IND | OTHER_CHARGES | EXTRACTED_DATE | CUST_ORD_REF_NO | UOM_TAX_VALUE_PER_UNIT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 2026-01-01 | 1 | 1 | 2026-01-01 | 1 | 1 | SAMPLE | 1 | 1 | SAMP | SAMPLE | 1.0000000000 | 1.0000 | 1.0000000000 | 1.0000 | 1.0000 | S | 1.0000 | 2026-01-01 | SAMPLE | 1.0000000000 |
| default | 2026-01-03 | 4 | 3 | 2026-01-03 | 3 | 1003 | Wf Billing Sales-002-ALT | 1103 | 1113 | Wf B | ALT-WF | 12.5000000000 | 12.5000 | 12.5000000000 | 12.5000 | 12.5000 | N | 12.5000 | 2026-01-03 | Wf Billing Sales-002 | 12.5000000000 |
| default | 2026-01-05 | 6 | 5 | 2026-01-05 | 5 | 1005 | Wf Billing Sales-003-EDGE | 1105 | 1115 | Wf B | EDGE-W | 14.0000000000 | 14.0000 | 14.0000000000 | 14.0000 | 14.0000 | N | 14.0000 | 2026-01-05 | Wf Billing Sales-003 | 14.0000000000 |
Example values from field definitions
- ORDER_DATER
- 2026-01-01
- WF_ORDER_NOR
- 1
- CUSTOMER_LOCR
- 1
- SHIPMENT_DATER
- 2026-01-01
- ID
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- SUBCLASS
- 1
- UOM_TYPE
- SAMP
- VAT_CODE
- SAMPLE
- VAT_RATE
- 1.0000000000
- ORDER_QTY
- 1.0000
- UOM_VALUE
- 1.0000000000
- FREIGHT_COST
- 1.0000
- CUSTOMER_COST
- 1.0000
- EXTRACTED_IND
- S
- OTHER_CHARGES
- 1.0000
- EXTRACTED_DATE
- 2026-01-01
- CUST_ORD_REF_NO
- SAMPLE
- UOM_TAX_VALUE_PER_UNIT
- 1.0000000000
default
- ORDER_DATER
- 2026-01-03
- WF_ORDER_NOR
- 4
- CUSTOMER_LOCR
- 3
- SHIPMENT_DATER
- 2026-01-03
- ID
- 3
- DEPT
- 1003
- ITEM
- Wf Billing Sales-002-ALT
- CLASS
- 1103
- SUBCLASS
- 1113
- UOM_TYPE
- Wf B
- VAT_CODE
- ALT-WF
- VAT_RATE
- 12.5000000000
- ORDER_QTY
- 12.5000
- UOM_VALUE
- 12.5000000000
- FREIGHT_COST
- 12.5000
- CUSTOMER_COST
- 12.5000
- EXTRACTED_IND
- N
- OTHER_CHARGES
- 12.5000
- EXTRACTED_DATE
- 2026-01-03
- CUST_ORD_REF_NO
- Wf Billing Sales-002
- UOM_TAX_VALUE_PER_UNIT
- 12.5000000000
default
- ORDER_DATER
- 2026-01-05
- WF_ORDER_NOR
- 6
- CUSTOMER_LOCR
- 5
- SHIPMENT_DATER
- 2026-01-05
- ID
- 5
- DEPT
- 1005
- ITEM
- Wf Billing Sales-003-EDGE
- CLASS
- 1105
- SUBCLASS
- 1115
- UOM_TYPE
- Wf B
- VAT_CODE
- EDGE-W
- VAT_RATE
- 14.0000000000
- ORDER_QTY
- 14.0000
- UOM_VALUE
- 14.0000000000
- FREIGHT_COST
- 14.0000
- CUSTOMER_COST
- 14.0000
- EXTRACTED_IND
- N
- OTHER_CHARGES
- 14.0000
- EXTRACTED_DATE
- 2026-01-05
- CUST_ORD_REF_NO
- Wf Billing Sales-003
- UOM_TAX_VALUE_PER_UNIT
- 14.0000000000
Rule Validation Summary
- Source Rule Count
- 54
- Governed Rule Count
- 41