Таблица: MP85 - «C.order -> WO 1». Маска имени таблицы: «MP85%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP85001 | NCHAR | STRING | 1 | 0 | 1 | TypeOfOrder | Type of Order | 0 - From customer orders
1 - From new work orders 2 - New work order release 4 - Move MRP to work order 5 - Delete work Order, interactive MRP 6 - New work order, interactive MRP 7 - Changed work order, interactive MRP 9 - Delete work orders |
1 | Да |
MP85002 | NCHAR | STRING | 10 | 0 | 10 | OrderNO | Order Number | 2 | Да | |
MP85003 | NCHAR | STRING | 6 | 0 | 6 | OrderLineNO | Order Line Number | 3 | Да | |
MP85004 | NCHAR | STRING | 6 | 0 | 6 | StructLineNO | Order Sub-line Number | 4 | Да | |
MP85005 | NVARCHAR | VSTRING | 10 | 0 | 10 | CusCodeBuyer | Customer Code Buyer | |||
MP85006 | DATETIME | DATE | 0 | 0 | 8 | DeliveryDate | Delivery Date | |||
MP85007 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | |||
MP85008 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Quantity | Quantity | |||
MP85009 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
MP85010 | NVARCHAR | VSTRING | 25 | 0 | 25 | WOText1 | Work Order Text Line 1 | |||
MP85011 | NVARCHAR | VSTRING | 25 | 0 | 25 | WOText2 | Work Order Text Line 2 | |||
MP85012 | NVARCHAR | VSTRING | 25 | 0 | 25 | WOText3 | Work Order Text Line 3 | |||
MP85013 | INT | INTEGER | 0 | 0 | 1 | Status1 | Options Answered | |||
MP85014 | INT | INTEGER | 0 | 0 | 1 | OpenItemExists | Open Item Exist | |||
MP85015 | INT | INTEGER | 0 | 0 | 1 | OpenQtyExists | Open Quantity Exist | |||
MP85016 | INT | INTEGER | 0 | 0 | 1 | OpenTimeExists | Open Time Exist | |||
MP85017 | INT | INTEGER | 0 | 0 | 1 | Status2 | Status 2 | 0 - Configuration not ready
1 - Configuration finished 2 - Okay to convert to work order |
||
MP85018 | NCHAR | SWITCH | 1 | 0 | 1 | MakeWO | Make Work Order | |||
MP85019 | NVARCHAR | VSTRING | 2 | 0 | 2 | AlternatRouting | Alternate Routing | |||
MP85020 | INT | INTEGER | 0 | 0 | 1 | Priority | Priority | |||
MP85021 | NVARCHAR | VSTRING | 15 | 0 | 15 | ResponsPriority | Responsible Priority | |||
MP85022 | INT | INTEGER | 0 | 0 | 1 | Status | Status | 0 - New record
1 - Material and operation list is created 2 - Material and operation list finished 3 - Work order is being released 4 - Work order has been released |
||
MP85023 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserId | Created By | |||
MP85024 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
MP85025 | NVARCHAR | VSTRING | 38 | 0 | 38 | ReleaseBatch | Release Batch | |||
MP85026 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | DueDateTimeFactor | Due Date Time Factor | |||
MP85027 | DATETIME | DATE | 0 | 0 | 8 | MtrlReservDate | Material reservation date | |||
MP85028 | NVARCHAR | VSTRING | 25 | 0 | 25 | TextLine1 | Text line 1 | |||
MP85029 | NVARCHAR | VSTRING | 25 | 0 | 25 | TextLine2 | Text line 2 | |||
MP85030 | NVARCHAR | VSTRING | 25 | 0 | 25 | TextLine3 | Text line 3 | |||
MP85031 | NVARCHAR | VSTRING | 10 | 0 | 10 | RMAReference | RMA Reference | |||
MP85032 | NVARCHAR | VSTRING | 50 | 0 | 50 | RMAComment | RMA Comment | |||
MP85033 | NVARCHAR | VSTRING | 10 | 0 | 10 | RMAReferenceNo | RMA Reference No. |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Material Production Control | Customer Order to Work Order 1