project QadFinancials > class BDInvoice > business logic query DInvoiceBankByDInvoiceID

Parameters


iiDInvoiceIdinteger

query condition


  each DInvoiceBank where
DInvoiceBank.DInvoice_ID = iiDInvoiceId

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

query resultset tqDInvoiceBankByDInvoiceID


field namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerDInvoiceBank.BankNumber_IDFormatted Bank Account No
tiBankPayFormat_IDintegerBankNumber.BankPayFormat_IDLink to BankPayFormat
tiDInvoice_IDintegerDInvoiceBank.DInvoice_IDLink to DInvoice
tiDInvoiceBank_IDintegerDInvoiceBank.DInvoiceBank_IDRecord ID
tdDInvoiceBankToPayTCdecimalDInvoiceBank.DInvoiceBankToPayTCTC Payment Amount. This field displays the payment amount in the transaction currency.

Internal usage


QadFinancials
method BBill.GetToBillDInvoice
method BDDocument.GetPossibleAllocationsByBank
method BDDocument.ValidateComponentPost
method BDPaymentSelection.DPaySelLineCalcValues
method BDPaymentSelection.GetToPayObjects