Understand the billing account or sub account entity

FOCUS Versions

v1.3 v1.4

Context

List all billing and sub-accounts with charges in the period, showing service provider, account ID, name, and type. This list allows practitioners to map entity hierarchies and allocate costs.

FOCUS SQL Query

SELECT DISTINCT
    ServiceProviderName,
    BillingAccountID,
    BillingAccountName,
    BillingAccountType
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail

FOCUS Columns

Service Provider Name Billing Account ID Billing Account Name Billing Account Type Charge Period Start Charge Period End

Previous Reconcile Multi-Currency Settlement using Lineage IDs Next Validate Tax Variance