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. | ||
ignore |
`` | 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 |
|---|---|---|---|---|---|
back |
decimal |
Cantidad pendiente de entrega | writable, ::ancestor. |
||
confirmation |
varchar2 |
Correo electrónico de confirmación | filters on the platform, writable, ::ancestor. |
||
cost |
varchar2 |
Código de Centro de Costo | writable, ::ancestor. |
||
cost |
varchar2 |
Código del Centro de Costo 2 | filters on the platform, writable, ::ancestor. |
||
currency |
varchar2 |
Código de la Moneda | writable, ::ancestor. |
||
currency |
varchar2 |
Código de moneda 2 | filters on the platform, writable, ::ancestor. |
||
currency |
decimal |
Tipo de cambio de la moneda | filters on the platform, writable, ::ancestor. |
||
currency |
int32 |
Unidad monetaria | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
ID del Cliente | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Nombre del Cliente | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Numero de cliente | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Dirección de Entrega | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Dirección de entrega 2 | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Ciudad de Entrega | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Código del país de destino | filters on the platform, writable, ::ancestor. |
||
delivery |
datetime |
Fecha de Entrega | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Nombre del destinatario | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Código postal de entrega | filters on the platform, writable, ::ancestor. |
||
dropship |
char |
Dropship | filters on the platform, writable, ::ancestor. |
||
id |
guid |
ID | writable, ::ancestor. |
||
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
||
internal |
varchar2 |
Referencia interna | filters on the platform, writable, ::ancestor. |
||
is |
char |
¿Está disponible en stock? | writable, ::ancestor. |
||
item |
varchar2 |
Descripción del Elemento | writable, ::ancestor. |
||
itemId |
varchar2 |
Identificación del Elemento | writable, ::ancestor. |
||
item |
varchar2 |
Unidad de artículo | writable, ::ancestor. |
||
language |
varchar2 |
Código del idioma | filters on the platform, writable, ::ancestor. |
||
manually |
char |
Rellenado manualmente | filters on the platform, writable, ::ancestor. |
||
message |
varchar2 |
Mensaje al proveedor | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | writable, note |
||
note_2 |
varchar2 |
Nota 2 | filters on the platform, writable, ::ancestor. |
||
order |
datetime |
Fecha de la Orden | filters on the platform, writable, ::ancestor. |
||
order |
decimal |
Importe del pedido | filters on the platform, writable, ::ancestor. |
||
order |
decimal |
Importe del pedido en SEK | filters on the platform, writable, ::ancestor. |
||
ordered |
decimal |
Cantidad solicitada | writable, ::ancestor. |
||
our |
varchar2 |
Ourreference | filters on the platform, writable, ::ancestor. |
||
outbound |
varchar2 |
N.º de referencia del documento de salida | filters on the platform, writable, ::ancestor. |
||
outbound |
varchar2 |
Tipo de referencia del documento de salida | filters on the platform, writable, ::ancestor. |
||
payment |
varchar2 |
Código de condiciones de pago | filters on the platform, writable, ::ancestor. |
||
price |
decimal |
Price | writable, ::ancestor. |
||
project |
varchar2 |
Identificación del Proyecto | writable, ::ancestor. |
||
project |
varchar2 |
N.º de proyecto 2 | filters on the platform, writable, ::ancestor. |
||
purchase |
int64 |
N.º de orden de compra | writable, purchase |
||
purchase |
int64 |
N.º de pedido 2 | writable, ::ancestor. |
||
purchase |
guid |
ROWID de la orden de compra | writable, purchase |
||
purchase |
varchar2 |
Estado de la orden de compra | filters on the platform, writable, ::ancestor. |
||
purchase |
varchar2 |
Tipo de compra | filters on the platform, writable, ::ancestor. |
||
received |
decimal |
Cantidad recibida | writable, ::ancestor. |
||
remaining |
decimal |
Cantidad pendiente de pedido | writable, ::ancestor. |
||
response |
varchar2 |
Estado de la respuesta | filters on the platform, writable, ::ancestor. |
||
rowNum |
int64 |
Número de la Fila | writable, rowNum |
||
row |
int64 |
Fila número 2 | writable, ::ancestor. |
||
stock |
varchar2 |
Código de ubicación de existencias | writable, ::ancestor. |
||
stock |
guid |
Identificador de ubicación de existencias | writable, ::ancestor. |
||
stock |
varchar2 |
Nombre de la ubicación de existencias | writable, ::ancestor. |
||
stock |
varchar2 |
Código de referencia de existencias | writable, ::ancestor. |
||
stock |
varchar2 |
Código de referencia 2 | filters on the platform, writable, ::ancestor. |
||
stock |
guid |
N.º de referencia del artículo | writable, ::ancestor. |
||
stock |
guid |
N.º de referencia de existencias 2 | filters on the platform, writable, ::ancestor. |
||
stock |
varchar2 |
Nombre del punto de existencias | writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Dirección del proveedor | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Dirección del proveedor 2 | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Ciudad del proveedor | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Código de país del proveedor | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Correo electrónico del proveedor | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Nombre del Proveedor | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Número de proveedor | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Código postal del proveedor | filters on the platform, writable, ::ancestor. |
||
total |
decimal |
Cantidad total recibida | filters on the platform, writable, ::ancestor. |
||
translated |
varchar2 |
Estado de la respuesta traducida | filters on the platform, writable, ::ancestor. |
||
voided |
char |
Voided | filters on the platform, writable, ::ancestor. |
||
your |
varchar2 |
Su Referencia | filters on the platform, writable, ::ancestor. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: