# AccountsAll - Name: `AccountsAll` - Catalog: `Octopus` - Schema: `Views` ## Table Columns The columns of the table `AccountsAll` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `act_ACCOUNTKEY` | `string` | General Ledger Account Key | | | | `act_ACCOUNTKEY_BOOKYEARKEY` | `string` | General Ledger Account Key Financial Year Key | | | | `act_ACCOUNTKEY_BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `act_ACCOUNTKEY_ID` | `int32` | General Ledger Account Key ID | | | | `act_COMPANY_CODE` | `string` | Partition Code | ☑ | | | `act_COMPANY_NAME` | `string` | Partition Name | ☑ | | | `act_COSTCENTRETYPE` | `int32` | Cost Center Type | | | | `act_DEFAULTCOSTCENTREKEY` | `string` | Default Cost Centre Key | | | | `act_DEFAULTCOSTCENTREKEY_ID` | `int32` | Default Cost Centre Key ID | | | | `act_DESCRIPTION_DESCRIPTION_FR` | `string` | Description Description (FR) | | | | `act_DESCRIPTION_DESCRIPTION_NL` | `string` | Description Description (NL) | | | | `act_FISCPROFESSIONALPERCENTAGE` | `double` | Fiscal Professional Percentage | | | | `act_FISCRECUPPERCENTAGE` | `double` | Fiscal Recovery Percentage | | | | `act_PURCHASEVATCODE` | `string` | Purchase VAT Code | | | | `act_SALESVATCODE` | `string` | Sales VAT Code | | | | `act_VATRECUPPERCENTAGE` | `double` | VAT Recovery Percentage | | | | `byr_BOOKYEARDESCRIPTION` | `string` | Financial Year Description | | | | `byr_BOOKYEARKEY` | `string` | Financial Year Key | | | | `byr_BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `byr_CLOSED` | `boolean` | Closed | | | | `byr_COMPANY_CODE` | `string` | Partition Code | ☑ | | | `byr_COMPANY_NAME` | `string` | Partition Name | ☑ | | | `byr_ENDDATE` | `datetime` | End Date | | | | `byr_PERIODS_BOOKYEARPERIOD` | `int32` | Period | | | | `byr_PERIODS_ENDDATE` | `datetime` | End Date | | | | `byr_PERIODS_STARTDATE` | `datetime` | Start Date | | | | `byr_STARTDATE` | `datetime` | Start Date | | |