Skip to main content

Payment Field Mappings: NetSuite to Zuora Sync


Payment Field Mappings: NetSuite to Zuora Sync

This topic describes the mappings of the Payment information sync from NetSuite to Zuora.

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

Payment 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 Payment.IntegrationId__NS  
ZuoraCustomerID Payment.AccountId  
payment n/a The total amount. 
tranDate Payment.EffectiveDate  
applyList.amount Payment.Amount The sum of all applied invoice amounts. This field is required. 
n/a Payment.PaymentNumber This value is generated automatically. 
ZuoraReferenceID Payment.ReferenceId  
memo Payment.Comment PaymentMethodId  
n/a PaymentType "External"
n/a Payment.Status "Draft," then "Processed" when completed. 
n/a Payment.TransferredToAccounting "Yes" when completed. 
n/a Payment.SyncDate__NS The current timestamp. 
ZuoraOrigin n/a Update to "NETSUITE" when completed.
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.