Skip to main content

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

Zuora

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.