Some standard fields of Zuora Billing can be mapped to the fields in RevPro staging tables for invoice item adjustments. The following tables list the standard fields of Zuora Billing that can and cannot be mapped to RevPro Invoice Item Adjustment staging fields as well as the RevPro staging fields that do not have corresponding fields in Zuora Billing.
The following table lists the mappings from invoice item adjustment fields in Zuora Billing to RevPro labels and staging fields.
The tax-related fields are not extracted from Zuora Billing as part of the Invoice Item Adjustment data extraction.
RatePlanCharge.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.
Sales Order Num Sales Order Number Character This field is used to identify a sales order or subscription.
Invoice Line Num IIA Line Num Character This value should be unique and is used to identify each line in an invoice item adjustment.
InvoiceItemAdjustment.Id Invoice Line ID IIA Id Character This value should be unique and is used to identify each line in an invoice item adjustment.
This field is used to establish the relationship between an invoice line and the original invoice line it got created from.
Invoice Num IIA Number Character This field identifies the Invoice Item Adjustment number.
Sales Rep Name SalesRep Name Character This field is used to capture the sales representative name for every transaction.
ProductRatePlanCharge. ContractLiabilityAccount Deferred Segments Deferred Revenue Segments Character This field is to create deferred revenue entries using these segments within RevPro.
Invoice.InvoiceDate 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.
InvoiceItem.Quantity Invoice Qty Adjustment Quantity Number This field is used to capture the quantity adjusted for the given invoice line.
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.
Subscription.Number Rc Line Atr54 Subscription Number Character This is used to capture the subscription number in Zuora Billing.
RatePlanChargeTier. PriceFormat Rc Line Atr52 Original Price Format Character For discount lines, it is the price format of the parent charge number.
InvoiceItemAdjustment.Type Rc Line Atr50 Adjustment Type Character This field is used to capture the type of an IIA.
Invoice.InvoiceNumber Rc Line Atr53 Invoice Number Character This is used to identify the number of an invoice where the IIA is related.
RatePlanCharge.BillingPeriod Not mapped Billing Period Character This field is used to identify the billing period of a rate plan charge.
InvoiceItemAdjustment. ReasonCode Not mapped Reason Code Character This field is used to identify the reason code of an invoice item adjustment.
This field is a unique identifier to track contracts in Zuora RevPro.
N/A Rc Line Atr58 Original Invoice Tran Type Character Rc Line Atr58 got frozen for future use.
N/A 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.