Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
ACCOUNT_REF
|
Sales/Purchase/Bank Account Reference
|
10
|
String
|
8
|
AGED_30
|
Gross in 1st period (eg 30-59 days)
|
10
|
Double
|
8
|
AGED_60
|
Gross in 2nd period (eg 60-89 days)
|
10
|
Double
|
8
|
AGED_90
|
Gross in 3rd period (eg 90-119 days)
|
10
|
Double
|
8
|
AGED_BALANCE
|
Gross towards current balance
|
10
|
Double
|
8
|
AGED_CUM_30
|
Gross in 1st period and beyond (eg 30 days and older)
|
10
|
Double
|
8
|
AGED_CUM_60
|
Gross in 2nd period and beyond (eg 60 days and older)
|
10
|
Double
|
8
|
AGED_CUM_90
|
Gross in 3rd period and beyond (eg 90 days and older)
|
10
|
Double
|
8
|
AGED_CUM_CURRENT
|
Gross in current period and beyond (eg all older)
|
10
|
Double
|
8
|
AGED_CURRENT
|
Gross in current period (eg 0-29 days)
|
10
|
Double
|
8
|
AGED_FUTURE
|
Gross in future period
|
10
|
Double
|
8
|
AGED_OLDER
|
Gross beyond 3rd period (eg 120 days and older)
|
10
|
Double
|
8
|
AMOUNT_PAID
|
Total amount paid (allocated against invoice/credit)
|
10
|
Double
|
8
|
BANK_AMOUNT
|
Gross amount (signed for use in bank statements)
|
10
|
Double
|
8
|
BANK_CODE
|
Bank Account Reference
|
10
|
String
|
8
|
BANK_FLAG
|
Bank reconciled flag
|
10
|
String
|
1
|
BANK_NAME
|
Bank Account Name
|
10
|
String
|
60
|
CIS_RECONCILED
|
This transaction has been CIS reconciled
|
14
|
Int32
|
2
|
CURRENCY
|
Which foreign currency
|
10
|
Int16
|
1
|
CURRENCY_TYPE
|
Foreign or Euro currency
|
10
|
Int16
|
1
|
DATE
|
Transaction date
|
10
|
Date
|
2
|
DATE_BANK_RECONCILED
|
Bank Reconciliation date
|
10
|
Date
|
2
|
DATE_BF
|
Report criteria date Brought forward
|
10
|
Date
|
2
|
DATE_ENTERED
|
Date Entered
|
10
|
Date
|
2
|
DATE_FLAG
|
Transaction date within report criteria
|
10
|
Int32
|
2
|
DATE_FROM
|
Report criteria date from
|
10
|
Date
|
2
|
DATE_TO
|
Report criteria date to
|
10
|
Date
|
2
|
DELETED_FLAG
|
Transaction deleted flag
|
10
|
Boolean
|
2
|
DETAILS
|
Details
|
10
|
String
|
60
|
DISPUTED
|
Number of Disputed items
|
10
|
Int32
|
2
|
DUE_DATE
|
Due date
|
10
|
Date
|
2
|
ELECTRONIC_TRANS
|
Electronic Transaction
|
10
|
Int32
|
2
|
EURO_GROSS
|
Gross amount in Euros
|
10
|
Double
|
8
|
EURO_RATE
|
Euro exchange rate
|
10
|
Double
|
8
|
FINANCE_CHARGE
|
Finance Charge flag
|
10
|
Int16
|
1
|
FOREIGN_AGED_30
|
Gross (foreign currency) in 1st period (eg 30-59 days)
|
10
|
Double
|
8
|
FOREIGN_AGED_60
|
Gross (foreign currency) in 2nd period (eg 60-89 days)
|
10
|
Double
|
8
|
FOREIGN_AGED_90
|
Gross (foreign currency) in 3rd period (eg 90-119 days)
|
10
|
Double
|
8
|
FOREIGN_AGED_BALANCE
|
Gross (foreign currency) towards current balance
|
10
|
Double
|
8
|
FOREIGN_AGED_CUM_30
|
Gross (foreign currency) in 1st period and beyond (eg 30 days and older)
|
10
|
Double
|
8
|
FOREIGN_AGED_CUM_60
|
Gross (foreign currency) in 2nd period and beyond (eg 60 days and older)
|
10
|
Double
|
8
|
FOREIGN_AGED_CUM_90
|
Gross (foreign currency) in 3rd period and beyond (eg 90 days and older)
|
10
|
Double
|
8
|
FOREIGN_AGED_CUM_CURRENT
|
Gross (foreign currency) in current period and beyond (eg all older)
|
10
|
Double
|
8
|
FOREIGN_AGED_CURRENT
|
Gross (foreign currency) in current period (eg 0-29 days)
|
10
|
Double
|
8
|
FOREIGN_AGED_FUTURE
|
Gross (foreign currency) in future period
|
10
|
Double
|
8
|
FOREIGN_AGED_OLDER
|
Gross (foreign currency) beyond 3rd period (eg 120 days and older)
|
10
|
Double
|
8
|
FOREIGN_AMOUNT_PAID
|
Total amount paid in foreign currency (allocated against invoice/credit)
|
10
|
Double
|
8
|
FOREIGN_BANK_AMOUNT
|
Gross amount in foreign currency (signed for use in bank statements)
|
10
|
Double
|
8
|
FOREIGN_GROSS_AMOUNT
|
Gross amount in foreign currency (signed according to transaction type)
|
10
|
Double
|
8
|
FOREIGN_NET_AMOUNT
|
Net amount in foreign currency (signed according to transaction type)
|
10
|
Double
|
8
|
FOREIGN_RATE
|
Foreign currency exchange rate
|
10
|
Double
|
8
|
FOREIGN_TAX_AMOUNT
|
Tax amount in foreign currency (signed according to transaction type)
|
10
|
Double
|
8
|
GROSS_AMOUNT
|
Gross amount (signed according to transaction type)
|
10
|
Double
|
8
|
HEADER_NUMBER
|
Header number
|
10
|
Int64
|
4
|
INTEREST_RATE
|
Interest Rate
|
10
|
Double
|
8
|
INV_REF
|
Invoice Reference Number
|
10
|
String
|
30
|
INV_REF_NUMERIC
|
Numeric version of INV_REF (NB not always the corresponding invoice number)
|
14
|
Int64
|
4
|
ITEM_COUNT
|
No of items for this header
|
10
|
Int64
|
4
|
LAST_CHARGE_DATE
|
Date Charges Last Applied
|
10
|
Date
|
2
|
NET_AMOUNT
|
Net amount (signed according to transaction type)
|
10
|
Double
|
8
|
OUTSTANDING
|
Amount outstanding (against invoice/credit)
|
10
|
Double
|
8
|
PAID_FLAG
|
Transaction paid flag - y/n
|
10
|
String
|
1
|
PAID_STATUS
|
Transaction disputed/paid status - */p/d*/dp
|
10
|
String
|
2
|
PAYMENT
|
Amount paid (as Sales Receipt/Purchase Payment/Payment on Account)
|
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
|
SALES_PURCHASE_REF
|
Sales/Purchase Account Reference
|
10
|
String
|
8
|
SPS_REF
|
Sage Payment Solutions reference
|
14
|
String
|
40
|
TAX_AMOUNT
|
Tax amount (signed according to transaction type)
|
10
|
Double
|
8
|
TRAN_NUMBER*
|
Item number
|
10
|
Int64
|
4
|
TYPE
|
Transaction type
|
10
|
String
|
2
|
USER_NAME
|
User name
|
10
|
String
|
32
|