На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Stock Control»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SC33 — Batch Information

Таблица / Table: SC33 — «Batch Information». Маска имени таблицы / Table name mask: «SC33%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 BatchNumber 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 FixedAssetCode Asset Code      
SC33047 NCHAR STRING 2 0 2 BatchType Batch Type 00 — Regular batch

01 — Consignment batch (suppliers)
   
SC33048 NCHAR STRING 10 0 10 CustSuppCode 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 LastBalanceUpdated Last Balance update date      
SC33051 NVARCHAR VSTRING 30 0 30 CustomsDispatchNumber Customs Dispatch Number      
SC33052 DATETIME DATE 0 0 8 DateImported Date Imported      
SC33053 NCHAR STRING 3 0 3 CountryOfOrigin Country of Origin      
SC33054 NCHAR STRING 10 0 10 CustomsOfficeCode Customs Office Code      
SC33055 NCHAR STRING 4 0 4 DestinationCode Destination Code      

Навигация / Navigation: