Organizations are required by law to produce a set of annual accounts. To this end, their general ledger systems must maintain a fiscal calendar. Although the specific start and end dates of a fiscal year vary from country to country, for our purposes, the year will start on July 1st and end on June 30th. In addition, each fiscal year is normally subdivided into periods. For our purposes, each period will be a calendar month.
Fiscal Year Table
CREATE TABLE gl_fiscal_year
(Cocode NUMBER Constraint fk_fiscal_year References gl_company (Cocode), Coyear NUMBER(4), Comonthid NUMBER(2), ...
