NameOdbc
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
ACCOUNT_REF
|
Sales/Purchase/Bank Account Reference
|
10
|
String
|
8
|
AMOUNT
|
Signed amount (credits negative)
|
10
|
Double
|
8
|
BANK_CODE
|
Bank Account Reference
|
10
|
String
|
8
|
BANK_FLAG
|
Bank reconciled flag - y/n/-
|
10
|
String
|
1
|
DATE
|
Transaction date
|
10
|
Date
|
2
|
DATE_ENTERED
|
|
10
|
Date
|
2
|
DATE_FLAG
|
Transaction date within report criteria
|
10
|
Int32
|
2
|
DELETED_FLAG
|
Transaction deleted flag
|
10
|
Int32
|
2
|
DEPT_NAME
|
Department name
|
10
|
String
|
60
|
DEPT_NUMBER
|
Department number
|
10
|
Int32
|
4
|
DETAILS
|
Details
|
10
|
String
|
60
|
DISPUTE_CODE
|
Dispute Reason Code
|
11
|
Int32
|
2
|
DISPUTED
|
Disputed flag
|
10
|
Int32
|
2
|
EXTRA_REF
|
Extra Reference
|
10
|
String
|
60
|
FOREIGN_AMOUNT
|
Signed amount (foreign currency, credits negative)
|
10
|
Double
|
8
|
FUND_ID
|
Fund ID
|
12
|
Int64
|
4
|
HEADER_NUMBER
|
Header number
|
10
|
Int64
|
4
|
INV_REF
|
Invoice Reference Number
|
10
|
String
|
30
|
NOMINAL_CODE
|
Nominal Code
|
10
|
String
|
8
|
PAID_FLAG
|
Transaction paid flag - y/n
|
10
|
String
|
1
|
PAID_STATUS
|
Transaction disputed/paid status - */p/d*/dp/
|
10
|
String
|
2
|
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
|
SPLIT_NUMBER
|
Split number
|
10
|
Int64
|
4
|
STMT_TEXT
|
Text for summary statements
|
10
|
String
|
60
|
TAX_CODE
|
Tax code (T0 to T99)
|
10
|
String
|
3
|
TRAN_NUMBER
|
Transaction number
|
10
|
Int64
|
4
|
TYPE
|
Transaction type
|
10
|
String
|
2
|
USER_NAME
|
User name
|
10
|
String
|
32
|
VAT_FLAG
|
VAT reconciled flag - y/n/-
|
10
|
String
|
1
|
VAT_FLAG_CODE
|
VAT reconciled flag - 0/1
|
10
|
Int16
|
1
|
VAT_LEDGER_RETURN_ID
|
VAT Ledger Return ID
|
14
|
Int64
|
4
|
VAT_RECONCILED_DATE
|
VAT Reconciled Date
|
10
|
Date
|
2
|