|
AccountNumber
|
string
|
24
|
N
|
|
Masked account number.
|
|
AccountId
|
integer
|
|
N
|
|
|
| FK: T_ACCOUNT_DATA.id Resource: Accounts |
|
Amount
|
decimal number
|
|
N
|
|
|
|
AuthCode
|
string
|
30
|
N
|
|
|
|
AvsAddress
|
string
|
64
|
N
|
|
Address submitted for Address Verification System (AVS).
|
|
AvsPostalcode
|
string
|
10
|
N
|
|
Postal code submitted for Address Verification System (AVS).
|
|
AvsResultCode
|
string
|
1
|
N
|
|
Response from Address Verification System (AVS) query.
|
|
BalanceAmount
|
decimal number
|
|
N
|
|
Customer balance after transaction - may be populated in Vantiv transactions with partial auth enabled. Vantiv requires that this field be an available option for receipts.
|
|
BalanceCurrencyCode
|
string
|
3
|
N
|
|
Currency code of customer balance - may be populated in Vantiv transactions with partial auth enabled. Vantiv requires that this field be an available option for receipts.
|
|
CreatedDateTime
|
date
|
|
N
|
|
Non-updatable
|
|
CreateLocation
|
string
|
|
N
|
|
Non-updatable
|
|
CreatedBy
|
string
|
|
N
|
|
Non-updatable
|
|
ConstituentId
|
integer
|
|
N
|
|
|
| FK: T_CUSTOMER.customer_no Resource: Constituents |
|
CvvResultCode
|
string
|
1
|
N
|
|
Result of checking the submitted CVV (Customer Verification Value) code against the CVV on the customer's account.
|
|
EcommerceIndicator
|
string
|
1
|
N
|
|
|
|
EmvApplicationName
|
string
|
16
|
N
|
|
Required by Vantiv as an option for EMV receipts.
|
|
EmvApplicationIdentifier
|
string
|
32
|
N
|
|
Required by Vantiv as an option for EMV receipts.
|
|
EmvPinVerified
|
string
|
1
|
N
|
|
Required by Vantiv as an option for EMV receipts.
|
|
EmvHostResponseCode
|
string
|
3
|
N
|
|
Required by Vantiv as an option for EMV receipts.
|
|
EmvHostResponseMessage
|
string
|
150
|
N
|
|
Required by Vantiv as an option for EMV receipts.
|
|
EmvCryptogram
|
string
|
25
|
N
|
|
Required by Vantiv as an option for EMV receipts.
|
|
EntryMethod
|
string
|
10
|
N
|
|
Method by which card data was supplied for transaction (Keyed, Swiped, Stored, etc.).
|
|
ExpirationDate
|
string
|
6
|
N
|
|
Expiration date of payment card.
|
|
Id
|
integer
|
|
Y
|
|
Non-updatable
|
|
UpdatedDateTime
|
date
|
|
Y
|
|
Auto-assigned
|
|
UpdatedBy
|
string
|
|
N
|
|
Auto-assigned
|
|
MerchantId
|
string
|
3
|
N
|
|
Merchant id used to locate processor credentials and charge the payment card or create a token.
|
|
Name
|
string
|
56
|
N
|
|
Name on card.
|
|
Origin
|
string
|
20
|
N
|
|
Area of Tessitura application (or user-supplied information) where the transaction originated.
|
|
PaymentGatewayTransactionType
|
PaymentGatewayTransactionType
|
|
Y
|
|
Follow-up transactions (Reverse/Confirm) will have most fields set to null -- they refer to the original Authorization row.
|
| FK: TR_PAYMENT_GATEWAY_TRANSACTION_TYPE.id Resource: PaymentGatewayTransactionTypes |
|
PaymentMethodGroupId
|
integer
|
|
N
|
|
|
| FK: TR_PMT_METHOD_GROUP.id Resource: PaymentMethodUserGroups |
|
PaymentMethodId
|
integer
|
|
N
|
|
|
| FK: TR_PAYMENT_METHOD.id Resource: PaymentMethods |
|
PaymentId
|
integer
|
|
N
|
|
|
| FK: T_PAYMENT.payment_no Resource: Payments |
|
ProviderCommunicationDurationMs
|
integer
|
|
N
|
|
The duration of time that it took for gateway provider to respond, start to finish, including network latency. Calculated from the start of the request to the receipt of the response.
|
|
ProviderTransactionDateTime
|
date
|
|
N
|
|
Transaction date/time according to gateway provider (if available), otherwise calculated by Tessitura.
|
|
ReferenceNumber
|
string
|
32
|
N
|
|
Used in subsequent reversal or refund requests or inquiries.
|
|
ResponseCode
|
string
|
20
|
N
|
|
A "SUCCESS" value (MasterCard) or zero "0" value (other gateways) indicates a successful transaction. Use the Success field, rather than this field, to interpret the disposition of the request.
|
|
ResponseMessage
|
string
|
4000
|
N
|
|
Sometimes includes more detailed information about the response than the ResponseCode.
|
|
Success
|
string
|
1
|
Y
|
|
Success (Y) or failure (N) of the request. Use this value, rather than ResponseCode, to interpret the disposition of the request.
|
|
TerminalIdentifier
|
string
|
16
|
N
|
|
For EMV transactions - which machine handled the transaction.
|
| FK: TR_MACHINE_SETTINGS.workstation_name Resource: MachineSettings |
|
TotalDurationMs
|
integer
|
|
N
|
|
Total amount of time spent in the Authorization call.
|
|
UserData
|
string
|
4000
|
N
|
|
User-generated free-form text stored in T_PAYMENT_GATEWAY_ACTIVITY.user_data. Tessitura-generated transactions write the invoice, order, or contribution number.
|
|
NetworkTransactionId
|
string
|
40
|
N
|
|
Transaction identifier returned from credential-on-file transactions (Worldpay).
|
|
ActivityData
|
string
|
|
N
|
|
|