# SalesOrderStockBatchNumbersBulk: Exact Online Stock Batch Numbers - Catalog: `ExactOnlineREST` - Schema: `SalesOrder` - Primary Keys: `ID` - Label: Stock Batch Numbers The data in this table is partitioned per value of the `Division` column. This is a read-only table. 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. ## Table Columns The columns of the table `SalesOrderStockBatchNumbersBulk` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BatchNumber` | `varchar2` | Batch Number | ☐ | Human readable batch number. | | `BatchNumberID` | `guid` | Batch Number ID | ☐ | Batch number ID. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2` | Creator Full Name | ☐ | Name of creator. | | `Division` | `int32` | Division ID | ☑ | Unique number of the Exact Online division. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `DraftStockTransactionID` | `guid` | | ☐ | ID representing a group of batch numbers being reserved for use in a subsequent stock transaction. | | `EndDate` | `datetime` | End Date | ☐ | End date of effective period for batch number. | | `ID` | `guid` | ID | ☑ | Primary key. | | `IsBlocked` | `int16` | Is Blocked | ☐ | Boolean value indicating whether or not the batch number is blocked. | | `IsDraft` | `int16` | Is Draft | ☐ | Boolean value indicating if this batch number is being reserved. | | `Item` | `guid` | Item | ☐ | Item. | | `ItemCode` | `varchar2` | Item Code | ☐ | Item code. | | `ItemDescription` | `varchar2` | Item Description | ☐ | Description of item. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2` | Modified Full Name | ☐ | Name of modifier. | | `ParentID` | `guid` | Parent ID | ☐ | | | `PickOrderLine` | `guid` | Pickorder Line | ☐ | ID of pick order entry in which this batch number was used. | | `Quantity` | `double` | Quantity | ☐ | Quantity of this batch number entering or leaving inventory. | | `Remarks` | `varchar2` | Remarks | ☐ | Remarks. | | `SalesOrderLine` | `guid` | Sales Order Line | ☐ | | | `SalesReturnLine` | `guid` | Sales Return Line | ☐ | ID of sales return entry in which this batch number was used. | | `StockCountLine` | `guid` | Stock Count Line | ☐ | ID of stock count entry. | | `StockTransactionID` | `guid` | Stock Transaction ID | ☐ | ID of the stock transaction in which this batch number was used. | | `StockTransactionType` | `int32` | | ☐ | Type of stock transaction associated with this batch 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. | | `StorageLocation` | `guid` | Storage Location | ☐ | Storage location which this batch number is entering or leaving. | | `StorageLocationCode` | `varchar2` | Storage Location Code | ☐ | Code of the storage location which this batch number is entering or leaving. | | `StorageLocationDescription` | `varchar2` | Storage Location Description | ☐ | Description of the storage location which this batch number is entering or leaving. | | `Warehouse` | `guid` | Warehouse | ☐ | Warehouse which this batch number is entering or leaving. | | `WarehouseCode` | `varchar2` | Warehouse Code | ☐ | Code of the warehouse which this batch number is entering or leaving. | | `WarehouseDescription` | `varchar2` | Warehouse Description | ☐ | Description of the warehouse which this batch number is entering or leaving. | | `WarehouseTransferLine` | `guid` | | ☐ | |