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
|
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_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
|
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_TAX_AMOUNT
|
Tax amount in foreign currency (signed according to transaction type)
|
10
|
Double
|
8
|
FUND_ID
|
Fund ID
|
12
|
Int64
|
4
|
GROSS_AMOUNT
|
Gross amount (signed according to transaction type)
|
10
|
Double
|
8
|
HEADER_NUMBER
|
Header number
|
10
|
Int64
|
4
|
INV_REF
|
Invoice Reference Number
|
10
|
String
|
30
|
NET_AMOUNT
|
Net amount (signed according to transaction type)
|
10
|
Double
|
8
|
NOMINAL_CODE
|
Nominal Code
|
10
|
String
|
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)
|
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
|
SPLIT_NUMBER*
|
Split number
|
10
|
Int64
|
4
|
STMT_TEXT
|
Text for summary statements
|
10
|
String
|
60
|
TAX_AMOUNT
|
Tax amount (signed according to transaction type)
|
10
|
Double
|
8
|
TAX_CODE
|
Tax code (T0 to T99)
|
10
|
String
|
3
|
TRAN_NUMBER
|
Transaction number
|
11
|
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
|