Maintenance
The main table for recording ledger account details.
General
Ledger
Maintenance
|
Name |
Type |
Linked To/Supplied & Supplied Values |
|
GLLedgerID |
Text (20) |
|
|
LastSavedDateTime |
Date/Time |
|
|
GLCategoryID |
Text (20) |
GL_Category.GLCategoryID |
|
AccountNo |
Text (50) |
|
|
Seg1 |
Text (20) |
|
|
Seg2 |
Text (20) |
|
|
Seg3 |
Text (20) |
|
|
Seg4 |
Text (20) |
|
|
Seg5 |
Text (20) |
|
|
Seg6 |
Text (20) |
|
|
Description |
Text (200) |
|
|
LastYearOpen |
Number (Float) |
|
|
CurrYearOpen |
Number (Float) |
|
|
NextYearOpen |
Number (Float) |
|
|
CurrBal |
Number (Float) |
|
|
ExpSign |
Yes/No |
0 = Debit;1 = Credit |
|
AccType |
Yes/No |
0 = Profit & Loss;1 = Balance Sheet |
|
AccClass |
Number (Integer) |
0 = Normal;1 = Retained Earnings;2 = Bank |
|
DistributionAcc |
Yes/No |
0 = No; 1 = Yes |
|
QuadAcc |
Yes/No |
0 = No; 1 = Yes |
|
QuadDebitGLLedgerID |
Text (20) |
GL_Ledger.GLLedgerID |
|
QuadDebitAccountNo |
Text (50) |
|
|
QuadCreditGLLedgerID |
Text (20) |
GL_Ledger.GLLedgerID |
|
QuadCreditAccountNo |
Text (50) |
|
|
ShortCut |
Text (50) |
|
|
PostingAcc |
Number (Integer) |
0 = No;1 = Yes;2 = Quad Postings |
|
ParentAccNo |
Text (50) |
|
|
UseTransCode1 |
Yes/No |
0 = No; 1 = Yes |
|
UseTransCode2 |
Yes/No |
0 = No; 1 = Yes |
|
UseTransCode3 |
Yes/No |
0 = No; 1 = Yes |
|
UseStaffCode |
Yes/No |
0 = No; 1 = Yes |
|
ClearingAccountID |
Text (20) |
GL_Ledger.GLLedgerID |
|
ClearingAccountNo |
Text (50) |
|
Copyright © 2012 Jiwa Financials. All rights reserved.