Zuora Billing - RevPro Integration is in Limited Availability.
Some standard fields of subscriptions or amendments in Zuora Billing are mapped to RevPro Staging fields for sales order lines. The following table describes the pre-defined sales order field mappings between Zuora Billing and RevPro Staging tables.
Standard field mapping
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|
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.
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.
This field is a unique ID for a customer from the source that is used to track customer accounts in RevPro.
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.|
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.
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.|
|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:
|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.|
|ORIG_TERM_START_DATE||Sales Order Date||Date||
All fields available for mapping include:
See Sales order date mapping for more information.
|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 Owner||Character||The name of the account associated with a subscription.|
Possible values are:
|Amendment.Id||Amendment Id||Character||This field is the unique ID of an amendment.|
This field is used to identify the type of an amendment.
If the Orders feature is enabled in your Zuora tenant, the Amendment Type field in RevPro is not mapped from any Zuora Billing field.
|RatePlanCharge.EffectiveStartDate||Revenue Start Date||Date||The effective start date of the service period associated with a rate plan charge. If the associated charge is a one-time fee, then this date is the date of that charge.|
|RatePlanCharge.EffectiveEndDate||Revenue End Date||Date||The effective end date of the service period associated with a rate plan charge. 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.|
|ChargeContractualValueAllCharges.Elp||Ext List Price||Number||The extended list price of a sales order.|
|ChargeContractualValueAllCharges.Amount||Ext Sell Price||Number||The extended selling price of a sales order.|
|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.|
||Product Rate Plan Charge Id||Character||The unique ID to identify a product rate plan charge.|
||Product Rate Plan Id||Character||The unique ID to identify a product rate plan.|
||Charge Created Date||Date||The date and time when the invoice item was created.|
||Charge Last Update Date||Date||The date and time when the invoice item was last updated.|
Sales order date mapping
The sales order date for each SO line is used to determine in which accounting period an SO line is collected or processed in RevPro.
By default, the SO date for a booking transaction equals the term start date of the subscription of the earliest version. You can use one of the following fields to customize the mapping for Sales Order Date based on your business requirements:
- ORIG_TERM_START_DATE (default): RevPro determines the subscription of the version where the segment was initially created, and takes
Subscription.TermStartDateas the value.
- ORIG_CHG_CRT_DATE: RevPro determines the rate plan charge of the earliest version for a particular rate plan charge number, and takes
RatePlanCharge.CreatedDateas the value.
- ORIG_CHG_SEG_CRT_DATE: RevPro determines the rate plan charge of the earliest version where the segment was initially created, and takes
RatePlanCharge.CreatedDateas the value.
- AMENDMENT_CRT_DATE: The creation date of the amendment in Zuora Billing. RevPro takes
Amendment.CreatedDateas the value.
- Any other standard or custom Zuora date in the format of Object.Field.