Cash Book 
BankReconciliationThis table stores the details of the Jiwa transaction side of the reconciliation – including cleared and opening transaction and excluding cashbook details. Linking to the originating General Ledger sets is also stored in this table.
General Ledger Cash Book BankReconciliation
|
Name |
Type |
Linked To/Supplied |
|
TransactionsID |
char (20) |
|
|
LastSavedDateTime |
datetime |
|
|
BankRecID |
char (20) |
BR_Main.BankRecID |
|
LineNum |
smallint |
|
|
LineLinkRef |
varchar (20) |
|
|
TransDate |
datetime |
|
|
LineReference |
varchar (50) |
|
|
DRAmount |
Number (Float) |
|
|
CRAmount |
Number (Float) |
|
|
Remark |
varchar (50) |
|
|
Reconciled |
bit |
0 = No 1 = Yes |
|
Cleared |
bit |
0 = No 1 = Yes |
|
Opening |
bit |
0 = No 1 = Yes |
|
GLTransID |
char (20) |
GL_Transactions.GLTransactionID |
|
GLSetID |
char (20) |
GL_Sets.GLSetID |
|
GLLedgerID |
char (20) |
GL_Ledger.GLLedgerID |
|
ReconciledAmount |
float |
|
Copyright © 2012 Jiwa Financials. All rights reserved.