project QadFinancials > class BCountry > business logic query CountryVatFormatByCountry
Description
give the fields of country vat format for a specified country
Parameters
| iiCountryId | integer | country ID |
| icCountryCode | character | Country Code |
query condition
each CountryVatFormat where
CountryVatFormat.Country_ID = iiCountryId
first Country (inner-join) where
Country.Country_ID = CountryVatFormat.Country_ID AND
Country.CountryCode matches icCountryCode
query sort order
CountryVatFormat.Country_ID (ascending)
CountryVatFormat.CountryVatFormat_ID (ascending)
query resultset tqCountryVatFormatByCountry
| field name | data type | db field | description |
|---|
| tiCountry_ID | integer | CountryVatFormat.Country_ID | Link to Country |
| tcCountryCode | character | Country.CountryCode | Country Code |
| tcCountryVatFormat | character | CountryVatFormat.CountryVatFormat | Tax Format |
| tiCountryVatFormat_ID | integer | CountryVatFormat.CountryVatFormat_ID | Record ID |
Internal usage
QadFinancials