invantive documentation
Invantive SupportforenAnmelden / Eintragen

PurchaseOrderRowNotesById: Fortnox Purchase Order Row Notes by ID

read only REST

  • Katalog: Fortnox
  • Schema: WarehousePurchaseOrders
  • Label: Purchase Order Row Notes by ID

Get Purchase Order

Es können nur Daten abgerufen werden.

API-Quelle

  • Endpunkt: /api/warehouse/purchaseorders-v1/{id}
  • Operation: get /api/warehouse/purchaseorders-v1/{id}

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 356
Anzahl der Vollscan-Zeilen pro Minute 85,000
Anzahl der Query-Zeilen pro Minute 168

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Parameter

Name Datentyp Required Default Documentation
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).
id `` Purchase order id.
ignoreIncomingGoodsId `` used for calculating the remaining ordered quantity. null will take the received quantity from all incoming goods
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).

Tabellenspalten

Die Spalten der Tabelle PurchaseOrderRowNotesById sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
backOrderQuantity decimal Rückstandsmenge writable, ::ancestor.backOrderQuantity
confirmationEmail varchar2(100) Bestätigungs-E-Mail filters on the platform, writable, ::ancestor.::ancestor.confirmationEmail
costCenterCode varchar2(25) Kostenstelle-Code writable, ::ancestor.costCenterCode
costCenterCode_2 varchar2(25) Kostenstelle 2 filters on the platform, writable, ::ancestor.::ancestor.costCenterCode
currencyCode varchar2(3) Währungscode writable, ::ancestor.currencyCode
currencyCode_2 varchar2(3) Währungscode 2 filters on the platform, writable, ::ancestor.::ancestor.currencyCode
currencyRate decimal Währung filters on the platform, writable, ::ancestor.::ancestor.currencyRate
currencyUnit int32 Währungseinheit filters on the platform, writable, ::ancestor.::ancestor.currencyUnit
customerId varchar2(25) Kunden-ID filters on the platform, writable, ::ancestor.::ancestor.customerId
customerName varchar2(1024) Name des Kunden filters on the platform, writable, ::ancestor.::ancestor.customerName
customerNumber varchar2(1024) Kundennummer filters on the platform, writable, ::ancestor.::ancestor.customerNumber
deliveryAddress varchar2(1024) Lieferadresse filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress
deliveryAddress2 varchar2(1024) Lieferadresse 2 filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress2
deliveryCity varchar2(50) Stadt der Lieferung filters on the platform, writable, ::ancestor.::ancestor.deliveryCity
deliveryCountryCode varchar2(3) Ländercode für die Lieferung filters on the platform, writable, ::ancestor.::ancestor.deliveryCountryCode
deliveryDate datetime Liefertermin filters on the platform, writable, ::ancestor.::ancestor.deliveryDate
deliveryName varchar2(50) Name des Lieferanten filters on the platform, writable, ::ancestor.::ancestor.deliveryName
deliveryZipCode varchar2(10) Postleitzahl für die Lieferung filters on the platform, writable, ::ancestor.::ancestor.deliveryZipCode
dropship char Dropship filters on the platform, writable, ::ancestor.::ancestor.dropship
id guid ID writable, ::ancestor.id
id_2 int64 ID filters on the platform, writable, ::ancestor.::ancestor.id
internalReference varchar2(50) Interne Geschäftszeichen / Bezug filters on the platform, writable, ::ancestor.::ancestor.internalReference
isStockItem char Ist Lagerware? writable, ::ancestor.isStockItem
itemDescription varchar2 Artikelbeschreibung writable, ::ancestor.itemDescription
itemId varchar2(50) Artikel ID writable, ::ancestor.itemId
itemUnit varchar2 Artikel Einheit writable, ::ancestor.itemUnit
languageCode varchar2(3) Sprachen-Code filters on the platform, writable, ::ancestor.::ancestor.languageCode
manuallyCompleted char Manuell ausgefüllt filters on the platform, writable, ::ancestor.::ancestor.manuallyCompleted
messageToSupplier varchar2(1000) Nachricht an den Lieferanten filters on the platform, writable, ::ancestor.::ancestor.messageToSupplier
note varchar2 Note writable, note
note_2 varchar2(1000) Anmerkung 2 filters on the platform, writable, ::ancestor.::ancestor.note
orderDate datetime Orderdatum filters on the platform, writable, ::ancestor.::ancestor.orderDate
orderValue decimal Bestellwert filters on the platform, writable, ::ancestor.::ancestor.orderValue
orderValueInSEK decimal Bestellwert in SEK filters on the platform, writable, ::ancestor.::ancestor.orderValueInSEK
orderedQuantity decimal Bestellte Menge writable, ::ancestor.orderedQuantity
ourReference varchar2(50) Ourreference filters on the platform, writable, ::ancestor.::ancestor.ourReference
outboundDocumentReference_id varchar2 Geschäftszeichen / Bezug des ausgehenden Dokuments filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.id
outboundDocumentReference_type varchar2 Referenztyp für ausgehende Dokumente filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.type
paymentTermsCode varchar2(20) Code für Zahlungsbedingungen filters on the platform, writable, ::ancestor.::ancestor.paymentTermsCode
price decimal Price writable, ::ancestor.price
projectId varchar2(25) Projekt ID writable, ::ancestor.projectId
projectId_2 varchar2(25) Projekt-ID 2 filters on the platform, writable, ::ancestor.::ancestor.projectId
purchaseOrderId int64 Bestellnummer writable, purchaseOrderId
purchaseOrderId_2 int64 Bestellnummer 2 writable, ::ancestor.purchaseOrderId
purchaseOrderRowId guid Bestell-ROWID writable, purchaseOrderRowId
purchaseOrderState varchar2 Status der Bestellung filters on the platform, writable, ::ancestor.::ancestor.purchaseOrderState
purchaseType varchar2 Art des Kaufs filters on the platform, writable, ::ancestor.::ancestor.purchaseType
receivedQuantity decimal Erhaltene Menge writable, ::ancestor.receivedQuantity
remainingOrderedQuantity decimal Verbleibende Bestellmenge writable, ::ancestor.remainingOrderedQuantity
responseState varchar2 Antwortstatus filters on the platform, writable, ::ancestor.::ancestor.responseState
rowNum int64 Zeilennummer writable, rowNum
rowNum_2 int64 Zeile 2 writable, ::ancestor.rowNum
stockLocationCode varchar2 Lagerstandortcode writable, ::ancestor.stockLocationCode
stockLocationId guid Lagerort-ID writable, ::ancestor.stockLocationId
stockLocationName varchar2 Name des Lagerorts writable, ::ancestor.stockLocationName
stockPointCode varchar2 Lager-Artikelnummer writable, ::ancestor.stockPointCode
stockPointCode_2 varchar2 Lager-Artikelnummer 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointCode
stockPointId guid Lagerort-ID writable, ::ancestor.stockPointId
stockPointId_2 guid Lagerort-ID 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointId
stockPointName varchar2 Name des Lagerpunkts writable, ::ancestor.stockPointName
supplier varchar2 Supplier filters on the platform, writable, ::ancestor.::ancestor.supplier
supplierAddress varchar2(1024) Lieferantenadresse filters on the platform, writable, ::ancestor.::ancestor.supplierAddress
supplierAddress2 varchar2(1024) Lieferantenadresse 2 filters on the platform, writable, ::ancestor.::ancestor.supplierAddress2
supplierCity varchar2(1024) Lieferantenort filters on the platform, writable, ::ancestor.::ancestor.supplierCity
supplierCountryCode varchar2(3) Ländercode des Lieferanten filters on the platform, writable, ::ancestor.::ancestor.supplierCountryCode
supplierEmail varchar2(100) E-Mail-Adresse des Lieferanten filters on the platform, writable, ::ancestor.::ancestor.supplierEmail
supplierName varchar2(1024) Name des Anbieters filters on the platform, writable, ::ancestor.::ancestor.supplierName
supplierNumber varchar2(1024) Lieferantennummer filters on the platform, writable, ::ancestor.::ancestor.supplierNumber
supplierPostCode varchar2(1024) Postleitzahl des Lieferanten filters on the platform, writable, ::ancestor.::ancestor.supplierPostCode
totalReceivedQuantity decimal Gesamtmenge (eingegangen) filters on the platform, writable, ::ancestor.::ancestor.totalReceivedQuantity
translatedResponseState varchar2 Übersetzter Antwortstatus filters on the platform, writable, ::ancestor.::ancestor.translatedResponseState
voided char Voided filters on the platform, writable, ::ancestor.::ancestor.voided
yourReference varchar2(50) Ihre Referenz filters on the platform, writable, ::ancestor.::ancestor.yourReference

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: