Common Azure CSV Mappings

You are here:
  • KB Home
  • Common Azure CSV Mappings
< Back

To help you out we have listed a few of the common Azure CSV mappings we are aware of.

NOTE: These are a guide, you can also replace fields of your choosing with a field in your csv to display that relevant data on an invoice.

These are in the format of

<Our field name>: <CSV Field name>

Microsoft Direct Partner

This is the column layout to map with the Microsoft Direct Partner reconciliation file. (the one you download from the partner center).

  • Customer name: CustomerCompanyName
  • Service Name: ServiceName
  • Service Type: ServiceType
  • Resource Name: ResourceName
  • Cost: ListPrice
  • Quantity: ConsumedQuantity
  • Amount: PretaxCharges
  • Multiply Cost by Quantity: YES
  • Multiple Certain Fields: NO (These files do not have an RRP only cost price, so we can use the amount column to apply billing profiles)
  • UnitPrice
  • BillableQuantity
  • ExcludePCtoBCExchangeRate:
  • PCtoBCExchangeRate:

Microsoft Direct Partner – New Commerce Experience (Azure Plan)

This is the column layout to map with the Microsoft Direct Partner reconciliation file. (the one you download from the partner center).

  • Customer name: CustomerName
  • Service Name: ProductName
  • Service Type: SkuName
  • Resource Name: MeterDescription
  • Cost: SubTotal
  • Quantity: BillableQuantity
  • Amount: Total
  • Multiply Cost by Quantity: NO
  • Multiple Certain Fields: NO (if using Markup, YES if billing with a different base currency (i.e. CAD/USD)
  • UnitPrice: UnitPrice
  • BillableQuantity: BillableQuantity
  • ExcludePCtoBCExchangeRate: unticked
  • PCtoBCExchangeRate: PCToBCExchangeRate

Synnex Australia (possibly USA too?)

  • Customer name: Customer_company_Name
  • Service Name: AZU_ServiceName
  • Service Type: AZU_ServiceType
  • Resource Name: AZU_ResourceName
  • Cost: Price_EX
  • Quantity: Quantity
  • Amount: Amount_EX
  • Multiply Cost by Quantity: Yes
  • Multiple Certain Fields: NO if you would like to use your own markup, YES if you would like to use RRP
    • If YES
      UnitPrice: RRP_EXC
    • BillableQuantity: Quantity
    • ExcludePCtoBCExchangeRate: NO
    • PCtoBCExchangeRate: