Financial Period
The financial period dimension only contains periods of type Fiscal and Reporting. Tax Periods are excluded from the dimension.
This table shows the tables from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tfgld003 | Group Company Parameters |
| tfgld005 | Periods |
| tfgld006 | End Dates by Year |
| tfgld007 | Period Status |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Company | Logical Company of tfgld005 |
| Correction Period | tfgld005.corr |
| Correction Period Filter | tfgld005.corr |
| Correction Period Sort | tfgld005.corr |
| End Date | For non-correction periods: Start Date of next non-correction
period minus one day. For last non-correction period: tfgld006.fpdt (End Date of Last Fiscal Period) For correction periods: tfgld006.fpdt (End Date of Last Fiscal Period). |
| Period | tfgld005.prno |
| Period Desc | tfgld005.desc |
| Period Duration | For non-correction periods: End Date – Start Date + 1. For correction periods: 0. |
| Period ID Desc | tfgld005.prno + tfgld005.desc |
| Period Status Gld | tfgld007.sgld |
| Period Status Gld Filter | tfgld007.sgld |
| Period Status Gld Sort | tfgld007.sgld |
| Period Type | tfgld005.ptyp |
| Period Type Filter | tfgld005.ptyp |
| Period Type Sort | tfgld005.ptyp |
| Start Date | For non-correction periods: tfgld005.stdt For correction periods: tfgld006.fpdt (End Date of Last Fiscal Period). |
| Unknown | 1 for null records, else 0 |
| Year | tfgld005.year |
| Year Period | tfgld005.year + tfgld003.psep + tfgld005.prno For example, 2019/11. |
| Year Period Sort | 100* tfgld005.year + tfgld005.prno Numeric representation that can be used to sort and filter. For example, 201911. |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |