business logic query CompanyPropertyByBusRelSimple

Description

CompanyPropertyByBusRelSimple

each CompanyProperty where

CompanyProperty.Company_Id = iiCompanyId AND

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 Currency (inner-join) where

Currency.Currency_ID = CompanyProperty.Currency_ID AND

field name	data type	db field	description
tiBusinessRelation_ID	integer	CompanyProperty.BusinessRelation_ID	Mandatory
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.
tcBusinessRelationICCode	character	BusinessRelation.BusinessRelationICCode	Intercompany Code. When Intercompany is true, this field is mandatory. The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports. The intercompany code must be unique for this business relation.
tiCompany_ID	integer	CompanyProperty.Company_ID	Link to Company
tcCompanyCode	character	Company.CompanyCode	Entity Code
tlCompanyIsActive	logical	Company.CompanyIsActive	Active
tiCompanyProperty_ID	integer	CompanyProperty.CompanyProperty_ID	Record ID
tcCompanyPropertyCode	character	CompanyProperty.CompanyPropertyCode	Entity Code
tlCompanyPropertyIsActive	logical	CompanyProperty.CompanyPropertyIsActive	Active
tiCurrency_ID	integer	CompanyProperty.Currency_ID	Base Currency
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code

QadFinancials