Invoice Item Adjustment Data Mapping

Knowledge Center > Zuora RevPro > Standard Fields Mapping > Invoice Item Adjustment Data Mapping

Invoice Item Adjustment Data Mapping

Standard Field Mapping

The following table lists the standard Invoice Item Adjustment fields mapping from Zuora to RevPro and describes where the corresponding Zuora fields derive from and the input value type.

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 RevPro labels to which Zuora fields are mapped to 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.Account Number Customer ID Customer Id Character

This field is a unique ID for a customer from the source that is used to track customer accounts in RevPro.

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.

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.

Account.Currency Tx Curr Transaction Currency Character

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

Home Currency Exchange Rate Global Ex Rate Global Currency Fx Rate Number

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

Rate Plan Charge.Name IIA Charge Name IIA Charge Name Character This field is used to uniquely identify the rate plan charge number where the IIA is applied.
Product.Name Product Line Product Line Character This field is used to capture the product name from Zuora Product Catalog.

Rate Plan Charge.Charge Number

 

Sales Order Line Num Sales Order Line Character

This is used to identify the subscription charge in RevPro.

The concatenated values of:

  • Order.Order Number
  • Rate Plan Charge.Charge Number
  • OrderAction.ID
  • OrderItem.ID
  • (Optional)Generated Reason
Sales Order Line ID Sales Order Line Id Character

This value should be unique and is used to identify each order line in a contract.

Order.Order Number

 

Sales Order Num Sales Order Number Character This field is used to identify a sales order or subscription.

Invoice Item Adjustment.ID

 

Invoice Line Num IIA Line Num Character This value should be unique and is used to identify each line in an invoice item adjustment.
Invoice Item Adjustment.ID Invoice Line ID IIA Id Character This value should be unique and is used to identify each line in an invoice item adjustment.

The concatenated values of:

  • Invoice Item.ID
  • Order Action.ID
  • Order Iterm.ID
  • (Optional) Generated Reason
Orig Inv Line ID Original Invoice Line ID Character

This field is used to establish the relationship between an invoice line and the original invoice line it got created from.

Invoice Item Adjustment.Adjustment Number

 

Invoice Num IIA Number Character This field identifies the Invoice Item Adjustment number.

Account.Sales Rep

Sales Rep Name SalesRep Name Character This field is used to capture the sales representative name for every transaction.

Invoice transaction type in Zuora. Possible values include:

  • INV
  • PRATE (Prorated)
  • CM-RO
Line Type Transaction Type Character

This is used to identify if the transaction is an Invoice, PRATE, or CM-RO in RevPro.

Product Rate Plan Charge. Contract Liability Account Deferred Segments Deferred Revenue Segments Character This field is to create deferred revenue entries using these segments within RevPro.
Product Rate Plan Charge. Recognized Revenue Account Revenue Segments Revenue Segments Character This field is to create revenue entries using these segments within RevPro.
Invoice.Invoice Date Invoice Date Adjustment Date Date This field is the invoice item adjustment date and it is used to collect data into RevPro based on the current open period in RevPro.
Invoice Item.Quantity Invoice Qty Adjustment Quantity Number This field is used to capture the quantity adjusted for the given invoice line.

Order.Order Date

 

Sales Order 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.
Derived from Zuora Ext List Price Extended List Price Number This value is used if SSP is percentage based on the list price.

Invoice Item.Breakdown Amount

 

Ext Sell Price Extended Selling Price Number

This field specifies an item amount of an invoice that is broken down by orders. You can get the amount by making a call to REST Get breakdown of invoice by order.

Invoice Item.Service Start Date

 

Revenue Start Date Revenue Start Date Date This is used to identify the date from which the Revenue Amortization to start.

Invoice Item.Service End Date

 

Revenue End Date Revenue End Date Date This is used to identify the date from which the Revenue Amortization to end.
Rate Plan Charge.Number Rc Line Atr56 Parent Charge Number Character

This field is used if a discount invoice item.

It indicates the original charge number that this discount is applied to.

Subscription.Number Rc Line Atr54 Subscription Number Character This is used to capture the subscription number in Zuora.
Rate Plan Charge.Charge Model Rc Line Atr51 Original Charge Model Character For discount lines, it is the charge model of the parent charge number.
Rate Plan Charge Tier. Price Format Rc Line Atr52 Original Price Format Character For discount lines, it is the price format of the parent charge number.
Product Rate Plan Charge.Adjustment Liability Adjustment Liability Account Adjustment Liability Account Character Adjustment Liability Account for the Product Rate Plan Charge
Product Rate Plan Charge.Adjustment Revenue Adjustment Revenue Account Adjustment Revenue Account Character Adjustment Revenue of the Product Rate Plan Charge
Invoice Item Adjustment.Type Rc Line Atr50 Adjustment Type Character This field is used to capture the type of an IIA.
Invoice.Invoice Number Rc Line Atr53 Invoice Number Character This is used to identify the number of an invoice where the IIA is related.

RevPro Staging Fields Unmapped to Zuora

This table lists the RevPro Staging fields that are not mapped to any particular Zuora field. Hence, the value for these fields is Null in the Zuora Field column.

Zuora Field Zuora RevPro Staging Field Input Value Label Input Value Type Description
Null Product Category Product Category Character This field is used to capture Sub-classifications of the products being sold by a customer.
Null Product Class Product Class Character This field is used to capture classifications of the products being sold by customer
Null Product Family Product Family Character This field is used to capture grouping of the products being sold by customer
Null SSP Eligible Flag SSP Eligible Flag Character This field is used to identify if the transaction needs to be included in SSP analyzer.
Null Right To Bill Flag Right To Bill Flag Character If this field is set to Y and revenue is recognized before billing, RevPro will consider the revenue as Contract Asset. If this field is set to N and revenue is recognized before billing, RevPro will consider the revenue as unbilled AR.
Null 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.
Null Rc Line Atr47 Contract Number Character

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

Null Ordered Qty Ordered Quantity Number The quantity of the Sales Order
Null LT Def Cogs Acct Long Term Deferred COGS Account Character The account number of the Long-term Deferred COGS account
Null Credit Rule Credit Rule Character The credit rule
Null Rc Line Atr58 Original Invoice Tran Type Character Rc Line Atr58 got frozen for future use.
Null Rc Line Atr55 Original Invoice uuid Character The Original Invoice Line Id derived from Zuora will be copied to this column during the transformation in RevPro.

Zuora Fields Unmapped to RevPro Staging

This table lists the Zuora fields that are not mapped in the Zuora RevPro by default. You can optionally map these fields to any available field in the RevPro Staging table, for example, map the Rate Plan Charge.Billing Period to the Rc Line Atr60 Staging Field. See Custom Fields Mapping for more information.

Zuora Field Zuora RevPro Staging Field Input Value Label Input Value Type Description
Rate Plan Charge.Billing Period Not mapped Billing Period Character This field is used to identify the billing period of a rate plan charge.
Invoice Item Adjustment. Reason Code Not mapped Reason Code Character This field is used to identify the reason code of an invoice item adjustment.
Last modified

Tags

Classifications

(not set)