Items: Exact Online Items
insert update delete per partition webhook REST
- Catalog:
ExactOnlineREST - Schema:
Logistics - Primary Keys:
ID - Label: Items
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
Changes arrive through the webhook topic Items.
API Source
- Endpoint:
/api/v1/{division}/logistics/Items - Metadata:
/api/v1/{division}/logistics/$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 Items 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 |
|---|---|---|---|---|---|
Assembled |
int32 |
itgen_eol_assembledleaddays | filters on the platform, writable | ||
Average |
double |
Average Cost | writable | The current average cost price. | |
Barcode |
varchar2 |
Barcode | filters on the platform, writable | Barcode of the item (numeric string). | |
Batch |
double |
Batch Quantity | filters on the platform, writable | ||
Class_ |
varchar2 |
Classification 1 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 1. | |
Class_ |
varchar2 |
Classification 2 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 2. | |
Class_ |
varchar2 |
Classification 3 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 3. | |
Class_ |
varchar2 |
Classification 4 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 4. | |
Class_ |
varchar2 |
Classification 5 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 5. | |
Class_ |
varchar2 |
Classification 6 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 6. | |
Class_ |
varchar2 |
Classification 7 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 7. | |
Class_ |
varchar2 |
Classification 8 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 8. | |
Class_ |
varchar2 |
Classification 9 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 9. | |
Class_ |
varchar2 |
Classification 10 | filters on the platform, writable | Item class code referring to ItemClasses with ClassID 10. | |
Code |
varchar2 |
Code | filters on the platform, writable | Item code. | |
Copy |
int16 |
Copy Remarks | writable | Copy sales remarks to sales lines. | |
Cost |
varchar2 |
Cost Price Currency | writable | The currency of the current and proposed cost price. | |
Cost |
double |
Cost Price New | filters on the platform, writable | Proposed cost price. | |
Cost |
double |
Cost Price Standard | writable | The current standard cost price. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Created (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Creator Full Name | writable | Name of creator. | |
Custom |
varchar2 |
Custom Field | filters on the platform, writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description of the item. | |
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. | |
End |
datetime |
End Date | filters on the platform, writable | Together with StartDate this determines if the item is active. | |
Extra |
varchar2 |
Extra Description | filters on the platform, writable | Extra description text, slightly longer than the regular description (255 instead of 60). | |
Free |
char |
Free Boolean Field #1 | filters on the platform, writable | Free boolean field 1. | |
Free |
char |
Free Boolean Field #2 | filters on the platform, writable | Free boolean field 2. | |
Free |
char |
Free Boolean Field #3 | filters on the platform, writable | Free boolean field 3. | |
Free |
char |
Free Boolean Field #4 | filters on the platform, writable | Free boolean field 4. | |
Free |
char |
Free Boolean Field #5 | filters on the platform, writable | Free boolean field 5. | |
Free |
datetime |
Free Date Field #1 | filters on the platform, writable | Free date field 1. | |
Free |
datetime |
Free Date Field #2 | filters on the platform, writable | Free date field 2. | |
Free |
datetime |
Free Date Field #3 | filters on the platform, writable | Free date field 3. | |
Free |
datetime |
Free Date Field #4 | filters on the platform, writable | Free date field 4. | |
Free |
datetime |
Free Date Field #5 | filters on the platform, writable | Free date field 5. | |
Free |
double |
Free Number Field #1 | filters on the platform, writable | Free numeric field 1. | |
Free |
double |
Free Number Field #2 | filters on the platform, writable | Free numeric field 2. | |
Free |
double |
Free Number Field #3 | filters on the platform, writable | Free numeric field 3. | |
Free |
double |
Free Number Field #4 | filters on the platform, writable | Free numeric field 4. | |
Free |
double |
Free Number Field #5 | filters on the platform, writable | Free numeric field 5. | |
Free |
double |
Free Number Field #6 | filters on the platform, writable | Free numeric field 6. | |
Free |
double |
Free Number Field #7 | filters on the platform, writable | Free numeric field 7. | |
Free |
double |
Free Number Field #8 | filters on the platform, writable | Free numeric field 8. | |
Free |
varchar2 |
Free Text Field #1 | filters on the platform, writable | Free text field 1. | |
Free |
varchar2 |
Free Text Field #2 | filters on the platform, writable | Free text field 2. | |
Free |
varchar2 |
Free Text Field #3 | filters on the platform, writable | Free text field 3. | |
Free |
varchar2 |
Free Text Field #4 | filters on the platform, writable | Free text field 4. | |
Free |
varchar2 |
Free Text Field #5 | filters on the platform, writable | Free text field 5. | |
Free |
varchar2 |
Free Text Field #6 | filters on the platform, writable | Free text field 6. | |
Free |
varchar2 |
Free Text Field #7 | filters on the platform, writable | Free text field 7. | |
Free |
varchar2 |
Free Text Field #8 | filters on the platform, writable | Free text field 8. | |
Free |
varchar2 |
Free Text Field #9 | filters on the platform, writable | Free text field 9. | |
Free |
varchar2 |
Free Text Field #10 | filters on the platform, writable | Free text field 10. | |
GL |
guid |
GL Costs | filters on the platform, writable | GL account the cost entries will be booked on. This overrules the GL account from the item group. If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. | |
GL |
varchar2 |
GL Account Code Costs | writable | Code of GL account for costs. | |
GL |
varchar2 |
GL Account Description Costs | writable | Description of GLCosts. | |
GL |
guid |
itgen_eol_glcostsworkinprogress | filters on the platform | ||
GL |
varchar2 |
itgen_eol_glcostsworkinprogresscode | filters on the platform | ||
GL |
varchar2 |
itgen_eol_glcostsworkinprogressdescription | filters on the platform | ||
GL |
guid |
GL Revenue | filters on the platform, writable | GL account the revenue will be booked on. This overrules the GL account from the item group. If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. | |
GL |
varchar2 |
GL Account Code Revenue | writable | Code of GLRevenue. | |
GL |
varchar2 |
GL Account Description Revenue | writable | Description of GLRevenue. | |
GL |
guid |
itgen_eol_glrevenueworkinprogress | filters on the platform | ||
GL |
varchar2 |
itgen_eol_glrevenueworkinprogresscode | filters on the platform | ||
GL |
varchar2 |
itgen_eol_glrevenueworkinprogressdescription | filters on the platform | ||
GL |
guid |
GL Account Stock | filters on the platform, writable | GL account the stock entries will be booked on. This overrules the GL account from the item group. If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. | |
GL |
varchar2 |
GL Account Code Stock | writable | Code of GL account for stock. | |
GL |
varchar2 |
GL Account Description Stock | writable | Description of GLStock. | |
Gross |
double |
Gross Weight | writable | Gross weight for international goods shipments. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Is |
int16 |
Is Batch Item | filters on the platform, writable | Indicates if batches are used for this item. | |
Is |
int16 |
Is Batch Number Item | filters on the platform, writable | This property is obsolete. Use property 'IsBatchItem' instead. | |
Is |
char |
Is Fraction Allowed on Item | filters on the platform, writable | Indicates if fractions (for example 0.35) are allowed for quantities of this item. | |
Is |
int16 |
Is Make Item | filters on the platform, writable | Indicates that an Item is produced to Inventory, not purchased. | |
Is |
int16 |
Is New Contract | writable | Only used for packages (IsPackageItem=1). To indicate if this package is a new contract type package. | |
Is |
int16 |
Is On-demand Item | writable | Is On demand Item. | |
Is |
char |
Is Package Item | writable | Indicates if the item is a package item. Can only be created in the hosting administration. | |
Is |
char |
Is Purchase Item | filters on the platform, writable | Indicates if the item can be purchased. | |
Is |
int16 |
Is Registration Code Item | filters on the platform, writable | Indicated if the item is used in voucher functionality. | |
Is |
char |
Is Sales Item | filters on the platform, writable | Indicates if the item can be sold. | |
Is |
char |
Is Serial Item | filters on the platform, writable | Indicates that serial numbers are used for this item. | |
Is |
char |
Is Serial Number Item | writable | This property is obsolete. Use property 'IsSerialItem' instead. | |
Is |
char |
Is Stock Item | filters on the platform, writable | If you have the Trade or Manufacturing license and you check this property the item will be shown in the stock positions overview, stock counts and transaction lists. If you have the Invoice module and you check this property you will get a general journal entry based on the Stock and Costs G/L accounts of the item group. If you don't want the general journal entry to be created you should change the Stock/Costs G/L account on the Item group page to the type Costs instead of Inventory. | |
Is |
char |
Is Subcontracted Item | filters on the platform, writable | Indicates if the item is provided by an outside supplier. | |
Is |
int16 |
Is Taxable Item | writable | Indicates if tax needs to be calculated for this item. | |
IsTime |
int16 |
Is Time | filters on the platform, writable | Indicates if the item is a time unit item (for example a labor hour item). | |
Is |
int16 |
Is Webshop Item | filters on the platform, writable | Indicates if the item can be exported to a web shop. | |
Item |
guid |
Is Item Group | filters on the platform, writable | GUID of Item group of the item. | |
Item |
varchar2 |
Item Group Code | filters on the platform, writable | Code of ItemGroup. | |
Item |
varchar2 |
Item Group Description | writable | Description of ItemGroup. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modified (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Modified Full Name | writable | Name of modifier. | |
Net |
double |
Net Weight | writable | Net weight for international goods shipments. | |
Net |
varchar2 |
Net Weight Unit | filters on the platform, writable | Net Weight unit for international goods shipment, only available in manufacturing packages. | |
Notes |
varchar2 |
Notes | writable | Notes. | |
Picture |
blob |
Picture | filters on the platform, writable | ||
Picture |
varchar2 |
Picture Name | writable | File name of picture. | |
Picture |
varchar2 |
Picture Thumbnail (URL) | writable | Url where thumbnail picture can be retrieved. | |
Picture |
varchar2 |
Picture (URL) | writable | Url where picture can be retrieved. | |
Sales |
varchar2 |
Sales VAT Code | filters on the platform, writable | Code of SalesVat. | |
Sales |
varchar2 |
Sales VAT Code Description | writable | Description of Sales VAT code. | |
Search |
varchar2 |
Search Code | filters on the platform, writable | Search code of the item. | |
Security |
int32 |
Security Level | writable | Security level (0 - 100). | |
Standard |
double |
Standard Sales Price | filters on the platform, writable | ||
Start |
datetime |
Start Date | filters on the platform, writable | Together with EndDate this determines if the item is active. | |
Statistical |
varchar2 |
Statistical Code | filters on the platform | ||
Statistical |
double |
Statistical Net Weight | filters on the platform | ||
Statistical |
double |
Statistical Units | filters on the platform | ||
Statistical |
double |
Statistical Value | filters on the platform | ||
Stock |
double |
Stock | writable | Quantity that is in stock. | |
Unit |
varchar2 |
Unit | filters on the platform, writable | The standard unit of this item. | |
Unit |
varchar2 |
Unit Description | writable | Description of Unit. | |
Unit |
varchar2 |
Unit Type | writable | Type of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=Weight. | |
Use |
int16 |
itgen_eol_useexplosion | filters on the platform, writable |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Items_ |
Creator |
Users. |
Key | |
Items_ |
GL |
GLAccounts.ID |
Key | |
Items_ |
GL |
GLAccounts.ID |
Key | |
Items_ |
GL |
GLAccounts.ID |
Key | |
Items_ |
Item |
ItemGroups.ID |
Key | |
Items_ |
Modifier |
Users. |
Key | |
Items_ |
Unit |
Units.Code |
Key |
Referenced By
- Budgets
Item(Key) - QuotationLines
Item(Key) - QuotationLinesBulk
Item(Key) - TransactionLines
Item(Key) - TransactionLinesBulk
Item(Key) - AssemblyOrders
Item(Key) - BatchNumbers
Item(Key) - ItemWarehousePlanningDetails
Item(Key) - ItemWarehouseStorageLocations
Item(Key) - ItemWarehouses
Item(Key) - SerialNumbers
Item(Key) - StockBatchNumbers
Item(Key) - StockCountLines
Item(Key) - StockSerialNumbers
Item(Key) - WarehouseTransferLines
Item(Key) - CustomerItems
Item(Key) - ItemVersions
Item(Key) - SalesItemPrices
Item(Key) - SalesItemPricesBulk
Item(Key) - SupplierItems
Item(Key) - BillOfMaterialMaterials
PartItem(Key) - BillOfMaterialVersions
Item(Key) - ByProductReceipts
Item(Key) - ByProductReversals
Item(Key) - MaterialIssues
Item(Key) - MaterialReversals
Item(Key) - MfgItemWarehouseStorageLocations
Item(Key) - Operations
Item(Key) - ShopOrderMaterialPlans
Item(Key) - ShopOrderReceipts
Item(Key) - ShopOrderReversals
Item(Key) - ShopOrders
Item(Key) - StageForDeliveryReceipts
Item(Key) - StageForDeliveryReversals
Item(Key) - SubOrderReceipts
Item(Key) - SubOrderReversals
Item(Key) - CostTransactions
Item(Key) - EmployeeRestrictionItems
Item(Key) - InvoiceTerms
Item(Key) - PjtTimeTransactions
Item(Key) - ProjectHourBudgets
Item(Key) - ProjectRestrictionEmployeeItems
Item(Key) - ProjectRestrictionItems
Item(Key) - ProjectWBS
DefaultItem(Key) - ProjectWBSBulk
DefaultItem(Key) - Projects
FixedPriceItem(Key) - Projects
PrepaidItem(Key) - RecentCosts
ItemId(Key) - RecentHours
ItemId(Key) - WBSActivities
DefaultItem(Key) - PurchaseInvoiceLines
Item(Key) - GoodsReceiptLines
Item(Key) - PurchaseOrderLines
Item(Key) - PurchaseOrderStockBatchNumbers
Item(Key) - PurchaseOrderStockSerialNumbers
Item(Key) - SalesPriceListVolumeDiscounts
Item(Key) - SalesInvoiceLines
Item(Key) - SalesInvoiceLinesBulk
Item(Key) - DigitalOrderPickingLines
Item(Key) - GoodsDeliveryLines
Item(Key) - GoodsDeliveryLinesBulk
Item(Key) - PlannedSalesReturnLines
Item(Key) - SalesOrderLines
Item(Key) - SalesOrderLinesBulk
Item(Key) - SalesOrderStockBatchNumbers
Item(Key) - SalesOrderStockBatchNumbersBulk
Item(Key) - SalesOrderStockSerialNumbersBulk
Item(Key) - SubscriptionLines
Item(Key) - SubscriptionRestrictionItems
Item(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: