One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Material Production Control»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table MP85 — Customer Order to Work Order 1

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
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 Да / Yes
MP85002 NCHAR STRING 10 0 10 OrderNO Order Number   2 Да / Yes
MP85003 NCHAR STRING 6 0 6 OrderLineNO Order Line Number   3 Да / Yes
MP85004 NCHAR STRING 6 0 6 StructLineNO Order Sub-line Number   4 Да / Yes
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.      
MP85034 INT INTEGER 0 0 1 ATPWOShift ATP WO Shift      

Навигация / Navigation: