Reconciliation file-UI fields mapping

 

The reconciliation file contains such fields.

  • Please check the screenshots on where these values are fetched from ,on the platform.

Field Name

Mapping to portal UI

Invoice number

AppXite Platform generated number per invoice receiver.

blobid0.png

Invoice Status

Invoice state. Three possible statuses: New, Verified, Processed.

mceclip0.png

Invoice date

Billing cycle i.e. date when invoices are generated.

mceclip1.png

Invoice provider

Entity issuing the invoice. Visible under main reseller profile under Select organizations.

Invoice receiver

Entity receiving the invoice.
There are 2 different scenarios:
1. either the end customer on Reseller platform.

2. reseller on Distributor platform.

mceclip2.png

Receiver status

Invoice receiver status in the platform. Three possible statuses: New, Active, Blocked.

mceclip3.png

Receiver ERP ID

Field available to enter customer ERP ID for invoice receiver in AppXite platform. Can be used for data mapping purposes.

mceclip4.png

Receiver country

Country of invoice receiver as defined for the organization under legal details.

mceclip5.png

Receiver VAT number

VAT number of invoice receiver as defined for the organization under legal details.

vat.png

Contract number

Field available to enter Contract number under Contract section in the Platform. Can be used for data mapping purposes.

mceclip7.png

Contract reference number

Field available to enter Contract reference number under Contract section in the Platform. Can be used for data mapping purposes.

2021-09-28_16_36_33-mceclip10.png

Reference contact person

Field available to enter Reference contact person under Contract section in the Platform.

mceclip9.png

Billing address

Invoice receiver billing address as defined for the organization under billing address. Important to maintain this field up to date as this field is used to issue invoices. 

mceclip8.png

Account manager

Account manager as defined for the organization under Contacts.

mceclip9.png

Account manager email

Account manager e-mail as defined for the organization under Contacts.

mceclip10.png

Comments

If the subscription was purchased outside of AppXite Platform but is synced from Vendor, this subscription will get a message "Created Automatically while synchronized", otherwise this field will be empty.

mceclip11.png

Reseller name

Entity part of the supply chain that is issuing the invoice to the end- customer.

Customer name

Entity that receives the final invoice.

mceclip12.png

Offer name

Offer name as available in the product catalog.

mceclip13.png

Subscription name

Purchased offer name. 

mceclip13.png

Subscription start date

Start date of subscription.

mceclip14.png

Subscription end date

End date of subscription.

mceclip15.png

Charge start date

Start date for charge calculation in this billing period. 

mceclip16.png

Charge end date

End date for charge calculation in this billing period. 

mceclip17.png

Charge type

Charge Type. As possible statuses: Cycle Fee, Purchase Fee, Usage Fee, Correction, One-Time.

mceclip12.png

Currency

Invoicing currency.

mceclip0.png

Customer Unit price

Unit price for a subscription for outgoing invoice to invoice receiver.

mceclip20.png

Customer quantity

Quantity for subscription for outgoing invoice to invoice receiver.

mceclip21.png

Customer total price

Total price for a subscription for outgoing invoice to invoice receiver.

mceclip22.png

Vendor

Vendor providing particular offer.

mceclip23.png

Reseller Unit Price

Unit price for a subscription for incoming invoice to invoice provider.

As a Disti , reseller unit price means in price for the distributor.

As a reseller, reseller price is my unit price.

Reseller Total Price

Quantity for subscription for incoming invoice to invoice provider.

As a Disti , reseller unit price means in price for the distributor.

As a reseller, reseller price is my unit price.

Reseller Currency

Total price for a subscription for incoming invoice to invoice provider. As a difference between Customer Price and Reseller Price can be calculated profitability of subscription, per customer, per reseller, or per vendor. 

mceclip1.png

Support Currency

Currency for Support Contract that can be used either for Channel Rebates management or additional fee for service provided that is linked to invoice amount.

Support Total Price

Total amount calculated in set currency for Support Contract and invoiced to invoice receiver.

Retail Price Source

Based on which price calculation is done: Vendor Retail Price or Reseller In Price

mceclip25.png

Retail Price Markup

The mark-up on retail price.

mceclip26.png

Customer Markup

Customer-specific markup

mceclip27.png

Price Markup Start Date

Date from which mark-up is effective.

mceclip28.png

Invoice Provider Id

AppXite Platform generated GUID number for Invoice Provider.

mceclip29.png

Invoice Receiver Id

AppXite Platform generated GUID number for Invoice Receiver

mceclip31.png

Reseller Id

AppXite Platform generated GUID number for Reseller

mceclip2.png

Customer Id

AppXite Platform generated GUID number for Customer (consuming the subscription)

mceclip3.png

Offer Id

AppXite Platform generated GUID number for Offer

mceclip4.png

Vendor Offer Id

Vendor generated GUID number for Offer (For every other vendor except Microsoft) Vendor Offer ID is the same as Offer ID generated by Platform

mceclip5.png

Subscription Id

Platform generated GUID number for provisioned Offer i.e. subscription

mceclip6.png

Vendor Subscription Id

Vendor generated GUID number for provisioned Offer i.e. subscription. For example for Microsoft this corresponds to SyndicationPartnerSubscriptionNumber.

mceclip7.png

Custom offer properties

Information regarding custom offer properties created via API

mceclip32.png

Buyer Purchase Order Number

Buyer Purchase Order number.

2021-09-28_16_36_33-mceclip10.png

Seller Purchase Order Number

Seller Purchase Order number (under construction on the platform)

 

Invoice Reference #

Unique invoice reference number across vendors and sellers

Was this article helpful?

0 out of 0 found this helpful

Add comment

Please sign in to leave a comment.