business logic query VatNumberByIdBusRelCntryVat

Description

Get all fields based on the business relation id

Parameters

iiBusinessRelationId	integer
iiIdentityCountryId	integer
icIdentityCountryCode	character
icVatNumberIdentity	character
iiVatNumberId	integer
ilVatNumberIsActive	logical	Is the vat number active or not ?

query condition

each VatNumber where

VatNumber.BusinessRelation_ID = iiBusinessRelationId AND
VatNumber.IdentityCountry_ID = iiIdentityCountryId AND
VatNumber.VatNumberIdentity matches icVatNumberIdentity AND
VatNumber.VatNumber_ID = iiVatNumberId AND
VatNumber.VatNumberIsActive = ilVatNumberIsActive

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = VatNumber.BusinessRelation_ID AND

first Country1 (inner-join) where

Country1.Country_ID = VatNumber.IdentityCountry_ID AND
Country1.CountryCode matches icIdentityCountryCode

first Country2 (inner-join) where

Country2.Country_ID = VatNumber.DeclarationCountry_ID AND

query sort order

VatNumber.BusinessRelation_ID (ascending)

query resultset tqVatNumberByIdBusRelCntryVat

field name	data type	db field	description
tiBusinessRelation_ID	integer	VatNumber.BusinessRelation_ID	Link to BusinessRelation
tcBusinessRelationAVRCode	character	BusinessRelation.BusinessRelationAVRCode	Obsolete field
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tiDeclarationCountry_ID	integer	VatNumber.DeclarationCountry_ID	Country Tax Declaration
tcDeclarationCountryCode	character	Country2.CountryCode	Country Code
tlDeclarationIsEUCountry	logical	Country2.CountryIsEUCountry	EU Member
tiIdentityCountry_ID	integer	VatNumber.IdentityCountry_ID	Country Tax Identification
tcIdentityCountryCode	character	Country1.CountryCode	Country Code
tlIdentityisEUCountry	logical	Country1.CountryIsEUCountry	EU Member
tiVatNumber_ID	integer	VatNumber.VatNumber_ID	Record ID
tcVatNumberDeclaration	character	VatNumber.VatNumberDeclaration	Obsolete field
tcVatNumberIdentity	character	VatNumber.VatNumberIdentity	Obsolete field
tlVatNumberIsActive	logical	VatNumber.VatNumberIsActive	Obsolete field

Internal usage

QadFinancials

method BCInvoice.ApiStdMaintainTTWithIntPost
method BDInvoice.ApiCreateDInvoicesFinCharge
method BDInvoice.ApiStdMaintainTTWithIntPost
method BDInvoice.StdMaintainTTWithIntPost
method BEmployee.ApiBusinessRelationInfo