invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

PurchaseOrderRowNotesById: Fortnox Purchase Order Row Notes by ID

read only REST

  • Catálogo: Fortnox
  • Esquema: WarehousePurchaseOrders
  • Label: Purchase Order Row Notes by ID

Get Purchase Order

Solo puede recuperar datos.

Fuente de la API

  • Punto final: /api/warehouse/purchaseorders-v1/{id}
  • Operación: get /api/warehouse/purchaseorders-v1/{id}

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 356
Número de filas escaneadas por minuto 85,000
Número de filas de queries puntuales por minuto 168

El resultado se puede almacenar en la Caché del cliente.

Parámetros

Name Tipo de Datos 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).

Columnas de la Tabla

A continuación se muestran las columnas de la tabla PurchaseOrderRowNotesById. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
backOrderQuantity decimal Cantidad pendiente de entrega writable, ::ancestor.backOrderQuantity
confirmationEmail varchar2(100) Correo electrónico de confirmación filters on the platform, writable, ::ancestor.::ancestor.confirmationEmail
costCenterCode varchar2(25) Código de Centro de Costo writable, ::ancestor.costCenterCode
costCenterCode_2 varchar2(25) Código del Centro de Costo 2 filters on the platform, writable, ::ancestor.::ancestor.costCenterCode
currencyCode varchar2(3) Código de la Moneda writable, ::ancestor.currencyCode
currencyCode_2 varchar2(3) Código de moneda 2 filters on the platform, writable, ::ancestor.::ancestor.currencyCode
currencyRate decimal Tipo de cambio de la moneda filters on the platform, writable, ::ancestor.::ancestor.currencyRate
currencyUnit int32 Unidad monetaria filters on the platform, writable, ::ancestor.::ancestor.currencyUnit
customerId varchar2(25) ID del Cliente filters on the platform, writable, ::ancestor.::ancestor.customerId
customerName varchar2(1024) Nombre del Cliente filters on the platform, writable, ::ancestor.::ancestor.customerName
customerNumber varchar2(1024) Numero de cliente filters on the platform, writable, ::ancestor.::ancestor.customerNumber
deliveryAddress varchar2(1024) Dirección de Entrega filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress
deliveryAddress2 varchar2(1024) Dirección de entrega 2 filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress2
deliveryCity varchar2(50) Ciudad de Entrega filters on the platform, writable, ::ancestor.::ancestor.deliveryCity
deliveryCountryCode varchar2(3) Código del país de destino filters on the platform, writable, ::ancestor.::ancestor.deliveryCountryCode
deliveryDate datetime Fecha de Entrega filters on the platform, writable, ::ancestor.::ancestor.deliveryDate
deliveryName varchar2(50) Nombre del destinatario filters on the platform, writable, ::ancestor.::ancestor.deliveryName
deliveryZipCode varchar2(10) Código postal de entrega 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) Referencia interna filters on the platform, writable, ::ancestor.::ancestor.internalReference
isStockItem char ¿Está disponible en stock? writable, ::ancestor.isStockItem
itemDescription varchar2 Descripción del Elemento writable, ::ancestor.itemDescription
itemId varchar2(50) Identificación del Elemento writable, ::ancestor.itemId
itemUnit varchar2 Unidad de artículo writable, ::ancestor.itemUnit
languageCode varchar2(3) Código del idioma filters on the platform, writable, ::ancestor.::ancestor.languageCode
manuallyCompleted char Rellenado manualmente filters on the platform, writable, ::ancestor.::ancestor.manuallyCompleted
messageToSupplier varchar2(1000) Mensaje al proveedor 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 Fecha de la Orden filters on the platform, writable, ::ancestor.::ancestor.orderDate
orderValue decimal Importe del pedido filters on the platform, writable, ::ancestor.::ancestor.orderValue
orderValueInSEK decimal Importe del pedido en SEK filters on the platform, writable, ::ancestor.::ancestor.orderValueInSEK
orderedQuantity decimal Cantidad solicitada writable, ::ancestor.orderedQuantity
ourReference varchar2(50) Ourreference filters on the platform, writable, ::ancestor.::ancestor.ourReference
outboundDocumentReference_id varchar2 N.º de referencia del documento de salida filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.id
outboundDocumentReference_type varchar2 Tipo de referencia del documento de salida filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.type
paymentTermsCode varchar2(20) Código de condiciones de pago filters on the platform, writable, ::ancestor.::ancestor.paymentTermsCode
price decimal Price writable, ::ancestor.price
projectId varchar2(25) Identificación del Proyecto writable, ::ancestor.projectId
projectId_2 varchar2(25) N.º de proyecto 2 filters on the platform, writable, ::ancestor.::ancestor.projectId
purchaseOrderId int64 N.º de orden de compra writable, purchaseOrderId
purchaseOrderId_2 int64 N.º de pedido 2 writable, ::ancestor.purchaseOrderId
purchaseOrderRowId guid ROWID de la orden de compra writable, purchaseOrderRowId
purchaseOrderState varchar2 Estado de la orden de compra filters on the platform, writable, ::ancestor.::ancestor.purchaseOrderState
purchaseType varchar2 Tipo de compra filters on the platform, writable, ::ancestor.::ancestor.purchaseType
receivedQuantity decimal Cantidad recibida writable, ::ancestor.receivedQuantity
remainingOrderedQuantity decimal Cantidad pendiente de pedido writable, ::ancestor.remainingOrderedQuantity
responseState varchar2 Estado de la respuesta filters on the platform, writable, ::ancestor.::ancestor.responseState
rowNum int64 Número de la Fila writable, rowNum
rowNum_2 int64 Fila número 2 writable, ::ancestor.rowNum
stockLocationCode varchar2 Código de ubicación de existencias writable, ::ancestor.stockLocationCode
stockLocationId guid Identificador de ubicación de existencias writable, ::ancestor.stockLocationId
stockLocationName varchar2 Nombre de la ubicación de existencias writable, ::ancestor.stockLocationName
stockPointCode varchar2 Código de referencia de existencias writable, ::ancestor.stockPointCode
stockPointCode_2 varchar2 Código de referencia 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointCode
stockPointId guid N.º de referencia del artículo writable, ::ancestor.stockPointId
stockPointId_2 guid N.º de referencia de existencias 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointId
stockPointName varchar2 Nombre del punto de existencias writable, ::ancestor.stockPointName
supplier varchar2 Supplier filters on the platform, writable, ::ancestor.::ancestor.supplier
supplierAddress varchar2(1024) Dirección del proveedor filters on the platform, writable, ::ancestor.::ancestor.supplierAddress
supplierAddress2 varchar2(1024) Dirección del proveedor 2 filters on the platform, writable, ::ancestor.::ancestor.supplierAddress2
supplierCity varchar2(1024) Ciudad del proveedor filters on the platform, writable, ::ancestor.::ancestor.supplierCity
supplierCountryCode varchar2(3) Código de país del proveedor filters on the platform, writable, ::ancestor.::ancestor.supplierCountryCode
supplierEmail varchar2(100) Correo electrónico del proveedor filters on the platform, writable, ::ancestor.::ancestor.supplierEmail
supplierName varchar2(1024) Nombre del Proveedor filters on the platform, writable, ::ancestor.::ancestor.supplierName
supplierNumber varchar2(1024) Número de proveedor filters on the platform, writable, ::ancestor.::ancestor.supplierNumber
supplierPostCode varchar2(1024) Código postal del proveedor filters on the platform, writable, ::ancestor.::ancestor.supplierPostCode
totalReceivedQuantity decimal Cantidad total recibida filters on the platform, writable, ::ancestor.::ancestor.totalReceivedQuantity
translatedResponseState varchar2 Estado de la respuesta traducida filters on the platform, writable, ::ancestor.::ancestor.translatedResponseState
voided char Voided filters on the platform, writable, ::ancestor.::ancestor.voided
yourReference varchar2(50) Su Referencia filters on the platform, writable, ::ancestor.::ancestor.yourReference

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: