Таблица | Table: SC33 - «Batch Information». Маска имени таблицы | Table Name Mask: «SC33%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SC33001 NCHAR STRING 35 0 35 StockItem Stock Item Code   1 Да / Yes
SC33002 NCHAR STRING 6 0 6 WarehouseID Warehouse   2 Да / Yes
SC33003 NCHAR STRING 12 0 12 BatchID Batch ID Unique identifier of the batch together with warehouse and stock item code, when batch is received this value is the same as the batch number but it can changes as the batch is moved between warehouses and/or bin's.
Batch numbers with 6 leading '*' are batches created automatically by the system in case of negative balances.
3 Да / Yes
SC33004 NVARCHAR VSTRING 6 0 6 BinNumber Bin      
SC33005 NUMERIC X_NUMERIC 20 8 12 BalanceQty Balance Quantity      
SC33006 NUMERIC X_NUMERIC 20 8 12 AllocQty Allocated Quantity      
SC33007 NUMERIC X_NUMERIC 20 8 12 OrderedQty Ordered Quantity      
SC33008 NUMERIC X_NUMERIC 20 8 12 ReceivedQty Received Quantity      
SC33009 NVARCHAR VSTRING 12 0 12 Batch Number Batch Number The batch number is the number assigned when the batch was received, it will be kept if batch is fully or partially moved to other locations.    
SC33010 INT INTEGER 0 0 1 Locktatus Batch Status Value 1-9 indicates that the batch is locked.    
SC33011 NVARCHAR VSTRING 20 0 20 SearchField Search Field      
SC33012 NCHAR SWITCH 1 0 1 FLAGEmptBatc Batch Empty Used internally to find batches with an open balance:
0 - The batch has an open balance
1 - Zero balance, all items for the batch has been delivered.
   
SC33013 DATETIME DATE 0 0 8 DateReceived Date Received      
SC33014 DATETIME DATE 0 0 8 DateManufact Date Manufactured      
SC33015 DATETIME DATE 0 0 8 DateBestBefo Best Before Date      
SC33016 DATETIME DATE 0 0 8 DateShipBefo Ship Before Date      
SC33017 BINARY BINSTRING 1 0 1 SourForBatch Batch Source Indicates where in the system the batch was created:
0 - Purchase Order
1 - Sales Order
2 - Service Order
4 - Stock Control
5 - Stock Control (Import of stock received transactions)
6 - Stock Control (Import of stock issued transactions)
7 - Stock Control (Movement of asset to stock)
8 - Stock Control (Movement of stock to assets)
A - Work Order
B - Work Order
K - Work Order
L - Work Order
   
SC33018 NVARCHAR VSTRING 10 0 10 SupplRetuCust Received by Supplier/Returned by Customer      
SC33019 NCHAR STRING 10 0 10 OrderReceive Order Number (Received)      
SC33020 NVARCHAR VSTRING 6 0 6 LineNoOrdRec Order Line Number (Received)      
SC33021 NVARCHAR VSTRING 6 0 6 StructLineOr Order Sub-line Number (Received)      
SC33022 NVARCHAR VSTRING 20 0 20 SupplBatchID Supplier Batch ID      
SC33023 NUMERIC MONEY 28 8 20 BatCostUnit1 Batch Cost per Unit      
SC33024 NVARCHAR VSTRING 20 0 20 UserDefFld1 User Defined Field 1      
SC33025 NVARCHAR VSTRING 10 0 10 UserDefFld2 User Defined Field 2      
SC33026 NVARCHAR VSTRING 10 0 10 UserDefFld3 User Defined Field 3      
SC33027 NVARCHAR VSTRING 8 0 8 UserDefFld4 User Defined Field 4      
SC33028 NVARCHAR VSTRING 8 0 8 UserDefFld5 User Defined Field 5      
SC33029 NVARCHAR VSTRING 4 0 4 UserDefFld6 User Defined Field 6      
SC33030 NVARCHAR VSTRING 4 0 4 UserDefFld7 User Defined Field 7      
SC33031 NVARCHAR VSTRING 2 0 2 UserDefFld8 User Defined Field 8      
SC33032 NVARCHAR VSTRING 2 0 2 UserDefFld9 User Defined Field 9      
SC33033 NVARCHAR VSTRING 1 0 1 UserDefFld10 User Defined Field 10      
SC33034 NUMERIC MONEY 28 8 20 BatCostUnit2 Batch Cost per Unit      
SC33035 DATETIME DATE 0 0 8 LatestStkTak Latest Stock Taking Date      
SC33036 NVARCHAR VSTRING 12 0 12 ParentBatcID Parent Batch ID      
SC33037 NUMERIC X_NUMERIC 11 8 3 MovemenLevel Movement Level      
SC33038 NCHAR STRING 2 0 2 QCCategory Quality Control Category      
SC33039 NUMERIC X_NUMERIC 20 8 12 QCQuantity Quality Control Quantity      
SC33040 NCHAR STRING 1 0 1 SubStatus Sub Status      
SC33041 NVARCHAR VSTRING 4 0 4 Spare Transaction Type Negative Batch (See SC07001 for details of transaction types)    
SC33042 NUMERIC X_NUMERIC 14 8 6 PotencyFactor Potency Factor      
SC33043 INT INTEGER 0 0 2 QCNoTimesControlled Times Controlled (Quality Control)      
SC33044 NCHAR STRING 20 0 20 BoxId Box ID      
SC33045 DATETIME DATE 0 0 8 ExpireDate Expire Date      
SC33046 NVARCHAR VSTRING 35 0 35 Fixed_Asset_Code Asset Code      
SC33047 NCHAR STRING 2 0 2 Batch type Batch Type 00 - Regular batch
01 - Consignment batch (suppliers)
   
SC33048 NCHAR STRING 10 0 10 Customer/Supplier Code Supplier Code Owner of the batch in case of consignment batches    
SC33049 NUMERIC X_NUMERIC 20 8 12 TransferredQTY Transferred Quantity      
SC33050 DATETIME DATE 0 0 8 Last Balance update date        
SC33051 NCHAR STRING 25 0 25 Customs Despatch Number Customs Despatch Number      
SC33052 DATETIME DATE 0 0 8 Date Imported Date Imported      
SC33053 NCHAR STRING 3 0 3 Country of Origin Country of Origin      
SC33054 NCHAR STRING 10 0 10 Customs Office Code Customs Office Code      
SC33055 NCHAR STRING 4 0 4 Destination Code        

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Batch Information