Таблица: MP9B - «Temporay File B for MRP». Маска имени таблицы: «MP9B0000»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP9B001 | NCHAR | STRING | 10 | 0 | 10 | ReportingNo | ReportingNo | 1 | Да | |
MP9B002 | NCHAR | STRING | 3 | 0 | 3 | OperationalNo | OperationalNo | 2 | Да | |
MP9B003 | NVARCHAR | VSTRING | 8 | 0 | 8 | WorkCenter | WorkCenter | |||
MP9B004 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | SetupTime | SetupTime | |||
MP9B005 | NUMERIC | X_NUMERIC | 17 | 8 | 9 | RunTime | RunTime | |||
MP9B006 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | QueuTime | QueuTime | |||
MP9B007 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | MoveTime | MoveTime | |||
MP9B008 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Overlap | Overlap | |||
MP9B009 | INT | INTEGER | 0 | 0 | 10 | LeadTime | LeadTime | |||
MP9B010 | DATETIME | DATE | 0 | 0 | 8 | StartDate | StartDate | |||
MP9B011 | DATETIME | DATE | 0 | 0 | 8 | DueDate | DueDate | |||
MP9B012 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | RequiredQty | RequiredQty | |||
MP9B013 | NUMERIC | X_NUMERIC | 12 | 8 | 4 | NoOfResources | NoOfResources | |||
MP9B014 | NVARCHAR | VSTRING | 35 | 0 | 35 | ParentItem | ParentItem | |||
MP9B015 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | ScrapFactor | ScrapFactor |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Material Production Control | Temporay File B for MRP