Payment Field Mappings: NetSuite to Zuora Sync

This topic covers the mappings of Payment information during the sync process from NetSuite to Zuora, including cases where Source and Destination fields are linked to different objects.

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)	Notes
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
paymentMethod.name	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.