Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица | Table: MP69 - «Load File». Маска имени таблицы | Table Name Mask: «MP69%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
MP69001 | NCHAR | STRING | 1 | 0 | 1 | RecordType | Record Type | B - Work centre load
D - |
1 | Да / Yes |
MP69002 | NCHAR | STRING | 8 | 0 | 8 | Workcentre | Work Centre | 2 | Да / Yes | |
MP69003 | NCHAR | STRING | 3 | 0 | 3 | DispatchOrder | Dispatch Order | 3 | Да / Yes | |
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 | Да / Yes |
MP69005 | DATETIME | DATE | 0 | 0 | 8 | StartDate | Start Date | 5 | Да / Yes | |
MP69006 | NCHAR | STRING | 1 | 0 | 1 | Priority | Priority | 6 | Да / Yes | |
MP69007 | NCHAR | STRING | 10 | 0 | 10 | ReportingNo | Report Number | 7 | Да / Yes | |
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 | |||
MP69018 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | StartDateTimeFactor | Start Date Time Factor (Op) | |||
MP69019 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | DueDateTimeFactor | Due Date Time Factor (Op) |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Material Production Control | Dispatched Load