business logic query CompanyPropertyByIdCode

Description

Returns CompanyProperty based on Ids and Codes

Parameters

iiCompanyId	integer	Company id
iiCompanyPropertyId	integer	CompanyPropertyId
iiBusinessRelationId	integer	BusinessRelationId
iiCurrencyId	integer	CurrencyID
icCompanyPropertyCode	character	CompanyPropertyCode
icCompanyCode	character	Entity Code
icBusinessRelationCode	character	Business Relation Code
icCurrencyCode	character	Currency Code

query condition

each CompanyProperty where

CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.CompanyProperty_ID = iiCompanyPropertyId AND
CompanyProperty.BusinessRelation_ID = iiBusinessRelationId AND
CompanyProperty.Currency_ID = iiCurrencyId AND
CompanyProperty.CompanyPropertyCode = icCompanyPropertyCode

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = CompanyProperty.BusinessRelation_ID AND
BusinessRelation.BusinessRelationCode = icBusinessRelationCode

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanyProperty.Company_ID AND
Company.CompanyCode = icCompanyCode

first DomainProperty (inner-join) where

DomainProperty.Domain_ID = Company.Domain_ID AND

first Currency (inner-join) where

Currency.Currency_ID = CompanyProperty.Currency_ID AND
Currency.CurrencyCode = icCurrencyCode

query resultset tqCompanyPropertyByIdCode

field name	data type	db field	description
tdCompanyPropertyExchTolAP	decimal	CompanyProperty.CompanyPropertyExchTolAP	AP Exchange Tolerance %
tdCompanyPropertyExchTolAR	decimal	CompanyProperty.CompanyPropertyExchTolAR	AR Exchange Tolerance %
tlDomainPropertyIsMaskCC	logical	DomainProperty.DomainPropertyIsMaskCC	Cost Center COA Mask
tiCompanyProperty_ID	integer	CompanyProperty.CompanyProperty_ID	Record ID
tiCompany_ID	integer	CompanyProperty.Company_ID	Link to Company
tiCurrency_ID	integer	CompanyProperty.Currency_ID	Base Currency
tiBusinessRelation_ID	integer	CompanyProperty.BusinessRelation_ID	Mandatory
tcCompanyPropertyCode	character	CompanyProperty.CompanyPropertyCode	Entity Code
tlCompanyPropertyIsActive	logical	CompanyProperty.CompanyPropertyIsActive	Active
tlCompanyPropertyIsBudOverCh	logical	CompanyProperty.CompanyPropertyIsBudOverCh	Check Budgets on Overlap
tlDomainPropertyIsMaskDiv	logical	DomainProperty.DomainPropertyIsMaskDiv	Sub-Account COA Mask
tlDomainPropertyIsMaskProj	logical	DomainProperty.DomainPropertyIsMaskProj	Project COA Mask
tlCompanyPropertyIsPLReverse	logical	CompanyProperty.CompanyPropertyIsPLReverse	Reverse P&L Revaluations
tcCompanyCode	character	Company.CompanyCode	Entity Code
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tdCompanyPropertyRevRecMinim	decimal	CompanyProperty.CompanyPropertyRevRecMinim	Minimum Percentage of Completion
tdCompanyPropertyRevRecTresh	decimal	CompanyProperty.CompanyPropertyRevRecTresh	Forecasted Revenue Threshold
tiCompanyPropertyPriceNumDec	integer	CompanyProperty.CompanyPropertyPriceNumDec	Decimals for Price
tiCompanyPropertyQtyNumDec	integer	CompanyProperty.CompanyPropertyQtyNumDec	Decimals for Qty

Internal usage

QadFinancials

method BBankEntry.ValidateComponentPreExchRateTolGetPerc
method BCompanyProperty.ValidateComponent
method BCreditorReport.CreditorAccountsSummary
method BDCollection.ExportCLIEOP03
method BDCollection.ExportDOM80
method BDCollection.ExportLCRBOR
method BDCollection.ExportXml
method BGLReport.CalDefaultCurrency
method BRevaluation.AdditionalUpdatesPostingCreate