Таблица | Table: SC62 - «BoxHeader». Маска имени таблицы | Table Name Mask: «SC62%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SC62001 | NCHAR | STRING | 10 | 0 | 10 | Shipment | Shipment Number | 1 | Да / Yes | |
SC62002 | NVARCHAR | VSTRING | 20 | 0 | 20 | PackList | Pack List Number | 2 | Да / Yes | |
SC62003 | NVARCHAR | VSTRING | 20 | 0 | 20 | Box | Box ID | 3 | Да / Yes | |
SC62004 | NVARCHAR | VSTRING | 25 | 0 | 25 | Description | Description | |||
SC62005 | DATETIME | DATE | 0 | 0 | 8 | CreatedDate | Date Created | |||
SC62006 | INT | INTEGER | 0 | 0 | 1 | CreatedFrom | Created From | |||
SC62007 | NCHAR | STRING | 5 | 0 | 5 | TypeOfPackage | Type of Package | |||
SC62008 | INT | INTEGER | 0 | 0 | 1 | Status | Status | |||
SC62009 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
SC62010 | NVARCHAR | VSTRING | 6 | 0 | 6 | Bin | Bin | |||
SC62011 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField01 | User Field 1 | |||
SC62012 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField02 | User Field 2 | |||
SC62013 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField03 | User Field 3 | |||
SC62014 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField04 | User Field 4 | |||
SC62015 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField05 | User Field 5 | |||
SC62016 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField06 | User Field 6 | |||
SC62017 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField07 | User Field 7 | |||
SC62018 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField08 | User Field 8 | |||
SC62019 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField09 | User Field 9 | |||
SC62020 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField10 | User Field 10 | |||
SC62021 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField11 | User Field 11 | |||
SC62022 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField12 | User Field 12 | |||
SC62023 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField13 | User Field 13 | |||
SC62024 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField14 | User Field 14 | |||
SC62025 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField15 | User Field 15 | |||
SC62026 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField16 | User Field 16 | |||
SC62027 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField17 | User Field 17 | |||
SC62028 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField18 | User Field 18 | |||
SC62029 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField19 | User Field 19 | |||
SC62030 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField20 | User Field 20 | |||
SC62031 | NVARCHAR | VSTRING | 35 | 0 | 35 | BoxStockCode | Stock Item Box |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Box Header