Skip to main content

Refund Field Mappings: Zuora to NetSuite Sync

Zuora

Refund Field Mappings: Zuora to NetSuite Sync

  1. Last updated
  2. Save as PDF

This article describes the mappings of the refund information sync from Zuora to NetSuite.

In some cases, the Source and Destination fields are associated with different objects.

 

Refund 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
(Customer Payment)		 Notes
RefundInvoicePayment.CreatedById n/a  
RefundInvoicePayment.CreatedDate n/a  
RefundInvoicePayment.Id n/a  
RefundInvoicePayment.RefundAmount CustomerRefund.applyList.amount  
RefundInvoicePayment.UpdatedById n/a  
RefundInvoicePayment.UpdatedDate n/a  
Account.AccountNumber n/a  
Account.AdditionalEmailAddresses n/a  
Account.AllowInvoiceEdit n/a  
Account.AutoPay n/a  
Account.Balance n/a  
Account.Batch n/a  
Account.BillCycleDay n/a  
Account.CreatedById n/a  
Account.CreatedDate n/a  
Account.CreditBalance n/a  
Account.CrmId n/a  
Account.Currency n/a  
Account.CustomerServiceRepName n/a  
Account.Id n/a  
Account.InvoiceDeliveryPrefsEmail n/a  
Account.InvoiceDeliveryPrefsPrint n/a  
Account.InvoiceTemplateId n/a  
Account.LastInvoiceDate n/a  
Account.Mrr n/a  
Account.Name n/a  
Account.Notes n/a  
Account.BillAddrIntegrationId__NS n/a  
Account.IntegrationId__NS CustomerRefund.customer.internalId  
Account.IntegrationStatus__NS n/a  
Account.ShipAddrIntegrationId__NS n/a  
Account.SyncDate__NS n/a  
Account.ParentId n/a  
Account.PaymentTerm n/a  
Account.PurchaseOrderNumber n/a  
Account.SalesRepName n/a  
Account.Status n/a  
Account.TaxExemptCertificateId n/a  
Account.TaxExemptCertificateType n/a  
Account.TaxExemptDescription n/a  
Account.TaxExemptEffectiveDate n/a  
Account.TaxExemptExpirationDate n/a  
Account.TaxExemptIssuingJurisdiction n/a  
Account.TaxExemptStatus n/a  
Account.TotalInvoiceBalance n/a  
Account.UpdatedById n/a  
Account.UpdatedDate n/a  
BillToContact.AccountId n/a  
BillToContact.Address1 n/a  
BillToContact.Address2 n/a  
BillToContact.City n/a  
BillToContact.Country n/a  
BillToContact.County n/a  
BillToContact.CreatedById n/a  
BillToContact.CreatedDate n/a  
BillToContact.Description n/a  
BillToContact.Fax n/a  
BillToContact.FirstName n/a  
BillToContact.HomePhone n/a  
BillToContact.Id n/a  
BillToContact.LastName n/a  
BillToContact.MobilePhone n/a  
BillToContact.NickName n/a  
BillToContact.OtherPhone n/a  
BillToContact.OtherPhoneType n/a  
BillToContact.PersonalEmail n/a  
BillToContact.PostalCode n/a  
BillToContact.State n/a  
BillToContact.TaxRegion n/a  
BillToContact.UpdatedById n/a  
BillToContact.UpdatedDate n/a  
BillToContact.WorkEmail n/a  
BillToContact.WorkPhone n/a  
Invoice.AdjustmentAmount n/a  
Invoice.Amount n/a  
Invoice.AmountWithoutTax n/a  
Invoice.Balance n/a  
Invoice.Comments n/a  
Invoice.CreatedById n/a  
Invoice.CreatedDate n/a  
Invoice.DueDate n/a  
Invoice.Id n/a  
Invoice.IncludesOneTime n/a  
Invoice.IncludesRecurring n/a  
Invoice.IncludesUsage n/a  
Invoice.InvoiceDate n/a  
Invoice.InvoiceNumber n/a  
Invoice.LastEmailSentDate n/a  
Invoice.IntegrationId__NS Payment.applyList.doc Used to identify the Payment applied Invoice to update.
Invoice.IntegrationStatus__NS n/a  
Invoice.SyncDate__NS n/a  
Invoice.PaymentAmount n/a  
Invoice.PostedBy n/a  
Invoice.PostedDate n/a  
Invoice.RefundAmount n/a  
Invoice.Source n/a  
Invoice.SourceId n/a  
Invoice.Status n/a  
Invoice.TargetDate n/a  
Invoice.TaxAmount n/a  
Invoice.TaxExemptAmount n/a  
Invoice.TransferredToAccounting n/a  
Invoice.UpdatedById n/a  
Invoice.UpdatedDate n/a  
InvoicePayment.Amount
InvoicePayment.RefundAmount		 Payment.applyList.amount InvoicePayment.Amount - InvoicePayment.RefundAmount

This calculation is required because multiple refunds can exist for a single invoicepayment record. This value must reflect the current amount that is still applied to the invoice. It is possible for this amount to equal 0 in the event of a full refund.
InvoicePayment.CreatedById n/a  
InvoicePayment.CreatedDate n/a  
InvoicePayment.Id n/a  
InvoicePayment.RefundAmount n/a  
InvoicePayment.UpdatedById n/a  
InvoicePayment.UpdatedDate n/a  
Payment.AccountingCode n/a  
Payment.Amount n/a  
Payment.AppliedCreditBalanceAmount n/a  
Payment.AuthTransactionId n/a  
Payment.BankIdentificationNumber n/a  
Payment.Comment n/a  
Payment.CreatedDate n/a  
Payment.EffectiveDate n/a  
Payment.GatewayOrderId n/a  
Payment.GatewayResponse n/a  
Payment.GatewayResponseCode n/a  
Payment.Id n/a  
Payment.IntegrationId__NS Payment.internalId Used to update existing Payment.
Payment.IntegrationId__NS CustomerRefund.applyList.doc  
Payment.IntegrationStatus__NS n/a  
Payment.SyncDate__NS n/a  
Payment.PaymentNumber n/a  
Payment.ReferenceId n/a  
Payment.RefundAmount n/a  
Payment.SecondPaymentReferenceId n/a  
Payment.SoftDescriptor n/a  
Payment.SoftDescriptorPhone n/a  
Payment.Status n/a  
Payment.Type n/a  
Payment.UpdatedById n/a  
Payment.UpdatedDate n/a  
PaymentMethod.AccountId n/a  
PaymentMethod.AchAbaCode n/a  
PaymentMethod.AchAccountName n/a  
PaymentMethod.AchAccountNumberMask n/a  
PaymentMethod.AchAccountType n/a  
PaymentMethod.AchBankName n/a  
PaymentMethod.Active n/a  
PaymentMethod.BankIdentificationNumber n/a  
PaymentMethod.CreatedById n/a  
PaymentMethod.CreatedDate n/a  
PaymentMethod.CreditCardAddress1 n/a  
PaymentMethod.CreditCardAddress2 n/a  
PaymentMethod.CreditCardCity n/a  
PaymentMethod.CreditCardCountry n/a  
PaymentMethod.CreditCardExpirationMonth n/a  
PaymentMethod.CreditCardExpirationYear n/a  
PaymentMethod.CreditCardHolderName n/a  
PaymentMethod.CreditCardMaskNumber n/a  
PaymentMethod.CreditCardPostalCode n/a  
PaymentMethod.CreditCardState n/a  
PaymentMethod.CreditCardType n/a  
PaymentMethod.Id n/a  
PaymentMethod.LastFailedSaleTransactionDate n/a  
PaymentMethod.LastTransactionDateTime n/a  
PaymentMethod.LastTransactionStatus n/a  
PaymentMethod.Name n/a  
PaymentMethod.NumConsecutiveFailures n/a  
PaymentMethod.PaypalBaid n/a  
PaymentMethod.PaypalEmail n/a  
PaymentMethod.Type n/a  
PaymentMethod.UpdatedById n/a  
PaymentMethod.UpdatedDate n/a  
Refund.Amount n/a NetSuite will derive this from applied amounts.
Refund.Comment CustomerRefund.memo  
Refund.CreatedDate CustomerRefund.ZuoraCreatedDate  
Refund.Gateway n/a  
Refund.GatewayResponse n/a  
Refund.GatewayResponseCode n/a  
Refund.Id CustomerRefund.ZuoraId  
Refund.MethodType CustomerRefund.paymentMethod picklist
Refund.ReferenceID CustomerRefund.
ZuoraRefundReferenceId		  
Refund.RefundDate CustomerRefund.tranDate  
Refund.RefundNumber CustomerRefund.tranId Map this if the Integration Widget setting Use Transaction auto-numbering is disabled.
Refund.RefundNumber CustomerRefund.
ZuoraReferenceNumber		  
Refund.RefundTransactionTime n/a  
Refund.SourceType n/a filter export where = "Payment"

Payment, Credit Balance
Refund.Status n/a filter export where = "Processed"
Refund.TransferredToAccounting n/a Update to Processing/Processing 2/Complete/Error upon completion
Refund.Type CustomerRefund.ZuoraRefundType External, Electronic
Refund.UpdatedDate CustomerRefund.ZuoraUpdatedDate  
Refund.NS_IntegrationId__NS CustomerRefund.internalId Update Zuora after initial create only
Refund.NS_IntegrationStatus__NS n/a Used to route in-process. Update Zuora with "Processing," "Processing 2," "Complete," or "Error."
Refund.NS_SyncDate__NS n/a Update Zuora after initial create only. Use the current timestamp.
Refund.Origin__NS n/a Update to "ZUORA"
SoldToContact.AccountId n/a  
SoldToContact.Address1 n/a  
SoldToContact.Address2 n/a  
SoldToContact.City n/a  
SoldToContact.Country n/a  
SoldToContact.County n/a  
SoldToContact.CreatedById n/a  
SoldToContact.CreatedDate n/a  
SoldToContact.Description n/a  
SoldToContact.Fax n/a  
SoldToContact.FirstName n/a  
SoldToContact.HomePhone n/a  
SoldToContact.Id n/a  
SoldToContact.LastName n/a  
SoldToContact.MobilePhone n/a  
SoldToContact.NickName n/a  
SoldToContact.OtherPhone n/a  
SoldToContact.OtherPhoneType n/a  
SoldToContact.PersonalEmail n/a  
SoldToContact.PostalCode n/a  
SoldToContact.State n/a  
SoldToContact.TaxRegion n/a  
SoldToContact.UpdatedById n/a  
SoldToContact.UpdatedDate n/a  
SoldToContact.WorkEmail n/a  
SoldToContact.WorkPhone n/a  
n/a CustomerRefund.ZuoraType "PAYMENT_REFUND"
n/a CustomerRefund.ZuoraOrigin "ZUORA"
n/a CustomerRefund.ZuoraSyncDate Current timestamp
n/a Payment.applyList.replaceAll "false"
Account.Class__NS class Map from the Zuora Account object (if the value is set). Otherwise, use the value specified in the integration manager.
Account.Department__NS department Map from the Zuora Account object (if the value is set). Otherwise, use the value specified in the integration manager.
Account.Location__NS location Map from the Zuora Account object (if the value is set). Otherwise, use the value specified in the integration manager.