# ExportDeliveryNote - Name: `ExportDeliveryNote` - Catalog: `Octopus` - Schema: `OctopusWS` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `bookyearKey_id` | `int32` | ☐ | | | | `COMPANY_CODE` | `string` | ☐ | | | | `documentSequenceNr` | `int32` | ☐ | | | | `journalKey` | `string` | ☐ | | | | `returnDeliverynote` | `boolean` | ☐ | | | | `returnPdfDocument` | `boolean` | ☐ | | | ## Table Columns The columns of the table `ExportDeliveryNote` 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 | ☑ | | | `DELIVERYNOTE_BOOKYEARKEY` | `string` | Delivery Note Financial Year Key | | | | `DELIVERYNOTE_BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `DELIVERYNOTE_BOOKYEARPERIODENR` | `int32` | Delivery Note Period Number | | | | `DELIVERYNOTE_COMMENT` | `string` | Delivery Note Comment | | | | `DELIVERYNOTE_CURRENCYCODE` | `string` | Delivery Note Currency Code | | | | `DELIVERYNOTE_DELIVERYNOTELINES_BOOKINGACCOUNTNR` | `int32` | Account Number | | | | `DELIVERYNOTE_DELIVERYNOTELINES_COSTCENTREKEY` | `string` | Cost Center Key | | | | `DELIVERYNOTE_DELIVERYNOTELINES_COSTCENTREKEY_ID` | `int32` | ID | | | | `DELIVERYNOTE_DELIVERYNOTELINES_COUNT` | `double` | Count | | | | `DELIVERYNOTE_DELIVERYNOTELINES_DESCRIPTION` | `string` | Description | | | | `DELIVERYNOTE_DELIVERYNOTELINES_DISCOUNTPERCENTAGE` | `double` | Discount Percentage | | | | `DELIVERYNOTE_DELIVERYNOTELINES_EXTERNPRODUCTNR` | `string` | External Product Number | | | | `DELIVERYNOTE_DELIVERYNOTELINES_UNIT` | `string` | Unit | | | | `DELIVERYNOTE_DELIVERYNOTELINES_UNITPRICE` | `double` | Unit Price | | | | `DELIVERYNOTE_DELIVERYNOTELINES_VATCODEKEY` | `string` | VAT Code Key | | | | `DELIVERYNOTE_DOCUMENTDATE` | `datetime` | Delivery Note Document Date | | | | `DELIVERYNOTE_DOCUMENTSEQUENCENR` | `int32` | Delivery Note Document Number | | | | `DELIVERYNOTE_EXCHANGERATE` | `double` | Delivery Note Exchange Rate | | | | `DELIVERYNOTE_EXPIRYDATE` | `datetime` | Delivery Note Expiry Date | | | | `DELIVERYNOTE_EXTERNALRELATIONID` | `int32` | Delivery Note External Relation ID | | | | `DELIVERYNOTE_FINANCIALDISCOUNT` | `double` | Delivery Note Financial Discount | | | | `DELIVERYNOTE_JOURNALKEY` | `string` | Delivery Note Journal Key | | | | `DELIVERYNOTE_REFERENCE` | `string` | Delivery Note Reference | | | | `PDFDOCUMENT` | `byte[]` | PDF Document | | | | `PUBLISHURL` | `string` | Publish URL | | | | `RETURN` | `int32` | Return | | |