eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BIM_DIMV_PERIODS

Product:	BIM - Marketing Intelligence(Obsolete)
Description:	Shows all the periods defined in gl_period for a user-selected accounting calendar
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT GL_PERIODS.PERIOD_SET_NAME PERIOD_SET_NAME
, GL_PERIODS.PERIOD_NAME PERIOD_NAME
, GL_PERIODS.PERIOD_TYPE PERIOD_TYPE
, GL_PERIODS.PERIOD_NUM PERIOD_NUM
, GL_PERIODS.QUARTER_NUM QUARTER_NUM
, GL_PERIODS.PERIOD_YEAR PERIOD_YEAR
, GL_PERIODS.START_DATE START_DATE
, GL_PERIODS.END_DATE END_DATE
, GL_PERIODS.ENTERED_PERIOD_NAME ENTERED_PERIOD_NAME
, GL_PERIODS.DESCRIPTION DESCRIPTION
, GL_PERIODS.ADJUSTMENT_PERIOD_FLAG ADJUSTMENT_PERIOD_FLAG FROM GL_PERIODS
WHERE ADJUSTMENT_PERIOD_FLAG = 'N'
AND PERIOD_SET_NAME = JTF_BIS_UTIL.PROFILEVALUE('CRMBIS:PERIOD_SET_NAME') WITH READ ONLY

Columns

Name
PERIOD_SET_NAME
PERIOD_NAME
PERIOD_TYPE
PERIOD_NUM
QUARTER_NUM
PERIOD_YEAR
START_DATE
END_DATE
ENTERED_PERIOD_NAME
DESCRIPTION
ADJUSTMENT_PERIOD_FLAG