Payment Field Mappings: NetSuite to Zuora Sync (Invoice Settlement Enabled)

This section outlines the mappings for Payment sync from NetSuite to Zuora with Invoice Settlement enabled, highlighting potential differences in Source and Destination field associations.

This feature is currently in development and is subject to change without advance notice. We are actively soliciting feedback from a small set of early adopters.

This reference describes the mappings of the Payment sync from NetSuite to Zuora when Invoice Settlement is enabled for your Zuora tenant.

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

Payment Field 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	Notes
n/a	Payment.PaymentNumber	This value is generated automatically.
Internal Id	IntegrationId__NS
CustomerPayment.Zuora_Customer_ID_Payments	Payment.AccountId
CustomerPayment.payment	Payment.Amount
ApplyTo.Amount	DebitMemo.Amount AND/OR Invoice.Amount
ApplyTo.Doc	DebitMemo.IntegrationId__NS AND/OR Invoice.IntegrationId__NS
CustomerPayment.memo	Payment.Comment
CustomerPayment.tranId	Transaction__NS
CustomerPayment.Zuora_Payment_Reference_ID	Payment.ReferenceId
paymentMethod.name	Payment.PaymentMethodId
n/a	Payment.TransferredToAccounting	“Yes” when completed.
n/a	Payment.Type	“External”
n/a	Payment.SyncDate__NS	The current timestamp.
Zuora Origin	n/a	Update to “NETSUITE” when completed.
Zuora ID	n/a	Update with the new Zuora ID when completed.
Zuora Sync Date	n/a	Update with the current timestamp when completed.
Zuora Integration Status	n/a	Update with “Sync Complete” when completed, and update with other statuses while processing.