project QadFinancials > class BDebtorReport > business logic query DebtorCurrencyByEntity
Parameters
| iiCompanyId | integer | Company id |
query condition
each Company where
Company.Company_Id = iiCompanyId AND
first Domains (inner-join) where
Domains.Domain_ID = Company.Domain_ID AND
each DomainProperty (inner-join) where
DomainProperty.Domain_ID = Domains.Domain_ID AND
first Currency1 (inner-join) where
Currency1.Currency_ID = DomainProperty.Currency_ID AND
first Currency2 (inner-join) where
Currency2.Currency_ID = DomainProperty.StatutoryCurrency_ID AND
query resultset tqDebtorCurrencyByEntity
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiCurrency_ID | integer | DomainProperty.Currency_ID | Base Currency |
| tcCurrencyCode | character | Currency1.CurrencyCode | Currency Code |
| tcCurrencyCode1 | character | Currency2.CurrencyCode | Currency Code |
| tiDomain_ID | integer | Domains.Domain_ID | Record ID |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiDomainProperty_ID | integer | DomainProperty.DomainProperty_ID | Record ID |
| tcDomainType | character | Domains.DomainType | Type |
| tiStatutoryCurrency_ID | integer | DomainProperty.StatutoryCurrency_ID | Statutory Currency |
Internal usage
QadFinancials