invantive documentation
Invantive Support ForumsLog In / Sign Up

ContractByDocumentNumber: Fortnox Contract by Document Number

read only REST

  • Catalog: Fortnox
  • Schema: Contracts
  • Label: Contract 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 ContractByDocumentNumber 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
Contract_Active char Contract Active filters on the platform, writable, Contract.Active
Contract_AdministrationFee double Contract Administration Fee filters on the platform, writable, Contract.AdministrationFee
Contract_BasisTaxReduction double Contract Basis Tax Reduction filters on the platform, writable, Contract.BasisTaxReduction
Contract_Comments varchar2(1024) Contract Comments filters on the platform, writable, Contract.Comments
Contract_Continuous char Contract Continuous filters on the platform, writable, Contract.Continuous
Contract_ContractDate datetime Contract Date filters on the platform, writable, Contract.ContractDate
Contract_ContractLength int32 Contract Length filters on the platform, writable, Contract.ContractLength
Contract_ContributionPercent double Contract Contribution Percent filters on the platform, writable, Contract.ContributionPercent
Contract_ContributionValue double Contract Contribution Value filters on the platform, writable, Contract.ContributionValue
Contract_CostCenter varchar2 Contract Cost Centre filters on the platform, writable, Contract.CostCenter
Contract_Currency varchar2 Contract Currency filters on the platform, writable, Contract.Currency
Contract_CustomerName varchar2 Contract Customer Name filters on the platform, writable, Contract.CustomerName
Contract_CustomerNumber varchar2 Contract Customernumber filters on the platform, writable, Contract.CustomerNumber
Contract_DocumentNumber varchar2 Contract Document Number filters on the platform, writable, Contract.DocumentNumber
Contract_EmailInformation_EmailAddressBCC varchar2 Contract Email Information Email Address Bcc filters on the platform, writable, Contract.EmailInformation.EmailAddressBCC
Contract_EmailInformation_EmailAddressCC varchar2 Contract Email Information Email Address CC filters on the platform, writable, Contract.EmailInformation.EmailAddressCC
Contract_EmailInformation_EmailAddressFrom varchar2 Contract Email Information Email Address From filters on the platform, writable, Contract.EmailInformation.EmailAddressFrom
Contract_EmailInformation_EmailAddressTo varchar2 Contract Email Information Email Address To filters on the platform, writable, Contract.EmailInformation.EmailAddressTo
Contract_EmailInformation_EmailBody varchar2 Contract Email Information Email Body filters on the platform, writable, Contract.EmailInformation.EmailBody
Contract_EmailInformation_EmailSubject varchar2 Contract Email Information Email Subject filters on the platform, writable, Contract.EmailInformation.EmailSubject
Contract_ExternalInvoiceReference1 varchar2 Contract External Invoice Reference 1 filters on the platform, writable, Contract.ExternalInvoiceReference1
Contract_ExternalInvoiceReference2 varchar2 Contract External Invoice Reference 2 filters on the platform, writable, Contract.ExternalInvoiceReference2
Contract_Freight double Contract Freight filters on the platform, writable, Contract.Freight
Contract_Gross double Contract Gross filters on the platform, writable, Contract.Gross
Contract_HouseWork char Contract House Work filters on the platform, writable, Contract.HouseWork
Contract_InvoiceDiscount double Contract Invoice Discount filters on the platform, writable, Contract.InvoiceDiscount
Contract_InvoiceInterval int32 Contract Invoice Interval filters on the platform, writable, Contract.InvoiceInterval
Contract_InvoicesRemaining varchar2 Contract Invoices Remaining filters on the platform, writable, Contract.InvoicesRemaining
Contract_Language varchar2 Contract Language filters on the platform, writable, Contract.Language
Contract_LastInvoiceDate varchar2 Contract Last Invoice Date filters on the platform, writable, Contract.LastInvoiceDate
Contract_Net double Contract Net filters on the platform, writable, Contract.Net
Contract_OurReference varchar2(25) Contract Ourreference filters on the platform, writable, Contract.OurReference
Contract_PeriodEnd datetime Contract Period End filters on the platform, writable, Contract.PeriodEnd
Contract_PeriodStart datetime Contract Period Start filters on the platform, writable, Contract.PeriodStart
Contract_PriceList varchar2 Contract Pricelist filters on the platform, writable, Contract.PriceList
Contract_PrintTemplate varchar2 Contract Print Template filters on the platform, writable, Contract.PrintTemplate
Contract_Project varchar2 Contract Project filters on the platform, writable, Contract.Project
Contract_Remarks varchar2(1024) Contract Remarks filters on the platform, writable, Contract.Remarks
Contract_RoundOff double Contract Round Off filters on the platform, writable, Contract.RoundOff
Contract_TaxReduction double Contract Tax Reduction filters on the platform, writable, Contract.TaxReduction
Contract_TaxReductionType varchar2 Contract Tax Reduction Type filters on the platform, writable, Contract.TaxReductionType
Contract_TemplateName varchar2 Contract Template Name filters on the platform, writable, Contract.TemplateName
Contract_TemplateNumber int32 Contract Template Number filters on the platform, writable, Contract.TemplateNumber
Contract_TermsOfDelivery varchar2 Contract Terms of Delivery filters on the platform, writable, Contract.TermsOfDelivery
Contract_TermsOfPayment varchar2 Contract Terms of Payment filters on the platform, writable, Contract.TermsOfPayment
Contract_Total double Contract Total filters on the platform, writable, Contract.Total
Contract_TotalToPay double Contract Total to Pay filters on the platform, writable, Contract.TotalToPay
Contract_TotalVAT double Contract Total VAT filters on the platform, writable, Contract.TotalVAT
Contract_VatIncluded char Contract Vatincluded filters on the platform, writable, Contract.VatIncluded
Contract_WayOfDelivery varchar2 Contract Way of Delivery filters on the platform, writable, Contract.WayOfDelivery
Contract_YourOrderNumber varchar2(75) Contract Your Order Number filters on the platform, writable, Contract.YourOrderNumber
Contract_YourReference varchar2 Contract Your Reference filters on the platform, writable, Contract.YourReference
Contract__url varchar2 Contract URL filters on the platform, writable, Contract.@url
Contract__urlTaxReductionList varchar2 Contract URL Tax Reduction List filters on the platform, writable, Contract.@urlTaxReductionList

Release Notes

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