business logic query CompanyPropertyByCompany

Description

Query on CompanyProperty.
Pass company code/id and returns currency_id/code

iiCompanyId	integer	Company id
icCompanyCode	character	parameter company code (list of company codes) Can-do operator.
icCurrencyCode	character

each CompanyProperty where

CompanyProperty.Company_ID = iiCompanyId

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanyProperty.Company_ID AND
Company.CompanyCode can-do icCompanyCode

first Currency (inner-join) where

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

first SafConcept (conditional-join) where

SafConcept.SafConcept_ID = CompanyProperty.SafConcept_ID AND

first Unit (outer-join) where

Unit.Unit_ID = CompanyProperty.Unit_ID AND

field name	data type	db field	description
tdCompanyPropertyActConvFact	decimal	CompanyProperty.CompanyPropertyActConvFact	Conversion Factor to Minutes
tlCompanyPropertyIsAPUseInvDate	logical	CompanyProperty.CompanyPropertyIsAPUseInvDate	AP Exchange Rate - Use Invoice Date
tlCompanyPropertyIsARUseTaxDate	logical	CompanyProperty.CompanyPropertyIsARUseTaxDate	AR Exchange Rate - Use Taxpoint Date
tlCompanyPropertyIsGrIncAcc	logical	CompanyProperty.CompanyPropertyIsGrIncAcc	Gross Income Accounting
tlCompanyPropertyIsWHT	logical	CompanyProperty.CompanyPropertyIsWHT	Use Withholding Tax
tiSafConcept_ID	integer	CompanyProperty.SafConcept_ID	SAF Concept Code
tcSafConceptCode	character	SafConcept.SafConceptCode	SAF Concept Code
tiUnit_ID	integer	CompanyProperty.Unit_ID	Time Unit of Measure
tcUnitCode	character	Unit.UnitCode	Unit of Measure
tiCompany_ID	integer	CompanyProperty.Company_ID	Link to Company
tcCompanyCode	character	Company.CompanyCode	Entity Code
tiCurrency_ID	integer	CompanyProperty.Currency_ID	Base Currency
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code

QadFinancials