project QadFinancials > class BCompanyProperty > business logic query CompanyPropertyByDomainID

Parameters

iiCompanyId	integer	Company id
iiDomainID	integer	DomainID

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.Domain_ID = iiDomainID

query resultset tqCompanyPropertyByDomainID

field name	data type	db field	description
tiBusinessRelation_ID	integer	CompanyProperty.BusinessRelation_ID	Mandatory
tiCompany_ID	integer	CompanyProperty.Company_ID	Link to Company
tcCompanyCode	character	Company.CompanyCode	Entity Code
tcCompanyDomain	character	Company.CompanyDomain	Domain
tlCompanyIsActive	logical	Company.CompanyIsActive	Active
tiCompanyProperty_ID	integer	CompanyProperty.CompanyProperty_ID	Record ID
tlCompanyPropertyIsAddGLNbr	logical	CompanyProperty.CompanyPropertyIsAddGLNbr	Additional GL Numbering
tlCompanyPropertyIsPrimary	logical	CompanyProperty.CompanyPropertyIsPrimary	Primary Entity
tiCurrency_ID	integer	CompanyProperty.Currency_ID	Base Currency
tiDomain_ID	integer	Company.Domain_ID	Domain
tiSharedAddNrCompany_ID	integer	CompanyProperty.SharedAddNrCompany_ID	Entity Code
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(CompanyProperty),rowid(Company)

Internal usage

QadFinancials

method BCompanyProperty.ReplicateCompanyFromDomain
method BCompanyProperty.ValidateComponent