project QadFinancials > class BBankNumber > business logic query BankNumberByBankFileFormat

Description

Get the Payment Format of the Customer base on the BankFileFormat
and own Bank Number


Parameters


iiParentObjectIdinteger
icBankFileFormatcharacter
icownBankNumbercharacter
icPayFormatTypeModulecharacter
iiCompanyIdintegerCompany id


query condition


  each BankNumber where
BankNumber.BankNumber = icownBankNumber

      each BankPayFormat (inner-join) where
BankPayFormat.BankNumber_ID = BankNumber.BankNumber_ID AND

          first BankFileFormat (inner-join) where
BankFileFormat.BankFileFormat_ID = BankPayFormat.BankFileFormat_ID AND
BankFileFormat.BankFileFormatCode = icBankFileFormat

          each BankNumber2 (inner-join) where
BankNumber2.BankPayFormat_ID = BankPayFormat.BankPayFormat_ID AND
BankNumber2.ParentObject_ID = iiParentObjectId

          first PayFormatType (inner-join) where
PayFormatType.PayFormatTypeCode = BankPayFormat.PayFormatTypeCode AND
PayFormatType.PayFormatTypeModule = icPayFormatTypeModule

      first CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber.CompanySharedSet_ID AND


query resultset tqBankNumberByBankFileFormat


field namedata typedb fielddescription
tiBankFileFormat_IDintegerBankPayFormat.BankFileFormat_IDBank File Format Code
tcBankFileFormatCodecharacterBankFileFormat.BankFileFormatCodeFormat Code
tcBankNumbercharacterBankNumber.BankNumberBank Number
tlBankNumberIsDefaultlogicalBankNumber2.BankNumberIsDefaultDefault
tcParentBankNumbercharacterBankNumber2.BankNumberBank Number
tiParentBankNumber_IDintegerBankNumber2.BankNumber_IDRecord ID
tiParentObject_IDintegerBankNumber2.ParentObject_IDParent Object
tcPayFormatTypeCodecharacterBankPayFormat.PayFormatTypeCodePayment Format
tcPayFormatTypeModulecharacterPayFormatType.PayFormatTypeModuleModule
tcPayFormatTypePayInstrumentcharacterPayFormatType.PayFormatTypePayInstrumentPayment Instrument


Internal usage


QadFinancials
method BBankImportLine.ProcessBankImpLineDDocStatusChg
method BBankImportLine.ProcessBankImpLineNewBankEntry
method BBankImportLine.ProcessBankImpLineNewDDocument