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

BR_DirectDebtorPayments

Purpose    

Records details of any direct debtor payments entered and reconciled in the bank reconciliation forms.

Path         

General  Ledger Cash Book Bank Reconciliation

Name

Type

Linked To/Supplied

DirectDebtorPaymentID 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
DebtorID char (20) DB_Main.DebtorID
ParentDebtorID char (20) DB_Main.ParentDebtorID
BankName varchar (50)  
BankAccountNo varchar (50)  
BSBN varchar (50)  
BankAccountName varchar (50)  
AmountReconciledIncGST decimal (19, 6)  
Reference varchar (50)  
PaymentTypeID varchar (20)  
TaxID char (20) TX_Main.TaxID
TaxRate decimal (19, 6)  
TaxAmount decimal (19, 6)  
InvoiceNo varchar (50)  

 

Copyright © 2012 Jiwa Financials. All rights reserved.