invantive documentation
Invantive Support ForumsLog In / Sign Up

ContractInvoiceLinesByDocumentNumber: Fortnox Contract Invoice Lines by Document Number

read only REST

  • Catalog: Fortnox
  • Schema: Contracts
  • Label: Contract Invoice Lines by Document Number

Retrieve a single contract

Can only retrieve data.

API Source

  • Endpoint: /3/contracts/{DocumentNumber}
  • Operation: get /3/contracts/{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 contract
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 ContractInvoiceLinesByDocumentNumber 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
AccountNumber int32 Account Number writable, AccountNumber
Active char Active writable, ::ancestor.Active
AdministrationFee double Administration Fee writable, ::ancestor.AdministrationFee
ArticleNumber varchar2 Article Number writable, ArticleNumber
BasisTaxReduction double Basis Tax Reduction writable, ::ancestor.BasisTaxReduction
Comments varchar2(1024) Comments writable, ::ancestor.Comments
Continuous char Continuous writable, ::ancestor.Continuous
ContractDate datetime Contract Date writable, ::ancestor.ContractDate
ContractLength int32 Contract Length writable, ::ancestor.ContractLength
ContributionPercent varchar2 Contribution Percent writable, ContributionPercent
ContributionPercent_2 double Contribution Percent 2 writable, ::ancestor.ContributionPercent
ContributionValue varchar2 Contribution Value writable, ContributionValue
ContributionValue_2 double Contribution Value 2 writable, ::ancestor.ContributionValue
CostCenter varchar2 Cost Centre writable, CostCenter
CostCenter_2 varchar2 Cost Centre 2 writable, ::ancestor.CostCenter
Currency varchar2 Currency writable, ::ancestor.Currency
CustomerName varchar2 Customer Name writable, ::ancestor.CustomerName
CustomerNumber varchar2 Customer Number writable, ::ancestor.CustomerNumber
DeliveredQuantity varchar2 Delivered Quantity writable, DeliveredQuantity
Description varchar2 Description writable, Description
Discount double Discount writable, Discount
DiscountType varchar2 Discount Type writable, DiscountType
DocumentNumber varchar2 Document Number writable, ::ancestor.DocumentNumber
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 Email Information Email Body writable, ::ancestor.EmailInformation.EmailBody
EmailInformation_EmailSubject varchar2 Email Information Email Subject writable, ::ancestor.EmailInformation.EmailSubject
ExternalInvoiceReference1 varchar2 External Invoice Reference 1 writable, ::ancestor.ExternalInvoiceReference1
ExternalInvoiceReference2 varchar2 External Invoice Reference 2 writable, ::ancestor.ExternalInvoiceReference2
Freight double Freight writable, ::ancestor.Freight
Gross double Gross writable, ::ancestor.Gross
HouseWork char House Work writable, HouseWork
HouseWorkHoursToReport int32 House Work Hours to Report writable, HouseWorkHoursToReport
HouseWorkType varchar2 House Worktype writable, HouseWorkType
HouseWork_2 char House Work 2 writable, ::ancestor.HouseWork
InvoiceDiscount double Invoice Discount writable, ::ancestor.InvoiceDiscount
InvoiceInterval int32 Invoice Interval writable, ::ancestor.InvoiceInterval
InvoicesRemaining varchar2 Invoices Remaining writable, ::ancestor.InvoicesRemaining
Language varchar2 Language writable, ::ancestor.Language
LastInvoiceDate varchar2 Last Invoice Date writable, ::ancestor.LastInvoiceDate
Net double Net writable, ::ancestor.Net
OurReference varchar2(25) Ourreference writable, ::ancestor.OurReference
PeriodEnd datetime Period End writable, ::ancestor.PeriodEnd
PeriodStart datetime Period Start writable, ::ancestor.PeriodStart
Price double Price writable, Price
PriceExcludingVAT double Price excluding VAT writable, PriceExcludingVAT
PriceList varchar2 Price List writable, ::ancestor.PriceList
PrintTemplate varchar2 Print Template writable, ::ancestor.PrintTemplate
Project varchar2 Project writable, Project
Project_2 varchar2 Project 2 writable, ::ancestor.Project
Remarks varchar2(1024) Remarks writable, ::ancestor.Remarks
RoundOff double Round Off writable, ::ancestor.RoundOff
RowId int32 Row ID writable, RowId
TaxReduction double Tax Reduction writable, ::ancestor.TaxReduction
TaxReductionType varchar2 Tax Reduction Type writable, ::ancestor.TaxReductionType
TemplateName varchar2 Template Name writable, ::ancestor.TemplateName
TemplateNumber int32 Template Number writable, ::ancestor.TemplateNumber
TermsOfDelivery varchar2 Terms of Delivery writable, ::ancestor.TermsOfDelivery
TermsOfPayment varchar2 Terms of Payment writable, ::ancestor.TermsOfPayment
Total double Total writable, Total
TotalExcludingVAT double Total Excluding VAT writable, TotalExcludingVAT
TotalToPay double Total to Pay writable, ::ancestor.TotalToPay
TotalVAT double Total VAT writable, ::ancestor.TotalVAT
Total_2 double Total 2 writable, ::ancestor.Total
Unit varchar2 Unit writable, Unit
VAT double VAT writable, VAT
VatIncluded char Vatincluded writable, ::ancestor.VatIncluded
WayOfDelivery varchar2 Way of Delivery writable, ::ancestor.WayOfDelivery
YourOrderNumber varchar2(75) Your Order Number writable, ::ancestor.YourOrderNumber
YourReference varchar2 Your Reference writable, ::ancestor.YourReference
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: