You are here: Reference Guide > Table Structures > Cash Book > BR_DirectGLTransactions

BR_DirectGLTransactions

Purpose    

Records the details on direct General Ledger transactions entered and reconciled in the bank reconciliation forms

Path         

General  Ledger Cash Book Bank Reconciliation

Name

Type

Linked To/Supplied

DirectGLTransactionID 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  
AmountIncGST decimal (19,6)  
DebitCredit tinyint  
Remark varchar (50)  
Status tinyint  
GLLedgerID char (20) GL_Ledger.GLLedgerID
TransactionType tinyint SO_PaymentTypes.PaymentType
Reference varchar (50)  
PaymentTypeID char (20)  
TaxID char (20) TX_Main.TaxID
TaxRate decimal (19,6)  
TaxAmount decimal (19,6)  
AmountReconciledIncGST decimal (19,6)  

Copyright © 2012 Jiwa Financials. All rights reserved.