project QadFinancials > class BCompany > business logic query CompanySSBySSCodeIDTypeForCAI
Description
This query will return the companies that match on based on the SharedSetID, SharedSetCode and SharedSetTypeCode
Parameters
| iiCompanyId | integer | Company id |
| iiSharedSetID | integer | SharedSet-id |
| icSharedSetCode | character | Shared Set Code |
| icSharedSetTypeCode | character | SharedSetTypeCode |
query condition
each Company where
Company.Company_Id = iiCompanyId AND
each CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.Company_ID = Company.Company_ID AND
CompanySharedSet.SharedSet_ID = iiSharedSetID
first SharedSet (inner-join) where
SharedSet.SharedSet_ID = CompanySharedSet.SharedSet_ID AND
SharedSet.SharedSetCode = icSharedSetCode AND
SharedSet.SharedSetTypeCode = icSharedSetTypeCode
query resultset tqCompanySSBySSCodeIDTypeForCAI
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tlCompanyIsActive | logical | Company.CompanyIsActive | Active |
| tiSharedSet_ID | integer | SharedSet.SharedSet_ID | Record ID |
| tcSharedSetCode | character | SharedSet.SharedSetCode | Shared Set Code |
| tcSharedSetDescription | character | SharedSet.SharedSetDescription | Shared Set Description |
| tlSharedSetIsActive | logical | SharedSet.SharedSetIsActive | Active |
| tcSharedSetTypeCode | character | SharedSet.SharedSetTypeCode | Shared Set Type |
Internal usage
QadFinancials