project QadFinancials > class BBankNumber > business logic query BankNumberByPayFormatParentObj
Parameters
| iiPaymentFormatID | integer | |
| iiParentObjectID | integer | |
| iiCompanyId | integer | Company id |
query condition
each BankNumber where
BankNumber.BankPayFormat_ID = iiPaymentFormatID AND
BankNumber.ParentObject_ID = iiParentObjectID
first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND
first BankNumber2 (inner-join) where
BankNumber2.BankNumber_ID = BankPayFormat.BankNumber_ID AND
first CompanySharedSet (outer-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber2.CompanySharedSet_ID AND
query resultset tqBankNumberByPayFormatParentObj
| field name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| tcBankNumberFormatted | character | BankNumber.BankNumberFormatted | Formatted Bank Account No |
| tlBankNumberIsDefault | logical | BankNumber.BankNumberIsDefault | Default |
| tiBankPayFormat_ID | integer | BankNumber.BankPayFormat_ID | Link to BankPayFormat |
| tiCompany_ID | integer | CompanySharedSet.Company_ID | Entity |
| tiParentObject_ID | integer | BankNumber.ParentObject_ID | Parent Object |
Internal usage
QadFinancials