แชร์ผ่าน


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: Billing admin | Admin agent | Sales agent

This article explains how to read daily rated usage reconciliation files.

Note

You can access your unbilled daily rated usage line items through the API or Partner Center portal. To ensure accurate data, allow up to 24 hours for availability. Depending on your location and when the meters report the usage, there might be further delays.

We prioritize on time delivery of billed daily rated usage data first. Occasionally, you might not see the most recent unbilled daily rated usage data until the previous month's billed usage data is available. Once you receive the billed usage data, you can then retrieve all the updated unbilled usage data from the start of the month.

Your understanding and patience are appreciated as we strive to provide the most accurate and timely information possible.

Note

These charges aren't included in the daily rated usage data:

  • Azure reservation
  • Azure savings plan
  • Office
  • Dynamics
  • Microsoft Power Apps
  • Perpetual software
  • Software subscription
  • Non-Microsoft or marketplace SaaS product

Fields in daily rated usage reconciliation file

Column Description Sample value
PartnerId Partner's Microsoft Entra ID—a unique identifier for Cloud Solution Provider program (CSP) partners. 0e195b37-4574-4539-bc42-0e539b9684c0
PartnerName Partner name. Fabrikam
CustomerId Customer's Microsoft Entra ID—a unique identifier for customers. 196e2273-9651-43a3-ba7e-7cbcd918fc40
CustomerName Customer's company name. Contoso
CustomerDomainName Domain name within the customer company using the product. testcustomerdomain.onmicrosoft.com
CustomerCountry Customer's country or region. See the full list of countries/regions for your country/region. US
MpnId Microsoft partner identifier. 12345
Tier2MpnId Identifier of the reseller on record. This field is optional in the unbilled usage data. 67890
InvoiceNumber Invoice number—a unique identifier for the invoice. G002297372
ProductId Product identifier. DZH318Z0BNZ5
SkuId Stock-keeping unit (SKU) identifier. 006G
AvailabilityId Availability identifier DZH318Z08B80
SkuName Name of the stock-keeping unit (SKU). Tables
ProductName Name of the product. Tables
PublisherName Name of the publisher. Microsoft
PublisherId A unique identifier of the publisher.
SubscriptionDescription Service offering name. (Identical to OfferName). Azure plan
SubscriptionId A unique identifier used in Microsoft's billing system, typically indicating the Azure plan ID for pay-as-you-go resources. aaaa0a0a-bb1b-cc2c-dd3d-eeeeee4e4e4e
ChargeStartDate Billing start date in a specific billing period. 9/1/2020
ChargeEndDate Billing end date in a specific billing period. This date doesn't influence the charges, as they’re calculated based on the Usage Date. 9/30/2020
UsageDate You used or consumed the service on this date. 9/21/2020
MeterType Type of the meter. 1 Disk/Month
MeterCategory Top-level service for the usage. Storage
MeterId A unique identifier of the meter. b9e5e77c-a0b3-4a2c-9b8b-57fa54f31c52
MeterSubCategory Azure service type. Tables
MeterName Name of the meter. Read Operations
MeterRegion The location of the data center in the region.
Unit Unit to determine the charge amount. 10K
ResourceLocation Data center where the meter is running. eastus
ConsumedService Azure platform service used. Microsoft.Storage
ResourceGroup Resource container. TestRG
ResourceURI URI of the resource. /subscriptions/bbbb1b1b-cc2c-dd3d-ee4e-ffffff5f5f5f/resourceGroups/TestRG/providers /Microsoft.Storage/storageAccounts /customerstorage0207
ChargeType Type of charge or credit. New
UnitPrice Cost of each unit in the price list at the time of purchase. 0.00036
Quantity Number of billed units. 3.0146
UnitType Unit used for billing.
BillingPreTaxTotal Cost in the billing currency after PEC deduction but before tax. 1.0000044676
BillingCurrency Partner's billing/invoice currency. USD
PricingPreTaxTotal The cost in the pricing currency before tax. 1.0000044676
PricingCurrency Currency in the price list. Azure plan products are only priced in USD. USD
ServiceInfo1 Number of Service Bus connections.
ServiceInfo2 Legacy field for service-specific metadata.
Tags User-defined logical structuring of Azure resources.
AdditionalInfo Additional information.
EffectiveUnitPrice Adjusted unit price after discounts or credits. 0.000306
PCToBCExchangeRate Exchange rate used for converting the cost from pricing currency to billing currency. 1.0
PCToBCExchangeRateDate Date when the the exchange rate is calculated. 9/30/2020
EntitlementId Azure subscription identifier (ID). 55eebd03-c6e7-4593-8ba8-0bb7c0b25e02
EntitlementDescription Azure subscription name. Demo subscription
PartnerEarnedCreditPercentage Partner earned credit (PEC) percentage. Either 0 or 15 percent. 15
CreditPercentage Percentage of charges covered by the credit. 15
CreditType Type of credit used for the usage. Partner Earned Credit Applied
BenefitOrderId A unique identifier for Azure savings plan, similar to the reservation order ID for Azure reservations. This field is optional for other products. bbbb1b1b-cc2c-dd3d-ee4e-ffffff5f5f5f
BenefitId A unique identifier for each Azure savings plan. This field is optional for other products. 427c1f90-dcd8-4779-a007-4e54fb4e7640
BenefitType An identifier indicating if this usage is covered by an Azure savings plan or subject to pay-as-you-go charges. SavingsPlan