# InsertUpdateProduct - Name: `InsertUpdateProduct` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `COMPANY_CODE` | `string` | ☐ | | | | `product_code_description_FR` | `string` | ☐ | | | | `product_code_description_NL` | `string` | ☐ | | | | `product_currencyCode` | `string` | ☐ | | | | `product_defaultBookingAccountNr` | `int32` | ☐ | | | | `product_defaultCostCentre` | `string` | ☐ | | | | `product_defaultCostCentre_id` | `int32` | ☐ | | | | `product_description_description_FR` | `string` | ☐ | | | | `product_description_description_NL` | `string` | ☐ | | | | `product_externProductNr` | `string` | ☐ | | | | `product_priceVatExclusive` | `double` | ☐ | | | | `product_priceVatInclusive` | `double` | ☐ | | | | `product_productGroup` | `string` | ☐ | | | | `product_productGroup_id` | `int32` | ☐ | | | | `product_productKey` | `string` | ☐ | | | | `product_productKey_id` | `int32` | ☐ | | | | `product_supplierInfo` | `string` | ☐ | | | | `product_unit` | `string` | ☐ | | | | `product_vatCode` | `string` | ☐ | | | ## Table Columns The columns of the table `InsertUpdateProduct` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `COMPANY_CODE` | `string` | Partition Code | ☑ | | | `COMPANY_NAME` | `string` | Partition Name | ☑ | | | `RETURN` | `int32` | Return | | |