Payment Field Mappings: NetSuite to Zuora Sync (Invoice Settlement Enabled)

Knowledge Center > Integrations > NetSuite Connector > Field Mappings > Payment Field Mappings: NetSuite to Zuora Sync (Invoice Settlement Enabled)

Payment Field Mappings: NetSuite to Zuora Sync (Invoice Settlement Enabled)

Table of contents

This reference describes the mappings of the Payment sync from NetSuite to Zuora when Invoice Settlement is enabled for your Zuora tenant.

The Invoice Settlement feature is in Limited Availability. This feature includes Unapplied Payments, Credit and Debit Memo, and Invoice Item Settlement. If you wish to have access to the feature, submit a request at Zuora Global Support

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.

Last modified

Tags

This page has no custom tags.

Classifications

(not set)