Cash Book Bank Reconciliation
This table stores the reconciled details and status of each General Ledger transaction as it appears for reconciliation
General Ledger Cash Book Bank Reconciliation
|
Name |
Type |
Linked To/Supplied |
| BRGLTransactionID | 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 |
| GLTransactionID | char (20) | GL_Transaction.GLTransactionID |
| AmountReconciledIncGST | decimal (19,6) | |
| Reference | varchar (50) | |
| DebitCredit | tinyint | |
| Remark | varchar (50) | |
| AmountIncGST | decimal (19,6) | |
| FirstAppearanceBankRecID | char (36) | BR_Main.BankRecID |
Copyright © 2012 Jiwa Financials. All rights reserved.