invantive documentation
Forum di supporto InvantiveAccedi / Registrati

PurchaseOrderRowNotesById: Fortnox Purchase Order Row Notes by ID

read only REST

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

Get Purchase Order

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Punto finale: /api/warehouse/purchaseorders-v1/{id}
  • Operazione: get /api/warehouse/purchaseorders-v1/{id}

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 356
Righe di scansione completa al minuto 85,000
Numero di righe di Query al minuto 168

Il risultato può essere memorizzato nella memoria cache sul client.

Parametri

Name Tipo di dati 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).

Colonne della tabella

Di seguito sono riportate le colonne della tabella PurchaseOrderRowNotesById. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
backOrderQuantity decimal Quantità di ordini arretrati writable, ::ancestor.backOrderQuantity
confirmationEmail varchar2(100) Email di conferma filters on the platform, writable, ::ancestor.::ancestor.confirmationEmail
costCenterCode varchar2(25) Codice del centro di costo writable, ::ancestor.costCenterCode
costCenterCode_2 varchar2(25) Codice centro di costo 2 filters on the platform, writable, ::ancestor.::ancestor.costCenterCode
currencyCode varchar2(3) Codice della valuta writable, ::ancestor.currencyCode
currencyCode_2 varchar2(3) Codice Valuta 2 filters on the platform, writable, ::ancestor.::ancestor.currencyCode
currencyRate decimal Tasso di cambio della valuta filters on the platform, writable, ::ancestor.::ancestor.currencyRate
currencyUnit int32 Valuta filters on the platform, writable, ::ancestor.::ancestor.currencyUnit
customerId varchar2(25) ID cliente filters on the platform, writable, ::ancestor.::ancestor.customerId
customerName varchar2(1024) Nome del cliente filters on the platform, writable, ::ancestor.::ancestor.customerName
customerNumber varchar2(1024) Numero del cliente filters on the platform, writable, ::ancestor.::ancestor.customerNumber
deliveryAddress varchar2(1024) Indirizzo di consegna filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress
deliveryAddress2 varchar2(1024) Indirizzo di consegna 2 filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress2
deliveryCity varchar2(50) Città di consegna filters on the platform, writable, ::ancestor.::ancestor.deliveryCity
deliveryCountryCode varchar2(3) Codice paese di destinazione filters on the platform, writable, ::ancestor.::ancestor.deliveryCountryCode
deliveryDate datetime Data di consegna filters on the platform, writable, ::ancestor.::ancestor.deliveryDate
deliveryName varchar2(50) Nome del destinatario filters on the platform, writable, ::ancestor.::ancestor.deliveryName
deliveryZipCode varchar2(10) Codice postale di consegna 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) Riferimento interno filters on the platform, writable, ::ancestor.::ancestor.internalReference
isStockItem char È un articolo a magazzino writable, ::ancestor.isStockItem
itemDescription varchar2 Descrizione dell'articolo writable, ::ancestor.itemDescription
itemId varchar2(50) ID dell'articolo writable, ::ancestor.itemId
itemUnit varchar2 Unità dell'articolo writable, ::ancestor.itemUnit
languageCode varchar2(3) Codice della lingua filters on the platform, writable, ::ancestor.::ancestor.languageCode
manuallyCompleted char Compilato manualmente filters on the platform, writable, ::ancestor.::ancestor.manuallyCompleted
messageToSupplier varchar2(1000) Messaggio al fornitore filters on the platform, writable, ::ancestor.::ancestor.messageToSupplier
note varchar2 Note writable, note
note_2 varchar2(1000) Nota 2 filters on the platform, writable, ::ancestor.::ancestor.note
orderDate datetime Data dell'ordine filters on the platform, writable, ::ancestor.::ancestor.orderDate
orderValue decimal Valore dell'ordine filters on the platform, writable, ::ancestor.::ancestor.orderValue
orderValueInSEK decimal Valore dell'ordine in SEK filters on the platform, writable, ::ancestor.::ancestor.orderValueInSEK
orderedQuantity decimal Quantità ordinata writable, ::ancestor.orderedQuantity
ourReference varchar2(50) Ourreference filters on the platform, writable, ::ancestor.::ancestor.ourReference
outboundDocumentReference_id varchar2 Riferimento del documento in uscita filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.id
outboundDocumentReference_type varchar2 Tipo di riferimento del documento in uscita filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.type
paymentTermsCode varchar2(20) Codice delle condizioni di pagamento filters on the platform, writable, ::ancestor.::ancestor.paymentTermsCode
price decimal Price writable, ::ancestor.price
projectId varchar2(25) Identificatore del progetto writable, ::ancestor.projectId
projectId_2 varchar2(25) ID progetto 2 filters on the platform, writable, ::ancestor.::ancestor.projectId
purchaseOrderId int64 Numero dell'ordine di acquisto writable, purchaseOrderId
purchaseOrderId_2 int64 Numero ordine di acquisto 2 writable, ::ancestor.purchaseOrderId
purchaseOrderRowId guid ROWID dell'ordine di acquisto writable, purchaseOrderRowId
purchaseOrderState varchar2 Stato dell'ordine di acquisto filters on the platform, writable, ::ancestor.::ancestor.purchaseOrderState
purchaseType varchar2 Tipo di acquisto filters on the platform, writable, ::ancestor.::ancestor.purchaseType
receivedQuantity decimal Quantità ricevuta writable, ::ancestor.receivedQuantity
remainingOrderedQuantity decimal Quantità rimanente dell'ordine writable, ::ancestor.remainingOrderedQuantity
responseState varchar2 Stato della risposta filters on the platform, writable, ::ancestor.::ancestor.responseState
rowNum int64 Numero di riga writable, rowNum
rowNum_2 int64 Riga numero 2 writable, ::ancestor.rowNum
stockLocationCode varchar2 Codice di ubicazione delle scorte writable, ::ancestor.stockLocationCode
stockLocationId guid ID ubicazione delle scorte writable, ::ancestor.stockLocationId
stockLocationName varchar2 Nome della sede di stoccaggio writable, ::ancestor.stockLocationName
stockPointCode varchar2 Codice articolo writable, ::ancestor.stockPointCode
stockPointCode_2 varchar2 Codice articolo 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointCode
stockPointId guid ID punto di magazzino writable, ::ancestor.stockPointId
stockPointId_2 guid Codice articolo 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointId
stockPointName varchar2 Nome del punto di stoccaggio writable, ::ancestor.stockPointName
supplier varchar2 Supplier filters on the platform, writable, ::ancestor.::ancestor.supplier
supplierAddress varchar2(1024) Indirizzo del fornitore filters on the platform, writable, ::ancestor.::ancestor.supplierAddress
supplierAddress2 varchar2(1024) Indirizzo del fornitore 2 filters on the platform, writable, ::ancestor.::ancestor.supplierAddress2
supplierCity varchar2(1024) Città del fornitore filters on the platform, writable, ::ancestor.::ancestor.supplierCity
supplierCountryCode varchar2(3) Codice paese del fornitore filters on the platform, writable, ::ancestor.::ancestor.supplierCountryCode
supplierEmail varchar2(100) E-mail del fornitore filters on the platform, writable, ::ancestor.::ancestor.supplierEmail
supplierName varchar2(1024) Nome del fornitore filters on the platform, writable, ::ancestor.::ancestor.supplierName
supplierNumber varchar2(1024) Numero fornitore filters on the platform, writable, ::ancestor.::ancestor.supplierNumber
supplierPostCode varchar2(1024) Codice postale del fornitore filters on the platform, writable, ::ancestor.::ancestor.supplierPostCode
totalReceivedQuantity decimal Quantità totale ricevuta filters on the platform, writable, ::ancestor.::ancestor.totalReceivedQuantity
translatedResponseState varchar2 Stato della risposta tradotta filters on the platform, writable, ::ancestor.::ancestor.translatedResponseState
voided char Voided filters on the platform, writable, ::ancestor.::ancestor.voided
yourReference varchar2(50) Il tuo Riferimento filters on the platform, writable, ::ancestor.::ancestor.yourReference

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: