Invoices

Overview

The Invoice table contains information associated with an invoices in CloudBilling. For further contextual information on how customers are configured in CloudBilling, view the Invoices page.

---

Fields

Name	Type	Description
Key	Integer	A unique identifier for each invoice across the entire dataset.
SourceId	String
CustomerCode	Integer	A unique external identifier for a customer in CloudBilling.
CustomerKey	Integer	A unique identifier for each customer across the entire dataset.
Number	String	Invoice Number. Approved Invoices will have an invoice number and all other invoices will have the value -1
Start	Integer	The start fo the invoice period (yyyymmdd).
End	Integer	The end of the invoice period (yyyymmdd).
StatusKey	Integer	1 = Pending; 2 = Calculating; 4 = Calculation Error; 6 = Invoiced; 8 = Approved; 11 = Rejected; 12 = Closed; 13 = Approving; 14 = Reopening; 15 = Closing;
Approved	Integer	The invoice approval date (yyyymmdd). It is -1 if invoice is not approved.
Type	Integer	0 = Period; 1 = AdHoc; 2 = Credit;
Amount	Decimal	The total amount in the invoice.
Cost	Decimal	The total cost in the invoice.
LastCalculatedDate	Datetimeoffset	The most date and time of invoice recalculation in UTC (yyyy-mm-dd hh:mm:ss +00:00)
LockedUntilDate	Datetimeoffset