PurchaseOrderStockSerialNumbers: Exact Online Purchase Order Stock Serial Numbers
insert update delete per partition REST
- Catalog:
ExactOnlineREST - Schema:
PurchaseOrder - Primary Keys:
ID - Label: Purchase Order Stock Serial Numbers
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/api/v1/{division}/purchaseorder/StockSerialNumbers - Metadata:
/api/v1/{division}/purchaseorder/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |
The result can be cached on the client.
Table Columns
The columns of the table PurchaseOrderStockSerialNumbers are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Created (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Creator Full Name | filters on the platform, writable | Name of creator. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Division Chamber of Commerce Number | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Division IBAN Number | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division Company Name | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Division RSIN Number | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Division VAT Number | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Division Wage Tax Number | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Division Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administration Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Subscription Holder Name | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Subscription Holder Number | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Division Short Name | writable | Short name of the Exact Online division. | |
Draft |
guid |
itgen_eol_draftstocktransactionid | filters on the platform, writable | ID representing a group of serial numbers being reserved for use in a subsequent stock transaction. | |
End |
datetime |
End Date | filters on the platform, writable | End date of effective period for serial number. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Is |
int16 |
Is Blocked | filters on the platform, writable | Boolean value indicating whether or not the serial number is blocked. | |
Is |
int16 |
Is Draft | filters on the platform, writable | Boolean value indicating if this serial number is being reserved. | |
Item |
guid |
Item | filters on the platform, writable | Item. | |
Item |
varchar2 |
Item Code | filters on the platform, writable | Item code. | |
Item |
varchar2 |
Item Description | filters on the platform, writable | Description of item. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modified (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Modified Full Name | filters on the platform, writable | Name of modifier. | |
Parent |
guid |
Parent ID | filters on the platform, writable | ||
Pick |
guid |
Pickorder Line | filters on the platform, writable | ID of pick order entry in which this serial number was used. | |
Remarks |
varchar2 |
Remarks | filters on the platform, writable | Remarks. | |
Sales |
guid |
Sales Order Line | filters on the platform, writable | ||
Sales |
guid |
Sales Return Line | filters on the platform, writable | ID of sales return entry in which this serial number was used. | |
Serial |
varchar2 |
Serial Number | filters on the platform, writable | Human readable serial number. | |
Serial |
guid |
Serial Number ID | filters on the platform, writable | Serial number ID. | |
Start |
datetime |
Start Date | filters on the platform, writable | Start date of effective period for serial number. | |
Stock |
guid |
Stock Count Line | filters on the platform, writable | ID of stock count entry. | |
Stock |
guid |
Stock Transaction ID | filters on the platform, writable | ID of the stock transaction in which this serial number was used. | |
Stock |
int32 |
itgen_eol_stocktransactiontype | filters on the platform, writable | Type of stock transaction associated with this serial number. Available values: 10 = Opening balance, 120 = Goods delivery, 121 = Sales return, 122 = Stock out (Drop shipment), 123 = Stock in (Drop shipment return), 124 = Warehouse transfer delivery, 125 = Location Transfer Delivery, 130 = Goods receipt, 131 = Purchase return, 132 = Stock in (Drop shipment), 133 = Stock out (Drop shipment return), 134 = Warehouse transfer receipt, 135 = Location Transfer Receipt, 140 = Shop order stock receipt, 141 = Shop order stock reversal, 147 = Shop order by-product receipt, 148 = Shop order by-product reversal, 150 = Requirement issue, 151 = Requirement reversal, 155 = Subcontract issue, 156 = Subcontract return, 160 = Receipt(Assembly), 161 = Return receipt(Disassembly), 165 = Issue(Assembly), 166 = Return issue(Disassembly), 180 = Stock revaluation, 181 = Financial revaluation, 195 = Stock count, 196 = Adjust stock - out, 197 = Adjust stock - in. | |
Storage |
guid |
Storage Location | filters on the platform, writable | Storage location which this serial number is entering or leaving. | |
Storage |
varchar2 |
Storage Location Code | filters on the platform, writable | Code of the storage location which this serial number is entering or leaving. | |
Storage |
varchar2 |
Storage Location Description | filters on the platform, writable | Description of the storage location which this serial number is entering or leaving. | |
Warehouse |
guid |
Warehouse | filters on the platform, writable | Warehouse which this serial number is entering or leaving. | |
Warehouse |
varchar2 |
Warehouse Code | filters on the platform, writable | Code of the warehouse which this serial number is entering or leaving. | |
Warehouse |
varchar2 |
Warehouse Description | filters on the platform, writable | Description of the warehouse which this serial number is entering or leaving. | |
Warehouse |
guid |
itgen_eol_warehousetransferline | filters on the platform, writable |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Purchase |
Creator |
Users. |
Key | |
Purchase |
Item |
Items.ID |
Key | |
Purchase |
Modifier |
Users. |
Key | |
Purchase |
Serial |
SerialNumbers.ID |
Key | |
Purchase |
Stock |
StockCountLines.ID |
Key | |
Purchase |
Storage |
StorageLocations.ID |
Key | |
Purchase |
Warehouse |
Warehouses.ID |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: