# InsertUpdateRelation - Name: `InsertUpdateRelation` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `COMPANY_CODE` | `string` | ☐ | | | | `relation_active` | `boolean` | ☐ | | | | `relation_bankAccountNr` | `string` | ☐ | | | | `relation_bicCode` | `string` | ☐ | | | | `relation_city` | `string` | ☐ | | | | `relation_client` | `boolean` | ☐ | | | | `relation_contactPerson` | `string` | ☐ | | | | `relation_corporationType` | `int32` | ☐ | | | | `relation_country` | `string` | ☐ | | | | `relation_defaultBookingAccountClient` | `int32` | ☐ | | | | `relation_defaultBookingAccountSupplier` | `int32` | ☐ | | | | `relation_email` | `string` | ☐ | | | | `relation_expirationDays` | `int32` | ☐ | | | | `relation_expirationType` | `int32` | ☐ | | | | `relation_externalRelationNr` | `int32` | ☐ | | | | `relation_factLanguage` | `int32` | ☐ | | | | `relation_fax` | `string` | ☐ | | | | `relation_firstName` | `string` | ☐ | | | | `relation_ibanAccountNr` | `string` | ☐ | | | | `relation_mobile` | `string` | ☐ | | | | `relation_name` | `string` | ☐ | | | | `relation_postalCode` | `string` | ☐ | | | | `relation_relationKey` | `string` | ☐ | | | | `relation_relationKey_id` | `int32` | ☐ | | | | `relation_remarks` | `string` | ☐ | | | | `relation_searchField1` | `string` | ☐ | | | | `relation_searchField2` | `string` | ☐ | | | | `relation_streetAndNr` | `string` | ☐ | | | | `relation_supplier` | `boolean` | ☐ | | | | `relation_telephone` | `string` | ☐ | | | | `relation_url` | `string` | ☐ | | | | `relation_vatNr` | `string` | ☐ | | | | `relation_vatType` | `int32` | ☐ | | | ## Table Columns The columns of the table `InsertUpdateRelation` 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 | | |