Skip to main content

Sales Order Field Mappings: NetSuite to Zuora Sync


Sales Order Field Mappings: NetSuite to Zuora Sync

This article describes the mappings of the Sales Order information sync from NetSuite to Zuora.

In some cases, the Source and Destination fields are associated with different objects.

Sales Order Mappings

The Destination column lists the default names for the fields in NetSuite. Your fields may have been modified from the default values.

Source Field Destination Field
(Invoice Payment)
internalId n/a  
tranDate n/a  
tranId Subscription.SalesOrder__NS  
ZuoraCustomerIdSales Account.Id  
currencyName Subscription.Currency This field is required. 
ZuoraSubscriptionNumber Subscription.Name  
ZuoraTermStartDate Subscription.TermStartDate Date
ZuoraAutoRenew Subscription.AutoRenew This is a boolean value (Yes, No). This field is required.
ZuoraInitialTerm Subscription.IntialTerm This field is required. 
ZuoraRenewalTerm Subscription.RenewalTerm This field is required. 
ZuoraContractEffectiveDate Subscription.ContractEffectiveDate  
ZuoraServiceActivationDate n/a  
ZuoraCustomerAcceptanceDate Subscription.ContractAcceptanceDate  
ZuoraTermSetting Subscription.TermType TERMED, EVERGREEN
ZuoraSendToZuora n/a This is a boolean value (Yes, No). 
item.ZuoraItemId RatePlanData.ProductRatePlanId  
ZuoraId n/a Update with the new Zuora ID when completed. 
ZuoraSyncDate n/a Update with the current timestamp when completed. 
ZuoraIntegrationStatus n/a Update with "Sync Complete" when completed, and update with other statuses while processing. 
ZuoraReferenceNumber n/a Update with the new Zuora subscription number when completed. 
n/a SubscribeOptions.GenerateInvoices "false"