project QadFinancials > class BCInvoice > business logic query CInvoiceBankForSEPA

Description

check if the payment format linked to the supplier invoice is a sepa payment format, based on the input parameter


Parameters


iiCInvoiceIDintegersupplier Invoice ID
ilPayFormatTypeIsSEPAlogicalis the payment format type a sepa payment format ?


query condition


  each CInvoiceBank where
CInvoiceBank.CInvoice_ID = iiCInvoiceID

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

          first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND

              first PayFormatType (inner-join) where
PayFormatType.PayFormatTypeCode = BankPayFormat.PayFormatTypeCode AND
PayFormatType.PayFormatTypeIsSEPA = ilPayFormatTypeIsSEPA


query resultset tqCInvoiceBankForSEPA


field namedata typedb fielddescription
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tiCInvoice_IDintegerCInvoiceBank.CInvoice_IDLink to CInvoice
tcPayFormatTypeCodecharacterPayFormatType.PayFormatTypeCodeFormat Name
tlPayFormatTypeIsSEPAlogicalPayFormatType.PayFormatTypeIsSEPASEPA


Internal usage


QadFinancials
method BPaymentSelection.FillProDataSetPayment