| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | VatPeriod.Company_ID | Link to Company |
| tiVatPeriod_ID | integer | VatPeriod.VatPeriod_ID | Record ID |
| ttVatPeriodEndDate | date | VatPeriod.VatPeriodEndDate | End Date |
| tiVatPeriodPeriod | integer | VatPeriod.VatPeriodPeriod | Tax Period |
| ttVatPeriodStartDate | date | VatPeriod.VatPeriodStartDate | Start Date |
| tcVatPeriodStatus | character | VatPeriod.VatPeriodStatus | Status |
| tiVatPeriodYear | integer | VatPeriod.VatPeriodYear | Tax Year |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(VatPeriod) |
each VatPeriod where