| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Period.Company_ID | Link to Company |
| tiPeriod_ID | integer | Period.Period_ID | Record ID |
| ttPeriodClosingDate | date | Period.PeriodClosingDate | Closing Date |
| ttPeriodEndDate | date | Period.PeriodEndDate | End Date |
| tlPeriodIsPostingGLAllowed | logical | Period.PeriodIsPostingGLAllowed | GL |
| tlPeriodIsPostingInvAllowed | logical | Period.PeriodIsPostingInvAllowed | Inventory |
| tlPeriodIsPostingOtherAllow | logical | Period.PeriodIsPostingOtherAllow | Other |
| tlPeriodIsPostingPurchAllow | logical | Period.PeriodIsPostingPurchAllow | Purchases |
| tlPeriodIsPostingSalesAllow | logical | Period.PeriodIsPostingSalesAllow | Sales |
| tlPeriodIsReportChecked | logical | Period.PeriodIsReportChecked | Checked/Reported |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| tcPeriodReportingPeriod | character | Period.PeriodReportingPeriod | Reporting GL Period |
| ttPeriodStartDate | date | Period.PeriodStartDate | Start Date |
| tcPeriodStatus | character | Period.PeriodStatus | Status |
| tcPeriodTypeCode | character | Period.PeriodTypeCode | GL Period Type |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiPeriodYearPeriod | integer | Period.PeriodYearPeriod | GL Calendar Year/GL Period |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Period) |
each Period where