This tables stores the line details for each journal set. The bank reconciliation process uses the data in this table as the source of Jiwa transactions for reconciling purposes.
Journal sets
Name |
Type |
Linked To/Supplied |
GLTransactionID |
Text (20) |
|
GLSetID |
Text (20) |
GL_Set.GLSetID |
GLLedgerID |
Text (20) |
GL_Ledger.GLLedgerID |
DebitCredit |
Yes/No |
0 = Debit; = Credit |
Amount |
Number (Float) |
|
Ref |
Text (20) |
|
Remark |
Text (200) |
|
LineNum |
Number (Integer) |
|
TransCode1ID |
Text (20) |
GL_TransCode.GLTranCodeID |
TransCode2ID |
Text (20) |
GL_TransCode.GLTranCodeID |
TransCode3ID |
Text (20) |
GL_TransCode.GLTranCodeID |
StaffID |
Text (20) |
HR_Staff.StaffID |
Allocated |
Yes/No |
0 = No; 1 = Yes |
Reconciled |
Yes/No |
0 = No; 1 = Yes |
Cleared |
Yes/No |
0 = No; 1 = Yes |
TransPostDateTime |
Date/Time |
|
JobNo |
Text (20) |
|
Copyright © 2012 Jiwa Financials. All rights reserved.