Payment Field Mappings: NetSuite to Zuora Sync
This topic describes the mappings of the Payment information sync from NetSuite to Zuora.
In some cases, the Source and Destination fields are associated with different objects.
Payment 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 (Invoice Payment) | Notes |
|---|---|---|
| internalId | Payment.IntegrationId__NS | |
| ZuoraCustomerID | Payment.AccountId | |
| payment | n/a | The total amount. |
| tranDate | Payment.EffectiveDate | |
| applyList.amount | Payment.Amount | The sum of all applied invoice amounts. This field is required. |
| n/a | Payment.PaymentNumber | This value is generated automatically. |
| ZuoraReferenceID | Payment.ReferenceId | |
| memo | Payment.Comment | |
| paymentMethod.name | PaymentMethodId | |
| n/a | PaymentType | "External" |
| n/a | Payment.Status | "Draft," then "Processed" when completed. |
| n/a | Payment.TransferredToAccounting | "Yes" when completed. |
| n/a | Payment.SyncDate__NS | The current timestamp. |
| ZuoraOrigin | n/a | Update to "NETSUITE" when completed. |
| ZuoraId | n/a | Update with the new Zuora ID when completed. |
| ZuoraSyncDate | n/a | Update with the current timestamp when completed. |
| ZuoraIntegrationStatus | n/a | Update with "Sync Complete" when completed, and update with other statuses while processing. |