project QadFinancials > class BDDocumentReport > business logic query SelectVatNumberForDDocument

Parameters

iiBussinessRelationID	integer
iiCountryID	integer

query condition

each VatNumber where

VatNumber.BusinessRelation_ID = iiBussinessRelationID AND
VatNumber.IdentityCountry_ID = iiCountryID

query resultset tqSelectVatNumberForDDocument

field name	data type	db field	description
tiBusinessRelation_ID	integer	VatNumber.BusinessRelation_ID	Link to BusinessRelation
tiIdentityCountry_ID	integer	VatNumber.IdentityCountry_ID	Country Tax Identification
tcVatNumberIdentity	character	VatNumber.VatNumberIdentity	Obsolete field
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(VatNumber)

Internal usage

QadFinancials

method BDDocumentReport.DDocumentReportAllCreate