Credit memo item data mapping

Knowledge Center > Zuora RevPro > Zuora Billing - RevPro Integration overview > Mapping between Zuora Billing and RevPro > Introduction to standard field mapping > Credit memo item data mapping

Credit memo item data mapping

Table of contents
No headers

Zuora Billing - RevPro Integration is in Limited Availability

The Invoice Settlement feature is in Limited Availability. This feature includes Unapplied Payments, Credit and Debit Memo, and Invoice Item Settlement. If you want to have access to the feature, submit a request at Zuora Global Support

Some standard fields of credit memo items in Zuora Billing are mapped to RevPro Staging fields. The following table describes the pre-defined credit memo item field mappings between Zuora Billing and RevPro Staging tables.

The table columns represent the following information:

  • Zuora Billing Field: The standard fields extracted from Zuora Billing. It is displayed as the Input Value Label column in RevPro field mapping templates.
  • RevPro Staging Field Name: The user-friendly name for RevPro Staging fields.
  • Input Value Type: The data type of the field.
  • Description: Additional information on field mappings.
Zuora Billing Field RevPro Staging Field Name Input Value Type Description

Entity.DisplayName

 

Business Unit Character

This field is used to set application context for multiple organization customers in 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.

Entity.EntityName

 

 

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.AccountNumber Customer Number 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 Character

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

Account.Id Account Id Character This field is a unique ID for a customer account.

Entity.HomeCurrency

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.

Account.Currency Transaction Currency Character

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

RatePlan.Id Rate Plan Id Character The unique ID of a rate plan.
RatePlan.Name Rate Plan Name Character The name of a rate plan.
RatePlanCharge.ChargeNumber Rate Plan Charge Num Character A unique number that identifies the charge. 

RatePlanCharge.Name

 

Rate Plan Charge Name Character

The name of a rate plan charge.

RatePlanCharge.Version Rate Plan Charge Version Number This field is to identify the version of a rate plan charge.
RatePlanCharge.ChargeModel Rate Plan Charge Model Character This field determines how to evaluate charges. The value inherits from ProductRatePlanCharge.ChargeModel
RatePlanCharge.ChargeType Rate Plan Charge Type Character Specifies the type of charge. The value inherits from ProductRatePlanCharge.ChargeType.
RatePlanCharge.TriggerEvent Rate Plan Charge Trigger Event Character

Specifies when to start billing the customer for the charge. The value inherits from ProductRatePlanCharge.TriggerEvent and possible values include:

  • ContractEffective
  • ServiceActivation
  • CustomerAcceptance
RatePlanCharge.Segment Rate Plan Charge Segment Number The identifying number of the subscription rate plan segment. Segments are numbered sequentially, starting with 1. 
RatePlanCharge.Id Rate Plan Charge Id Character The unique ID to identify a rate plan charge.
RatePlanCharge.OriginalId Original Rate Plan Charge Id Character The original ID of the rate plan charge. 
Product.Id Product Id Character This field is the unique ID of a product from the Zuora Billing Product Catalog.
Subscription.TermStartDate Sales Order Date Date This field is used to derive the term start date from a subscription.
Subscription.Id Subscription ID Character The unique ID used to identify a subscription
Subscription.Name Subscription Name Character The name of a subscription
Subscription.Version Subscription Version Number The version of a subscription
Subscription. SubscriptionStartDate Subscription Start Date Date The date when the subscription term starts. This date is the same as the start date of the original term, which isn't necessarily the start date of the current or new term.
Subscription. SubscriptionEndDate Subscription End Date Date The date when the subscription term ends, where the subscription ends at midnight the day before. For example, if the SubscriptionEndDate is 12/31/2016, the subscriptions ends at midnight (00:00:00 hours) on 12/30/2016. This date is the same as the term end date or the cancelation date, as appropriate. 
Subscription.TermType Subscription Type Character

Possible values are:

  • TERMED
  • EVERGREEN
CreditMemoItem. ServiceStartDate
 
Revenue Start Date Date The start date of the service period associated with this credit memo item. If the associated charge is a one-time fee, then this date is the date of that charge.
CreditMemoItem. ServiceEndDate Revenue End Date Date The end date of the service period associated with this credit memo item. Service ends one second before the date in this value.
RatePlanCharge.Quantity Ordered Qty Number The default quantity of units, such as the number of authors in a hosted wiki service. Valid for all charge models except for Flat Fee pricing.
CreditMemoItem. AmountWithoutTax Ext Sell Price Number The amount being charged for the credit memo item without tax. 
ProductRatePlanCharge. ContractLiabilityAccountingCode.Name Deferred Segments Character The name of the accounting code for contract liability.
ProductRatePlanCharge. ContractRecognizedRevenueAccountingCode.Name Revenue Segments Character The name of the accounting code for the contract recognized revenue.
ProductRatePlanCharge. AdjustmentLiabilityAccountingCode.Name Adjustment Liability Account Character The name of the adjustment liability accounting code.
ProductRatePlanCharge. AdjustmentRevenueAccountingCode.Name Adjustment Revenue Account Character The name of the adjustment revenue accounting code.
ProductRatePlanCharge. UnbilledReceivablesAccountingCode.Name Unbilled AR Account Character The name of the unbilled receivables accounting code.
ProductRatePlanCharge. ContractAssetAccountingCode.Name Contract Asset Account Character The name of the contract asset accounting code.
ProductRatePlanCharge.Id
 
Product Rate Plan Charge Id Character The unique ID to identify a product rate plan charge.
ProductRatePlan.Id
 
Product Rate Plan Id Character The unique ID to identify a product rate plan.
RatePlanCharge.CreatedDate
 
Charge Created Date Date The date and time when the invoice item was created. 
RatePlanCharge.UpdatedDate
 
Charge Last Update Date Date The date and time when the invoice item was last updated. 
Invoice.Id Billing Id Character The unique ID of an invoice upon which the credit memo is created.
CreditMemoItem.Id Billing Item Id Character The unique ID of a credit memo item.

CreditMemo.MemoNumber

 

Invoice Num Character The number of a credit memo.

CreditMemo.MemoDate

 

Invoice Date Date This field is the date when the credit memo is created.

CreditMemoItem.Quantity

Invoice Qty Number This field is used to capture the number of quantity invoiced for the given credit memo line.
Last modified

Tags

This page has no custom tags.

Classifications

(not set)