CSP Data Tables

Overview

Purchases generated by the CSP connector contain purchase metadata specific to CSP usage. CloudBilling retrieves this information from Microsoft’s Billing APIs. The LineItems associated with these purchases retain the metadata. Since most metadata fields have string type values, they are stored in separate tables in the dataset to improve storage and performance efficiency. Each table is linked to a LineItem using its primary key. For further information on the fields listed in the below tables, refer to Microsoft’s documentation on invoice reconciliation and daily rated usage files.

• CspInstances
• CspOrders
• CspProducts
• CspResourceGroups
• CspSubscriptions

---

CspInstances

CSP Reserved Instances help you save money by committing to one-year or three-year plans for multiple Azure Plan products. The commitment allows you to get a discount on the resource you use. All CSP Reserved Instance purchases contain reservation details as purchase metadata. The following table contains these details. Combining this table with the LineItems table will provide the reservation details associated with a LineItem.

Name	Type	Description
Key	Integer	Primary Key - CspInstances Table.
InstanceName	String	Azure Plan Instance Name.
InstanceType	String	Azure Plan Instance Type.
CustomerCode	String	The customer code in CloudBilling.

CspOrders

All CSP purchases have an order ID which is Microsoft’s internal order identifier. This information is present in the CspOrders table. Combine this table with the LineItems table to find the OrderId of the CSP purchase that generated a LineItem. If you identify any anomalies in the CSP LineItem(s), and want to investigate it further with Microsoft, the OrderId is helpful when you contact Microsoft’s support services.

Name	Type	Description
Key	Integer	Primary Key - CspOrders Table.
OrderId	String	A unique order id.
EffectiveStart	Integer	Foreign Key - DateDimension Table. Order start date (yyyymmdd).
CustomerCode	String	The customer code in CloudBilling.

CspProducts

CSP purchases also contain product-related information as purchase metadata. The CspProducts table contains this information. Joining this table with the LineItems table will provide product details associated with a LineItem.

Name	Type	Description
Key	Integer	Primary Key - CspProducts Table.
MeteredRegion	String	The location of the data center in the region.
MeteredService	String	Service description.
MeteredServiceType	String	How service usage is measured.
MeterId	String	A unique identifier of the meter.
MeterName	String	Name of the meter.
AzureCategory	String	Top-level service for the usage.
AzureSubCategory	String	Azure service type.

CspResourceGroups

A resource group is a container that holds related resources for an Azure solution. Resource groups can help coordinate changes between related resources such as deploying, updating, and deleting them together. Users decide which resources belong in a resource group. For further information on what these groups are and how to configure them, refer to Microsoft’s documentation on Resource Groups. Joining this table with the LineItems table will provide information on the associated resource group name and customer code in CloudBilling.

Name	Type	Description
Key	Integer	Primary Key - CspResourceGroups Table.
ResourceGroup	String	Resource container.
CustomerCode	String	Customer Code in CloudBilling

CspSubscriptions

A subscription is an agreement you have with Microsoft to use one or more Microsoft cloud platforms or services. The charges for these subscriptions can be either a per-user licence fee or on pay-per resource consumption. For example, Microsoft 365 is charged per-user licence, and Azure Virtual Network is charged per-usage. Organisations can have multiple subscriptions. The CspSubscriptions table contains information related to these subscriptions. Joining this with the LineItems table shows which Subscription a LineItem belongs to.

Name	Type	Description
Key	Integer	Primary Key - CspSubscriptions Table.
SubscriptionId	String	A unique identifier used in Microsoft’s billing system.
SubscriptionName	String	Service offering name.
CustomerCode	String	Customer Code in CloudBilling.