# InsertDeliveryNote - Name: `InsertDeliveryNote` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `COMPANY_CODE` | `string` | ☐ | | | | `deliveryNote_bookyearKey` | `string` | ☐ | | | | `deliveryNote_bookyearKey_id` | `int32` | ☐ | | | | `deliveryNote_bookyearPeriodeNr` | `int32` | ☐ | | | | `deliveryNote_comment` | `string` | ☐ | | | | `deliveryNote_currencyCode` | `string` | ☐ | | | | `deliveryNote_deliveryNoteLines_bookingAccountNr` | `int32` | ☐ | | | | `deliveryNote_deliveryNoteLines_costCentreKey` | `string` | ☐ | | | | `deliveryNote_deliveryNoteLines_costCentreKey_id` | `int32` | ☐ | | | | `deliveryNote_deliveryNoteLines_count` | `double` | ☐ | | | | `deliveryNote_deliveryNoteLines_description` | `string` | ☐ | | | | `deliveryNote_deliveryNoteLines_discountPercentage` | `double` | ☐ | | | | `deliveryNote_deliveryNoteLines_externProductNr` | `string` | ☐ | | | | `deliveryNote_deliveryNoteLines_unit` | `string` | ☐ | | | | `deliveryNote_deliveryNoteLines_unitPrice` | `double` | ☐ | | | | `deliveryNote_deliveryNoteLines_vatCodeKey` | `string` | ☐ | | | | `deliveryNote_documentDate` | `datetime` | ☐ | | | | `deliveryNote_documentSequenceNr` | `int32` | ☐ | | | | `deliveryNote_exchangeRate` | `double` | ☐ | | | | `deliveryNote_expiryDate` | `datetime` | ☐ | | | | `deliveryNote_externalRelationId` | `int32` | ☐ | | | | `deliveryNote_financialDiscount` | `double` | ☐ | | | | `deliveryNote_journalKey` | `string` | ☐ | | | | `deliveryNote_reference` | `string` | ☐ | | | ## Table Columns The columns of the table `InsertDeliveryNote` 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 | | |