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