The table records the header details for all creditor transactions – payments, journals, discounts etc, available from the Creditor Transaction Form Tab or from the Creditor menu options – Invoices and Payments with the exception of cheque payments. These transactions are stored in CR_BatchPayment and CR_BatchPayLines
Creditor Payments, Creditor Discounts, Creditor Invoices, Creditor Credit and Debit Journals and Notes
|
Name |
Type |
Linked To/Supplied |
|
ReceiptID |
Text (20) |
|
|
LastSavedDateTime |
Date/Time |
|
|
JiwaUser |
Text (50) |
|
|
ReceiptDate |
Date/Time |
|
|
BatchNum |
Text (50) |
|
|
ReceiptType |
Number (Integer) |
1 = Purchase; 2 = Debit Note3 = Debit Journal; 4
= Payment;5 = Credit Note; 6 = Credit Journal |
|
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) |
|
|
GroupOtherLedger |
Number (Integer) |
|
|
GroupCRLedger |
Yes/No |
|
Copyright © 2012 Jiwa Financials. All rights reserved.