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
| iiParentObjectId | integer | |
| icBankFileFormat | character | |
| icownBankNumber | character | |
| icPayFormatTypeModule | character | |
| iiCompanyId | integer | Company 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 name | data type | db field | description |
|---|
| tiBankFileFormat_ID | integer | BankPayFormat.BankFileFormat_ID | Bank File Format Code |
| tcBankFileFormatCode | character | BankFileFormat.BankFileFormatCode | Format Code |
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tlBankNumberIsDefault | logical | BankNumber2.BankNumberIsDefault | Default |
| tcParentBankNumber | character | BankNumber2.BankNumber | Bank Number |
| tiParentBankNumber_ID | integer | BankNumber2.BankNumber_ID | Record ID |
| tiParentObject_ID | integer | BankNumber2.ParentObject_ID | Parent Object |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
| tcPayFormatTypeModule | character | PayFormatType.PayFormatTypeModule | Module |
| tcPayFormatTypePayInstrument | character | PayFormatType.PayFormatTypePayInstrument | Payment Instrument |
Internal usage
QadFinancials