© 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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.