EventUID

Key used to uniquely identify a captured or imported event.

Yes

IDENTITYREF

13

Foreign key: Wgn3Event

EventTimestamp

The time at which the event occurred.

Yes

TIMESTAMP

8

Foreign key: Wgn3Event

TransType

INTEGER

4

Not used.

TransState

The transactions current state.

INTEGER

4

Follow the hyperlink for details.

TransTimestamp

The time at which the transaction occurred.

TIMESTAMP

8

TransCurrency

The currency in which the transaction occurred.

VARCHAR

4

Should be the ISO currency value.

TransTotal

The total amount of the transaction.

DECIMAL

13

TransTotal is a fixed point decimal and must be divided by 1000 to get the actual value in the specified currency units

TransTax

The amount of tax paid on the transaction.

DECIMAL

13

TransTax is a fixed point decimal and must be divided by 1000 to get the actual value in the specified currency units

TransDelivery

The delivery charge associated with the transaction.

DECIMAL

13

TransDelivery is a fixed point decimal and must be divided by 1000 to get the actual value in the specified currency units

PaymentMethod

How the transaction was paid for.

VARCHAR

255

This is a simple string which the user must supply. It provides more information about the payment method (for example, 'Mastercard')

PaymentData

Payment method specific information, such as a credit card number.

LONGVARCHAR

TransSiteName

The web site or email address associated with the transaction.

VARCHAR

255

TransDescription

A user supplied description of the transaction.

LONGVARCHAR

TransComment

A user supplied comment about the transaction.

LONGVARCHAR

SupplierReference

The suppliers reference number for the transaction.

VARCHAR

255

BuyerReference

The users reference number for the transaction.

VARCHAR

255

TransactionIDM

Part-key that uniquely identifies this transaction.

INTEGER

4

TransactionID

Part-key that uniquely identifies this transaction.

INTEGER

4

ConfidenceLevels

Indicates the degree of confidence with which the values of other columns in this table were detected.

VARCHAR

255

Follow the hyperlink for details.

ParentIDM

Part-key that uniquely identifies the full transaction associated with a partial transaction.

INTEGER

4

Only valid for partial transactions (see TransState).

Foreign key: TransactionIDM/ID

ParentID

Part-key that uniquely identifies the full transaction associated with a partial transaction.

INTEGER

4

Only valid for partial transactions (see TransState).

Foreign key: TransactionIDM/ID