Таблица: MP85 - «C.order -> WO 1». Маска имени таблицы: «MP85%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Material Production Control | Customer Order to Work Order 1