| 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. |