project QadFinancials > class BBankNumber > business logic query BankNumberForParentObject2
Parameters
iiCompanyId | integer | Company id |
iiParentObjectID | integer | |
icBankNumber | character | |
icOwnBankNumber | character | |
icPayFormatTypeCode | character | |
query condition
each BankNumber where
BankNumber.BankNumber = icBankNumber AND
BankNumber.ParentObject_ID = iiParentObjectID
first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND
BankPayFormat.PayFormatTypeCode = icPayFormatTypeCode
first BankNumber2 (inner-join) where
BankNumber2.BankNumber_ID = BankPayFormat.BankNumber_ID AND
BankNumber2.BankNumber = icOwnBankNumber
first CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber2.CompanySharedSet_ID AND
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND
query resultset tqBankNumberForParentObject2
field name | data type | db field | description |
tcBankNumber | character | BankNumber.BankNumber | Bank Number |
tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
tcBankNumberExtension1 | character | BankNumber.BankNumberExtension | Bank Extension |
tcBankNumberFormatted | character | BankNumber.BankNumberFormatted | Formatted Bank Account No |
tiBankPayFormat_ID | integer | BankPayFormat.BankPayFormat_ID | Record ID |
tiCompany_ID | integer | Company.Company_ID | Record ID |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
tcOwnBankNumber | character | BankNumber2.BankNumber | Bank Number |
tiOwnBankNumber_ID | integer | BankNumber2.BankNumber_ID | Record ID |
tiParentObject_ID | integer | BankNumber.ParentObject_ID | Parent Object |
tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
Internal usage
QadFinancials