project QadFinancials > class BVATPeriod > business logic query VATPeriodPrim
Description
VAT Period Prim
Parameters
| iiCompanyId | integer | Company id |
| iiVATPeriodID | integer | Tax Period ID |
| iiYear | integer | |
| iiPeriod | integer | VAT 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 name | data type | db field | description |
|---|
| tiCompany_ID | integer | VatPeriod.Company_ID | Link to Company |
| tiVatPeriod_ID | integer | VatPeriod.VatPeriod_ID | Record ID |
| tiVatPeriodPeriod | integer | VatPeriod.VatPeriodPeriod | Tax Period |
| tiVatPeriodYear | integer | VatPeriod.VatPeriodYear | Tax Year |
Internal usage
QadFinancials