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

DB_AutoTranLines

Purpose

Records the line details, including the destination batch number, of each automatic transactions.

Path              

Debtors Auto Transactions

Name

Type

Linked To/Supplied & Supplied Values

DBAutoTranLineID 

Text (20)

 

DBAutoTranID 

Text (20)

DB_AutoTran.DBAutoTranID 

SourceDBBatchID 

Text (20)

DB_BatchTrans.ReceiptID 

SourceBatchNo Text (20)  

SourceReceiptType 

Text (20)

1 = Receipt; 2 = Credit Note;3 = Credit Journal;4 = Invoice;5 = Debit Note;6 = Debit Journal;7 = Discount

SourceDesc 

Text (250)

 

PostingDue 

Date/Time

 

Reason

Text (50)

 

DestDBBatchID 

Text (20)

DB_BatchTrans.ReceiptID 

DestBatchNo 

Text (20)

 

LineNum 

Number (Integer)

 

Copyright © 2012 Jiwa Financials. All rights reserved.