You are here: Reference Guide > Table Structures > Debtors > DB_BatchTranLines

DB_BatchTranLines

Purpose       

The table records the batch transaction details for all debtor transaction batches.

Path    

Debtor Receipts, Debtor Discounts, Debtor Invoices, Debtor Credit and Debit Journals and  Notes 

Name Type Linked To/Supplied
ReceiptLineID char (20)  
ReceiptID char (20)  
LastSavedDateTime datetime  
AccountID char (20)  
LedgerID char (20)  
LineReference varchar (200)  
Remark] varchar (200)  
RemitNo varchar (50)  
Amount float  
DBTransID char (20)  
LineNum int  
OtherLedgerID char (20)  
OtherAmount float  
ReceiptDate datetime  
BankName varchar (50)  
BankAcc varchar (50)  
BSBN char (20)  
AccountName varchar (50)  
ParentAccountID char (20)  
TaxID char (20)  
TaxRate float  
TaxAmount float  
TaxLedgerID char (20)  
DiscountAmount float  
DiscountLedgerID char (20)  
DiscountTransID char (20)  
HomeTaxID char (20)  
HomeTaxRate float  
HomeTaxAmount float  
DiscountTaxID char (20)  
DiscountTaxRate float  
DiscountTaxAmount flaot  
DueDate datetime  

Copyright © 2012 Jiwa Financials. All rights reserved.