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

DB_BatchTrans

Purpose    

The table records the header details for all debtor transactions - receipts, journals, discounts etc, available from the Debtor Transaction Form Tab or from the Debtor menu options - Receipts and Invoices

Path           

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

Name

Type

Linked To/Supplied & Supplied Values

ReceiptID 

Text (20)

 

LastSavedDateTime 

Date/Time

 

JiwaUser 

Text (50)

 

ReceiptDate 

Date/Time

 

BatchNum 

Text (50)

 

ReceiptType 

Number (Integer)

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

ReceiptStatus 

Number (Integer)

0 = Entered;1 = Activated

BatchType 

Number (Integer)

0 = Normal;1 = Template

RepeatingType 

Number (Integer)

0 = None;1 = Day;2 = Month

RepeatingUnits 

Number (Integer)

 

NextRepeatingDate 

Date/Time

 

RepeatingWillEnd 

Yes/No

 

RepeatingEndDate 

Date/Time

 

Description

Text (250)

 

GroupBank 

Number (Integer)

 

Copyright © 2012 Jiwa Financials. All rights reserved.