# Accounts - Name: `Accounts` - 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 `Accounts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCOUNTKEY` | `string` | General Ledger Account Key | | | | `ACCOUNTKEY_BOOKYEARKEY` | `string` | General Ledger Account Key Financial Year Key | | | | `ACCOUNTKEY_BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `ACCOUNTKEY_ID` | `int32` | General Ledger Account Key ID | | | | `COMPANY_CODE` | `string` | Partition Code | ☑ | | | `COMPANY_NAME` | `string` | Partition Name | ☑ | | | `COSTCENTRETYPE` | `int32` | Cost Center Type | | | | `DEFAULTCOSTCENTREKEY` | `string` | Default Cost Centre Key | | | | `DEFAULTCOSTCENTREKEY_ID` | `int32` | Default Cost Centre Key ID | | | | `DESCRIPTION_DESCRIPTION_FR` | `string` | Description Description (FR) | | | | `DESCRIPTION_DESCRIPTION_NL` | `string` | Description Description (NL) | | | | `FISCPROFESSIONALPERCENTAGE` | `double` | Fiscal Professional Percentage | | | | `FISCRECUPPERCENTAGE` | `double` | Fiscal Recovery Percentage | | | | `PURCHASEVATCODE` | `string` | Purchase VAT Code | | | | `SALESVATCODE` | `string` | Sales VAT Code | | | | `VATRECUPPERCENTAGE` | `double` | VAT Recovery Percentage | | |