| Field |
Type |
Default |
Description |
| period |
int(11) |
0 |
(Primary Key) Holds the accounting period. Starting at 1 for the first peeriod of the fiscal year. |
| fiscal_year | int(11) | 0 | Holds the fiscal year (2007, 2008, etc.) |
| start_date | date | 0000-00-00 | Holds the calendar date of the start of the period (format YYYY-MM-DD) |
| end_date | date | 0000-00-00 | Holds the calendar date of the end of the period (format YYY-MM-DD) |
| date_added | date | 0000-00-00 | Holds the date the period was first added (format YYYY-MM-DD) |
| last_update | timestamp | NOT NULL | Timestamps the record if any changes are made to the record. |