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
| iiCInvoiceID | integer | supplier Invoice ID |
| ilPayFormatTypeIsSEPA | logical | is 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 name | data type | db field | description |
|---|
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| tiCInvoice_ID | integer | CInvoiceBank.CInvoice_ID | Link to CInvoice |
| tcPayFormatTypeCode | character | PayFormatType.PayFormatTypeCode | Format Name |
| tlPayFormatTypeIsSEPA | logical | PayFormatType.PayFormatTypeIsSEPA | SEPA |
Internal usage
QadFinancials