project QadFinancials > class BBankPayFormat > business logic query BankPayFormatByModuleInstrument

Description

Return bank number and payment format based on Module type Payment Instrument, and company


Parameters


iiCompanyIdintegerCompany id
icPayFormatTypeModulecharacter
icPayFormatTypePayInstrumentcharacter


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 namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankPayFormat_IDintegerBankPayFormat.BankPayFormat_IDRecord ID
tiBankPayFormatNextCheckNbrintegerBankPayFormat.BankPayFormatNextCheckNbrNext Pre-Printed Number
tiCompany_IDintegerCompany.Company_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tcPayFormatTypeCodecharacterBankPayFormat.PayFormatTypeCodePayment Format
tcPayFormatTypeModulecharacterPayFormatType.PayFormatTypeModuleModule
tcPayFormatTypePayInstrumentcharacterPayFormatType.PayFormatTypePayInstrumentPayment Instrument
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(BankPayFormat),rowid(BankNumber),rowid(CompanySharedSet),rowid(Company),rowid(PayFormatType)


Internal usage


QadFinancials
method BCDocumentReport.GetBusinessFields