Sales Order Field Mappings: NetSuite to Zuora Sync
This section outlines the mappings for syncing Sales Order information from NetSuite to Zuora, highlighting cases where fields are linked to different objects.
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) |
Notes |
|---|---|---|
|
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" |