Learn how to read daily-rated usage reconciliation files in Partner Center
Applies to: Partner Center | Partner Center for Microsoft Cloud for US Government
Appropriate roles: Admin agent | Billing admin | Sales agent | Helpdesk agent
This article explains how to read daily-rated usage reconciliation files.
Note
Generally, daily rated usage is available in the Partner Center or via API after 24 hours.
Fields in daily-rated usage reconciliation files
| Column | Description |
|---|---|
| PartnerId | Partner identifier in GUID format. |
| PartnerName | Partner name. |
| CustomerId | Unique Microsoft identifier for the customer in GUID format. |
| CustomerName | Customer's organization name as reported in Partner Center. This column is important for reconciling the invoice with your system information. |
| CustomerDomainName | The customer's domain name. |
| CustomerCountry | The country in which the customer is located. |
| MpnId | MPN identifier of the CSP partner. |
| Tier2MpnId | MPN identifier of the reseller of record for the subscription. |
| InvoiceNumber | Invoice number where the specified transaction appears. |
| ProductId | The identifier for the product. |
| SkuId | The identifier for a particular SKU. |
| AvailabilityId | The identifier for a particular SKU's availability. This column shows whether the SKU is available for purchase in the given country, currency, industry segment, etc. |
| SkuName | The title for a particular SKU. |
| ProductName | The name of the product. |
| PublisherName | The name of the publisher. |
| PublisherId | The identifier of the publisher in GUID format. |
| SubscriptionDescription | The name of the service offering purchased by the customer, as defined in the price list. (This column is an identical field to OfferName). |
| SubscriptionId | Unique identifier for a subscription in the Microsoft billing platform. Not used for reconciliation. This identifier isn't the same as the Subscription ID on the partner admin console. |
| ChargeStartDate | Start date of the charge cycle (except when presenting dates of previously uncharged latent usage data from the previous billing cycle). The time is always the beginning of the day, 0:00. |
| ChargeEndDate | End date of charge cycle (except when presenting dates of previously uncharged latent usage data from the previous billing cycle). The time is always the end of the day, 23:59. |
| UsageDate | Date of service usage. |
| MeterType | The type of meter. |
| MeterCategory | The top-level service for the usage. |
| MeterId | The identifier for the meter being used. |
| MeterSubCategory | The type of Azure service, which can affect the rate. |
| MeterName | The unit of measure for the meter being consumed. |
| MeterRegion | This column identifies the location of a data center within the region for services where MeterRegion is applicable and populated. |
| Unit | The unit of the resource Name. |
| ResourceLocation | The data center where the meter is running. |
| ConsumedService | The Azure platform service that you used. |
| ResourceGroup | Represents a container that holds related resources for an Azure solution. |
| ResourceURI | The URI of the resource being used. |
| ChargeType | The type of charge or adjustment. |
| UnitPrice | Price per license, as published in the price list at the time of purchase. Make sure this price matches the information stored in your billing system during reconciliation. |
| Quantity | Number of licenses. Make sure this price matches the information stored in your billing system during reconciliation. |
| UnitType | The type of unit the meter is charged in. |
| BillingPreTaxTotal | Total billing amount before taxes. |
| BillingCurrency | The currency in the customer's geographic region. |
| PricingPreTaxTotal | The pricing, before taxes are added. |
| PricingCurrency | The currency in the price list. |
| ServiceInfo1 | The number of Service Bus connections that were provisioned and used on a given day. |
| ServiceInfo2 | A legacy field that captures optional service-specific metadata. |
| Tags | Represents a logical organization of Azure resources set by the user. |
| AdditionalInfo | Any additional information not covered in other columns. |
| EffectiveUnitPrice | The actual value charged per unit, including any discounts, earned credit, and so on. |
| PCToBCExchangeRate | Exchange rate applied for pricing currency to billing currency. |
| PCToBCExchangeRateDate | The date on which the pricing currency to the billing currency is determined. |
| EntitlementId | Represents the Azure Subscription ID. |
| EntitlementDescription | Represents the name of the Azure Subscription ID. |
| PartnerEarnedCreditPercentage | Displays the PartnerEarnedCredit for the line item. Earned credit will be either 0 or 15 percent |
| CreditPercentage | Displays the Azure Consumption Credit. Earned credit will be either 0 or 100 percent. |
| CreditType | Type of the credit. For example, Azure Credit Applied. |