business logic query CompanyPropertyByCompanyCode

Parameters

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

field name	data type	db field	description
tiCompany_ID	integer	CompanyProperty.Company_ID	Link to Company
tcCompanyCode	character	Company.CompanyCode	Entity Code
tiCompanyProperty_ID	integer	CompanyProperty.CompanyProperty_ID	Record ID
tlCompanyPropertyIsAddGLNbr	logical	CompanyProperty.CompanyPropertyIsAddGLNbr	Additional GL Numbering
tlCompanyPropertyIsAddNrYrly	logical	CompanyProperty.CompanyPropertyIsAddNrYrly	Yearly Additional JE Numbering
tlCompanyPropertyIsConsolid	logical	CompanyProperty.CompanyPropertyIsConsolid	Consolidation Entity
tdCompanyPropertyUppLimit	decimal	CompanyProperty.CompanyPropertyUppLimit	Invoice Upper Limit
tcDomainCode	character	Domains.DomainCode	Domain
tlDomainIsActive	logical	Domains.DomainIsActive	Active
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(CompanyProperty),rowid(Company),rowid(Domains)

QadFinancials

QadFitnesse