Invoice Payment Field Mappings: Zuora to NetSuite Sync
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 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 |