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(21)
Rules & Considerations(35)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | DEPTRPK | ITEMRPK | CLASSR | SUBCLASSR | VAT_CODERPK | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | 1 | SAMPLE | 2026-01-01 | 1 | 1 | S | 2026-01-01 | SAMP | 1.0000000000 | 1.0000 | 1.0000000000 | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | SAMPLE | 1.0000000000 |
Example values from field definitions
- IDRPK
- 1
- DEPTRPK
- 1
- ITEMRPK
- SAMPLE
- CLASSR
- 1
- SUBCLASSR
- 1
- VAT_CODERPK
- SAMPLE
- ORDER_DATER
- 2026-01-01
- WF_ORDER_NORPK
- 1
- CUSTOMER_LOCRPK
- 1
- EXTRACTED_INDR
- S
- SHIPMENT_DATER
- 2026-01-01
- UOM_TYPE
- SAMP
- VAT_RATE
- 1.0000000000
- ORDER_QTY
- 1.0000
- UOM_VALUE
- 1.0000000000
- FREIGHT_COST
- 1.0000
- CUSTOMER_COST
- 1.0000
- OTHER_CHARGES
- 1.0000
- EXTRACTED_DATE
- 2026-01-01
- CUST_ORD_REF_NO
- SAMPLE
- UOM_TAX_VALUE_PER_UNIT
- 1.0000000000
Rule Validation Summary
- Source Rule Count
- 48
- Governed Rule Count
- 35