project BLF > class BCompany > business logic query CompanySSByCompanyIDCodeSSType
Description
Query on tables company, companysharedset and sharedsettype
CompanySSByCompanyIDCodeSSType
Parameters
iiCompanyId | integer | Entity ID |
icSharedSetType | character | SharedSetType |
icCompanyCode | character | Entity Code |
query condition
each Company where
Company.Company_ID = iiCompanyId AND
Company.CompanyCode = icCompanyCode
each CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.Company_ID = Company.Company_ID AND
first SharedSet (inner-join) where
SharedSet.SharedSet_ID = CompanySharedSet.SharedSet_ID AND
SharedSet.SharedSetTypeCode = icSharedSetType
query resultset tqCompanySSByCompanyIDCodeSSType
field name | data type | db field | description |
tiCompanySharedSet_ID | integer | CompanySharedSet.CompanySharedSet_ID | Record ID |
tiCompany_ID | integer | Company.Company_ID | Record ID |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
tlCompanyIsActive | logical | Company.CompanyIsActive | Active |
tiSharedSet_ID | integer | CompanySharedSet.SharedSet_ID | Shared Set |
tcSharedSetCode | character | SharedSet.SharedSetCode | Shared Set Code |
tlSharedSetIsActive | logical | SharedSet.SharedSetIsActive | Active |
tcSharedSetTypeCode | character | SharedSet.SharedSetTypeCode | Shared Set Type |
Internal usage
QadFinancials