© Riaz Ahmed 2019
Riaz AhmedCloud Computing Using Oracle Application Expresshttps://doi.org/10.1007/978-1-4842-4243-8_4

4. Fiscal Year

Riaz Ahmed1 
Karachi, Pakistan

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

Get Cloud Computing Using Oracle Application Express: Develop Internet-Facing Business Applications Accessible Anywhere and Anytime now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.