Name | Description | Type | Additional 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. |