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) | 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" |