Таблица: SC36 - «Bin Information». Маска имени таблицы: «SC36%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SC36001 | NVARCHAR | VSTRING | 6 | 0 | 6 | WarehouseID | Warehouse | 1 | Да | |
SC36002 | NVARCHAR | VSTRING | 6 | 0 | 6 | BinNumber | Bin | 2 | Да | |
SC36003 | NVARCHAR | VSTRING | 25 | 0 | 25 | BinDescript1 | Description Line 1 | |||
SC36004 | NVARCHAR | VSTRING | 25 | 0 | 25 | BinDescript2 | Description Line 2 | |||
SC36005 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Length | Length | |||
SC36006 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Width | Width | |||
SC36007 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Height | Height | |||
SC36008 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | MaxWeigInBin | Maximum Weight on Bin | |||
SC36009 | NCHAR | STRING | 4 | 0 | 4 | Area | Warehouse Area | |||
SC36010 | NCHAR | STRING | 3 | 0 | 3 | BinType | Bin Type | |||
SC36011 | NCHAR | STRING | 1 | 0 | 1 | StorageType | Storage Type | |||
SC36012 | NCHAR | STRING | 1 | 0 | 1 | BinStatus | Bin Status | |||
SC36013 | NCHAR | STRING | 1 | 0 | 1 | ExclusItem | Exclusive Item | |||
SC36014 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
SC36015 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | StockQty | Stock Quantity | |||
SC36016 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | BlockedQty | Blocked Quantity | |||
SC36017 | DATETIME | DATE | 0 | 0 | 8 | Date_ | Date | |||
SC36018 | NCHAR | STRING | 6 | 0 | 6 | Time_ | Time | |||
SC36019 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SC36020 | NCHAR | STRING | 3 | 0 | 3 | Spare | (obsolete) | |||
SC36021 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Spare | (obsolete) | |||
SC36022 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Spare | (obsolete) | |||
SC36023 | INT | INTEGER | 0 | 0 | 1 | CapacityCheck | Capacity checking | |||
SC36024 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | VolumeCapacity | Volume Capacity | |||
SC36025 | INT | INTEGER | 0 | 0 | 3 | VolumeMargin | Volume Margin | |||
SC36026 | INT | INTEGER | 0 | 0 | 3 | MinTemperature | Minimum Storage Temperature | |||
SC36027 | INT | INTEGER | 0 | 0 | 3 | MaxTemperature | Maximum Temperature | |||
SC36028 | INT | INTEGER | 0 | 0 | 3 | MinHumidity | Minimum Humidity | |||
SC36029 | INT | INTEGER | 0 | 0 | 3 | MaxHumidity | Maximum Humidity | |||
SC36030 | INT | INTEGER | 0 | 0 | 1 | ItemBranchPlacement | (obsolete) |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Stock Control | Bin Information