business logic query CompanyPropertyByIDCodeCurr

Description

CompanyPropertyByIDCodeCurr: Query on company-property with a join to currency

iiCompanyId

integer

Company id

each CompanyProperty where

CompanyProperty.Company_Id = iiCompanyId AND

first Currency (inner-join) where

Currency.Currency_ID = CompanyProperty.Currency_ID AND

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
tiCurrency_ID	integer	CompanyProperty.Currency_ID	Base Currency
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code

QadFinancials