Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: MP69 - «Load File». Маска имени таблицы: «MP69%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP69001 | NCHAR | STRING | 1 | 0 | 1 | RecordType | Record Type | B - Work centre load
D - |
1 | Да |
MP69002 | NCHAR | STRING | 8 | 0 | 8 | Workcentre | Work Centre | 2 | Да | |
MP69003 | NCHAR | STRING | 3 | 0 | 3 | DispatchOrder | Dispatch Order | 3 | Да | |
MP69004 | NCHAR | STRING | 35 | 0 | 35 | SortTerm | Sort Key | Depending on the dispatch code (MP50059) on the work centre this field hold the value that the list shall be sorted by. Can be stock code, tool or just empty if there is no sort order defined. | 4 | Да |
MP69005 | DATETIME | DATE | 0 | 0 | 8 | StartDate | Start Date | 5 | Да | |
MP69006 | NCHAR | STRING | 1 | 0 | 1 | Priority | Priority | 6 | Да | |
MP69007 | NCHAR | STRING | 10 | 0 | 10 | ReportingNo | Report Number | 7 | Да | |
MP69008 | NVARCHAR | VSTRING | 11 | 0 | 11 | Hours | Hours | |||
MP69009 | DATETIME | DATE | 0 | 0 | 8 | ChangedDate | Date Changed | |||
MP69010 | DATETIME | DATE | 0 | 0 | 8 | ActComplDate | Actual Completion Date | |||
MP69011 | NCHAR | STRING | 10 | 0 | 10 | WorkorderNo | Work Order Number | |||
MP69012 | NCHAR | STRING | 3 | 0 | 3 | OperationNo | Operation Number | |||
MP69013 | NCHAR | STRING | 3 | 0 | 3 | Sequence | Sequence | |||
MP69014 | NVARCHAR | VSTRING | 1 | 0 | 1 | RobotFlag | Is Robot | |||
MP69015 | NUMERIC | X_NUMERIC | 17 | 8 | 9 | SetupTime | Setup Time | |||
MP69016 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Weight | Weight | |||
MP69017 | NCHAR | STRING | 3 | 0 | 3 | OperationDepCode | Operation Dependent Code |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Material Production Control | Dispatched Load