Invoice Item Adjustment Data Mapping

Knowledge Center > Zuora RevPro > Zuora RevPro Integration Overview > DRAFT: Maintaining Transaction Upload Templates > Standard Data Mapping > Invoice Item Adjustment Data Mapping

Invoice Item Adjustment Data Mapping

Table of contents
No headers

The following table lists the mapping of Zuora fields to Zuora RevPro invoice item adjustment staging fields and describes where the corresponding Zuora fields derive from, the input value type, and the sequence. This is used for the mapping of the transactions/cost data in Zuora RevPro.

You can also map custom fields to Zuora RevPro, see Custom Fields in Data Mapping for more information.

The table columns represent the following information:

  • The Zuora Field column represents the fields defined in Zuora.
  • The Zuora RevPro Staging Field column represents the corresponding field names used in RevPro staging tables.
  • The Input Value Label column represents the corresponding label names used in the template and your upload file.
  • The Input Value Type column represents the field data types.
  • The Description column gives the description and note of the field mapping.
Zuora Field Zuora RevPro Staging Field Input Value Label Input Value Type Description

Tenant Name or Entity Display Name

 

Business Unit Business Unit Character

This field is used to set application context for multiple organization customers in Zuora RevPro.

This should be populated with the name of the tenant. If you have the Multi-entity feature enabled, it is populated with the entity display name.

Tenant Name or Entity Name

 

 

Company Code Company Code Character

In general, this field is used to identify inter-company transactions.

This should be populated with the name of the tenant. If you have the Multi-entity feature enabled, it is populated with the entity name.

Account Name

 

Customer Name Customer Name Character

This field is a unique ID for a customer from the source that is used to identify customer accounts by name in Zuora RevPro.

Not Available Contract Number Contract Number Character

This field is a unique identifier to track contracts in Zuora RevPro.

This should optionally be populated with any custom field from Zuora, which represents the contract number.

Home Currency

Func Curr Functional Currency Character

This field refers to the main currency used by Business unit.

If you have the Currency Conversion feature enabled, this is the home currency you set. If you do not have this feature enabled, this is the currency used in your invoices.

Home Currency Exchange Rate

 

Func Ex Rate Functional Currency Fx Rate Number

This field is used to derive amount in functional currency based on the transaction amount.

Home Currency Exchange Rate Global Ex Rate Global Currency Fx Rate Number This field is to derive amount in reporting currency (USD) from the Functional amount in RevPro.

Rate Plan Charge Name

Line Item Num IIA Charge Name Character

This field is used to uniquely identify a line item in an order.

Not Available Product Category Product Category Character This field is used to capture Subclassifications of the Products being sold by a customer.
Product Name Product Line Product Line Character This field is used to capture the product name from Zuora Product Catalog.
Invoice Item Id ORIG_INV_LINE_ID Original Invoice Line Id Character This field is used to capture the invoice item ID, which the invoice item adjustment is applied to
Invoice Item Adjustment Id Invoice Line Num IIA Line Num Character This field is an additional invoice item identifier under an invoice

The concatenated values of:

  • Invoice Item Adjustment Id
  • Order number
Invoice Line ID IIA Id Character This value should be unique and is used to identify each invoice line under an invoice.

Invoice Item Adjustment Number

Invoice Num IIA Number Character This is used to identify an invoice number and its corresponding items in RevPro.

Rate Plan Charge Number

SO Line Sales Order Line Character Leave this field blank.

The concatenated values of:

  • Order Number
  • Order Action ID
  • Rate Plan Charge Number
Sales Order Line ID Sales Order Line Id Character Leave this field blank.

Order Number

 

SO Num Sales Order Number Character Leave this field blank.
Account Currency Tx Curr Transaction Currency Character

This field is used to identify the transaction currency for every transaction in RevPro.

Not Available Tran Type Transaction Type Character

The value of this field in the upload file should be set as INV. This is used to identify if the transaction is a SalesOrder or Invoice in RevPro.

Valid values are: 

  • SO
  • INV
  • RORD
  • CM
  • CM-C
  • CM-RO
Contract Liability Account of the Product Rate Plan Charge Deferred Segments Deferred Revenue Segments Character This field is to create deferred revenue entries using these segments within RevPro.
Recognized Revenue Account of Product Rate Plan Charge Revenue Segments Revenue Segments Character This field is to create revenue entries using these segments within RevPro.
Not Available LT Def Cogs Acct Long Term Deferred COGS Account Character This field is used to capture Long Term Deferred COGS Account and is used when creating LT deferred cogs accounting entries.
Not Available Allocation Eligible Flag Allocation Eligible Flag Character The value of this field needs to be set to Y if the sales order line needs to participate in Allocation.

Order Date

 

SO Date Sales Order Date Date This field is used to derive SSP values or passed back to GL as the exchange rate date for SO level accounting entries.

Adjustment Date of Invoice Item Adjustment

 

Invoice Date Adjustment Date Date This field specifies the Invoiced Date. It is used to collect data into RevPro based on the current open period in RevPro.
Not Available Ext List Price Extended List Price Number This value is used if SSP is percentage based on list price.

Invoice Item Adjustment Breakdown Amount

 

Ext Sell Price Extended Selling Price Number

This field is used to contribute to the total revenue contract value and the amount that the customer is liable to pay.

The breakdown amount of an invoice item adjustment is calculated based on the proportion of breaking down the invoice item that the adjustment is associated with. The same proportion is used for calculating the breakdown amount of the invoice item adjustment.

Not Available Invoice Qty Adjustment Quantity Number

This field is used to capture the number of quantity invoiced for the given invoice line.

The default value of this field is 1.

Not Available Ordered Qty Ordered Qty Number Leave this field blank.
The start date of the service period associated with the invoice item. Revenue Start Date Revenue Start Date Date This is used to identify the date from which the Revenue Amortization to start.
The end date of the service period associated with the invoice item. Revenue End Date Revenue End Date Date This is used to identify the date from which the Revenue Amortization to end.
Not Available Credit Rule Credit Rule Character The default value of this field is F.
Subscription number Subscription Number Subscription Number Character This is used to capture the subscription number in Zuora.
Last modified

Tags

Classifications

(not set)