| Column Name |
Type |
Precision |
Length |
Nullable |
Description |
| PayPalTransactionLogId |
int |
10 |
0 |
NO |
The eSuite transaction reference |
| DateTimeCreated |
datetime |
10 |
N/A |
NO |
The time the request was sent to PayPal |
| DateTimeLastedUpdated |
datetime |
255 |
N/A |
NO |
The time at which the transaction was last updated by eSuite or PayPal |
| TransactionStatusLastUpdateTime |
datetime |
23 |
N/A |
YES |
The time at which the transaction status was last updated by eSuite or PayPal |
| TransactionStatus |
string |
N/A |
16 |
NO |
The current status of the transaction within eSuite |
| TransactionMessage |
string |
N/A |
255 |
YES |
The message received by PayPal |
| Currency |
string |
N/A |
3 |
NO |
The currency of the transaction. |
| Amount |
int |
10 |
10 |
NO |
The total gross value of the transaction |
| OrderID |
int |
10 |
10 |
NO |
The eSuite order reference identifier |
| Description |
string |
N/A |
18000 |
NO |
A description of what has been purchased |
| OrderDate |
datetime |
10 |
0 |
NO |
The date at which the purchase was requested by the customer |
| AccountID |
int |
10 |
16 |
NO |
The eSuite AccountId for the users eSuite Account |
| EmailAddress |
string |
10 |
255 |
NO |
The associated eSuite email address for the Account |
| PayPalTransactionType |
string |
N/A |
16 |
NO |
The type of transaction this relates to e.g. purchase or refund |
