Cash Book Bank Reconciliation
This table stores transactions that are entered as Opening Transactions, the status of the transaction and amount reconciled.
General Ledger Cash Book Bank Reconciliation
|
Name |
Type |
Linked To/Supplied |
| OpeningBalanceTransactionID | char (36) |
|
| BankRecID | char (36) | BR_Main.BankRecID |
| CreatedByStaffID | char (20) | HR_Staff.StaffID |
| CreatedDateTime | datetime | |
| LastSavedByStaffID | char (20) | HR_Staff.StaffID |
| LastSavedDateTime | datetime | |
| LineNumber | int | |
| TransactionDateTime | datetime | |
| Status | tinyint | 0 = Unreconciled 1 = Reconciled 2 = Cleared |
| AmountReconciledIncGST | decimal (19,6) | |
| Reference | varchar (50) | |
| DebitCredit | tinyint | |
| Remark | varchar (50) | |
| AmountIncGST | decimal (19,6) | |
| PreviousBankRecID | char (36) | BR_Main.BankRecID |
Copyright © 2012 Jiwa Financials. All rights reserved.