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. |