Learn how to read new commerce invoice reconciliation files in Partner Center
Appropriate roles: Billing admin | Global admin | Admin agent | Sales agent
Using the recon file
This table explains and gives examples of the reconciliation file fields for new commerce transactions or billing event. See Use the reconciliation files.
Column | Description | Sample value |
---|---|---|
PartnerId | CSP (Cloud Solution Providers) partner identifier. | 0e195b37-4574-4539-bc42-0e539b9684c0 |
CustomerId | Customer identifier. | 196e2273-9651-43a3-ba7e-7cbcd918fc40 |
CustomerName | Customer's organization. | Johnny Modern Cust DE2 |
CustomerDomainName | Customer's domain name. | testcustomerdomain.onmicrosoft.com |
CustomerCountry | Customer's location. See the full list of countries/regions for your region. | DE |
InvoiceNumber | Invoice Number. | G002297372 |
MPNID | Microsoft partner identifier. | 6034453 |
ResellerMPNID | Reseller on record. | 6048879 |
OrderId | Internal order identifier. When you contact support, this ID can be helpful. | 0ET2qaZvJGfF9wgSKnWzR5JLmhp10lOc1, 6dc5c039750a |
OrderDate | UTC date of the transaction or billing event. | 10/3/2020 |
ProductId | Product identifier. | DZH318Z0BNZ5 |
SkuId | SKU identifier. | 006G |
AvailabilityId | Availability identifier. | DZH318Z08B80 |
SkuName | SKU name. | Tables - LRS |
ProductName | Product name. | Tables |
ChargeType | The type of charge or adjustment. | New |
UnitPrice | Price per unit or license, as listed in the price list in supported currencies for applicable countries/regions. | 0.045 |
Quantity | Units bought. Use BillableQuantity for reconciliation. | 1 |
Subtotal | Pretax cost. See details: Usage-based: ROUNDDOWN(ROUNDDOWN(EffectiveUnitPrice * BillableQuantity, 2) * PCToBCExchangeRate, 2) License or seat-based: ROUNDDOWN(EffectiveUnitPrice * PCToBCExchangeRate, 2) * BillableQuantity |
0.01 |
TaxTotal | Tax amount. Based on your market's tax rules and specific circumstances. | 0 |
Total | Total cost. Equal to the subtotal plus the tax amount. | 0.045 |
Currency | Billing currency. Your bill is generated in the context of the partner's billing currency. | EUR |
PriceAdjustmentDescription | Unit price adjustment reason. The value is text-based information that can be rearranged or presented in different formats while keeping the same meaning. | ["15.0% Partner earned credit for services managed"] |
PublisherName | Product publisher. | Microsoft |
PublisherId | Publisher identifier. | NA |
SubscriptionDescription | Service offering name, as defined in the price list. | Azure plan |
SubscriptionId | Subscription identifier. This identifier isn't the same as the Subscription ID on the partner admin console. | 307628f1-d9d2-f09c-ea1f-4183f0cae308 |
ChargeStartDate | Date when billing starts. | 9/1/2020 |
ChargeEndDate | Date when billing ends. It depends on the charge cycle, billing plan, and coterminosity. Learn more at How are one-time and recurring charges calculated. | 9/30/2020 |
TermAndBillingCycle | The duration of your subscription. 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 | Adjusted unit price. The unit price may vary because of discounts, adjustments, billable days, or other factors. | 0.03825 |
UnitType | Billable unit type. | 1 GB/Month |
AlternateId | Alternate order ID. | 6dc5c039750a |
BillableQuantity | Number of licenses, usage hours, or quantity. | 0.005001 |
BillingFrequency | Billing plan. Left blank for one-time payments and all unbilled billing line items. |
Monthly, Annual |
PricingCurrency | Currency for pricing. If the product is available in multiple currencies, the customer's local currency is used. | USD |
PCToBCExchangeRate | Exchange rate applied to convert pricing currency to billing currency. | 0.846202666 |
PCToBCExchangeRateDate | The date that is used to determine the exchange rate. | 9/30/2020 |
MeterDescription | Meter description. | Tables - LRS Data Stored (GB/Month) |
ReservationOrderId | Order ID for Azure reservation or savings plan. To calculate monthly costs from daily charges, see "Note." | 55eebd03-c6e7-4593-8ba8-0bb7c0b25e02 |
CreditReasonCode | Azure credit reason (not applicable to refunds). | Azure Credit, Sponsorship Credit, etc. |
SubscriptionStartDate | Date of purchase or renewal of a subscription. | 5/1/2021 |
SubscriptionEndDate | Date when the subscription ends or expires. | 4/30/2022 |
ReferenceID | Concurrent transactions identifier. | 025d68a6-1bd6-42ab-9636-15e8d776a30e |
ProductQualifiers | Purchase type identifier (add-on, a trial, or both). | ["Add-on"] |
PromotionID | Promotion identifier. | CFQ7TTC0LDPB:1:CFQ7TTC0GZQJ |
Next steps
Palaute
https://aka.ms/ContentUserFeedback.
Tulossa pian: Vuoden 2024 aikana poistamme asteittain GitHub Issuesin käytöstä sisällön palautemekanismina ja korvaamme sen uudella palautejärjestelmällä. Lisätietoja on täällä:Lähetä ja näytä palaute kohteelle