Line details for cheque payments including foreign currency information made for purchase and creditor invoices
Creditors Payments Cheque Payments
Name |
Type |
Linked To/Supplied |
CR_BatchPayLinesID |
Text (20) |
|
CR_BatchPayID |
Text (20) |
CR_BatchPayment.CR_BatchPayID |
CR_TransID |
Text (20) |
CR_Trans.TransID |
HomePaymentMade |
Number (Float) |
|
BatchLineNo |
Number (Integer) |
|
HistoryText |
Text (100) |
|
PaymentTransID |
Text (20) |
CR_Trans.TransID |
ChequeNo |
Text (20) |
|
LedgerID |
Text (20) |
GL_Ledger.GLLedgerID |
HomePaymentExpected |
Number (Float) |
|
SuppliersPayment |
Number (Float) |
|
CurrencyRateUsed |
Number (Float) |
|
FXShortCode |
Text (3) |
FX_Currency.ShortDescription |
DiscountAmount |
Number (Float) |
|
HomeDiscountAmount |
Number (Float) |
|
GSTID |
Text (20) |
|
GSTAmount |
Number (Float) |
|
GSTRate |
Number (Float) |
|
DiscountLedgerID |
Text (20) |
|
LastSavedDateTime |
Date/Time |
|
CurrencyID |
Text (20) |
|
UnrealisedGainLoss |
Number (Float) |
|
RealisedGainLoss |
Number (Float) |
|
PaymentFromBankFXAmount |
Number (Float) |
|
BankLedgerID |
Text (20) |
|
FeeAmount |
Number (Float) |
|
FeeGSTID |
Text (20) |
|
FeeGSTRate |
Number (Float) |
|
FeeGSTAmount |
Number (Float) |
|
FeeIncGSTAmount |
Number (Float) |
|
LineNumber |
Number (Integer) |
|
CR_TransOutstandingAmount |
Number (Float) |
|
CR_TransOutstandingFXAmount |
Number (Float) |
|
EFTReference |
Text (255) |
|
Copyright © 2012 Jiwa Financials. All rights reserved.