NameOdbc
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
AMOUNT
|
Amount Paid (Base currency)
|
10
|
Double
|
8
|
CIS_VAT
|
CIS VAT value
|
14
|
Double
|
8
|
DATE
|
Date
|
10
|
Date
|
2
|
DELETED_FLAG
|
Transaction deleted flag
|
10
|
Int32
|
2
|
DETAILS
|
Details
|
10
|
String
|
60
|
FOREIGN_AMOUNT
|
Amount Paid (Foreign Currency)
|
10
|
Double
|
8
|
RECORD_CREATE_DATE
|
Date and time when the record was created.
|
15
|
Date
|
8
|
RECORD_DELETED
|
Flag denoting if the record has been deleted or not.
|
15
|
Boolean
|
2
|
RECORD_MODIFY_DATE
|
Date and time when the record was modified.
|
15
|
Date
|
8
|
REFERENCE
|
Payment reference
|
10
|
String
|
30
|
SPLIT_CROSSREF
|
Cross reference split number
|
10
|
Int64
|
4
|
SPLIT_NUMBER
|
Split number
|
10
|
Int64
|
4
|
TYPE
|
Transaction type
|
10
|
String
|
2
|
USAGE_NUMBER*
|
Usage number
|
10
|
Int64
|
4
|
USER_NAME
|
User name
|
10
|
String
|
32
|