Diagrams


Table

MS- PayPal Transaction

Fields

# Name Type
1 Account ID (Account ID) Code127
2 Transaction ID (Transaction ID) Text19
3 Transaction Status (Transaction Status) Code10
4 Transaction Date (Transaction Date) DateTime
6 Transaction Type (Transaction Type) Code28
7 Currency Code (Currency Code) Code3
8 Gross Amount (Gross Amount) Decimal
9 Net Amount (Net Amount) Decimal
10 Fee Amount (Fee Amount) Decimal
11 Payer E-mail (Payer E-mail) Text127
12 Payer Name (Payer Name) Text127
13 Payer Address (Payer Address) Text100
14 Note (Note) Text250
15 Custom (Custom) Text250
16 Invoice No. (Invoice No.) Code20
101 Response Date (Response Date) DateTime
200 Details (Details) BLOB

Keys

# Fields
0 Account ID,Transaction ID (Account ID,Transaction ID) Clustered: Yes
1 Transaction Date (Transaction Date)
2 Currency Code (Currency Code)

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field