NameDescriptionTypeAdditional information
TransactionIndexID

Primary key, auto-incremented. database reference = transactions.id

integer

None.

OrderID

database reference = transactions.orderid

integer

None.

TransactionID

database reference = transactions.transactionid

string

String length: inclusive between 0 and 50

TransactionDateTime

database reference = transactions.datetime

date

None.

TransactionType

database reference = transactions.ttype

string

String length: inclusive between 0 and 10

TransactionMethod

database reference = transactions.paymenttype

string

String length: inclusive between 0 and 255

TransactionAmount

database reference = transactions.amount

decimal number

None.

TransactionApproval

database reference = transactions.approvalcode

string

String length: inclusive between 0 and 50

TransactionReference

database reference = transactions.reference

string

String length: inclusive between 0 and 255

TransactionGatewayID

database reference = transactions.gwid

integer

None.

TransactionCVV2

database reference = transactions.cvv2

string

String length: inclusive between 0 and 255

TransactionAVS

database reference = transactions.avs

string

String length: inclusive between 0 and 255

TransactionResponseText

database reference = transactions.responsetext

string

String length: inclusive between 0 and 65535

TransactionResponseCode

database reference = transactions.responsecode

string

String length: inclusive between 0 and 50

TransactionCaptured

database reference = transactions.captured

integer

None.