# ModifiedRelations - Name: `ModifiedRelations` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `COMPANY_CODE` | `string` | ☐ | | | | `modifiedSince` | `datetime` | ☐ | | | ## Table Columns The columns of the table `ModifiedRelations` 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 | ☑ | | | `DELETEDRELATIONS_ACTIVE` | `boolean` | Deleted Relations Active | | | | `DELETEDRELATIONS_BANKACCOUNTNR` | `string` | Deleted Relations Bank Account Number | | | | `DELETEDRELATIONS_BICCODE` | `string` | Deleted Relations BIC Code | | | | `DELETEDRELATIONS_CITY` | `string` | Deleted Relations City | | | | `DELETEDRELATIONS_CLIENT` | `boolean` | Deleted Relations Client | | | | `DELETEDRELATIONS_CONTACTPERSON` | `string` | Deleted Relations Contact Person | | | | `DELETEDRELATIONS_CORPORATIONTYPE` | `int32` | Deleted Relations Corporation Type | | | | `DELETEDRELATIONS_COUNTRY` | `string` | Deleted Relations Country | | | | `DELETEDRELATIONS_DEFAULTBOOKINGACCOUNTCLIENT` | `int32` | Deleted Relations Default Booking Account Client | | | | `DELETEDRELATIONS_DEFAULTBOOKINGACCOUNTSUPPLIER` | `int32` | Deleted Relations Default Booking Account Supplier | | | | `DELETEDRELATIONS_EMAIL` | `string` | Deleted Relations Email | | | | `DELETEDRELATIONS_EXPIRATIONDAYS` | `int32` | Deleted Relations Expiration Days | | | | `DELETEDRELATIONS_EXPIRATIONTYPE` | `int32` | Deleted Relations Expiration Type | | | | `DELETEDRELATIONS_EXTERNALRELATIONNR` | `int32` | Deleted Relations External Relation Number | | | | `DELETEDRELATIONS_FACTLANGUAGE` | `int32` | Deleted Relations Invoice Language | | | | `DELETEDRELATIONS_FAX` | `string` | Deleted Relations Fax | | | | `DELETEDRELATIONS_FIRSTNAME` | `string` | Deleted Relations First Name | | | | `DELETEDRELATIONS_IBANACCOUNTNR` | `string` | Deleted Relations IBAN Account Number | | | | `DELETEDRELATIONS_MOBILE` | `string` | Deleted Relations Mobile | | | | `DELETEDRELATIONS_NAME` | `string` | Deleted Relations Name | | | | `DELETEDRELATIONS_POSTALCODE` | `string` | Deleted Relations Postal Code | | | | `DELETEDRELATIONS_RELATIONKEY` | `string` | Deleted Relations Relation Key | | | | `DELETEDRELATIONS_RELATIONKEY_ID` | `int32` | Deleted Relations Relation Key ID | | | | `DELETEDRELATIONS_REMARKS` | `string` | Deleted Relations Remarks | | | | `DELETEDRELATIONS_SEARCHFIELD1` | `string` | Deleted Relations Search Field 1 | | | | `DELETEDRELATIONS_SEARCHFIELD2` | `string` | Deleted Relations Search Field 2 | | | | `DELETEDRELATIONS_STREETANDNR` | `string` | Deleted Relations Street and House Number | | | | `DELETEDRELATIONS_SUPPLIER` | `boolean` | Deleted Relations Supplier | | | | `DELETEDRELATIONS_TELEPHONE` | `string` | Deleted Relations Telephone | | | | `DELETEDRELATIONS_URL` | `string` | Deleted Relations URL | | | | `DELETEDRELATIONS_VATNR` | `string` | Deleted Relations VAT Number | | | | `DELETEDRELATIONS_VATTYPE` | `int32` | Deleted Relations VAT Type | | | | `MODIFIEDRELATIONS_ACTIVE` | `boolean` | Active | | | | `MODIFIEDRELATIONS_BANKACCOUNTNR` | `string` | Bank Account Number | | | | `MODIFIEDRELATIONS_BICCODE` | `string` | BIC Code | | | | `MODIFIEDRELATIONS_CITY` | `string` | City | | | | `MODIFIEDRELATIONS_CLIENT` | `boolean` | Client | | | | `MODIFIEDRELATIONS_CONTACTPERSON` | `string` | Contact Person | | | | `MODIFIEDRELATIONS_CORPORATIONTYPE` | `int32` | Corporation Type | | | | `MODIFIEDRELATIONS_COUNTRY` | `string` | Country | | | | `MODIFIEDRELATIONS_DEFAULTBOOKINGACCOUNTCLIENT` | `int32` | Default Booking Account Client | | | | `MODIFIEDRELATIONS_DEFAULTBOOKINGACCOUNTSUPPLIER` | `int32` | Default Booking Account Supplier | | | | `MODIFIEDRELATIONS_EMAIL` | `string` | Email | | | | `MODIFIEDRELATIONS_EXPIRATIONDAYS` | `int32` | Expiration Days | | | | `MODIFIEDRELATIONS_EXPIRATIONTYPE` | `int32` | Expiration Type | | | | `MODIFIEDRELATIONS_EXTERNALRELATIONNR` | `int32` | External Relation Number | | | | `MODIFIEDRELATIONS_FACTLANGUAGE` | `int32` | Invoice Language | | | | `MODIFIEDRELATIONS_FAX` | `string` | Fax | | | | `MODIFIEDRELATIONS_FIRSTNAME` | `string` | First Name | | | | `MODIFIEDRELATIONS_IBANACCOUNTNR` | `string` | IBAN Account Number | | | | `MODIFIEDRELATIONS_MOBILE` | `string` | Mobile | | | | `MODIFIEDRELATIONS_NAME` | `string` | Name | | | | `MODIFIEDRELATIONS_POSTALCODE` | `string` | Postal Code | | | | `MODIFIEDRELATIONS_RELATIONKEY` | `string` | Relation Key | | | | `MODIFIEDRELATIONS_RELATIONKEY_ID` | `int32` | Modified Relations Relation Key ID | | | | `MODIFIEDRELATIONS_REMARKS` | `string` | Remarks | | | | `MODIFIEDRELATIONS_SEARCHFIELD1` | `string` | Search Field 1 | | | | `MODIFIEDRELATIONS_SEARCHFIELD2` | `string` | Search Field 2 | | | | `MODIFIEDRELATIONS_STREETANDNR` | `string` | Street and House Number | | | | `MODIFIEDRELATIONS_SUPPLIER` | `boolean` | Supplier | | | | `MODIFIEDRELATIONS_TELEPHONE` | `string` | Telephone | | | | `MODIFIEDRELATIONS_URL` | `string` | URL | | | | `MODIFIEDRELATIONS_VATNR` | `string` | VAT Number | | | | `MODIFIEDRELATIONS_VATTYPE` | `int32` | VAT Type | | | | `RETURN` | `int32` | Return | | |