project QadFinancials > class BCountry > business logic query CountryPrim

Description

this query can be used by other components that the ID of a country but that needs to know the logical identification of the country or vice-versa

Parameters

iiCountryId	integer	country ID
icCountryCode	character

query condition

each Country where

Country.Country_ID = iiCountryId AND
Country.CountryCode = icCountryCode

query sort order

Country.CountryCode (ascending)

query resultset tqCountryPrim

field name	data type	db field	description
tiCountry_ID	integer	Country.Country_ID	Record ID
tcCountryCode	character	Country.CountryCode	Country Code
tcCountryDescription	character	Country.CountryDescription	Description
tiCountryFormat	integer	Country.CountryFormat	Postal Format

Internal usage

QadFinancials

method BBusinessRelation.ApiLoadBusinessRelation
method BBusinessRelation.ApiLoadBusinessRelationCalcCountryCode
method BBusinessRelation.ApiSynchronise
method BBusinessRelation.DataLoadByInput
method BCountry.ApiStdMaintainTT
method BCountry.ApiSynchronise
method BDebtorShipTo.DataLoadByInput
method BMfgAddress.ApiGetDockAddress
method BMfgAddress.ApiGetHeadOfficeAddress
method BMfgAddress.UpdateMfgData
method BPaymentSelection.ExportBEAbroadPreselect
method BProjectReport.ProjectMastercard
method BVATBox.ConvCountryCodeToId
method BVATExportListing.ApiOmzetBelastingNL
method TTSM.ValidateTSMNumber
read related business field(s) on tAddress.Country_ID
read related business field(s) on tCInvoice.TransactionStartCountry_ID
read related business field(s) on tCInvoice.TransactionEndCountry_ID
read related business field(s) on tDInvoice.TransactionStartCountry_ID
read related business field(s) on tDInvoice.TransactionEndCountry_ID
read related business field(s) on tRegion.Country_ID
read related business field(s) on tVatBox.Country_ID
read related business field(s) on tVatNumber.IdentityCountry_ID
read related business field(s) on tVatNumber.DeclarationCountry_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tAddress.Country_ID
validate related business field(s) on tCInvoice.TransactionStartCountry_ID
validate related business field(s) on tCInvoice.TransactionEndCountry_ID
validate related business field(s) on tDInvoice.TransactionStartCountry_ID
validate related business field(s) on tDInvoice.TransactionEndCountry_ID
validate related business field(s) on tRegion.Country_ID
validate related business field(s) on tVatNumber.IdentityCountry_ID
validate related business field(s) on tVatNumber.DeclarationCountry_ID