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 from which the item is being billed to | 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 reseller's extended reference for the customer | string |
| tenantname2 | The name of customer | string |
| resellercode3 | The reseller's tenant id | string |
| resellercodeext3 | The extended reference for the reseller | string |
| resellername3 | The name of the reseller | string |
| endcustomercode4 | The reseller's tenant id (deprecated) | string |
| endcustomercodeext4 | The extended reference for the reseller (deprecated) | string |
| endcustomername4 | The name of the reseller (deprecated) | 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,endcustomercode,endcustomercodeext,endcustomername,userid,username,resellercode,resellercodeext,resellername
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-000000000222,reseller ref 1,ABC Reseller,00000000-0000-0000-0000-000000000001,[[email protected]](mailto:[email protected]),00000000-0000-0000-0000-000000000222,reseller ref 1,ABC Reseller
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-000000000222,reseller ref 1,ABC Reseller,00000000-0000-0000-0000-000000000001,[[email protected]](mailto:[email protected]),00000000-0000-0000-0000-000000000222,reseller ref 1,ABC Reseller-
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 reseller's Reference number that has been configured against the reseller. ↩︎
-
The 'ResellerCode', 'ResellerCodeExt' and 'ResellerName' fields are populated with information about the reseller account the customer belongs to. The 'ResellerCodeExt' will be populated with the Reference number that has been configured against the reseller. This can be updated as required to allow linking of reseller records to external systems. ↩︎
-
These properties are deprecated and will be removed in a future release. ↩︎