Details all creditor transactions sourced from both purchase invoices and from creditor transactions – payments, discounts, creditor invoices, debit and credit journals and notes.
Purchase Invoices, Creditor Cheque and Other Payments, Discounts, Creditor Invoices, Credit and Debit Journals and Notes
|
Name |
Type |
Linked To/Supplied & Supplied Values |
|
TransID |
Text (20) |
|
|
CreditorID |
Text (20) |
CR_Main1.CreditorID |
|
DebitCredit |
Yes/No |
|
|
Source |
Number (Integer) |
0 = Cheque Payments or Purchase Invoice;1 = Creditor Sourced Transactions;2 = Cash Book |
|
Ref |
Text (20) |
|
|
Remark |
Text (200) |
|
|
TranDate |
Date/Time |
|
|
InvRemitNo |
Text (50) |
|
|
Amount |
Number (Float) |
|
|
DiscountedAmount |
Number (Float) |
|
|
AgedOut |
Yes/No |
|
|
SourceID |
Text (20) |
CR_BatchTrans.ReceiptID; CR_BatchTrans.CBBatchID; |
|
AllocatedAmount |
Number (Float) |
|
|
InitDateTime |
Date/Time |
|
|
LastSavedDateTime |
Date/Time |
|
|
SubType |
Number (Integer) |
1 = Invoice; 2 = Debit Note; 3 = Debit Journal |
|
BatchNo |
Text (20) |
|
|
ChequePrinting |
Yes/No |
|
|
ChequeRunID |
Text (20) |
CR_BatchPayment.CR_BatchPayID |
|
DueDate |
Date/Time |
|
|
HomeAmount |
Number (Float) |
|
|
CurrencyRateUsed |
Number (Float) |
|
|
FXAllocAmount |
Number (Float) |
|
|
GSTAmount |
Number (Float) |
|
|
RealisedGainLoss |
Number (Float) |
|
|
UnRealisedGainLoss |
Number (Float) |
|
|
FXDecimalPlaces |
Number (Integer) |
|
|
DecimalPlaces |
Number (Integer) |
|
|
CurrencyID |
Text (20) |
FX_Currency.CurrencyID |
Copyright © 2012 Jiwa Financials. All rights reserved.