project QadFinancials > class BCInvoice > business logic query CInvoiceBankByCInvoiceID

Description

Query that give some fields based on the creditor invoice or the country


Parameters


iiCInvoiceIdinteger


query condition


  each CInvoiceBank where
CInvoiceBank.CInvoice_ID = iiCInvoiceId

      first BankNumber (inner-join) where
BankNumber.BankNumber_ID = CInvoiceBank.BankNumber_ID AND


query sort order


CInvoiceBank.CInvoiceBank_ID (ascending)


query resultset tqCInvoiceBankByCInvoiceID


field namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerCInvoiceBank.BankNumber_IDBank Number
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tiBankPayFormat_IDintegerBankNumber.BankPayFormat_IDLink to BankPayFormat
tiCInvoice_IDintegerCInvoiceBank.CInvoice_IDLink to CInvoice
tiCInvoiceBank_IDintegerCInvoiceBank.CInvoiceBank_IDRecord ID
tdCInvoiceBankToPayTCdecimalCInvoiceBank.CInvoiceBankToPayTCTC Payment Amount. This field displays the payment amount in the transaction currency.


Internal usage


QadFinancials
method BCInvoiceAPMatching.ApiGetCInvoiceAPMatchingDetails
method BPaymentSelection.CalculatePaySelLineWhtMultBanks
method BPaymentSelection.GetToPayObjectsForCInvoice
method BPaymentSelection.GetToPayObjectsForCInvoiceWhtMultBanks
method BPaymentSelection.ValidateComponentPost