Payment Field Mappings: NetSuite to Zuora 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 NetSuite to Zuora 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 |
|---|---|---|
|
n/a |
Payment.PaymentNumber |
This value is generated automatically. |
|
Internal Id |
IntegrationId__NS |
|
|
CustomerPayment.Zuora_Customer_ID_Payments |
Payment.AccountId |
|
|
CustomerPayment.payment |
Payment.Amount |
|
|
ApplyTo.Amount |
DebitMemo.Amount AND/OR Invoice.Amount |
|
|
ApplyTo.Doc |
DebitMemo.IntegrationId__NS AND/OR Invoice.IntegrationId__NS |
|
|
CustomerPayment.memo |
Payment.Comment |
|
|
CustomerPayment.tranId |
Transaction__NS |
|
|
CustomerPayment.Zuora_Payment_Reference_ID |
Payment.ReferenceId |
|
|
paymentMethod.name |
Payment.PaymentMethodId |
|
|
n/a |
Payment.TransferredToAccounting |
"Yes" when completed. |
|
n/a |
Payment.Type |
"External" |
|
n/a |
Payment.SyncDate__NS |
The current timestamp. |
|
Zuora Origin |
n/a |
Update to "NETSUITE" when completed. |
|
Zuora ID |
n/a |
Update with the new Zuora ID when completed. |
|
Zuora Sync Date |
n/a |
Update with the current timestamp when completed. |
|
Zuora Integration Status |
n/a |
Update with "Sync Complete" when completed, and update with other statuses while processing. |