Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
ACCOUNT_REF*
|
Account Code
|
10
|
String
|
8
|
NAME
|
Name
|
10
|
String
|
60
|
ACCOUNT_TYPE
|
Account Type Code
|
10
|
Int16
|
1
|
BALANCE
|
Balance
|
10
|
Double
|
8
|
QUICK_RATIO
|
Account in Quick Ratio
|
10
|
Boolean
|
1
|
SOFA_ID
|
Sofa Category ID
|
12
|
Int32
|
4
|
PRIOR_YR_MTH1
|
Prior Year Month 1
|
10
|
Double
|
8
|
PRIOR_YR_MTH2
|
Prior Year Month 2
|
10
|
Double
|
8
|
PRIOR_YR_MTH3
|
Prior Year Month 3
|
10
|
Double
|
8
|
PRIOR_YR_MTH4
|
Prior Year Month 4
|
10
|
Double
|
8
|
PRIOR_YR_MTH5
|
Prior Year Month 5
|
10
|
Double
|
8
|
PRIOR_YR_MTH6
|
Prior Year Month 6
|
10
|
Double
|
8
|
PRIOR_YR_MTH7
|
Prior Year Month 7
|
10
|
Double
|
8
|
PRIOR_YR_MTH8
|
Prior Year Month 8
|
10
|
Double
|
8
|
PRIOR_YR_MTH9
|
Prior Year Month 9
|
10
|
Double
|
8
|
PRIOR_YR_MTH10
|
Prior Year Month 10
|
10
|
Double
|
8
|
PRIOR_YR_MTH11
|
Prior Year Month 11
|
10
|
Double
|
8
|
PRIOR_YR_MTH12
|
Prior Year Month 12
|
10
|
Double
|
8
|
PRIOR_YR2_MTH1
|
Prior Year 2 Month 1
|
10
|
Double
|
8
|
PRIOR_YR2_MTH2
|
Prior Year 2 Month 2
|
10
|
Double
|
8
|
PRIOR_YR2_MTH3
|
Prior Year 2 Month 3
|
10
|
Double
|
8
|
PRIOR_YR2_MTH4
|
Prior Year 2 Month 4
|
10
|
Double
|
8
|
PRIOR_YR2_MTH5
|
Prior Year 2 Month 5
|
10
|
Double
|
8
|
PRIOR_YR2_MTH6
|
Prior Year 2 Month 6
|
10
|
Double
|
8
|
PRIOR_YR2_MTH7
|
Prior Year 2 Month 7
|
10
|
Double
|
8
|
PRIOR_YR2_MTH8
|
Prior Year 2 Month 8
|
10
|
Double
|
8
|
PRIOR_YR2_MTH9
|
Prior Year 2 Month 9
|
10
|
Double
|
8
|
PRIOR_YR2_MTH10
|
Prior Year 2 Month 10
|
10
|
Double
|
8
|
PRIOR_YR2_MTH11
|
Prior Year 2 Month 11
|
10
|
Double
|
8
|
PRIOR_YR2_MTH12
|
Prior Year 2 Month 12
|
10
|
Double
|
8
|
PRIOR_YR3_MTH1
|
Prior Year 3 Month 1
|
10
|
Double
|
8
|
PRIOR_YR3_MTH2
|
Prior Year 3 Month 2
|
10
|
Double
|
8
|
PRIOR_YR3_MTH3
|
Prior Year 3 Month 3
|
10
|
Double
|
8
|
PRIOR_YR3_MTH4
|
Prior Year 3 Month 4
|
10
|
Double
|
8
|
PRIOR_YR3_MTH5
|
Prior Year 3 Month 5
|
10
|
Double
|
8
|
PRIOR_YR3_MTH6
|
Prior Year 3 Month 6
|
10
|
Double
|
8
|
PRIOR_YR3_MTH7
|
Prior Year 3 Month 7
|
10
|
Double
|
8
|
PRIOR_YR3_MTH8
|
Prior Year 3 Month 8
|
10
|
Double
|
8
|
PRIOR_YR3_MTH9
|
Prior Year 3 Month 9
|
10
|
Double
|
8
|
PRIOR_YR3_MTH10
|
Prior Year 3 Month 10
|
10
|
Double
|
8
|
PRIOR_YR3_MTH11
|
Prior Year 3 Month 11
|
10
|
Double
|
8
|
PRIOR_YR3_MTH12
|
Prior Year 3 Month 12
|
10
|
Double
|
8
|
PRIOR_YR4_MTH1
|
Prior Year 4 Month 1
|
10
|
Double
|
8
|
PRIOR_YR4_MTH2
|
Prior Year 4 Month 2
|
10
|
Double
|
8
|
PRIOR_YR4_MTH3
|
Prior Year 4 Month 3
|
10
|
Double
|
8
|
PRIOR_YR4_MTH4
|
Prior Year 4 Month 4
|
10
|
Double
|
8
|
PRIOR_YR4_MTH5
|
Prior Year 4 Month 5
|
10
|
Double
|
8
|
PRIOR_YR4_MTH6
|
Prior Year 4 Month 6
|
10
|
Double
|
8
|
PRIOR_YR4_MTH7
|
Prior Year 4 Month 7
|
10
|
Double
|
8
|
PRIOR_YR4_MTH8
|
Prior Year 4 Month 8
|
10
|
Double
|
8
|
PRIOR_YR4_MTH9
|
Prior Year 4 Month 9
|
10
|
Double
|
8
|
PRIOR_YR4_MTH10
|
Prior Year 4 Month 10
|
10
|
Double
|
8
|
PRIOR_YR4_MTH11
|
Prior Year 4 Month 11
|
10
|
Double
|
8
|
PRIOR_YR4_MTH12
|
Prior Year 4 Month 12
|
10
|
Double
|
8
|
PRIOR_YR5_MTH1
|
Prior Year 5 Month 1
|
10
|
Double
|
8
|
PRIOR_YR5_MTH2
|
Prior Year 5 Month 2
|
10
|
Double
|
8
|
PRIOR_YR5_MTH3
|
Prior Year 5 Month 3
|
10
|
Double
|
8
|
PRIOR_YR5_MTH4
|
Prior Year 5 Month 4
|
10
|
Double
|
8
|
PRIOR_YR5_MTH5
|
Prior Year 5 Month 5
|
10
|
Double
|
8
|
PRIOR_YR5_MTH6
|
Prior Year 5 Month 6
|
10
|
Double
|
8
|
PRIOR_YR5_MTH7
|
Prior Year 5 Month 7
|
10
|
Double
|
8
|
PRIOR_YR5_MTH8
|
Prior Year 5 Month 8
|
10
|
Double
|
8
|
PRIOR_YR5_MTH9
|
Prior Year 5 Month 9
|
10
|
Double
|
8
|
PRIOR_YR5_MTH10
|
Prior Year 5 Month 10
|
10
|
Double
|
8
|
PRIOR_YR5_MTH11
|
Prior Year 5 Month 11
|
10
|
Double
|
8
|
PRIOR_YR5_MTH12
|
Prior Year 5 Month 12
|
10
|
Double
|
8
|
BUDGET_MTH1
|
Budget Month 1
|
10
|
Double
|
8
|
BUDGET_MTH2
|
Budget Month 2
|
10
|
Double
|
8
|
BUDGET_MTH3
|
Budget Month 3
|
10
|
Double
|
8
|
BUDGET_MTH4
|
Budget Month 4
|
10
|
Double
|
8
|
BUDGET_MTH5
|
Budget Month 5
|
10
|
Double
|
8
|
BUDGET_MTH6
|
Budget Month 6
|
10
|
Double
|
8
|
BUDGET_MTH7
|
Budget Month 7
|
10
|
Double
|
8
|
BUDGET_MTH8
|
Budget Month 8
|
10
|
Double
|
8
|
BUDGET_MTH9
|
Budget Month 9
|
10
|
Double
|
8
|
BUDGET_MTH10
|
Budget Month 10
|
10
|
Double
|
8
|
BUDGET_MTH11
|
Budget Month 11
|
10
|
Double
|
8
|
BUDGET_MTH12
|
Budget Month 12
|
10
|
Double
|
8
|
BALANCE_BF
|
Balance Brought forward
|
10
|
Double
|
8
|
BALANCE_MTH1
|
Balance Month 1
|
10
|
Double
|
8
|
BALANCE_MTH2
|
Balance Month 2
|
10
|
Double
|
8
|
BALANCE_MTH3
|
Balance Month 3
|
10
|
Double
|
8
|
BALANCE_MTH4
|
Balance Month 4
|
10
|
Double
|
8
|
BALANCE_MTH5
|
Balance Month 5
|
10
|
Double
|
8
|
BALANCE_MTH6
|
Balance Month 6
|
10
|
Double
|
8
|
BALANCE_MTH7
|
Balance Month 7
|
10
|
Double
|
8
|
BALANCE_MTH8
|
Balance Month 8
|
10
|
Double
|
8
|
BALANCE_MTH9
|
Balance Month 9
|
10
|
Double
|
8
|
BALANCE_MTH10
|
Balance Month 10
|
10
|
Double
|
8
|
BALANCE_MTH11
|
Balance Month 11
|
10
|
Double
|
8
|
BALANCE_MTH12
|
Balance Month 12
|
10
|
Double
|
8
|
BALANCE_FUTURE
|
Balance for Future
|
10
|
Double
|
8
|
DEBIT_BF
|
Debit Brought Forward
|
10
|
Double
|
8
|
DEBIT_MTH1
|
Debit Month 1
|
10
|
Double
|
8
|
DEBIT_MTH2
|
Debit Month 2
|
10
|
Double
|
8
|
DEBIT_MTH3
|
Debit Month 3
|
10
|
Double
|
8
|
DEBIT_MTH4
|
Debit Month 4
|
10
|
Double
|
8
|
DEBIT_MTH5
|
Debit Month 5
|
10
|
Double
|
8
|
DEBIT_MTH6
|
Debit Month 6
|
10
|
Double
|
8
|
DEBIT_MTH7
|
Debit Month 7
|
10
|
Double
|
8
|
DEBIT_MTH8
|
Debit Month 8
|
10
|
Double
|
8
|
DEBIT_MTH9
|
Debit Month 9
|
10
|
Double
|
8
|
DEBIT_MTH10
|
Debit Month 10
|
10
|
Double
|
8
|
DEBIT_MTH11
|
Debit Month 11
|
10
|
Double
|
8
|
DEBIT_MTH12
|
Debit Month 12
|
10
|
Double
|
8
|
DEBIT_FUTURE
|
Debit for Future
|
10
|
Double
|
8
|
CREDIT_BF
|
Credit Brought Forward
|
10
|
Double
|
8
|
CREDIT_MTH1
|
Credit Month 1
|
10
|
Double
|
8
|
CREDIT_MTH2
|
Credit Month 2
|
10
|
Double
|
8
|
CREDIT_MTH3
|
Credit Month 3
|
10
|
Double
|
8
|
CREDIT_MTH4
|
Credit Month 4
|
10
|
Double
|
8
|
CREDIT_MTH5
|
Credit Month 5
|
10
|
Double
|
8
|
CREDIT_MTH6
|
Credit Month 6
|
10
|
Double
|
8
|
CREDIT_MTH7
|
Credit Month 7
|
10
|
Double
|
8
|
CREDIT_MTH8
|
Credit Month 8
|
10
|
Double
|
8
|
CREDIT_MTH9
|
Credit Month 9
|
10
|
Double
|
8
|
CREDIT_MTH10
|
Credit Month 10
|
10
|
Double
|
8
|
CREDIT_MTH11
|
Credit Month 11
|
10
|
Double
|
8
|
CREDIT_MTH12
|
Credit Month 12
|
10
|
Double
|
8
|
CREDIT_FUTURE
|
Credit for Future
|
10
|
Double
|
8
|
RECORD_CREATE_DATE
|
Date and time when the record was created.
|
2009
|
Date
|
8
|
RECORD_MODIFY_DATE
|
Date and time when the record was modified.
|
2009
|
Date
|
8
|
RECORD_DELETED
|
Flag denoting if the record has been deleted or not.
|
2009
|
Boolean
|
2
|
* Denotes the primary key field used to distinguish unique records.
|