Таблица | Table: SC33 - «Batch Information». Маска имени таблицы | Table Name Mask: «SC33%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | 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