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