# Journals - Name: `Journals` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `bookyearKey_id` | `int32` | ☐ | | | | `COMPANY_CODE` | `string` | ☐ | | | ## Table Columns The columns of the table `Journals` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BOOKYEARKEY` | `string` | Financial Year Key | | | | `BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `CLOSED` | `boolean` | Closed | | | | `CLOSEDPERIOD` | `int32` | Closed Period | | | | `COMPANY_CODE` | `string` | Partition Code | ☑ | | | `COMPANY_NAME` | `string` | Partition Name | ☑ | | | `CURRENCYCODE` | `string` | Currency Code | | | | `INSERTIONTYPE` | `int32` | Insertion Type | | | | `JOURNALKEY` | `string` | Journal Key | | | | `LASTBOOKEDDOCUMENTNR` | `int32` | Last Book Document Number | | | | `NAME` | `string` | Name | | | | `PROTECTEDPERIOD` | `int32` | Protected Period | | |