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 |
Related content
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για