# ShopOrdersIncremental
- Catalog: `ExactOnlineREST`
- Schema: `Incremental`
- Primary Keys: `ID`
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 `ShopOrdersIncremental` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `CADDrawingURL` | `varchar2` | CAD Drawing (URL) | ☐ | |
| `Costcenter` | `varchar2` | Cost Centre | ☐ | |
| `Costunit` | `varchar2` | Cost Unit | ☐ | |
| `Created` | `datetime` | Created | ☐ | |
| `Creator` | `guid` | Creator | ☐ | |
| `Description` | `varchar2` | Description | ☐ | |
| `Division` | `int32` | Division | ☐ | |
| `EntryDate` | `datetime` | Entry Date | ☐ | |
| `ID` | `guid` | ID | ☑ | |
| `IsBatch` | `int16` | Is Batch | ☑ | |
| `IsFractionAllowedItem` | `int16` | Is Fraction Allowed on Item | ☑ | |
| `IsInPlanning` | `int16` | Is In Planning | ☑ | |
| `IsOnHold` | `int16` | Is on Hold | ☑ | |
| `IsReleased` | `int16` | Is Released | ☑ | |
| `IsSerial` | `int16` | Is Serial | ☑ | |
| `Item` | `guid` | Item | ☐ | |
| `ItemVersion` | `guid` | Item Version | ☐ | |
| `Modified` | `datetime` | Modified | ☐ | |
| `Modifier` | `guid` | Modifier | ☐ | |
| `Notes` | `varchar2` | Notes | ☐ | |
| `PlannedDate` | `datetime` | Planned Date | ☐ | |
| `PlannedQuantity` | `double` | Planned Quantity | ☐ | |
| `PlannedStartDate` | `datetime` | Planned Start Date | ☐ | |
| `ProducedQuantity` | `double` | Produced Quantity | ☐ | |
| `ProductionLeadDays` | `int32` | Production Lead Days | ☑ | |
| `Project` | `guid` | Project | ☐ | |
| `ReadyToShipQuantity` | `double` | Ready to Ship Quantity | ☐ | |
| `SalesOrderLineCount` | `int32` | Sales Order Line Count | ☑ | |
| `SelectionCode` | `guid` | Selection Code | ☐ | |
| `ShopOrderByProductPlanBackflushCount` | `int32` | | ☑ | |
| `ShopOrderByProductPlanCount` | `int32` | | ☑ | |
| `ShopOrderMain` | `guid` | Shop Order Main | ☐ | |
| `ShopOrderMaterialPlanBackflushCount` | `int32` | | ☑ | |
| `ShopOrderMaterialPlanCount` | `int32` | | ☑ | |
| `ShopOrderNumber` | `int32` | Shop Order Number | ☐ | |
| `ShopOrderNumberString` | `varchar2` | | ☐ | |
| `ShopOrderParent` | `guid` | Shop Order Parent | ☐ | |
| `ShopOrderRoutingStepPlanCount` | `int32` | | ☑ | |
| `Status` | `int32` | Status | ☐ | |
| `SubShopOrderCount` | `int32` | Sub Shop Order Count | ☑ | |
| `Timestamp` | `int64` | Timestamp | ☑ | |
| `Type` | `int32` | Type | ☐ | |
| `Unit` | `varchar2` | Unit | ☐ | |
| `Warehouse` | `guid` | Warehouse | ☐ | |
| `YourRef` | `varchar2` | Your Reference | ☐ | |