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