Knowledge Center

Knowledge Center > Commerce > Zuora 360 > Synchronize Data from Zuora > Zuora 360 Sync Objects Mapping > Sync Field Mapping of Subscription and Related Objects

Sync Field Mapping of Subscription and Related Objects

This article shows how the Zuora subscription and related objects and their fields are mapped and synchronized to Salesforce objects and fields in Zuora 360.

Each sync objects pair is marked as <Zuora object> : <Salesforce object>.

Any Zuora field marked as "internal" is a field that is not exposed in the Zuora SOAP API. However, these internal fields are synchronized between Zuora and Salesforce in Zuora 360. 

The descriptions of the "internal" sync fields are provided in this article. For the descriptions of the standard fields, refer to  SOAP API Objects.

​Subscription : Zuora__Subscription__c

Zuora Object Zuora Field Salesforce Object Salesforce Field Comments
Subscription Zuora__Subscription__c  
  AutoRenew   Zuora__AutoRenew__c  
  CancelledDate   Zuora__CancelledDate
__c
 
  ContractAcceptanceDate   Zuora__​
ContractAcceptanceDate
​__c
 
  ContractEffectiveDate   Zuora__​
ContractEffectiveDate__c
 
  CurrentTerm   Zuora__CurrentTerm__c

Supported in Zuora 360, Version 3.40+.

To use the field in Order Builder, use Zuora WSDL, Version 80+.

  CurrentTermPeriodType   Zuora__
CurrentTermPeriodType__c

Supported in Zuora 360, Version 3.40+.

To use the field in Order Builder, use Zuora WSDL, Version 80+.

  Id   Zuora__Zuora_Id__c  
  id   Zuora__External_Id__c
(External ID)
 
  InitialTerm   Zuora__InitialTerm__c  
  InitialTermPeriodType   Zuora__
InitialTermPeriodType__c

Supported in Zuora 360, Version 3.40+.

To use the field in Order Builder, use Zuora WSDL, Version 80+.

 

AccountId

  Zuora__InvoiceOwner__c  
  MRR (internal)   Zuora__MRR__c Monthly Recurring Revenue for this subscription
  Name   Name  
  NextChargeDate (internal)   Zuora__
NextChargeDate__c

An internal date when the charge is to be invoiced next.

The field is usually updated (in bulk) during the Bill Run process and is not synchronized for a performance reason.

If you want to sync this field in Real-time Sync and Turbo Sync, you need to have the tenant level setting turned on. 

Submit a request at Zuora Global Support to enable this feature or service.

If you execute a Bill Run with this setting enabled, you may experience degraded sync performance. 
See below for more information about the field.
  Notes   Zuora__Notes__c  
  OpportunityCloseDate
__QT
  Zuora__
OpportunityCloseDate__c
 
  OpportunityName__QT   Zuora__OpportunityName
​__c
 
  OriginalCreatedDate   Zuora__
OriginalCreatedDate__c
 
  OriginalId   Zuora__OriginalId__c  
  PreviousSubscriptionId   Zuora__
PreviousSubscriptionId__c
 
  QuoteBusinessType
__QT
  Zuora__
QuoteBusinessType__c
 
  QuoteNumber__QT   Zuora__QuoteNumber__c  
  QuoteType__QT   Zuora__QuoteType__c  
  RenewalTerm   Zuora__
RenewalTerm__c
 
  RenewalTermPeriodType   Zuora__
RenewalTermPeriodType__c

Supported in Zuora 360, Version 3.40+.

To use the field in Order Builder, use Zuora WSDL, Version 80+.

  SubscriptionEndDate   Zuora__​
SubscriptionEndDate__c
 
  SubscriptionStartDate   Zuora__
SubscriptionStartDate__c
 
  ServiceActivationDate   Zuora__​
ServiceActivationDate__c
 
  TCV (internal)   Zuora__TCV__c Total Contract Value of this subscription
  TermStartDate   Zuora__
TermStartDate__c
 
  TermEndDate   Zuora__
TermEndDateDate__c
 
  TermEndDate   Zuora__
NextRenewalDate__c
 
  TermType   Zuora__
TermSettingType__c
 
  Version   Zuora__Version__c  

NextChargeDate

The subscription's Next Charge Date is the rate plan charge's Invoice Through Date (Zuora API Name: RatePlanCharge.<wbr/>ChargedThroughDate) in Zuora. For example, if the charge was last invoiced from 05/01/2014 to 05/31/2014, the charge's Invoice Through Date and subscription's Next Charge Date would be 06/01/2014. If the subscription has multiple rate plan charges which have different billing periods, it would be the earliest Invoice Through Date of one the charges.

Account : Zuora__Subscription__c

Zuora Object Zuora Field Salesforce Object Salesforce Field Comments

Account (referenced through AccountId)

  Zuora__Subscription__c    
  CrmId   Zuora__Account__c A foreign key reference to Account
  Currency     CurrencyIsoCode

Product : Zuora__Product__c

Zuora Object Zuora Field Salesforce Object Salesforce Field

Product 

Zuora__Product__c
  Name   Name
  Id   Zuora__External_Id__c
  Description   Zuora__Description__c
  EffectiveEndDate   Zuora__EffectiveEndDate__c
  SKU   Zuora__SKU__c

RatePlan : Zuora__SubscriptionRatePlan__c

Zuora Object Zuora Field Salesforce Object Salesforce Field

RatePlan

Zuora__SubscriptionRatePlan__c
  AmendmentId   Zuora__AmendmentId__c
  AmendmentSubscriptionRatePlanId   Zuora__AmendmentSubscriptionRatePlanId
​__c
  AmendmentType   Zuora__AmendmentType__c
  Id   Zuora__External_Id__c
  Name   Name
  ProductRatePlanId   Zuora__ProductRatePlanId__c
  SubscriptionId   Zuora__Subscription__c

RatePlan : Zuora__SubscriptionProductFeature__c

To create features in product catalog and use them in subscriptions and Zuora Quotes, you need to enable the following:

Zuora Object Zuora Field Salesforce Object Salesforce Field
RatePlan
(referenced through SubscriptionProductFeature.RatePlanId)
Zuora__SubscriptionProductFeature__c
  Description   Zuora__RatePlanDescription__c
  EffectiveEndDate   Zuora__RatePlanEffectiveDate__c
  Name   Zuora__RatePlanName__c
  Id   Zuora__RatePlanZuoraId__c

RatePlanCharge : Zuora__UnitOfMeasure__c

Zuora Object Zuora Field Salesforce Object Salesforce Field Comments

RatePlanCharge 

Zuora__UnitOfMeasure__c
  UOM   Name Unit Of Measure

RatePlanCharge : Zuora__SubscriptionProductCharge__c

Zuora 
Object

Zuora Field Salesforce
Object
Salesforce Field Comments
RatePlanCharge Zuora__SubscriptionProductCharge__c  
  AccountingCode   Zuora__AccountingCode__c  
  ApplyDiscountTo   zuora__ApplyDiscountTo__c  
  BillCycleDay   Zuora__BillCycleDay__c  
  BillCycleType   Zuora__BillCycleType__c  
  BillingPeriod   Zuora__BillingPeriod__c  
  BillingPeriodAlignment   Zuora__
BillingPeriodAlignment__c
 
 

BillingPeriodStartDay 

(internal)

  Zuora__
BillingPeriodStartDay__c
Billing day of the charge. Same as BillCycleDay of the ProductRatePlanCharge object.
  ChargedThroughDate   Zuora__
ChargedThroughDate__c
 
  ChargeModel   Zuora__Model__c  
  ChargeNumber   Zuora__ChargeNumber__c  
  ChargeType   Zuora__Type__c  
 

ComplexTotal 

(internal)

  Zuora__ExtendedAmount__c

MRR*(number of months in a period)

For example:

For a quarterly charge with MRR=100, complexTotal =100 * 3 = 300.

  DiscountAmount   Zuora__DiscountAmount__c  
  DiscountLevel   Zuora__DiscountLevel__c  
  DiscountPercentage   Zuora__
DiscountPercentage__c
 
  Description   Zuora__Description__c  
  DMRC   Zuora__DMRC__c  
  DTCV   Zuora__DTCV__c  
  EffectiveEndDate   Zuora__EffectiveEndDate__c  
  EffectiveStartDate   Zuora__EffectiveStartDate__c  
  EndDateCondition   Zuora__EndDateCondition__c  
  Id   Zuora__Zuora_Id__c  
  id   Zuora__External_Id__c
(External ID)
 
  IncludedUnits   Zuora__IncludedUnits__c  
  IsLastSegment   Zuora__IsLastSegment__c  
  ListPriceBase   Zuora__ListPriceBase__c  
  MRR   Zuora__
MonthlyRecurringRevenue__c
 
  Name   Name  
  NumberOfPeriods   Zuora__NumberOfPeriods__c  
  OriginalId   Zuora__OriginalId__c  
  OverageCalculationOption   Zuora__
OverageCalculationOption__c
 
  OveragePrice   Zuora__OveragePrice__c  
  OverageUnusedUnitsCreditOption   Zuora__
OverageUnusedUnits
​CreditOption
__c
 
  Price   Zuora__Price__c  
  PriceIncreasePercentage   Zuora__
PriceIncreasePercentage
__c
 
  ProcessedThroughDate   Zuora__
ProcessedThroughDate__c
 
  ProductRatePlanChargeId   Zuora__
ProductRatePlanChargeId
__c
 
  Quantity   Zuora__Quantity__c  
  RatePlanId   Zuora__RatePlanId__c  
  RevRecCode   Zuora__RevRecCode__c  
  RevRecTriggerCondition   Zuora__
RevRecTriggerCondition
​__c
 
  Segment   Zuora__Segment__c  
  SpecificBillingPeriod   Zuora__SpecificEndDate__c  
  TCV   Zuora__
TotalContractValue__c
 
  TriggerDate   Zuora__TriggerDate__c  
  TriggerEvent   Zuora__TriggerEvent__c  
  UnusedUnitsCreditRates   Zuora__
UnusedUnitsCreditRates
​__c
 
  UOM   Zuora__UOM__c  
  UOM   Zuora__PriceTable__c Calculated from the related RatePlanChargeTier objects
  UpToPeriods   Zuora__UpToPeriods__c  
  UpToPeriodsType   Zuora__UpToPeriodsType__c  
  UsageRecordRatingOption   Zuora__
UsageRecordRatingOption__c
 
  UseDiscountSpecificAccountingCode   Zuora__
UseDiscountSpecific
​AccountingCode__c
 
  Version   Zuora__Version__c  
  WeeklyBillCycleDay   Zuora__WeeklyBillCycleDay__c  

RatePlanChargeTier : Zuora__SubscriptionRatePlanChargeTier__c

This feature is in Controlled ReleaseSubmit a request at Zuora Global Support to get this feature enabled for your tenant.

Zuora Object Zuora Field Salesforce Object Salesforce Field
RatePlanChargeTier Zuora__SubscriptionRatePlanChargeTier__c
  EndingUnit   Zuora__EndingUnit__c
  Id   Zuora__External_Id__c
  IsOveragePrice   Zuora__IsOveragePrice__c
  Price   Zuora__Price__c
  PriceFormat   Zuora__PriceFormat__c
  RatePlanChargeId   Zuora__SubscriptionRatePlanCharge__c
  StartingUnit   Zuora__StartingUnit__c
  Tier   Zuora__Tier__c

Product : Zuora__SubscriptionProductCharge__c

Zuora Object Zuora Field Salesforce Object Salesforce Field
Product 
(referenced through ProductRatePlanChargeId.ProductRatePlanId.ProductId)
Zuora__SubscriptionProductCharge__c
  Description   Zuora__Description__c
  Name   Zuora__ProductName__c
  SKU   Zuora__ProductSKU__c
  EffectiveEndDate   Zuora__ProductEffectiveEndDate__c

ProductRatePlan : Zuora__SubscriptionProductCharge__c

Zuora Object Zuora Field Salesforce Object Salesforce Field
ProductRatePlan 
(referenced through ProductRatePlanChargeId.ProductRatePlanId)
Zuora__SubscriptionProductCharge__c
  Description   Zuora__Description__c
  Name   Zuora__​RatePlanName__c
  SKU   Zuora__ProductSKU__c
  EffectiveEndDate   Zuora__RatePlanEffectiveEndDate__c

SubscriptionProductFeature : Zuora__SubscriptionProductFeature__c

To create features in product catalog and use them in subscriptions and Zuora Quotes, you need to enable the following:

Zuora Object Zuora Field Salesforce Object Salesforce Field Comments
SubscriptionProductFeature Zuora__SubscriptionProductFeature__c  
  Id   Zuora__External_Id__c  
  Name   Name The feature name. Up to 80 characters are supported.
  Description   Zuora__FeatureDescription__c  
  Name   Zuora__FeatureName__c The full name of the feature

Feature : Zuora__SubscriptionProductFeature__c

To create features in product catalog and use them in subscriptions and Zuora Quotes, you need to enable the following:

Zuora Object Zuora Field Salesforce Object Salesforce Field

Feature (referenced through SubscriptionProductFeature.FeatureId)

Zuora__SubscriptionProductFeature__c
  Code   Zuora__FeatureCode__c

Product : Zuora__SubscriptionProductFeature__c

To create features in product catalog and use them in subscriptions and Zuora Quotes, you need to enable the following:

Zuora Object Zuora Field Salesforce Object Salesforce Field
Product 
(referenced through SubscriptionProductFeature.RatePlanId, RatePlan.ProductRatePlanId, and ProductRatePlan.ProductId)
Zuora__SubscriptionProductFeature__c
  Description   Zuora__ProductDescription__c
  EffectiveEndDate   Zuora__ProductEffectiveEndDate__c
  SKU   Zuora__ProductSKU__c
  Id   Zuora__ProductZuoraId__c
  Name   Zuora__ProductName__c

Subscription : Zuora__SubscriptionProductFeature__c

To create features in product catalog and use them in subscriptions and Zuora Quotes, you need to enable the following:

Zuora Object Zuora Field Salesforce Object Salesforce Field Comments
Subscription
(referenced through
SubscriptionProductFeature.RatePlanId and RatePlan.SubscriptionId)
Zuora__SubscriptionProductFeature__c  
  Id   Zuora__Subscription__c Holds a look-up relationship to Subscription.
Last modified
13:06, 7 Nov 2016

Tags

Classifications

(not set)