One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Material Production Control»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица MP85 — Customer Order to Work Order 1

Таблица: 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      
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.      

Навигация: