project QadFinancials > class BVATPeriod > business logic query VATPeriodPrim

Description

VAT Period Prim


Parameters


iiCompanyIdintegerCompany id
iiVATPeriodIDintegerTax Period ID
iiYearinteger
iiPeriodintegerVAT Period Period


query condition


  each VatPeriod where
VatPeriod.Company_Id = iiCompanyId AND
VatPeriod.VatPeriod_ID = iiVATPeriodID AND
VatPeriod.VatPeriodYear = iiYear AND
VatPeriod.VatPeriodPeriod = iiPeriod


query resultset tqVATPeriodPrim


field namedata typedb fielddescription
tiCompany_IDintegerVatPeriod.Company_IDLink to Company
tiVatPeriod_IDintegerVatPeriod.VatPeriod_IDRecord ID
tiVatPeriodPeriodintegerVatPeriod.VatPeriodPeriodTax Period
tiVatPeriodYearintegerVatPeriod.VatPeriodYearTax Year


Internal usage


QadFinancials
method BJournalEntry.AutoUpdatePostingVatVatGroups
method BVATExportListing.ApiOmzetBelastingNL
method BVATPeriod.APIUpdateVATPeriodStatus
read related business field(s) on tVatExport.VatPeriod_ID
ApiGetAlternateKeyValues
validate related business field(s) on tVatExport.VatPeriod_ID