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