project QadFinancials > class BCompanyProperty > business logic query CompanyPropertyByIdCode

Description

Returns CompanyProperty based on Ids and Codes


Parameters


iiCompanyIdintegerCompany id
iiCompanyPropertyIdintegerCompanyPropertyId
iiBusinessRelationIdintegerBusinessRelationId
iiCurrencyIdintegerCurrencyID
icCompanyPropertyCodecharacterCompanyPropertyCode
icCompanyCodecharacterEntity Code
icBusinessRelationCodecharacterBusiness Relation Code
icCurrencyCodecharacterCurrency 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 namedata typedb fielddescription
tdCompanyPropertyExchTolAPdecimalCompanyProperty.CompanyPropertyExchTolAPAP Exchange Tolerance %
tdCompanyPropertyExchTolARdecimalCompanyProperty.CompanyPropertyExchTolARAR Exchange Tolerance %
tlDomainPropertyIsMaskCClogicalDomainProperty.DomainPropertyIsMaskCCCost Center COA Mask
tiCompanyProperty_IDintegerCompanyProperty.CompanyProperty_IDRecord ID
tiCompany_IDintegerCompanyProperty.Company_IDLink to Company
tiCurrency_IDintegerCompanyProperty.Currency_IDBase Currency
tiBusinessRelation_IDintegerCompanyProperty.BusinessRelation_IDMandatory
tcCompanyPropertyCodecharacterCompanyProperty.CompanyPropertyCodeEntity Code
tlCompanyPropertyIsActivelogicalCompanyProperty.CompanyPropertyIsActiveActive
tlCompanyPropertyIsBudOverChlogicalCompanyProperty.CompanyPropertyIsBudOverChCheck Budgets on Overlap
tlDomainPropertyIsMaskDivlogicalDomainProperty.DomainPropertyIsMaskDivSub-Account COA Mask
tlDomainPropertyIsMaskProjlogicalDomainProperty.DomainPropertyIsMaskProjProject COA Mask
tlCompanyPropertyIsPLReverselogicalCompanyProperty.CompanyPropertyIsPLReverseReverse P&L Revaluations
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tcBusinessRelationCodecharacterBusinessRelation.BusinessRelationCodeBusiness 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.
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tdCompanyPropertyRevRecMinimdecimalCompanyProperty.CompanyPropertyRevRecMinimMinimum Percentage of Completion
tdCompanyPropertyRevRecTreshdecimalCompanyProperty.CompanyPropertyRevRecTreshForecasted Revenue Threshold
tiCompanyPropertyPriceNumDecintegerCompanyProperty.CompanyPropertyPriceNumDecDecimals for Price
tiCompanyPropertyQtyNumDecintegerCompanyProperty.CompanyPropertyQtyNumDecDecimals 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