business logic query CompanyPropertyPrim

Description

Prim query
= query that can be used to find the logical key based on the prim-key and vice-versa.

Parameters

iiCompanyId	integer	Company id
iiCompanyPropertyId	integer	CompanyPropertyId
icCompanyPropertyCode	character	CompanyPropertyCode

query condition

each CompanyProperty where

CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.CompanyProperty_ID = iiCompanyPropertyId AND
CompanyProperty.CompanyPropertyCode = icCompanyPropertyCode

query resultset tqCompanyPropertyPrim

field name	data type	db field	description
tiCompany_ID	integer	CompanyProperty.Company_ID	Link to Company
tiCompanyProperty_ID	integer	CompanyProperty.CompanyProperty_ID	Record ID
tcCompanyPropertyCode	character	CompanyProperty.CompanyPropertyCode	Entity Code
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(CompanyProperty)

Internal usage

QadFinancials

method BCompanyProperty.SwitchPrimaryCompany