project BLF > class BCompany > business logic query CompanySSByCompanyIDCodeSSType

Description

Query on tables company, companysharedset and sharedsettype
CompanySSByCompanyIDCodeSSType


Parameters


iiCompanyIdintegerEntity ID
icSharedSetTypecharacterSharedSetType
icCompanyCodecharacterEntity 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 namedata typedb fielddescription
tiCompanySharedSet_IDintegerCompanySharedSet.CompanySharedSet_IDRecord ID
tiCompany_IDintegerCompany.Company_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tlCompanyIsActivelogicalCompany.CompanyIsActiveActive
tiSharedSet_IDintegerCompanySharedSet.SharedSet_IDShared Set
tcSharedSetCodecharacterSharedSet.SharedSetCodeShared Set Code
tlSharedSetIsActivelogicalSharedSet.SharedSetIsActiveActive
tcSharedSetTypeCodecharacterSharedSet.SharedSetTypeCodeShared Set Type


Internal usage


QadFinancials
method BAnalyticalReport.SetDataItemsBasedOnFilterTT
method BBankNumber.ValidateComponentBeforeAncestor
method BBudget.ValidateComponentCheckUpdates
method BBudget.ValidateComponentValidateStructDet
method BCDocument.ValidateComponentPostWHT
method BCompany.PreValidateComponent
method BExchangeRate.ApiCalculateDerivedExchangeRates
method BPaymentSelection.GetToPayObjectsForCInvoice
method BPaymentSelection.ValidateComponentPost
method BProfile.ApiStdMaintainTTDetail
method BProfile.DataLoadByInput
method MfgNotification.ProcessMfgNotification