Writing a P80010 Table Definition Browser App.

In OneWorld XE/8.0 days, we used to have an application – P80010 – Table Definition Browser Application. This application was of great help, as it showed the database fields in the Table, its indexes, the DD item name, description, the Data type of the field etc.
You can do the same in the Newer versions of EnterpriseOne too, with a very simple app as shown in the article.

Calculate Begin and End Dates for Month/Year

Calculate the Begin and End dates from a given Period/Year combination or to calculate the month’s begin and end dates from a given date. Like if you are given Period=3, Year=9, the Begin and End dates will be 03/01/2009 and 03/30/2009 respectively. Similarly if you were given a date say – 2/17/2009, the return Begin & End dates will be 02/01/2009 and 02/28/2009.