This tables stores all details entered or reconciled into the Bank Transaction (Bank Statement) grid of the bank reconciliation are stored in this table, including reference to amounts entered in the Cashbook and Opening Balances grid under a previous data structure to allow old bank recs to be displayed and printed.
General Ledger Cash Book Bank Reconciliation
Name |
Type |
Linked To/Supplied |
BankTransID | char (20) |
|
LastSavedDateTime | datetime | |
BankRecID | char (20) | |
LineNum | smallint | |
LineLinkRef | varchar (20) | |
StatementDate | datetime | |
LineReference | varchar (50) | |
DRAmount | float | |
CRAmount | float | |
Remark | varchar (50) | |
Reconciled | bit | |
ReconciledAmount | float |
Copyright © 2012 Jiwa Financials. All rights reserved.