Table accouting_periods

Phreebooks uses accounting periods to track costs. 12 or 13 accounting periods make up a fiscal year. This table holds the acccounting period and the dates assigned to the period. It also maps the period to the fiscal year. Accounting periods may be changed only from the date of the last joiurnal entry to the end of the generated fiscal years.

NOTE: It is best no to generate fiscal years beyond what is actually needed. PhreeBooks is a real-time posting accounting application and the balance sheet is updated fromthe posting date to the end of the fiscal year in the system. This will add additional sql accesses as the information may flow through the fiscal years.

This table is first populated during install with the first fiscal year. Additional fiscal years can be added through the General Ledger -> Utilities menu.

Table Type: InnoDB

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_yearint(11)0Holds the fiscal year (2007, 2008, etc.)
start_datedate0000-00-00Holds the calendar date of the start of the period (format YYYY-MM-DD)
end_datedate0000-00-00Holds the calendar date of the end of the period (format YYY-MM-DD)
date_addeddate0000-00-00Holds the date the period was first added (format YYYY-MM-DD)
last_updatetimestampNOT NULLTimestamps the record if any changes are made to the record.