Report corrections by subaccount for a previously invoiced billing period v1.3
Inspect the result, its parameters and the SQL behind it.
- Source
- FOCUS use-case library
- Data
- FOCUS 1.0 sample
- Status
- Not in v1.0 sample
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
- Source
- FOCUS use-case SQL
- Status
- Not in v1.0 sample
- Results
- Not run
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
ChargeClass is null on every row of the v1.0 sample, so there are no 'Correction' charges to report for any billing period.
Original FOCUS SQL
SELECT ServiceProviderName, BillingAccountId, ServiceCategory, SubAccountId, SubAccountName, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? AND ChargeClass = 'Correction' GROUP BY ServiceProviderName, BillingAccountId, SubAccountId, SubAccountName, ServiceCategory