Billing Data CSV #
The information below provides details of the CSV data provided when downloading the data for a specific invoice. The CSV data provides information on each user licence used but does not provide any invoice summary information.
CSV Invoice Item Schema #
Each entry in the CSV billing data provides the parameters listed below.
| Key | Description | Type |
|---|---|---|
| id | A unique id for the individual purchase | string |
| quantity1 | The quantity used | double |
| value | The monetary cost of the item | double |
| fromdate | The date from which the item is being billed for | string |
| todate | The date to which the item is being billed for | string |
| productname | The name of the feature/product the Invoice Item is for. | string |
| partnumber | The part number of the feature/product the Invoice Item is for. | string |
| tenantcode2 | The customer's tenant id | string |
| tenantcodeext2 | The extended reference for the customer | string |
| tenantname2 | The name of customer | string |
| resellercode[^3] | The reseller's tenant id | string |
| resellercodeext[^3] | The extended reference for the reseller | string |
| resellername[^3] | The name of the reseller | string |
| userId | The id of the user | string |
| username | The username of the user | string |
note
The first row of the CSV file contains column headings
Example CSV Output #
id,quantity,value,fromdate,todate,productname,partnumber,tenantcode,tenantcodeext,tenantname,userid,username,resellercode,resellercodeext,resellername,role
000000000000000000000001,1,1.25,2020-04-01T00:00:00.000+00:00,2020-04-30T23:59:59.000+00:00,Essential User,#XDM00001,00000000-0000-0000-0000-000000000111,custom ref 1,Example Customer 1,00000000-0000-0000-0000-000000000001,[[email protected]](mailto:[email protected]),00000000-0000-0000-0000-000000000222,reseller ref 1,ABC Reseller,customer.user.pbx
000000000000000000000003,1,15,2020-04-01T00:00:00.000+00:00,2020-04-30T23:59:59.000+00:00,Real-Time Supervisor,#XDM00010,00000000-0000-0000-0000-000000000111,custom ref 1,Example Customer 1,00000000-0000-0000-0000-000000000001,[[email protected]](mailto:[email protected]),00000000-0000-0000-0000-000000000222,reseller ref 1,ABC Reseller,customer.user.supervisorl2-
If the invoice entry is a credit, the quantity will be a negative figure. ↩︎
-
The 'TenantCode', 'TenantCodeExt' and 'TenantName' fields are populated with information about the customer account the licence usage applies to. The 'TenantCodeExt' will be populated with the Reference number that has been configured against the customer. This can be updated as required to allow linking of customer records to external systems. ↩︎