# BookYearPeriods: Financial Periods - Name: `BookYearPeriods` - Catalog: `Octopus` - Schema: `OctopusWS` - Label: Financial Periods ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `COMPANY_CODE` | `string` | ☐ | | | | `GetBookyears` | `string` | ☐ | | | ## Table Columns The columns of the table `BookYearPeriods` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BOOKYEARPERIOD` | `int32` | Period | | | | `COMPANY_CODE` | `string` | Partition Code | ☑ | | | `COMPANY_NAME` | `string` | Partition Name | ☑ | | | `ENDDATE` | `datetime` | End Date | | | | `RETURN_BOOKYEARDESCRIPTION` | `string` | Financial Year Description | | | | `RETURN_BOOKYEARKEY` | `string` | Financial Year Key | | | | `RETURN_BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `RETURN_CLOSED` | `boolean` | Closed | | | | `RETURN_ENDDATE` | `datetime` | End Date | | | | `RETURN_STARTDATE` | `datetime` | Start Date | | | | `STARTDATE` | `datetime` | Start Date | | |