Welcome to Zuora Product Documentation

Explore our rich library of product information

Payments

This reference article lists the fields associated with the Payments data dictionary.

.

Note: Fields with an asterisk mark indicate mandatory fields.
NameDescriptionValue
IsNewPaymentMarker ColumnTRUE
Amount*The total amount of the payment.Number <double>
Currency Code*The value of the field is dependent upon enablement of Standalone Payments and Multiple CurrenciesString
Type*If you specify the type as Electronic, you must specify the value for accountId or accountNumberString
Account IdThe ID of the customer account that the payment is created for.String
Account NumberThe number of the customer account that the payment is created forString
Auth Transaction IdThe authorization transaction ID from the payment gateway. Use this field for electronic payments, such as credit cardsstring <= 50 characters
CommentAdditional information related to the payment.string [ 0 .. 255 ] characters
Effective DateThe date when the payment takes effect, in yyyy-mm-dd format.string <date>
Gateway IdThe ID of the gateway instance that processes the payment.string
Gateway Order IdA merchant-specified natural key value that can be passed to the electronic payment gateway when a payment is created. If not specified, the payment number will be passed in instead.string <= 50 characters
Mit Transaction SourcePayment transaction source used to differentiate the transaction source in Stored Credential Transaction framework.string
Payment Method IdThe unique ID of the payment method that the customer used to make the payment.string
Payment Method TypeDefault: null, The type of the payment method that the customer used to make the payment.string
Payment Schedule KeyThe unique ID or the number of the payment schedule to be linked with the payment.string
Pre-PaymentThis field is available with Prepaid Cash with DropDown enablementboolean
Reference IdThe transaction ID returned by the payment gateway.string [ 0 .. 100 ] characters
Soft DescriptorA payment gateway-specific field that maps to Zuora for the gateways, Orbital, Vantiv and Verifi.string <= 35 characters
Soft Descriptor PhoneA payment gateway-specific field that maps to Zuora for the gateways, Orbital, Vantiv and Verifi.string <= 20 characters
StandaloneThis field is only available if support for standalone payments is enabled.boolean
IsNewcustomRatesMarker ColumnTRUE/ FALSE
Custom Rates Currency Code*The currency code for either Reporting or Home currency.string
Custom Rates Custom FX Rate*The Custom FX conversion rate between Home/Reporting and Transactional currency items.number <decimal>
Custom Rates Rate DateThe date on which a particular currency rate is fixed or obtained on.string <date>
IsNewDebitMemoMarker ColumnTRUE/ FALSE
Debit Memo Amount*The amount of the payment associated with the debit memo.number <double>
Debit Memo IdThe unique ID of the debit memo that the payment is created on.string
IsNewDebitMemoItemMarker ColumnTRUE/ FALSE
Debit Memo Items Amount*The amount of the payment associated with the specific debit memo or taxation item.number <double>
Debit Memo Items Debit Memo IdThe ID of the specific debit memo item.string
Debit Memo Items Tax Item IdThe ID of the specific taxation item.string
Finance Information AccountingWhether the payment was transferred to an external accounting system.string
Finance Information Bank Account Accounting CodeThe accounting code that maps to a bank account in your accounting system.string [ 0 .. 100 ] characters
Finance Information Unapplied Payment Accounting CodeThe accounting code for the unapplied payment.string [ 0 .. 100 ] characters
Gateway Options KeyThe name of a gateway-specific parameter.string <= 255 characters
Gateway Options ValueThe value of the gateway-specific parameter.string <= 255 characters
IsNewInvoiceMarker ColumnTRUE/ FALSE
Invoice Amount*The amount of the payment associated with the invoice.number <double>
Invoice IdThe unique ID of the invoice on which the payment is created.string
IsNewInvoiceItemMarker ColumnTRUE/ FALSE
Invoice Items Amount*The amount of the payment associated with the specific invoice or taxation item.number <double>
Invoice Items Invoice Item IdThe ID of the specific invoice item.string
Invoice Items Tax Item IdThe ID of the specific taxation item.string
IsNewpaymentOptionMarker ColumnTRUE/ FALSE
paymentOption TypeThe type of the payment option. Currently, only GatewayOptions is supported for specifying Gateway Options fields supported by a payment gateway.string
paymentOption Detail SecCodeWebstring