# InvoiceLines: Invoice Lines - Name: `InvoiceLines` - Catalog: `Octopus` - Schema: `OctopusWS` - Label: Invoice Lines ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `bookyearKey_id` | `int32` | ☐ | | | | `COMPANY_CODE` | `string` | ☐ | | | | `documentSequenceNr` | `int32` | ☐ | | | | `journalKey` | `string` | ☐ | | | ## Table Columns The columns of the table `InvoiceLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BOOKINGACCOUNTNR` | `int32` | Account Number | | | | `COMPANY_CODE` | `string` | Partition Code | ☑ | | | `COMPANY_NAME` | `string` | Partition Name | ☑ | | | `COSTCENTREKEY` | `string` | Cost Center Key | | | | `COSTCENTREKEY_ID` | `int32` | Cost Center Key ID | | | | `COUNT` | `double` | Count | | | | `DESCRIPTION` | `string` | Description | | | | `DISCOUNTPERCENTAGE` | `double` | Discount Percentage | | | | `EXTERNPRODUCTNR` | `string` | External Product Number | | | | `RETURN_BOOKYEARKEY` | `string` | Financial Year Key | | | | `RETURN_BOOKYEARKEY_ID` | `int32` | Financial Year ID | | | | `RETURN_BOOKYEARPERIODENR` | `int32` | Period Number | | | | `RETURN_COMMENT` | `string` | Comment | | | | `RETURN_CURRENCYCODE` | `string` | Currency Code | | | | `RETURN_DOCUMENTDATE` | `datetime` | Document Date | | | | `RETURN_DOCUMENTSEQUENCENR` | `int32` | Document Number | | | | `RETURN_EXCHANGERATE` | `double` | Exchange Rate | | | | `RETURN_EXPIRYDATE` | `datetime` | Expiry Date | | | | `RETURN_EXTERNALRELATIONID` | `int32` | External Relation ID | | | | `RETURN_FINANCIALDISCOUNT` | `double` | Financial Discount | | | | `RETURN_JOURNALKEY` | `string` | Journal Key | | | | `RETURN_REFERENCE` | `string` | Reference | | | | `UNIT` | `string` | Unit | | | | `UNITPRICE` | `double` | Unit Price | | | | `VATCODEKEY` | `string` | VAT Code Key | | |