# InvoiceByDocumentNumber: Fortnox Invoice by Document Number Retrieve a single invoice - Catalog: `Fortnox` - Schema: `Invoices` - Label: Invoice by Document Number This is a read-only table function. The Fortnox API may not support changing the data or the Invantive UniversalSQL driver for Fortnox does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Fortnox API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `InvoiceByDocumentNumber`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `DocumentNumber` | `` | ☑ | | identifies the invoice | | `financialyear` | `` | ☐ | | Selects what financial year that should be used (does not work on every table). | | `financialyeardate` | `` | ☐ | | Selects by date, what financial year that should be used (does not work on every table). | | `fromdate` | `` | ☐ | | Defines a selection based on a start date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table). | | `lastmodified` | `` | ☐ | | Retrieves all records since the provided timestamp (does not work on every table). | | `todate` | `` | ☐ | | Defines a selection based on an end date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table). | ## Columns of Table Function The columns of the table function `InvoiceByDocumentNumber` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Invoice_AccountingMethod` | `varchar2` | Invoice Accounting Method | ☐ | | | `Invoice_Address1` | `varchar2` | Invoice Address 1 | ☐ | | | `Invoice_Address2` | `varchar2` | Invoice Address 2 | ☐ | | | `Invoice_AdministrationFeeVAT` | `double` | Invoice Administration Fee VAT | ☐ | | | `Invoice_AdministrationFee` | `double` | Invoice Administration Fee | ☐ | | | `Invoice_Balance` | `double` | Invoice Balance | ☐ | | | `Invoice_BasisTaxReduction` | `double` | Invoice Basis Tax Reduction | ☐ | | | `Invoice_Booked` | `char` | Invoice Booked | ☐ | | | `Invoice_Cancelled` | `char` | Invoice Cancelled | ☐ | | | `Invoice_City` | `varchar2(1024)` | Invoice City | ☐ | | | `Invoice_Comments` | `varchar2(1024)` | Invoice Comments | ☐ | | | `Invoice_ContractReference` | `int32` | Invoice Contract Reference | ☐ | | | `Invoice_ContributionPercent` | `double` | Invoice Contribution Percent | ☐ | | | `Invoice_ContributionValue` | `double` | Invoice Contribution Value | ☐ | | | `Invoice_CostCenter` | `varchar2` | Invoice Cost Centre | ☐ | | | `Invoice_Country` | `varchar2` | Invoice Country | ☐ | | | `Invoice_CreditInvoiceReference` | `varchar2` | Invoice Credit Invoice Reference | ☐ | | | `Invoice_Credit` | `varchar2` | Invoice Credit | ☐ | | | `Invoice_CurrencyRate` | `double` | Invoice Currency Rate | ☐ | | | `Invoice_CurrencyUnit` | `int32` | Invoice Currency Unit | ☐ | | | `Invoice_Currency` | `varchar2` | Invoice Currency | ☐ | | | `Invoice_CustomerName` | `varchar2` | Invoice Customer Name | ☐ | | | `Invoice_CustomerNumber` | `varchar2` | Invoice Customernumber | ☐ | | | `Invoice_DeliveryAddress1` | `varchar2(1024)` | Invoice Delivery Address 1 | ☐ | | | `Invoice_DeliveryAddress2` | `varchar2(1024)` | Invoice Delivery Address 2 | ☐ | | | `Invoice_DeliveryCity` | `varchar2(1024)` | Invoice Delivery City | ☐ | | | `Invoice_DeliveryCountry` | `varchar2` | Invoice Delivery Country | ☐ | | | `Invoice_DeliveryDate` | `datetime` | Invoice Delivery Date | ☐ | | | `Invoice_DeliveryName` | `varchar2(1024)` | Invoice Delivery Name | ☐ | | | `Invoice_DeliveryZipCode` | `varchar2(1024)` | Invoice Delivery Zip Code | ☐ | | | `Invoice_DocumentNumber` | `varchar2` | Invoice Document Number | ☐ | | | `Invoice_DueDate` | `datetime` | Invoice Duedate | ☐ | | | `Invoice_EDIInformation_EDIGlobalLocationNumberDelivery` | `varchar2(13)` | Invoice EDI Information EDI Global Location Number Delivery | ☐ | | | `Invoice_EDIInformation_EDIGlobalLocationNumber` | `varchar2(13)` | Invoice EDI Information EDI Global Location Number | ☐ | | | `Invoice_EDIInformation_EDIInvoiceExtra1` | `varchar2` | Invoice EDI Information EDI Invoice Extra 1 | ☐ | | | `Invoice_EDIInformation_EDIInvoiceExtra2` | `varchar2` | Invoice EDI Information EDI Invoice Extra 2 | ☐ | | | `Invoice_EDIInformation_EDIOurElectronicReference` | `varchar2` | Invoice EDI Information EDI Our Electronic Reference | ☐ | | | `Invoice_EDIInformation_EDIStatus` | `varchar2` | Invoice EDI Information EDI Status | ☐ | | | `Invoice_EDIInformation_EDIYourElectronicReference` | `varchar2` | Invoice EDI Information EDI Your Electronic Reference | ☐ | | | `Invoice_EUQuarterlyReport` | `char` | Invoice EU Quarterly Report | ☐ | | | `Invoice_EmailInformation_EmailAddressBCC` | `varchar2` | Invoice Email Information Email Address Bcc | ☐ | | | `Invoice_EmailInformation_EmailAddressCC` | `varchar2` | Invoice Email Information Email Address CC | ☐ | | | `Invoice_EmailInformation_EmailAddressFrom` | `varchar2` | Invoice Email Information Email Address From | ☐ | | | `Invoice_EmailInformation_EmailAddressTo` | `varchar2` | Invoice Email Information Email Address To | ☐ | | | `Invoice_EmailInformation_EmailBody` | `varchar2(20000)` | Invoice Email Information Email Body | ☐ | | | `Invoice_EmailInformation_EmailSubject` | `varchar2(100)` | Invoice Email Information Email Subject | ☐ | | | `Invoice_ExternalInvoiceReference1` | `varchar2(80)` | Invoice External Invoice Reference 1 | ☐ | | | `Invoice_ExternalInvoiceReference2` | `varchar2(80)` | Invoice External Invoice Reference 2 | ☐ | | | `Invoice_FinalPayDate` | `datetime` | Invoice Final Pay Date | ☐ | | | `Invoice_FreightVAT` | `double` | Invoice Freight VAT | ☐ | | | `Invoice_Freight` | `double` | Invoice Freight | ☐ | | | `Invoice_Gross` | `double` | Invoice Gross | ☐ | | | `Invoice_HouseWork` | `char` | Invoice House Work | ☐ | | | `Invoice_InvoiceDate` | `datetime` | Invoice Date | ☐ | | | `Invoice_InvoicePeriodEnd` | `datetime` | Invoice Period End | ☐ | | | `Invoice_InvoicePeriodReference` | `varchar2` | Invoice Period Reference | ☐ | | | `Invoice_InvoicePeriodStart` | `datetime` | Invoice Period Start | ☐ | | | `Invoice_InvoiceType` | `varchar2` | Invoice Type | ☐ | | | `Invoice_Language` | `varchar2` | Invoice Language | ☐ | | | `Invoice_LastRemindDate` | `datetime` | Invoice Last Remind Date | ☐ | | | `Invoice_Net` | `double` | Invoice Net | ☐ | | | `Invoice_NotCompleted` | `char` | Invoice Notcompleted | ☐ | | | `Invoice_NoxFinans` | `char` | Invoice Nox Finans | ☐ | | | `Invoice_OCR` | `varchar2` | Invoice Ocr | ☐ | | | `Invoice_OfferReference` | `varchar2` | Invoice Offer Reference | ☐ | | | `Invoice_OrderReference` | `varchar2` | Invoice Order Reference | ☐ | | | `Invoice_OrganisationNumber` | `varchar2` | Invoice Organisation Number | ☐ | | | `Invoice_OurReference` | `varchar2(50)` | Invoice Ourreference | ☐ | | | `Invoice_OutboundDate` | `datetime` | Invoice Outbound Date | ☐ | | | `Invoice_PaymentWay` | `varchar2` | Invoice Payment Way | ☐ | | | `Invoice_Phone1` | `varchar2(1024)` | Invoice Phone 1 | ☐ | | | `Invoice_Phone2` | `varchar2(1024)` | Invoice Phone 2 | ☐ | | | `Invoice_PriceList` | `varchar2` | Invoice Pricelist | ☐ | | | `Invoice_PrintTemplate` | `varchar2` | Invoice Print Template | ☐ | | | `Invoice_Project` | `varchar2` | Invoice Project | ☐ | | | `Invoice_Remarks` | `varchar2(1024)` | Invoice Remarks | ☐ | | | `Invoice_Reminders` | `int32` | Invoice Reminders | ☐ | | | `Invoice_RoundOff` | `double` | Invoice Round Off | ☐ | | | `Invoice_Sent` | `char` | Invoice Sent | ☐ | | | `Invoice_TaxReductionType` | `varchar2` | Invoice Tax Reduction Type | ☐ | | | `Invoice_TaxReduction` | `int32` | Invoice Tax Reduction | ☐ | | | `Invoice_TermsOfDelivery` | `varchar2` | Invoice Terms of Delivery | ☐ | | | `Invoice_TermsOfPayment` | `varchar2` | Invoice Terms of Payment | ☐ | | | `Invoice_TimeBasisReference` | `int32` | Invoice Time Basis Reference | ☐ | | | `Invoice_TotalToPay` | `double` | Invoice Total to Pay | ☐ | | | `Invoice_TotalVAT` | `double` | Invoice Total VAT | ☐ | | | `Invoice_Total` | `double` | Invoice Total | ☐ | | | `Invoice_VATIncluded` | `char` | Invoice Vatincluded | ☐ | | | `Invoice_VoucherNumber` | `int32` | Invoice Voucher Number | ☐ | | | `Invoice_VoucherSeries` | `varchar2` | Invoice Voucher Series | ☐ | | | `Invoice_VoucherYear` | `int32` | Invoice Voucher Year | ☐ | | | `Invoice_WarehouseReady` | `char` | Invoice Warehouse Ready | ☐ | | | `Invoice_WayOfDelivery` | `varchar2` | Invoice Way of Delivery | ☐ | | | `Invoice_YourOrderNumber` | `varchar2(75)` | Invoice Your Order Number | ☐ | | | `Invoice_YourReference` | `varchar2(50)` | Invoice Your Reference | ☐ | | | `Invoice_ZipCode` | `varchar2(1024)` | Invoice ZIP Code | ☐ | | | `Invoice__urlTaxReductionList` | `varchar2` | Invoice URL Tax Reduction List | ☐ | | | `Invoice__url` | `varchar2` | Invoice URL | ☐ | |