# Relations - Name: `Relations` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `COMPANY_CODE` | `string` | ☐ | | | | `GetRelations` | `string` | ☐ | | | ## Table Columns The columns of the table `Relations` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACTIVE` | `boolean` | Active | | | | `BANKACCOUNTNR` | `string` | Bank Account Number | | | | `BICCODE` | `string` | BIC Code | | | | `CITY` | `string` | City | | | | `CLIENT` | `boolean` | Client | | | | `COMPANY_CODE` | `string` | Partition Code | ☑ | | | `COMPANY_NAME` | `string` | Partition Name | ☑ | | | `CONTACTPERSON` | `string` | Contact Person | | | | `CORPORATIONTYPE` | `int32` | Corporation Type | | | | `COUNTRY` | `string` | Country | | | | `DEFAULTBOOKINGACCOUNTCLIENT` | `int32` | Default Booking Account Client | | | | `DEFAULTBOOKINGACCOUNTSUPPLIER` | `int32` | Default Booking Account Supplier | | | | `EMAIL` | `string` | Email | | | | `EXPIRATIONDAYS` | `int32` | Expiration Days | | | | `EXPIRATIONTYPE` | `int32` | Expiration Type | | | | `EXTERNALRELATIONNR` | `int32` | External Relation Number | | | | `FACTLANGUAGE` | `int32` | Invoice Language | | | | `FAX` | `string` | Fax | | | | `FIRSTNAME` | `string` | First Name | | | | `IBANACCOUNTNR` | `string` | IBAN Account Number | | | | `MOBILE` | `string` | Mobile | | | | `NAME` | `string` | Name | | | | `POSTALCODE` | `string` | Postal Code | | | | `RELATIONKEY` | `string` | Relation Key | | | | `RELATIONKEY_ID` | `int32` | Relation Key ID | | | | `REMARKS` | `string` | Remarks | | | | `SEARCHFIELD1` | `string` | Search Field 1 | | | | `SEARCHFIELD2` | `string` | Search Field 2 | | | | `STREETANDNR` | `string` | Street and House Number | | | | `SUPPLIER` | `boolean` | Supplier | | | | `TELEPHONE` | `string` | Telephone | | | | `URL` | `string` | URL | | | | `VATNR` | `string` | VAT Number | | | | `VATTYPE` | `int32` | VAT Type | | |