project QadFinancials > class BBankPayFormat > business logic query BankPayFormatByModuleInstrument
Description
Return bank number and payment format based on Module type Payment Instrument, and company
Parameters
| iiCompanyId | integer | Company id |
| icPayFormatTypeModule | character | |
| icPayFormatTypePayInstrument | character | |
query condition
each BankPayFormat where
first BankNumber (inner-join) where
BankNumber.BankNumber_ID = BankPayFormat.BankNumber_ID AND
first CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber.CompanySharedSet_ID AND
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND
first PayFormatType (inner-join) where
PayFormatType.PayFormatTypeCode = BankPayFormat.PayFormatTypeCode AND
PayFormatType.PayFormatTypeModule = icPayFormatTypeModule AND
PayFormatType.PayFormatTypePayInstrument = icPayFormatTypePayInstrument
query resultset tqBankPayFormatByModuleInst
| field name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankPayFormat_ID | integer | BankPayFormat.BankPayFormat_ID | Record ID |
| tiBankPayFormatNextCheckNbr | integer | BankPayFormat.BankPayFormatNextCheckNbr | Next Pre-Printed Number |
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
| tcPayFormatTypeModule | character | PayFormatType.PayFormatTypeModule | Module |
| tcPayFormatTypePayInstrument | character | PayFormatType.PayFormatTypePayInstrument | Payment Instrument |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(BankPayFormat),rowid(BankNumber),rowid(CompanySharedSet),rowid(Company),rowid(PayFormatType) |
Internal usage
QadFinancials