# DeliveryNotesAll - Name: `DeliveryNotesAll` - Catalog: `Octopus` - Schema: `Views` ## Table Columns The columns of the table `DeliveryNotesAll` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `byr_BOOKYEARDESCRIPTION` | `string` | Financial Year Description | | | | `byr_BOOKYEARKEY` | `string` | Financial Year Key | | | | `byr_BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `byr_CLOSED` | `boolean` | Closed | | | | `byr_COMPANY_CODE` | `string` | Partition Code | ☑ | | | `byr_COMPANY_NAME` | `string` | Partition Name | ☑ | | | `byr_ENDDATE` | `datetime` | End Date | | | | `byr_PERIODS_BOOKYEARPERIOD` | `int32` | Period | | | | `byr_PERIODS_ENDDATE` | `datetime` | End Date | | | | `byr_PERIODS_STARTDATE` | `datetime` | Start Date | | | | `byr_STARTDATE` | `datetime` | Start Date | | | | `dne_BOOKYEARKEY` | `string` | Financial Year Key | | | | `dne_BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `dne_BOOKYEARPERIODENR` | `int32` | Period Number | | | | `dne_COMMENT` | `string` | Comment | | | | `dne_COMPANY_CODE` | `string` | Partition Code | ☑ | | | `dne_COMPANY_NAME` | `string` | Partition Name | ☑ | | | `dne_CURRENCYCODE` | `string` | Currency Code | | | | `dne_DELIVERYNOTELINES_BOOKINGACCOUNTNR` | `int32` | Delivery Note Lines Account Number | | | | `dne_DELIVERYNOTELINES_COSTCENTREKEY` | `string` | Delivery Note Lines Cost Center Key | | | | `dne_DELIVERYNOTELINES_COSTCENTREKEY_ID` | `int32` | Delivery Note Lines Cost Center Key ID | | | | `dne_DELIVERYNOTELINES_COUNT` | `double` | Delivery Note Lines Count | | | | `dne_DELIVERYNOTELINES_DESCRIPTION` | `string` | Delivery Note Lines Description | | | | `dne_DELIVERYNOTELINES_DISCOUNTPERCENTAGE` | `double` | Delivery Note Lines Discount Percentage | | | | `dne_DELIVERYNOTELINES_EXTERNPRODUCTNR` | `string` | Delivery Note Lines External Product Number | | | | `dne_DELIVERYNOTELINES_UNIT` | `string` | Delivery Note Lines Unit | | | | `dne_DELIVERYNOTELINES_UNITPRICE` | `double` | Delivery Note Lines Unit Price | | | | `dne_DELIVERYNOTELINES_VATCODEKEY` | `string` | Delivery Note Lines VAT Code Key | | | | `dne_DOCUMENTDATE` | `datetime` | Document Date | | | | `dne_DOCUMENTSEQUENCENR` | `int32` | Document Number | | | | `dne_EXCHANGERATE` | `double` | Exchange Rate | | | | `dne_EXPIRYDATE` | `datetime` | Expiry Date | | | | `dne_EXTERNALRELATIONID` | `int32` | External Relation ID | | | | `dne_FINANCIALDISCOUNT` | `double` | Financial Discount | | | | `dne_JOURNALKEY` | `string` | Journal Key | | | | `dne_REFERENCE` | `string` | Reference | | | | `jnl_BOOKYEARKEY` | `string` | Financial Year Key | | | | `jnl_BOOKYEARKEY_ID` | `int32` | Financial Year Key ID | | | | `jnl_CLOSED` | `boolean` | Closed | | | | `jnl_CLOSEDPERIOD` | `int32` | Closed Period | | | | `jnl_COMPANY_CODE` | `string` | Partition Code | ☑ | | | `jnl_COMPANY_NAME` | `string` | Partition Name | ☑ | | | `jnl_CURRENCYCODE` | `string` | Currency Code | | | | `jnl_INSERTIONTYPE` | `int32` | Insertion Type | | | | `jnl_JOURNALKEY` | `string` | Journal Key | | | | `jnl_LASTBOOKEDDOCUMENTNR` | `int32` | Last Book Document Number | | | | `jnl_NAME` | `string` | Name | | | | `jnl_PROTECTEDPERIOD` | `int32` | Protected Period | | |