invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceLabelsByDocumentNumber: Fortnox Invoice Labels by Document Number

read only REST

  • Catalog: Fortnox
  • Schema: Invoices
  • Label: Invoice Labels by Document Number

Retrieve a single invoice

Can only retrieve data.

API Source

  • Endpoint: /3/invoices/{DocumentNumber}
  • Operation: get /3/invoices/{DocumentNumber}

Performance Characteristics

Characteristic Value
Average access latency (ms) 356
Full scan rows per minute 85,000
Point query rows per minute 168

The result can be cached on the client.

Parameters

Name Data Type Required Default 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).

Table Columns

The columns of the table InvoiceLabelsByDocumentNumber are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
AccountingMethod varchar2 Accounting Method writable, ::ancestor.AccountingMethod
Address1 varchar2 Address Line 1 writable, ::ancestor.Address1
Address2 varchar2 Address Line 2 writable, ::ancestor.Address2
AdministrationFee double Administration Fee writable, ::ancestor.AdministrationFee
AdministrationFeeVAT double Administration Fee VAT writable, ::ancestor.AdministrationFeeVAT
Balance double Balance writable, ::ancestor.Balance
BasisTaxReduction double Basis Tax Reduction writable, ::ancestor.BasisTaxReduction
Booked char Booked writable, ::ancestor.Booked
Cancelled char Cancelled writable, ::ancestor.Cancelled
City varchar2(1024) City writable, ::ancestor.City
Comments varchar2(1024) Comments writable, ::ancestor.Comments
ContractReference int32 Contract Reference writable, ::ancestor.ContractReference
ContributionPercent double Contribution Percent writable, ::ancestor.ContributionPercent
ContributionValue double Contribution Value writable, ::ancestor.ContributionValue
CostCenter varchar2 Cost Centre writable, ::ancestor.CostCenter
Country varchar2 Country writable, ::ancestor.Country
Credit varchar2 Credit writable, ::ancestor.Credit
CreditInvoiceReference varchar2 Credit Invoice Reference writable, ::ancestor.CreditInvoiceReference
Currency varchar2 Currency writable, ::ancestor.Currency
CurrencyRate double Currency Rate writable, ::ancestor.CurrencyRate
CurrencyUnit int32 Currency Unit writable, ::ancestor.CurrencyUnit
CustomerName varchar2 Customer Name writable, ::ancestor.CustomerName
CustomerNumber varchar2 Customer Number writable, ::ancestor.CustomerNumber
DeliveryAddress1 varchar2(1024) Delivery Address 1 writable, ::ancestor.DeliveryAddress1
DeliveryAddress2 varchar2(1024) Delivery Address 2 writable, ::ancestor.DeliveryAddress2
DeliveryCity varchar2(1024) Delivery City writable, ::ancestor.DeliveryCity
DeliveryCountry varchar2 Delivery Country writable, ::ancestor.DeliveryCountry
DeliveryDate datetime Delivery Date writable, ::ancestor.DeliveryDate
DeliveryName varchar2(1024) Delivery Name writable, ::ancestor.DeliveryName
DeliveryZipCode varchar2(1024) Delivery Zip Code writable, ::ancestor.DeliveryZipCode
DocumentNumber varchar2 Document Number writable, ::ancestor.DocumentNumber
DueDate datetime Due Date writable, ::ancestor.DueDate
EDIInformation_EDIGlobalLocationNumber varchar2(13) EDI Information EDI Global Location Number writable, ::ancestor.EDIInformation.EDIGlobalLocationNumber
EDIInformation_EDIGlobalLocationNumberDelivery varchar2(13) EDI Information EDI Global Location Number Delivery writable, ::ancestor.EDIInformation.EDIGlobalLocationNumberDelivery
EDIInformation_EDIInvoiceExtra1 varchar2 EDI Information EDI Invoice Extra 1 writable, ::ancestor.EDIInformation.EDIInvoiceExtra1
EDIInformation_EDIInvoiceExtra2 varchar2 EDI Information EDI Invoice Extra 2 writable, ::ancestor.EDIInformation.EDIInvoiceExtra2
EDIInformation_EDIOurElectronicReference varchar2 EDI Information EDI Our Electronic Reference writable, ::ancestor.EDIInformation.EDIOurElectronicReference
EDIInformation_EDIStatus varchar2 EDI Information EDI Status writable, ::ancestor.EDIInformation.EDIStatus
EDIInformation_EDIYourElectronicReference varchar2 EDI Information EDI Your Electronic Reference writable, ::ancestor.EDIInformation.EDIYourElectronicReference
EUQuarterlyReport char EU Quarterly Report writable, ::ancestor.EUQuarterlyReport
EmailInformation_EmailAddressBCC varchar2 Email Information Email Address Bcc writable, ::ancestor.EmailInformation.EmailAddressBCC
EmailInformation_EmailAddressCC varchar2 Email Information Email Address CC writable, ::ancestor.EmailInformation.EmailAddressCC
EmailInformation_EmailAddressFrom varchar2 Email Information Email Address From writable, ::ancestor.EmailInformation.EmailAddressFrom
EmailInformation_EmailAddressTo varchar2 Email Information Email Address To writable, ::ancestor.EmailInformation.EmailAddressTo
EmailInformation_EmailBody varchar2(20000) Email Information Email Body writable, ::ancestor.EmailInformation.EmailBody
EmailInformation_EmailSubject varchar2(100) Email Information Email Subject writable, ::ancestor.EmailInformation.EmailSubject
ExternalInvoiceReference1 varchar2(80) External Invoice Reference 1 writable, ::ancestor.ExternalInvoiceReference1
ExternalInvoiceReference2 varchar2(80) External Invoice Reference 2 writable, ::ancestor.ExternalInvoiceReference2
FinalPayDate datetime Final Pay Date writable, ::ancestor.FinalPayDate
Freight double Freight writable, ::ancestor.Freight
FreightVAT double Freight VAT writable, ::ancestor.FreightVAT
Gross double Gross writable, ::ancestor.Gross
HouseWork char House Work writable, ::ancestor.HouseWork
Id int32 ID writable, Id
InvoiceDate datetime Invoice Date writable, ::ancestor.InvoiceDate
InvoicePeriodEnd datetime Invoice Period End writable, ::ancestor.InvoicePeriodEnd
InvoicePeriodReference varchar2 Invoice Period Reference writable, ::ancestor.InvoicePeriodReference
InvoicePeriodStart datetime Invoice Period Start writable, ::ancestor.InvoicePeriodStart
InvoiceType varchar2 Invoice Type writable, ::ancestor.InvoiceType
Language varchar2 Language writable, ::ancestor.Language
LastRemindDate datetime Last Remind Date writable, ::ancestor.LastRemindDate
Net double Net writable, ::ancestor.Net
NotCompleted char Notcompleted writable, ::ancestor.NotCompleted
NoxFinans char Nox Finans writable, ::ancestor.NoxFinans
OCR varchar2 Ocr writable, ::ancestor.OCR
OfferReference varchar2 Offer Reference writable, ::ancestor.OfferReference
OrderReference varchar2 Order Reference writable, ::ancestor.OrderReference
OrganisationNumber varchar2 Organisation Number writable, ::ancestor.OrganisationNumber
OurReference varchar2(50) Ourreference writable, ::ancestor.OurReference
OutboundDate datetime Outbound Date writable, ::ancestor.OutboundDate
PaymentWay varchar2 Payment Way writable, ::ancestor.PaymentWay
Phone1 varchar2(1024) Phone 1 writable, ::ancestor.Phone1
Phone2 varchar2(1024) Phone 2 writable, ::ancestor.Phone2
PriceList varchar2 Price List writable, ::ancestor.PriceList
PrintTemplate varchar2 Print Template writable, ::ancestor.PrintTemplate
Project varchar2 Project writable, ::ancestor.Project
Remarks varchar2(1024) Remarks writable, ::ancestor.Remarks
Reminders int32 Reminders writable, ::ancestor.Reminders
RoundOff double Round Off writable, ::ancestor.RoundOff
Sent char Sent writable, ::ancestor.Sent
TaxReduction int32 Tax Reduction writable, ::ancestor.TaxReduction
TaxReductionType varchar2 Tax Reduction Type writable, ::ancestor.TaxReductionType
TermsOfDelivery varchar2 Terms of Delivery writable, ::ancestor.TermsOfDelivery
TermsOfPayment varchar2 Terms of Payment writable, ::ancestor.TermsOfPayment
TimeBasisReference int32 Time Basis Reference writable, ::ancestor.TimeBasisReference
Total double Total writable, ::ancestor.Total
TotalToPay double Total to Pay writable, ::ancestor.TotalToPay
TotalVAT double Total VAT writable, ::ancestor.TotalVAT
VATIncluded char Vatincluded writable, ::ancestor.VATIncluded
VoucherNumber int32 Voucher Number writable, ::ancestor.VoucherNumber
VoucherSeries varchar2 Voucher Series writable, ::ancestor.VoucherSeries
VoucherYear int32 Voucher Year writable, ::ancestor.VoucherYear
WarehouseReady char Warehouse Ready writable, ::ancestor.WarehouseReady
WayOfDelivery varchar2 Way of Delivery writable, ::ancestor.WayOfDelivery
YourOrderNumber varchar2(75) Your Order Number writable, ::ancestor.YourOrderNumber
YourReference varchar2(50) Your Reference writable, ::ancestor.YourReference
ZipCode varchar2(1024) ZIP Code writable, ::ancestor.ZipCode
c_url varchar2 Call URL writable, ::ancestor.@url
c_urlTaxReductionList varchar2 URL Tax Reduction List writable, ::ancestor.@urlTaxReductionList

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: