project QadFinancials > class BCDocumentReport > business logic query GetPayFormatByPaySelCode
Description
Retrieve the Pay Format with the Payment Selection Code
Parameters
| iiCompanyId | integer | Company id |
| icPaySelCode | character | |
query condition
each PaySel where
PaySel.Company_Id = iiCompanyId AND
PaySel.PaySelCode = icPaySelCode
first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = PaySel.BankPayFormat_ID AND
first BankNumber (inner-join) where
BankNumber.BankNumber_ID = BankPayFormat.BankNumber_ID AND
query resultset tqGetPayFormatByPaySelCode
| field name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankPayFormat_ID | integer | BankPayFormat.BankPayFormat_ID | Record ID |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
| tiPaySel_ID | integer | PaySel.PaySel_ID | Record ID |
| tcPaySelCode | character | PaySel.PaySelCode | Code |
Internal usage
QadFinancials