# ItemsIncremental: Exact Online Items (Incremental) - Catalog: `ExactOnlineREST` - Schema: `Incremental` - Primary Keys: `ID` - Label: Items (Incremental) The data in this table is partitioned per value of the `Division` column. This is a read-only view. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. ## View Columns The columns of the view `ItemsIncremental` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AssembledLeadDays` | `int32` | | ☐ | | | `AverageCost` | `double` | Average Cost | ☐ | The current average cost price. | | `Barcode` | `varchar2` | Barcode | ☐ | Barcode of the item. | | `BatchQuantity` | `double` | Batch Quantity | ☐ | | | `Class_01` | `varchar2` | Classification 1 | ☐ | Item class code referring to item class with class ID 1. | | `Class_02` | `varchar2` | Classification 2 | ☐ | Item class code referring to item class with class ID 2. | | `Class_03` | `varchar2` | Classification 3 | ☐ | Item class code referring to item class with class ID 3. | | `Class_04` | `varchar2` | Classification 4 | ☐ | Item class code referring to item class with class ID 4. | | `Class_05` | `varchar2` | Classification 5 | ☐ | Item class code referring to item class with class ID 5. | | `Class_06` | `varchar2` | Classification 6 | ☐ | Item class code referring to item class with class ID 6. | | `Class_07` | `varchar2` | Classification 7 | ☐ | Item class code referring to item class with class ID 7. | | `Class_08` | `varchar2` | Classification 8 | ☐ | Item class code referring to item class with class ID 8. | | `Class_09` | `varchar2` | Classification 9 | ☐ | Item class code referring to item class with class ID 9. | | `Class_10` | `varchar2` | Classification 10 | ☐ | Item class code referring to item class with class ID 10. | | `Code` | `varchar2` | Code | ☐ | Item code. | | `CopyRemarks` | `int16` | Copy Remarks | ☐ | Copy sales remarks to sales lines. | | `CopyRemarks` | `int16` | Copy Remarks | ☐ | Copy sales remarks to sales lines. | | `CostPriceCurrency` | `varchar2` | Cost Price Currency | ☐ | The currency of the current and proposed cost price. | | `CostPriceNew` | `double` | Cost Price New | ☐ | Proposed cost price. | | `CostPriceStandard` | `double` | Cost Price Standard | ☐ | The current standard cost price. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `Description` | `varchar2` | Description | ☐ | Description of the item. | | `Division` | `int32` | Division | ☑ | Division code. | | `EndDate` | `datetime` | End Date | ☐ | Together with StartDate this determines if the item is active. | | `ExtraDescription` | `varchar2` | Extra Description | ☐ | Extra description text, slightly longer than the regular description (255 instead of 60). | | `FreeBoolField_01` | `char` | Free Boolean Field #1 | ☐ | Free boolean field 1. | | `FreeBoolField_02` | `char` | Free Boolean Field #2 | ☐ | Free boolean field 2. | | `FreeBoolField_03` | `char` | Free Boolean Field #3 | ☐ | Free boolean field 3. | | `FreeBoolField_04` | `char` | Free Boolean Field #4 | ☐ | Free boolean field 4. | | `FreeBoolField_05` | `char` | Free Boolean Field #5 | ☐ | Free boolean field 5. | | `FreeDateField_01` | `datetime` | Free Date Field #1 | ☐ | Free date field 1. | | `FreeDateField_02` | `datetime` | Free Date Field #2 | ☐ | Free date field 2. | | `FreeDateField_03` | `datetime` | Free Date Field #3 | ☐ | Free date field 3. | | `FreeDateField_04` | `datetime` | Free Date Field #4 | ☐ | Free date field 4. | | `FreeDateField_05` | `datetime` | Free Date Field #5 | ☐ | Free date field 5. | | `FreeNumberField_01` | `double` | Free Number Field #1 | ☐ | Free numeric field 1. | | `FreeNumberField_02` | `double` | Free Number Field #2 | ☐ | Free numeric field 2. | | `FreeNumberField_03` | `double` | Free Number Field #3 | ☐ | Free numeric field 3. | | `FreeNumberField_04` | `double` | Free Number Field #4 | ☐ | Free numeric field 4. | | `FreeNumberField_05` | `double` | Free Number Field #5 | ☐ | Free numeric field 5. | | `FreeNumberField_06` | `double` | Free Number Field #6 | ☐ | Free numeric field 6. | | `FreeNumberField_07` | `double` | Free Number Field #7 | ☐ | Free numeric field 7. | | `FreeNumberField_08` | `double` | Free Number Field #8 | ☐ | Free numeric field 8. | | `FreeTextField_01` | `varchar2` | Free Text Field #1 | ☐ | Free text field 1. | | `FreeTextField_02` | `varchar2` | Free Text Field #2 | ☐ | Free text field 2. | | `FreeTextField_03` | `varchar2` | Free Text Field #3 | ☐ | Free text field 3. | | `FreeTextField_04` | `varchar2` | Free Text Field #4 | ☐ | Free text field 4. | | `FreeTextField_05` | `varchar2` | Free Text Field #5 | ☐ | Free text field 5. | | `FreeTextField_06` | `varchar2` | Free Text Field #6 | ☐ | Free text field 6. | | `FreeTextField_07` | `varchar2` | Free Text Field #7 | ☐ | Free text field 7. | | `FreeTextField_08` | `varchar2` | Free Text Field #8 | ☐ | Free text field 8. | | `FreeTextField_09` | `varchar2` | Free Text Field #9 | ☐ | Free text field 9. | | `FreeTextField_10` | `varchar2` | Free Text Field #10 | ☐ | Free text field 10. | | `GLCosts` | `guid` | GL Costs | ☐ | 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. | | `GLRevenue` | `guid` | GL Revenue | ☐ | 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. | | `GLStock` | `guid` | GL Account Stock | ☐ | 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. | | `GrossWeight` | `double` | Gross Weight | ☐ | Gross weight for international goods shipments. | | `ID` | `guid` | ID | ☑ | A guid that is the unique identifier of the item. | | `IsBatchItem` | `int16` | Is Batch Item | ☐ | Indicates if batches are used for this item. | | `IsFractionAllowedItem` | `char` | Is Fraction Allowed on Item | ☐ | Indicates if fractions (for example 0.35) are allowed for quantities of this item. | | `IsMakeItem` | `int16` | Is Make Item | ☐ | Indicates that an Item is produced to Inventory, not purchased. | | `IsNewContract` | `int16` | Is New Contract | ☐ | Only used for packages (IsPackageItem=1). To indicate if this package is a new contract type package. | | `IsOnDemandItem` | `int16` | Is On-demand Item | ☐ | Is On demand Item. | | `IsPackageItem` | `char` | Is Package Item | ☐ | Indicates if the item is a package item. Can only be created in the hosting administration. | | `IsPurchaseItem` | `char` | Is Purchase Item | ☐ | Indicates if the item can be purchased. | | `IsRegistrationCodeItem` | `int16` | Is Registration Code Item | ☑ | | | `IsSalesItem` | `char` | Is Sales Item | ☐ | Indicates if the item can be sold. | | `IsSerialItem` | `char` | Is Serial Item | ☐ | Indicates that serial numbers are used for this item. | | `IsStockItem` | `char` | Is Stock Item | ☐ | 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. | | `IsSubcontractedItem` | `char` | Is Subcontracted Item | ☐ | Indicates if the item is provided by an outside supplier. | | `IsTaxableItem` | `int16` | Is Taxable Item | ☐ | Indicates if tax needs to be calculated for this item. | | `IsTime` | `int16` | Is Time | ☐ | Indicates if the item is a time unit item (for example a labor hour item). | | `IsWebshopItem` | `int16` | Is Webshop Item | ☐ | Indicates if the item can be exported to a web shop. | | `ItemGroup` | `guid` | Is Item Group | ☐ | GUID of item group of the item. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `NetWeight` | `double` | Net Weight | ☐ | Net weight for international goods shipments. | | `NetWeightUnit` | `varchar2` | Net Weight Unit | ☐ | Net Weight unit for international goods shipment, only available in manufacturing packages. | | `Notes` | `varchar2` | Notes | ☐ | Notes. | | `Picture` | `blob` | Picture | ☐ | | | `PictureName` | `varchar2` | Picture Name | ☐ | File name of picture. | | `PictureThumbnailUrl` | `varchar2` | Picture Thumbnail (URL) | ☐ | URL where thumbnail picture can be retrieved. | | `PictureUrl` | `varchar2` | Picture (URL) | ☐ | URL where picture can be retrieved. | | `SalesVatCode` | `varchar2` | Sales VAT Code | ☐ | Code of sales VAT. | | `SearchCode` | `varchar2` | Search Code | ☐ | Search code of the item. | | `SecurityLevel` | `int32` | Security Level | ☐ | Security level (0 - 100). | | `StartDate` | `datetime` | Start Date | ☐ | Together with EndDate this determines if the item is active. | | `StatisticalCode` | `varchar2` | Statistical Code | ☐ | Statistical code. | | `StatisticalNetWeight` | `double` | Statistical Net Weight | ☐ | Netweight weight for statistical reporting. | | `StatisticalUnits` | `double` | Statistical Units | ☐ | Units for statistical reporting. | | `StatisticalValue` | `double` | Statistical Value | ☐ | Value for statistical reporting. | | `Stock` | `double` | Stock | ☐ | | | `Timestamp` | `int64` | Timestamp | ☑ | Timestamp. | | `Unit` | `varchar2` | Unit | ☐ | The standard unit of this item. | | `UnitType` | `varchar2` | Unit Type | ☐ | Type of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=Weight. | | `UseExplosion` | `int16` | | ☐ | |