E.3.2 Using a Calendar Year Configuration
Under the default calendar year configuration, the FSI_FISCAL_YEAR_INFO/ LEDGER_CCY_AND_FISCAL_YR_INFO table contains a Fiscal Period value of 12 and a Start Month value of 1. For the following calendar year example, calendar months for 2020 correspond to the monthly buckets as shown in the following table:
Table E-4 Monthly Data for Calendar Year 2020
Month 01 | Month 02 | Month 03 | Month 04 | Month 05 | Month 06 | Month 07 | Month 08 | Month 09 | Month 10 | Month 11 | Month 12 |
---|---|---|---|---|---|---|---|---|---|---|---|
Jan2020 | Feb2020 | Mar2020 | Apr2020 | May2020 | Jun2020 | Ju2020 | Aug2020 | Sep2020 | Oct2020 | Nov2020 | Dec2020 |
If you have set your As-of-Date to June 2020, then any OFSAA process will insert the Balance for the sixth month into the Management Ledger table with FISCAL_MONTH as 06.
Continuing with this calendar year example, the 12 YTD buckets correspond to 2020 calendar month ranges as shown in the following table:
Table E-5 Year-to-Date Data for Calendar Year 2020
YTD as of Month 01 | YTD as of Month 02 | YTD as of Month 03 | YTD as of Month 04 | YTD as of Month 05 | YTD as of Month 06 | YTD as of Month 07 | YTD as of Month 08 | YTD as of Month 09 | YTD as of Month 10 | YTD as of Month 11 | YTD as of Month 12 |
---|---|---|---|---|---|---|---|---|---|---|---|
Jan2020 | Jan to Feb 2020 | Jan to Mar 2020 | Jan to April 2020 | Jan to May 2020 | Jan to June 2020 | Jan to July 2020 | Jan to Aug 2020 | Jan to Sep 2020 | Jan to Oct 2020 | Jan to Nov 2020 | Jan to Dec 2020 |
For details on the relationships between Month-to-Date columns and Year-to-Date columns, see Management Ledger.