project BLF > class BCompany > business logic query CompanySharedSetBySharedSet
Description
CompanySharedSetBySharedSet
Parameters
| iiSharedSetId | integer | |
| iiCompanyId | integer | Company id |
query condition
each CompanySharedSet where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.SharedSet_ID = iiSharedSetId
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND
query resultset tqCompanySharedSetBySharedSet
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiSharedSet_ID | integer | CompanySharedSet.SharedSet_ID | Shared Set |
Internal usage
BLF
QadFinancials