Header details for each bank reconciliation form, including status and opening and closing balances, are stored in this table.
General Ledger Cash Book BankReconciliation
Name |
Type |
Linked To/Supplied |
BankRecID |
char (36) |
|
BankRecNo |
varchar (20) |
|
Reference |
var char (255) |
|
BankAccountLedgerID |
char (20) |
|
BankStatementDate |
datetime |
|
Status |
int |
0 = Entered;1 = Activated |
CreatedByStaffID |
char (20) |
HR_Staff_StaffID |
CreatedDateTime |
datetime |
|
LastSavedByStaffID |
char (20) |
|
LastSavedDateTime |
datetime |
|
BankStatementOpeningBalance |
decimal (19,6) |
|
BankAccountLedgerCurrentBalance |
decimal (19,6) |
|
BankStatementClosingBalance |
decimal (19,6) |
|
BankAccountLedgerBalanceBroughtForward |
decimal (19,6) |
|
Copyright © 2012 Jiwa Financials. All rights reserved.