CSP one-time purchase reconciliation file fields
Appropriate roles: Account admin | Billing agent
Using the recon file
The table below gives descriptions and sample values for the fields in the reconciliation file for CSP one-time purchases.
For more information on reconciliation files, see Use the reconciliation files.
| Column | Description | Sample value |
|---|---|---|
| PartnerId | Unique identifier in GUID format for a specific billing entity. Not required for reconciliation. Same in all rows. | 0e195b37-4574-4539-bc42-0e539b9684c0 |
| CustomerId | Unique Microsoft identifier for the customer in GUID format. | 196e2273-9651-43a3-ba7e-7cbcd918fc40 |
| CustomerName | Customer's organization name as reported in Partner Center. This column is important for reconciling the invoice with your system information. | Johnny Modern Cust DE2 |
| CustomerDomainName | Customer’s domain name. | testcustomerdomain.onmicrosoft.com |
| CustomerCountry | The country where your customer is located. See the full list of countries for your region. | DE |
| InvoiceNumber | The invoice number associated with the reconciliation file. | G002297372 |
| MpnId | MPN identifier of the CSP partner. For more information, see how to itemize by partner. | 6034453 |
| ResellerMpnId | MPN identifier of the reseller of record for the subscription. | 6048879 |
| OrderId | Unique identifier for an order in the Microsoft billing platform. May be useful to identify the order when contacting support. Not used for reconciliation. | 0ET2qaZvJGfF9wgSKnWzR5JLmhp10lOc1, 6dc5c039750a |
| OrderDate | Date in UTC the order was placed. | 10/3/2020 |
| ProductId | The product's unique identifier. | DZH318Z0BNZ5 |
| SkuId | The SKU unique identifier. | 006G |
| AvailabilityId | The availability unique identifier. | DZH318Z08B80 |
| SkuName | The SKU name. | Tables - LRS |
| ProductName | The product name. | Tables |
| ChargeType | The type of charge or adjustment. | New |
| UnitPrice | Price per unit or license, as published in the price list at the purchase time. For the applicable countries/regions, the unit price may be displayed in different supported currencies. During reconciliation, ensure that this corresponds to the information maintained in your billing system. | 0.045 |
| Quantity | The number of licenses. Be sure this matches the information stored in your billing system during reconciliation. | 1 |
| Subtotal | Total before tax. The subtotal should equal the effective unit price multiplied by the exchange rate and billable quantity. The order of multiplication is different for usage and license-based products. See the following: Usage-based: ROUNDDOWN(ROUNDDOWN(EffectiveUnitPrice * BillableQuantity,2) * PCToBCExchangeRate, 2) License or seat-based: ROUNDDOWN(EffectiveUnitPrice * PCToBCExchangeRate,2) * BillableQuantity |
0.01 |
| TaxTotal | Tax amount charge. Based on your market's tax rules and specific circumstances. | 0 |
| Total | The total amount is equal to the subtotal plus the tax amount. | 0.045 |
| Currency | The invoice’s billing currency. Your bill is generated in the context of the partner’s billing currency. | EUR |
| PriceAdjustmentDescription | The reasons for the adjustments in the unit price. These are the main reasons, but not limited to determining the effective unit price. | ["15.0% Partner earned credit for services managed"] |
| PublisherName | Publisher of the product. | Microsoft |
| PublisherId | A unique identifier the Partner Center uses to identify the publisher. | NA |
| 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. | Azure plan |
| 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. | 307628f1-d9d2-f09c-ea1f-4183f0cae308 |
| ChargeStartDate | The subscription’s billing start date in a billing period. It starts from the purchase date and repeats on the same day every month or every year according to the billing plan. | 9/1/2020 |
| ChargeEndDate | The subscription’s billing end date in a billing period. The billing plan determines this. For more information, see How monthly term subscriptions expire. | 9/30/2020 |
| TermAndBillingCycle | The duration commitment to continue the subscription at the time of purchase. For more information, see How do I find the billing term in a reconciliation file?. | Data Stored (GB/Month), One-Year commitment for monthly/yearly billing |
| EffectiveUnitPrice | The prorated unit price to calculate the cost for the charge cycle. Discounts, adjustments in billing days, and other factors determine the effective unit price. For more information, see Effective Unit Price Calculation. | 0.03825 |
| UnitType | The type of unit in which the meter is charged. | 1 GB/Month |
| AlternateId | The alternate ID of the referenced order line item. | 6dc5c039750a |
| BillableQuantity | The total quantity being billed. | 0.005001 |
| BillingFrequency | The billing plan selected at the time of purchase. One-time payments and all unbilled transactions have no billing plans. |
Monthly, Annual |
| PricingCurrency | The unit price’s currency. If the customer is from a different location than the partner, the currency is most likely the customer’s location currency. Otherwise, it should be the same as the billing currency. | USD |
| PCToBCExchangeRate | The exchange rate applied for pricing currency to billing currency. | 0.846202666 |
| PCToBCExchangeRateDate | The date on which the pricing currency to the billing currency is determined. | 9/30/2020 |
| MeterDescription | Meter description. | Tables - LRS Data Stored (GB/Month) |
| ReservationOrderId | The Reservation Order ID. | E21A6344E398FFC1C4D7... |
| CreditReasonCode | The reason why the credit is given. | Azure Credit Offer |
| SubscriptionStartDate | The date when a subscription is purchased. | 5/1/2021 |
| SubscriptionEndDate | The date when a subscription expires. | 4/30/2022 |
| ReferenceID | The linkage to transactions that occur concurrently with a user event. | 025d68a6-1bd6-42ab-9636-15e8d776a30e |
| ProductQualifiers | The identifier to know Add-on or Trial purchases. | ["Add-on"] |
| PromotionID | The identifier to use to fetch the promotion’s information. | CFQ7TTC0LDPB:1:CFQ7TTC0GZQJ |
Note
You can reconcile your Azure consumption in your one-time purchase recon file. To do this, go to your daily-rated usage recon file and search for your SubscriptionID. This will display all costs associated with your Azure plan ID. Your Azure SubscriptionID is shown as the EntitlementID.