This table stores details of new Cash Book transactions entered into the system via the bank reconciliation form. Activation of the form creates journal set(s) for the reconciled cash book entries
General Ledger Cash Book BankReconciliation
Name |
Type |
Linked To/Supplied |
CBTransID |
Text (20) |
|
LastSavedDateTime |
Date/Time |
|
BankRecID |
Text (20) |
BR_Main.BankRecID |
LineNum |
Number (Integer) |
|
LineLinkRef |
Text (20) |
|
TransDate |
Date/Time |
|
LineReference |
Text (50) |
|
DRAmount |
Number (Float) |
|
CRAmount |
Number (Float) |
|
Remark |
Text (50) |
|
Reconciled |
Yes/No |
0 = No 1 = Yes |
LedgerID |
Text (20) |
GL_Ledger.GLLedgerID |
LedgerAcc |
Text (50) |
|
DebtorCreditor |
Number (Integer) |
|
DebtorCreditorID |
Text (20) |
|
ReceiptPayment |
Number (Integer) |
|
TransType |
Text (20) |
|
DiscountLedgerID |
Text (20) |
|
HomeDiscountTaken |
Number (Float) |
|
SupplierAmount |
Number (Float) |
|
CurrencyRateUsed |
Number (Float) |
|
SupplierDiscountTaken |
Number (Float) |
|
ParentDebtorID |
Text (20) |
|
BankName |
Text (50) |
|
BankAcc |
Text (50) |
|
BSBN |
Text (20) |
|
AccountName |
Text (50) |
|
AllocatedAmount |
Number (Float) |
|
PaymentTypeID |
Text (20) |
|
Approval |
Text (255) |
|
HomeTaxID |
Text (20) |
|
HomeTaxAmount |
Number (Float) |
|
HomeTaxRate |
Number (Float) |
|
DiscountTaxID |
Text (20) |
|
DiscountTaxAmount |
Number (Float) |
|
DiscountTaxRate |
Number (Float) |
|
Copyright © 2012 Jiwa Financials. All rights reserved.