Skip to navigation

Invoice Payment Field Mappings: Zuora to NetSuite Sync

View as Markdown

This reference details the mappings for syncing invoice payment information from Zuora to NetSuite, highlighting that payments can be applied to multiple invoices.

In some cases, the Source and Destination fields are associated with different objects. Note that a payment may be applied to more than one invoice.

Zuora Payment

Source FieldDestination Field (Customer Payment)Notes
Account.IntegrationId__NSCustomerNetSuite Customer reference
InvoicePayment.AmountPayment AmountSum of applied invoice payment amounts. Note that “over payments” are not synced.
Payment.CommentMemo
Payment.CreatedDateZuora Created Date
Payment.EffectiveDateDate (tranDate)
Account.Class__NSClassIf not populated, map from NetSuite Connector preference NetSuite Default Class if populated. See NetSuite Classifications for more information.
Account.Department__NSDepartmentIf not populated, map from NetSuite Connector preference NetSuite Default Department if populated. See NetSuite Classifications for more information.
Account.Location__NSLocationIf not populated, map from NetSuite Connector preference NetSuite Default Location if populated. See NetSuite Classifications for more information.
PaymentMethod.TypePayment MethodACH, Cash, Check, CreditCard, Other, PayPal, WireTransfer, DebitCard, CreditCardReferenceTransaction.
Payment.IdZuora ID
Payment.PaymentNumberZuora Reference Number
Payment.ReferenceIdZuora Payment Reference ID
Payment.TypeZuora Payment Type
Payment.IntegrationId__NSInternal IdUpdate Zuora after sync
Payment.IntegrationStatus__NSn/aUpdate Zuora after sync. See Integration Status and Error Recovery for more information.
Payment.SyncDate__NSn/aUpdate Zuora after sync. Uses the current timestamp.
Payment.Origin__NSn/aUpdate to “ZUORA”
PaymentMethod.CreditCardTypeZuora Credit Card TypeOnly populated if a specific electronic payment was used.
n/aZuora Origin”ZUORA”
InvoicePayment.AmountApplyTo.AmountAmount applied to a specific invoice.
InvoicePayment.Invoice.IntegrationId__NSApplyTo.InvoiceNetSuite invoice reference