# Products - Name: `Products` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `COMPANY_CODE` | `string` | ☐ | | | | `GetProducts` | `string` | ☐ | | | ## Table Columns The columns of the table `Products` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CODE_DESCRIPTION_FR` | `string` | Code Description (FR) | | | | `CODE_DESCRIPTION_NL` | `string` | Code Description (NL) | | | | `COMPANY_CODE` | `string` | Partition Code | ☑ | | | `COMPANY_NAME` | `string` | Partition Name | ☑ | | | `CURRENCYCODE` | `string` | Currency Code | | | | `DEFAULTBOOKINGACCOUNTNR` | `int32` | Default Booking Account Number | | | | `DEFAULTCOSTCENTRE` | `string` | Default Cost Center | | | | `DEFAULTCOSTCENTRE_ID` | `int32` | Default Cost Center ID | | | | `DESCRIPTION_DESCRIPTION_FR` | `string` | Description Description (FR) | | | | `DESCRIPTION_DESCRIPTION_NL` | `string` | Description Description (NL) | | | | `EXTERNPRODUCTNR` | `string` | External Product Number | | | | `PRICEVATEXCLUSIVE` | `double` | Price Excluding VAT | | | | `PRICEVATINCLUSIVE` | `double` | Price Including VAT | | | | `PRODUCTGROUP` | `string` | Product Group | | | | `PRODUCTGROUP_ID` | `int32` | Product Group ID | | | | `PRODUCTKEY` | `string` | Product Key | | | | `PRODUCTKEY_ID` | `int32` | Product Key ID | | | | `SUPPLIERINFO` | `string` | Supplier Information | | | | `UNIT` | `string` | Unit | | | | `VATCODE` | `string` | VAT Code | | |