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

This section outlines the mappings for Payment sync from Zuora to NetSuite with Invoice Settlement enabled.

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 Zuora to NetSuite 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
Account.IntegrationId__NS	Customer	If the Payment is assigned to a customer, the record will be associated with that customer when synced to NetSuite. If the customer is “unassigned”, the internal ID supplied in the “Unassigned Payments” field from the Sync Preference settings will be used instead.
Payment.Amount	Payment Amount	Sum of applied invoice and debit memo payment amounts.
Payment.Comment	Memo
Payment.CreatedDate	Zuora Created Date
Payment.EffectiveDate	Date (tranDate)
n/a	Class	If not populated, map from NetSuite Connector preference NetSuite Default Class if populated. See NetSuite Classifications for more information.
n/a	Department	If not populated, map from NetSuite Connector preference NetSuite Default Class if populated. See NetSuite Classifications for more information.
n/a	Location	If not populated, map from NetSuite Connector preference NetSuite Default Class if populated. See NetSuite Classifications for more information.
PaymentMethod.Type	Payment Method	ACH, Cash, Check, CreditCard, Other, PayPal, WireTransfer, DebitCard, and CreditCardReferenceTransaction.
PaymentMethod.CreditCardType	Zuora Credit Card Type	Only populated if a specific electronic payment is used.
PaymentMethodSnapshot.Type	Payment Method	ACH, Cash, Check, CreditCard, Other, PayPal, WireTransfer, DebitCard, and CreditCardReferenceTransaction.
PaymentMethodSnapshot.CreditCardType	Zuora Credit Card Type	Only populated if a specific electronic payment is used.
Payment.Id	Zuora ID
n/a	Zuora Origin	”ZUORA”
Payment.ReferenceId	Zuora Payment Reference ID
Payment.PaymentNumber	Zuora Reference Number
n/a	Zuora Sync Date	Current timestamp
Invoice.IntegrationId__NS	ApplyTo.Invoice	NetSuite invoice reference
DebitMemo.IntegrationId__NS	ApplyTo.Invoice	NetSuite debit memo reference
PaymentPart.Amount	ApplyTo.Amount
Payment.IntegrationId__NS	Internal Id	Update Zuora after sync
Payment.IntegrationStatus__NS	n/a	Update Zuora after sync. See Integration Status and Error Recovery for more information.
Payment.SyncDate__NS	n/a	Update Zuora after sync. Uses the current timestamp.