# RappelInformation - Name: `RappelInformation` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `COMPANY_CODE` | `string` | ☐ | | | | `expirationDate` | `datetime` | ☐ | | | ## Table Columns The columns of the table `RappelInformation` 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 | ☑ | | | `INVOICELIST_BOOKYEARKEY` | `string` | Financial Year Key | | | | `INVOICELIST_BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `INVOICELIST_COMMENT` | `string` | Comment | | | | `INVOICELIST_CURRENCYCODE` | `string` | Currency Code | | | | `INVOICELIST_DOCUMENTDATE` | `datetime` | Document Date | | | | `INVOICELIST_DOCUMENTSEQUENCENR` | `int32` | Document Number | | | | `INVOICELIST_EXPIRATIONDATE` | `datetime` | Expiration Date | | | | `INVOICELIST_JOURNALKEY` | `string` | Journal Key | | | | `INVOICELIST_OPENAMOUNT` | `double` | Open Amount | | | | `INVOICELIST_RAPPELINFOLIST_RAPPELDATE` | `datetime` | Dunning Date | | | | `INVOICELIST_RAPPELINFOLIST_RAPPELID` | `int32` | Dunning ID | | | | `INVOICELIST_REFERENCE` | `string` | Reference | | | | `RELATION_ACTIVE` | `boolean` | Relation Active | | | | `RELATION_BANKACCOUNTNR` | `string` | Relation Bank Account Number | | | | `RELATION_BICCODE` | `string` | Relation BIC Code | | | | `RELATION_CITY` | `string` | Relation City | | | | `RELATION_CLIENT` | `boolean` | Relation Client | | | | `RELATION_CONTACTPERSON` | `string` | Relation Contact Person | | | | `RELATION_CORPORATIONTYPE` | `int32` | Relation Corporation Type | | | | `RELATION_COUNTRY` | `string` | Relation Country | | | | `RELATION_DEFAULTBOOKINGACCOUNTCLIENT` | `int32` | Relation Default Booking Account Client | | | | `RELATION_DEFAULTBOOKINGACCOUNTSUPPLIER` | `int32` | Relation Default Booking Account Supplier | | | | `RELATION_EMAIL` | `string` | Relation Email | | | | `RELATION_EXPIRATIONDAYS` | `int32` | Relation Expiration Days | | | | `RELATION_EXPIRATIONTYPE` | `int32` | Relation Expiration Type | | | | `RELATION_EXTERNALRELATIONNR` | `int32` | Relation External Relation Number | | | | `RELATION_FACTLANGUAGE` | `int32` | Relation Invoice Language | | | | `RELATION_FAX` | `string` | Relation Fax | | | | `RELATION_FIRSTNAME` | `string` | Relation First Name | | | | `RELATION_IBANACCOUNTNR` | `string` | Relation IBAN Account Number | | | | `RELATION_MOBILE` | `string` | Relation Mobile | | | | `RELATION_NAME` | `string` | Relation Name | | | | `RELATION_POSTALCODE` | `string` | Relation Postal Code | | | | `RELATION_RELATIONKEY` | `string` | Relation Relation Key | | | | `RELATION_RELATIONKEY_ID` | `int32` | Relation Key ID | | | | `RELATION_REMARKS` | `string` | Relation Remarks | | | | `RELATION_SEARCHFIELD1` | `string` | Relation Search Field 1 | | | | `RELATION_SEARCHFIELD2` | `string` | Relation Search Field 2 | | | | `RELATION_STREETANDNR` | `string` | Relation Street and House Number | | | | `RELATION_SUPPLIER` | `boolean` | Relation Supplier | | | | `RELATION_TELEPHONE` | `string` | Relation Telephone | | | | `RELATION_URL` | `string` | Relation URL | | | | `RELATION_VATNR` | `string` | Relation VAT Number | | | | `RELATION_VATTYPE` | `int32` | Relation VAT Type | | |