Knowledge Center

Knowledge Center > Integrations and Extensions > NetSuite Connector > Field Mappings > Invoice Payment Field Mappings: Zuora to NetSuite Sync

Invoice Payment Field Mappings: Zuora to NetSuite Sync

Table of contents

This reference describes the mappings of the invoice payment information sync from Zuora to NetSuite. Note that a payment may be applied to more than one invoice.

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

Zuora Payment

Source Field Destination Field
(Customer Payment)
Notes
Account.IntegrationId__NS Customer NetSuite Customer reference
InvoicePayment.Amount Payment Amount Sum of applied invoice payment amounts. Note that "over payments" are not synced.

 

Payment.Comment Memo  
Payment.CreatedDate Zuora Created Date  
Payment.EffectiveDate Date (tranDate)  
Account.Class__NS Class If not populated, map from NetSuite Connector preference NetSuite Default Class if populated. See NetSuite Classifications for more information.
Account.Department__NS Department If not populated, map from NetSuite Connector preference NetSuite Default Department if populated. See NetSuite Classifications for more information. 
Account.Location__NS Location If not populated, map from NetSuite Connector preference NetSuite Default Location if populated. See NetSuite Classifications for more information. 
PaymentMethod.Type Payment Method ACH, Cash, Check, CreditCard, Other, PayPal, WireTransfer, DebitCard, CreditCardReferenceTransaction.
Payment.Id Zuora ID  
Payment.PaymentNumber Zuora Reference Number  
Payment.ReferenceId Zuora Payment Reference ID  
Payment.Type Zuora Payment Type  
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.
Payment.Origin__NS n/a Update to "ZUORA"
PaymentMethod.CreditCardType Zuora Credit Card Type Only populated if a specific electronic payment was used.
n/a Zuora Origin "ZUORA"
InvoicePayment.Amount ApplyTo.Amount Amount applied to a specific invoice.
InvoicePayment.Invoice.IntegrationId__NS ApplyTo.Invoice NetSuite invoice reference

 

  1.  
Last modified
13:40, 10 Jan 2017

Tags

Classifications

(not set)