project QadFinancials > class BDDocumentReport > business logic query GetBankPayCodeByInvID

Parameters


iiInvoiceIdinteger

query condition


  each DInvoiceBank where
DInvoiceBank.DInvoice_ID = iiInvoiceId

      each DInvoiceBankPayCode (inner-join) where
DInvoiceBankPayCode.DInvoiceBank_ID = DInvoiceBank.DInvoiceBank_ID AND

          first PayFormatCode (inner-join) where
PayFormatCode.PayFormatCode_ID = DInvoiceBankPayCode.PayFormatCode_ID AND

          first PayFormatGroup (inner-join) where
PayFormatGroup.PayFormatGroup_ID = DInvoiceBankPayCode.PayFormatGroup_ID AND

query resultset tqGetBankPayCodeByInvID


field namedata typedb fielddescription
tiBankNumber_IDintegerDInvoiceBank.BankNumber_IDFormatted Bank Account No
tiDInvoice_IDintegerDInvoiceBank.DInvoice_IDLink to DInvoice
tiDInvoiceBank_IDintegerDInvoiceBank.DInvoiceBank_IDRecord ID
tcPayFormatCodecharacterPayFormatCode.PayFormatCodeAttribute Value
tiPayFormatCode_IDintegerDInvoiceBankPayCode.PayFormatCode_IDLink to PayFormatCode
tcPayFormatCodeDescriptioncharacterPayFormatCode.PayFormatCodeDescriptionDescription
tiPayFormatGroup_IDintegerDInvoiceBankPayCode.PayFormatGroup_IDLink to PayFormatGroup
tcPayFormatTypeCodecharacterPayFormatGroup.PayFormatTypeCodePayment Format Type

Internal usage


QadFinancials
method BDDocumentReport.DDocumentReportDraft