project QadFinancials > class BBLWIReport > business logic query CompanyPropertyForBLWIReport
Parameters
| iiCompanyId | integer | Company id |
query condition
each CompanyProperty where
CompanyProperty.Company_Id = iiCompanyId AND
first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = CompanyProperty.BusinessRelation_ID AND
each Address (inner-join) where
Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND
first Country (inner-join) where
Country.Country_ID = Address.Country_ID AND
query resultset tqCompanyPropertyForBLWIReport
| field name | data type | db field | description |
|---|
| tiBusinessRelation_ID | integer | CompanyProperty.BusinessRelation_ID | Mandatory |
| tiBusinessRelation_ID2 | integer | BusinessRelation.BusinessRelation_ID | Record ID |
| tiCompany_ID | integer | CompanyProperty.Company_ID | Link to Company |
| tiCountry_ID | integer | Country.Country_ID | Record ID |
| tcCountryBLWICode | character | Country.CountryBLWICode | BLWI Code |
| tcCountryCode | character | Country.CountryCode | Country Code |
| tcCountryDescription | character | Country.CountryDescription | Description |
| tlCountryIsActive | logical | Country.CountryIsActive | Active |
| tlCountryIsEUCountry | logical | Country.CountryIsEUCountry | EU Member |
Internal usage
QadFinancials