You are here: Reference Guide > Table Structures > Cash Book & Bank Reconciliation Tables Overview

Cash Book and Bank Reconciliation

The header details for each bank reconciliation form are maintained in BR_Main.  Details recorded in the cashbook grid of the form are maintained in BR_CBTrans.  BR_Transactions stores details of the Jiwa transactions, including opening and cleared records and BR_BankTrans maintains records entered or reconciled into the banking grid of the reconciliation form.  The relationship between the Jiwa transactions and banking records is maintained in BR_JBRelationship.

Cash Book & Bank Reconciliation Diagram

 

Cashbook header details are stored in CB_BatchTrans and line detail information is maintained in CB_BatchTranLines.

Copyright © 2012 Jiwa Financials. All rights reserved.

Bank Reconciliation

BR_BankTransOLD

BR_CBTransAllocsOLD

BR_CBTransOLD

BR_CustomSetting

BR_CustomSettingValues

BR_DirectCreditorPaymentAllocations

BR_DirectCreditorPayments

BR_DirectCreditorReceipts

BR_DirectDebtorPayments

BR_DirectDebtorReceiptAllocations

BR_DirectDebtorReceipts

BR_DirectGLTransactions

BR_Documents

BR_DocumentTypes

BR_GLTransactions

BR_CBTrans

BR_JBRelationship

BR_Transactions

BR_OpeningBalanceTransactions

BR_MainOLD

BR_Main

CashBook Receipts and Payments

CB_BatchTranLines

CB_BatchTranLinesAllocs

CB_BatchTrans

CB_CustomSetting

CB_CustomSettingValues

CB_Documents

CB_Notes