# ReportHistoryCostCentre - Name: `ReportHistoryCostCentre` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `COMPANY_CODE` | `string` | ☐ | | | | `historyCostCentreQueryData_fromAccountNr` | `int32` | ☐ | | | | `historyCostCentreQueryData_fromBookyearKey` | `string` | ☐ | | | | `historyCostCentreQueryData_fromBookyearKey_id` | `int32` | ☐ | | | | `historyCostCentreQueryData_fromBookyearPeriodNr` | `int32` | ☐ | | | | `historyCostCentreQueryData_showActiveCostCentres` | `boolean` | ☐ | | | | `historyCostCentreQueryData_showEmptyCostcentres` | `boolean` | ☐ | | | | `historyCostCentreQueryData_showInactiveCostCentres` | `boolean` | ☐ | | | | `historyCostCentreQueryData_toAccountNr` | `int32` | ☐ | | | | `historyCostCentreQueryData_toBookyearKey` | `string` | ☐ | | | | `historyCostCentreQueryData_toBookyearKey_id` | `int32` | ☐ | | | | `historyCostCentreQueryData_toBookyearPeriodNr` | `int32` | ☐ | | | ## Table Columns The columns of the table `ReportHistoryCostCentre` 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 | | | | `ACCOUNTNAME` | `string` | Account Name | | | | `ACTIVECOSTCENTRE` | `boolean` | Active Cost Center | | | | `BOOKYEARKEY` | `string` | Financial Year Key | | | | `BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `BOOKYEARPERIODNR` | `int32` | Financial Period Number | | | | `COMMENT` | `string` | Comment | | | | `COMPANY_CODE` | `string` | Partition Code | ☑ | | | `COMPANY_NAME` | `string` | Partition Name | ☑ | | | `COSTCENTREKEY` | `string` | Cost Center Key | | | | `COSTCENTREKEY_ID` | `int32` | Cost Center Key ID | | | | `COSTCENTRENAME` | `string` | Cost Center Name | | | | `CREDITBOOKINGAMOUNT` | `double` | Credit Booking Amount | | | | `DEBETBOOKINGAMOUNT` | `double` | Debit Booking Amount | | | | `DOCUMENTDATE` | `datetime` | Document Date | | | | `DOCUMENTSEQUENCENR` | `int32` | Document Number | | | | `JOURNALKEY` | `string` | Journal Key | | | | `RELATIONKEY` | `string` | Relation Key | | | | `RELATIONKEY_ID` | `int32` | Relation Key ID | | | | `RELATIONNAME` | `string` | Relation Name | | |