project QadFinancials > class BCompanyProperty > business logic query CompanyPropertyByCompanyCode


Parameters


iiCompanyIdintegerCompany id
icCompanyCodecharacter
icDomainCodecharacter


query condition


  each CompanyProperty where
CompanyProperty.Company_Id = iiCompanyId AND

      first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanyProperty.Company_ID AND
Company.CompanyCode = icCompanyCode

          first Domains (inner-join) where
Domains.Domain_ID = Company.Domain_ID AND
Domains.DomainCode = icDomainCode


query resultset tqCompanyPropertyByCompanyCode


field namedata typedb fielddescription
tiCompany_IDintegerCompanyProperty.Company_IDLink to Company
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tiCompanyProperty_IDintegerCompanyProperty.CompanyProperty_IDRecord ID
tlCompanyPropertyIsAddGLNbrlogicalCompanyProperty.CompanyPropertyIsAddGLNbrAdditional GL Numbering
tlCompanyPropertyIsAddNrYrlylogicalCompanyProperty.CompanyPropertyIsAddNrYrlyYearly Additional JE Numbering
tlCompanyPropertyIsConsolidlogicalCompanyProperty.CompanyPropertyIsConsolidConsolidation Entity
tdCompanyPropertyUppLimitdecimalCompanyProperty.CompanyPropertyUppLimitInvoice Upper Limit
tcDomainCodecharacterDomains.DomainCodeDomain
tlDomainIsActivelogicalDomains.DomainIsActiveActive
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(CompanyProperty),rowid(Company),rowid(Domains)


Internal usage


QadFinancials
method BCompany.GetAdditionalGLNumbering
method BCompanyProperty.ApiGetUpperLimit
method BCompanyProperty.CheckAdditionalGLNumbering
method BConsolidCycle.ValidateComponentAll
method BPosting.ValidateComponentPostPosting1
method BPosting.ValidateComponentPostStopQueries

QadFitnesse
method BCompanyProperty.ApiCompanyUpdate
method BCompanyProperty.ApiUpdateARAPTaxDateProperties