project QadFinancials > class BCompanyProperty > business logic query CompanyPropertyForSharedSetDet
Description
CompanyPropertyForSharedSetDetails:
Get company data that is required for calculating exchange rates
Note this query holds a join to the shared-set with a condition on the shared-set-type
Better do not extend this query and do not call this query from elsewhere
Parameters
| iiCompanyID | integer | company id |
| icSharedSetTypeCode | character | |
query condition
each CompanyProperty where
CompanyProperty.Company_ID = iiCompanyId
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanyProperty.Company_ID AND
each CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.Company_ID = Company.Company_ID AND
first SharedSet (inner-join) where
SharedSet.SharedSet_ID = CompanySharedSet.SharedSet_ID AND
SharedSet.SharedSetTypeCode = icSharedSetTypeCode
first DomainProperty (inner-join) where
DomainProperty.Domain_ID = Company.Domain_ID AND
first Currency2 (inner-join) where
Currency2.Currency_ID = DomainProperty.Currency_ID AND
first Currency1 (inner-join) where
Currency1.Currency_ID = CompanyProperty.Currency_ID AND
query resultset tqCompanyPropertyForSharedSetDet
| field name | data type | db field | description |
|---|
| tlDomainPropertyIsStatutory | logical | DomainProperty.DomainPropertyIsStatutory | Statutory Currency Enabled |
| tiCompany_ID | integer | CompanyProperty.Company_ID | Link to Company |
| tiCompanyProperty_ID | integer | CompanyProperty.CompanyProperty_ID | Record ID |
| tiLCCurrency_ID | integer | CompanyProperty.Currency_ID | Base Currency |
| tcLCCurrencyCode | character | Currency1.CurrencyCode | Currency Code |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiDomain_ID | integer | Company.Domain_ID | Domain |
| tiDomainProperty_ID | integer | DomainProperty.DomainProperty_ID | Record ID |
| tiCCCurrency_ID | integer | DomainProperty.Currency_ID | Base Currency |
| tcCCCurrencyCode | character | Currency2.CurrencyCode | Currency Code |
| tiSharedSet_ID | integer | CompanySharedSet.SharedSet_ID | Shared Set |
| tcSharedSetTypeCode | character | SharedSet.SharedSetTypeCode | Shared Set Type |
Internal usage
QadFinancials