General Ledger (GL) Calendar Dates

The following columns represent the General Ledger calendar:

• GL_ACCT_START_DT_WID

• GL_ACCT_END_DT_WID

• GL_PERIOD_WID

For forecasts that are time-phased using the General Ledger (GL) Calendar, the GL_ACCT_START_DT_WID and GL_ACCT_END_DT_WID columns are populated directly from the START_DATE and END_DATE of the forecast line. The GL_PERIOD_WID identifies the corresponding GL accounting period.

For forecasts with Time Phase set to Project Accounting (P), No Time Phase (N), or Date Range (R):

• GL_ACCT_START_DT_WID and GL_PERIOD_WID are derived using the START_DATE of the forecast line.

• The ETL resolves these values by selecting the GL accounting period that contains the forecast line START_DATE, based on the associated General Ledger Calendar.