project QadFinancials > class BCompany > business logic query CompanyBySharedSetUsrRole
Parameters
| iiCompanyId | integer | Company id |
| iiShareSetId | integer | |
| icUserCode | character | |
query condition
each CompanySharedSet where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.SharedSet_ID = iiShareSetId
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND
each UsrCompany (inner-join) where
UsrCompany.Company_Id = iiCompanyId AND
UsrCompany.Company_ID = Company.Company_ID AND
first Usr (inner-join) where
Usr.Usr_ID = UsrCompany.Usr_ID AND
Usr.UsrLogin = icUserCode
query resultset tqCompanyBySharedSetUsrRole
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcCompanyDescription | character | Company.CompanyDescription | Entity Description |
| tlCompanyIsActive | logical | Company.CompanyIsActive | Active |
| tiCompanySharedSet_ID | integer | CompanySharedSet.CompanySharedSet_ID | Record ID |
| tiUsr_ID | integer | Usr.Usr_ID | Record ID |
| tiUsrCompany_ID | integer | UsrCompany.UsrCompany_ID | Record ID |
| tlUsrIsActive | logical | Usr.UsrIsActive | Active |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tcUsrName | character | Usr.UsrName | User Name |
Internal usage
QadFinancials