Payment

Fields

Amount
decimal
Monetary amount of the Payment
PaymentDate
dateTime
Date of the Payment
CreationDate
dateTime
Timestamp indicating when the record was created
CreatedBy
nonNegativeInteger
Constituent who created the record
ModifyDate
dateTime
Timestamp indicating when the record was last changed
LastChangeBy
nonNegativeInteger
Constituent who last modified the record
CreationMethod
CreationMethod
One of the following values that determines how this transaction was processed: 0 if entered in the database as an offline transaction (for example, an offline gift or registration fee), 1 if processed online, 2 if from a recurring pledge
BillingName
Name
Name on the credit card used to make the online transaction, for the bank account withdrawal, or entered by the administrator when recording or processing the transaction offline
BillingAddress
Address
Billing address of the party making the Payment
ConfirmationCode
string
Code supplied by the financial transaction processor (credit card center) to the system confirming the transaction
ConvioConfirmationCode
string
System-generated transaction confirmation code provided to the donor confirming the transaction
ProcessorTransactionId
string
Transaction ID supplied to the system by the financial institution (credit card center or bank)
ProcessorRefNumber
string
Processor-supplied reference number for the payment transaction
TenderType
TenderType
Indicates the method of payment
CreditCardType
CreditCardType
Indicates the type of credit card (for credit card payment)
OrgId
string
The ID of the organization
DonorType
string
The type of donor
DonationTypeId
string
The ID of the donation type
ReceiptId
string
The receipt ID
GatewayId
string
The Gateway ID
CreditCardNumber
string
The card number (for credit card payment)
CreditCardExpDate
string
The expiration date (for credit card payments)
BatchSettlementNumber
string
The batch settlement number received from the financial institution when the payment was settled
SettlementDate
dateTime
Date on which this transaction was settled
SettlementStatus
SettlementStatus
The step in the payment and settlement process that this transaction is in: Settled, Unsettled, Submitted, ACH only
MerchantAccountId
nonNegativeInteger
The system-generated unique identifier of the Merchant Account associated with this Payment
CheckNumber
string
Check number for payment by check
SecurityCategoryId
nonNegativeInteger
References a system-generated value identifying the Security Category, controlling which constituents can see the record
RoutingNumber
string
ACH Routing number
TransitNumber
string
ACH transit number (Canada)
BankNumber
string
ACH bank number (Canada)
AccountType
string
ACH account type: CHECKING (default), SAVINGS
AccountNumber
string
ACH (debit) account number
OriginationType
OriginationType
Payment origination: entered by a consitituent or administrator online, posted via an internal or external API call, or entered by an administrator in CRM.
CustomString1
string
CustomString2
string
CustomString3
string
CustomString4
string
Discount
Discount

Supported Operations

Find
Query

Leave a Comment

Nickname
Comment
Enter this word: