invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

OrderLabelsByDocumentNumber: Fortnox Order Labels by Document Number

read only REST

  • Catalogue : Fortnox
  • Schéma : Orders
  • Label: Order Labels by Document Number

Retrieve a single order

Permet uniquement de récupérer des données.

Source de l'API

  • Point de terminaison : /3/orders/{DocumentNumber}
  • Opération : get /3/orders/{DocumentNumber}

Caractéristiques de performance

Characteristic Value
Latence moyenne d'accès (ms) 356
Nombre de lignes par minute en mode de balayage complet 85,000
Nombre de lignes de requêtes ponctuelles par minute 168

Le résultat peut être mis en cache côté client.

Paramètres

Name Type de données Required Default Documentation
DocumentNumber `` identifies the order
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).

Colonnes de table

Les colonnes de la table OrderLabelsByDocumentNumber sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
Address1 varchar2 Adresse ligne 1 writable, ::ancestor.Address1
Address2 varchar2 Adresse ligne 2 writable, ::ancestor.Address2
AdministrationFee double Frais administratifs writable, ::ancestor.AdministrationFee
AdministrationFeeVAT double Frais administratifs TVA writable, ::ancestor.AdministrationFeeVAT
BasisTaxReduction double Réduction de l'assiette fiscale writable, ::ancestor.BasisTaxReduction
Cancelled char Cancelled writable, ::ancestor.Cancelled
City varchar2 City writable, ::ancestor.City
Comments varchar2 Comments writable, ::ancestor.Comments
ContributionPercent double Pourcentage de contribution writable, ::ancestor.ContributionPercent
ContributionValue double Valeur de la contribution writable, ::ancestor.ContributionValue
CopyRemarks char Copier les remarques writable, ::ancestor.CopyRemarks
CostCenter varchar2 Centre de coûts writable, ::ancestor.CostCenter
Country varchar2 Country writable, ::ancestor.Country
Currency varchar2(3) Currency writable, ::ancestor.Currency
CurrencyRate double Taux de change de la devise writable, ::ancestor.CurrencyRate
CurrencyUnit double Devise writable, ::ancestor.CurrencyUnit
CustomerName varchar2 Nom du client writable, ::ancestor.CustomerName
CustomerNumber varchar2 Numéro de client writable, ::ancestor.CustomerNumber
DeliveryAddress1 varchar2 Adresse de livraison 1 writable, ::ancestor.DeliveryAddress1
DeliveryAddress2 varchar2 Adresse de livraison 2 writable, ::ancestor.DeliveryAddress2
DeliveryCity varchar2 Ville de livraison writable, ::ancestor.DeliveryCity
DeliveryCountry varchar2 Pays de livraison writable, ::ancestor.DeliveryCountry
DeliveryDate datetime Date de livraison writable, ::ancestor.DeliveryDate
DeliveryName varchar2 Nom du destinataire writable, ::ancestor.DeliveryName
DeliveryState varchar2 État de livraison writable, ::ancestor.DeliveryState
DeliveryZipCode varchar2 Code postal de livraison writable, ::ancestor.DeliveryZipCode
DocumentNumber varchar2 Numéro de document writable, ::ancestor.DocumentNumber
EmailInformation_EmailAddressBCC varchar2 Informations relatives à l'e-mail Adresse e-mail Cci writable, ::ancestor.EmailInformation.EmailAddressBCC
EmailInformation_EmailAddressCC varchar2 Informations relatives à l'e-mail Adresse e-mail CC writable, ::ancestor.EmailInformation.EmailAddressCC
EmailInformation_EmailAddressFrom varchar2 Informations relatives à l'e-mail Adresse e-mail de l'expéditeur writable, ::ancestor.EmailInformation.EmailAddressFrom
EmailInformation_EmailAddressTo varchar2 Informations relatives à l'e-mail Adresse e-mail À writable, ::ancestor.EmailInformation.EmailAddressTo
EmailInformation_EmailBody varchar2 Informations relatives à l'e-mail Corps du message writable, ::ancestor.EmailInformation.EmailBody
EmailInformation_EmailSubject varchar2 Informations relatives à l'e-mail Objet de l'e-mail writable, ::ancestor.EmailInformation.EmailSubject
ExternalInvoiceReference1 varchar2 Référence de facture externe 1 writable, ::ancestor.ExternalInvoiceReference1
ExternalInvoiceReference2 varchar2 Référence de facture externe 2 writable, ::ancestor.ExternalInvoiceReference2
Freight double Freight writable, ::ancestor.Freight
FreightVAT double TVA sur le fret writable, ::ancestor.FreightVAT
Gross double Gross writable, ::ancestor.Gross
HouseWork char Tâches ménagères writable, ::ancestor.HouseWork
Id int32 ID writable, Id
InvoiceReference varchar2 Référence de la facture writable, ::ancestor.InvoiceReference
Language varchar2 Language writable, ::ancestor.Language
Net double Net writable, ::ancestor.Net
NotCompleted char Notcompleted writable, ::ancestor.NotCompleted
OfferReference varchar2 Référence de l'offre writable, ::ancestor.OfferReference
OrderDate datetime Date de la commande writable, ::ancestor.OrderDate
OrderType varchar2 Type d'ordre writable, ::ancestor.OrderType
OrganisationNumber varchar2 Numéro d'identification de l'organisation writable, ::ancestor.OrganisationNumber
OurReference varchar2(50) Ourreference writable, ::ancestor.OurReference
OutboundDate datetime Date d'expédition writable, ::ancestor.OutboundDate
Phone1 varchar2 Téléphone 1 writable, ::ancestor.Phone1
Phone2 varchar2 Téléphone 2 writable, ::ancestor.Phone2
PriceList varchar2 Tarif writable, ::ancestor.PriceList
PrintTemplate varchar2 Modèle d'impression writable, ::ancestor.PrintTemplate
Project varchar2 Project writable, ::ancestor.Project
Remarks varchar2(1024) Remarks writable, ::ancestor.Remarks
RoundOff double Arrondir writable, ::ancestor.RoundOff
Sent char Sent writable, ::ancestor.Sent
StockPointCode varchar2 Code de référence writable, ::ancestor.StockPointCode
StockPointId varchar2 Référence de stock writable, ::ancestor.StockPointId
TaxReduction double Allègement fiscal writable, ::ancestor.TaxReduction
TaxReductionType varchar2 Type d'allègement fiscal writable, ::ancestor.TaxReductionType
TermsOfDelivery varchar2 Conditions de livraison writable, ::ancestor.TermsOfDelivery
TermsOfPayment varchar2 Conditions de paiement writable, ::ancestor.TermsOfPayment
TimeBasisReference int32 Référence temporelle writable, ::ancestor.TimeBasisReference
Total double Total writable, ::ancestor.Total
TotalToPay double Montant total à payer writable, ::ancestor.TotalToPay
TotalVAT double Total TVA writable, ::ancestor.TotalVAT
VATIncluded char Vatincluded writable, ::ancestor.VATIncluded
WarehouseReady char En stock writable, ::ancestor.WarehouseReady
WayOfDelivery varchar2 Mode de livraison writable, ::ancestor.WayOfDelivery
YourOrderNumber varchar2(75) Votre numéro de commande writable, ::ancestor.YourOrderNumber
YourReference varchar2(50) Votre référence writable, ::ancestor.YourReference
ZipCode varchar2 Code postal writable, ::ancestor.ZipCode
c_url varchar2 URL d'appel writable, ::ancestor.@url
c_urlTaxReductionList varchar2 Liste des réductions d'impôt sur les URL writable, ::ancestor.@urlTaxReductionList

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :