credit_automated_invoice_deduction
represents a reduction of the credit balance from an invoice
line_items
, ignore this ledger entry type as revenue is already included from line_items
where invoices.type
= CONTRACT_USAGE
credit_segment_expiration
represents the expiration of the credit balance segment (aka true-up)
prepaid_automated_invoice_deduction
represents a reduction of the prepaid commit balance from an invoice
line_items
, ignore this ledger entry type as revenue is already included from line_items
where invoices.type
= CONTRACT_USAGE
prepaid_segment_expiration
represents the expiration of the prepaid commit balance segment
postpaid_automated_invoice_deduction
represents a reduction of the postpaid commit balance from an invoice
line_items
, ignore this ledger entry type as revenue is already included from line_items
where invoices.type
= CONTRACT_TRUEUP
postpaid_trueup
represents a true-up invoice that was issued for this postpaid commit to invoice for the remainder of the postpaid commit balance
line_items
, ignore this ledger entry type as amounts are duplicatedcredits
and commits
objects are consolidated into the balances
object to simplify reporting.
invoices.type = 'CONTRACT_SCHEDULED'
, the invoice contains scheduled charges, including prepaid commit purchasesinvoices.type = 'CONTRACT_USAGE'
, the invoice contains usage chargesinvoices.type = 'CONTRACT_TRUEUP'
, the invoice contains true-up charges for postpaid commitsinvoices.credit_type_id
indicates the billing currency (for example, USD cents)invoices.start_timestamp
and invoices.end_timestamp
indicate the service period
line_items.product_id
indicates which product is being invoiced
line_items.product_id
is mapped to a SKU or line item ID in the ERP systemline_items.commit_id
is populated, a credit or commit has been applied to the line item
line_items
to balances
(line_items.commit_id = balances.id
) to fetch balances.type
balances.type
determines whether line item amount should be categorized as credit, prepaid commit, or postpaid commit revenuebalances.type
are: credit
, prepaid
, or postpaid
line_items.commit_id
is null, this indicates the line item amount should be categorized as either on-demand (pay-as-you-go) or overage revenue
contracts
or commits
objects to differentiate on-demand (pay-as-you-go) versus overage revenuestatus = 'FINALIZED'
will produce a report of recognized revenue
status = 'DRAFT'
will produce a report of accrued revenue