project QadFinancials > class BCountry > business logic query CountryVatFormatByCountry

Description

give the fields of country vat format for a specified country


Parameters


iiCountryIdintegercountry ID
icCountryCodecharacterCountry 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 namedata typedb fielddescription
tiCountry_IDintegerCountryVatFormat.Country_IDLink to Country
tcCountryCodecharacterCountry.CountryCodeCountry Code
tcCountryVatFormatcharacterCountryVatFormat.CountryVatFormatTax Format
tiCountryVatFormat_IDintegerCountryVatFormat.CountryVatFormat_IDRecord ID


Internal usage


QadFinancials
method BCountry.ApiCheckVatNumber