Name | Description | Type | Additional information |
---|---|---|---|
OCCUR_PERIOD |
Occur Period which is YYYYMM format. |
string |
None. |
FISCAL_YEAR |
Fiscal Year contains the concatenated version of the Fiscal Year Begin and the Fiscal Year End July to June. |
string |
None. |
CALENDAR_YEAR |
Calendar Year contains the concatenated version of the Calendar Year Begin and the Calendar Year End January to December. |
string |
None. |
FY_YEAR |
The 4 digit fiscal year the occur period falls in YYYY |
string |
None. |
CY_YEAR |
The 4 digit calendar year the occur period falls in YYYY |
string |
None. |
START_FISCAL_PERIOD |
The start of the fiscal period in MMMMDD format that the occur period falls in. (July) |
string |
None. |
END_FISCAL_PERIOD |
The end of the fiscal period in MMMMDD format that the occur period falls in. (June) |
string |
None. |
START_CAL_PERIOD |
The start of the calendar period in MMMMDD format that the occur period falls in. |
string |
None. |
END_CAL_PERIOD |
The end of the calendar period in MMMMDD format that the occur period falls in. (June) |
string |
None. |
FY_YEAR_REP |
The fiscal year date formatted for reports YYYY/YYYY |
string |
None. |
OCCUR_PERIOD_MINUS1 |
The previous occur period |
string |
None. |
OCCUR_PERIOD_MINUS6 |
The occur period that is 6 months previous |
string |
None. |
OCCUR_PERIOD_REP |
The occur period for reports |
string |
None. |
OCCUR_PERIOD_PLUS1 |
The next occur period |
string |
None. |
FY_YEAR_REP_LONG |
The long display date of the fiscal year |
string |
None. |
NO_OF_DAYS |
The number of days in the occur period |
string |
None. |
OCCUR_PERIOD_MINUS12 |
TThe occur period that is 12 months previous |
string |
None. |
OCCUR_PERIOD_MINUS3 |
TThe occur period that is 3 months previous |
string |
None. |
OCCUR_PERIOD_MINUS9 |
TThe occur period that is 9 months previous |
string |
None. |