project BLF > class BCompany > business logic query CompanySSByIds
Description
CompanySSByIds
Parameters
| iiCompanyId | integer | Company id |
| iiCompanySharedSetId | integer | CompanySharedSetId |
| iiSharedSetId | integer | SharedSetId |
query condition
each CompanySharedSet where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = iiCompanySharedSetId AND
CompanySharedSet.SharedSet_ID = iiSharedSetId
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND
first SharedSet (inner-join) where
SharedSet.SharedSet_ID = CompanySharedSet.SharedSet_ID AND
query resultset tqCompanySSByIds
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | CompanySharedSet.Company_ID | Entity |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiCompanySharedSet_ID | integer | CompanySharedSet.CompanySharedSet_ID | Record ID |
| tiSharedSet_ID | integer | CompanySharedSet.SharedSet_ID | Shared Set |
| tcSharedSetCode | character | SharedSet.SharedSetCode | Shared Set Code |
| tcSharedSetTypeCode | character | SharedSet.SharedSetTypeCode | Shared Set Type |
Internal usage
QadFinancials