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 :: Таблица MP64 — Work Orders

Таблица: MP64 — «Work Orders». Маска имени таблицы: «MP64%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
MP64001 NCHAR STRING 10 0 10 WorkorderNo Work Order Number   1 Да
MP64002 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
MP64003 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
MP64004 NUMERIC X_NUMERIC 20 8 12 PlannedQty Quantity Planned      
MP64005 NUMERIC X_NUMERIC 20 8 12 ManufactQty Quantity Manufactured      
MP64006 NVARCHAR VSTRING 2 0 2 Alternate Alternate Routing      
MP64007 NVARCHAR VSTRING 1 0 1 SchedulCode Schedule Code 0 — Forward scheduling
1 — Backwards scheduling
2 — Locked scheduling
   
MP64008 NVARCHAR VSTRING 10 0 10 CustomerNo Customer Code      
MP64009 NCHAR STRING 10 0 10 SalesOrderNo Sales Order Number      
MP64010 NCHAR STRING 6 0 6 SalesOrdLine Sales Order Line Number      
MP64011 DATETIME DATE 0 0 8 ReqDelDate Date Requested      
MP64012 DATETIME DATE 0 0 8 PlnStartDate Planned Start Date      
MP64013 DATETIME DATE 0 0 8 PlanDueDate Planned Due Date      
MP64014 DATETIME DATE 0 0 8 DueDate Due Date      
MP64015 INT INTEGER 0 0 1 WorkorderType Work Order Type 0 — Normal work order
1 — Work order created for sales order
   
MP64016 DATETIME DATE 0 0 8 MatReservDate Material Reservation Date      
MP64017 NVARCHAR VSTRING 25 0 25 text1 Text Line 1      
MP64018 NVARCHAR VSTRING 25 0 25 text2 Text Line 2      
MP64019 NVARCHAR VSTRING 25 0 25 text3 Text Line 3      
MP64020 NVARCHAR VSTRING 1 0 1 OptionExist Option Exist      
MP64021 NVARCHAR VSTRING 1 0 1 ExtrDesExist Extra Description Exist      
MP64022 NVARCHAR VSTRING 1 0 1 OpenQtyExist Open Quantity Exist      
MP64023 NVARCHAR VSTRING 1 0 1 OpenTimeExist Open Time Exist      
MP64024 NVARCHAR VSTRING 15 0 15 Planner Planner      
MP64025 NVARCHAR VSTRING 15 0 15 SelectionTerm Selection Term      
MP64026 DATETIME DATE 0 0 8 RegistDate Date Entered      
MP64027 DATETIME DATE 0 0 8 OptionRegistered Option Entered      
MP64028 DATETIME DATE 0 0 8 ReleaseDate Release Date      
MP64029 DATETIME DATE 0 0 8 LastChngDate Last Date Changed      
MP64030 NVARCHAR VSTRING 15 0 15 ResponsChng Changed By      
MP64031 INT INTEGER 0 0 2 ChngVersion Change Version      
MP64032 DATETIME DATE 0 0 8 ScheduleDate Schedule Date      
MP64033 DATETIME DATE 0 0 8 StopDate Stop Date      
MP64034 INT INTEGER 0 0 1 Priority Priority      
MP64035 NVARCHAR VSTRING 15 0 15 ResponsPriority Priority Set By      
MP64036 NCHAR SWITCH 1 0 1 Staging Material Availability Test      
MP64037 DATETIME DATE 0 0 8 StagingDate Staging Date      
MP64038 DATETIME DATE 0 0 8 WOCloseDate Work Order Close Date      
MP64039 INT INTEGER 0 0 3 PlanLeadtime Planned Lead Time      
MP64040 INT INTEGER 0 0 3 Leadtime Lead Time      
MP64041 NCHAR STRING 10 0 10 CopiedFromWO Work Order Copied From      
MP64042 NVARCHAR VSTRING 1 0 1 RoutingExist Routing Exist      
MP64043 NUMERIC X_NUMERIC 20 8 12 Lot Lot      
MP64044 NVARCHAR VSTRING 35 0 35 AddressName Address Name      
MP64045 NVARCHAR VSTRING 35 0 35 Address1 Address Line 1      
MP64046 NVARCHAR VSTRING 35 0 35 Address2 Address Line 2      
MP64047 NVARCHAR VSTRING 35 0 35 Address3 Address Line 3      
MP64048 DATETIME DATE 0 0 8 PickListDate Date Picking List Printed      
MP64049 DATETIME DATE 0 0 8 MatReqDate Material Requisition Date      
MP64050 DATETIME DATE 0 0 8 TravelerDate Traveller Date      
MP64051 DATETIME DATE 0 0 8 LabelDate Label Date 1      
MP64052 DATETIME DATE 0 0 8 Label2Date Label Date 2      
MP64053 DATETIME DATE 0 0 8 TravVendDate Traveller Supplier Date      
MP64054 DATETIME DATE 0 0 8 RepVendDate Reporting Supplier Date      
MP64055 DATETIME DATE 0 0 8 JobTicketDate Job Ticket Date      
MP64056 DATETIME DATE 0 0 8 OperListDate Operation List Date      
MP64057 NCHAR SWITCH 1 0 1 ProductCost Production Cost      
MP64058 NCHAR SWITCH 1 0 1 ActualCost Create Actual Cost      
MP64059 NCHAR SWITCH 1 0 1 SummActCost Summarized Actual Cost      
MP64060 DATETIME DATE 0 0 8 ActCostDate Actual Cost Date      
MP64061 DATETIME DATE 0 0 8 MaterialIssued Material Issue Date      
MP64062 DATETIME DATE 0 0 8 AllMatIssued Date All Material Issued      
MP64063 NVARCHAR VSTRING 1 0 1 Only2Or3Comp Only 2 or 3 Components      
MP64064 DATETIME DATE 0 0 8 OperatStarted Operation Started      
MP64065 DATETIME DATE 0 0 8 OperatFinished Operation Finished      
MP64066 NCHAR SWITCH 1 0 1 AutoMakeOperation Automatically Create Operation List      
MP64067 INT INTEGER 0 0 6 MatShortage Material Shortage      
MP64068 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
MP64069 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP64070 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP64071 INT INTEGER 0 0 2 AccCode Accounting Code      
MP64072 INT INTEGER 0 0 2 NoPickList Picking List by Operation Copies      
MP64073 INT INTEGER 0 0 2 NoMatReq Picking List Copies      
MP64074 INT INTEGER 0 0 2 NoTraveler Traveller Document Copies      
MP64075 INT INTEGER 0 0 2 NoLabel Label Type 1 Copies      
MP64076 INT INTEGER 0 0 2 NoLabel2 Label Type 2 Copies      
MP64077 INT INTEGER 0 0 2 NoTravVendor Traveller Vendor Document Copies      
MP64078 INT INTEGER 0 0 2 NoRepVendor Report Work Order Receipt Copies      
MP64079 INT INTEGER 0 0 2 NoJobTicket Job Ticket Copies      
MP64080 INT INTEGER 0 0 2 NoOperatList Operation List Copies      
MP64081 DATETIME DATE 0 0 8 ActStartDate Actual Start Date      
MP64082 NVARCHAR VSTRING 35 0 35 Address4 Address Line 4      
MP64083 NVARCHAR VSTRING 10 0 10 ResponsStop Stopped By      
MP64084 NCHAR SWITCH 1 0 1 BoMExist BOM Exist      
MP64085 NUMERIC X_NUMERIC 20 8 12 OldQuantity Quantity Old      
MP64086 DATETIME DATE 0 0 8 OldDueDate Due Date Old      
MP64087 NUMERIC X_NUMERIC 20 8 12 TotalScrap Total Scrap Quantity      
MP64088 INT INTEGER 0 0 2 Status1 Status 1 0 — Work order entered
1 — Work order entered and in batch queue
2 — Bill of material and operation list created
3 — Work order released
7 — Work order provisionally closed. This work order cannot be closed.
8 — Closed
9 — Saved
   
MP64089 INT INTEGER 0 0 2 Status2 Status 2 0 — No batch in progress
1/2 — Batch in progress
   
MP64090 NCHAR STRING 6 0 6 SOStructLineNo Sales Order Sub-line Number      
MP64091 NUMERIC X_NUMERIC 20 8 12 NoUnitsLot Number of Units per Lot      
MP64092 NUMERIC X_NUMERIC 20 8 12 SizeOfLot Size of Lot      
MP64093 NUMERIC X_NUMERIC 20 8 12 RestQty Rest Quantity      
MP64094 NUMERIC X_NUMERIC 20 8 12 OldSizeOfLot Old Size of Lot      
MP64095 NVARCHAR VSTRING 1 0 1 ShopScheduled Shop Scheduled      
MP64096 NCHAR SWITCH 1 0 1 MakeWOMatList Create Work Order from Material List      
MP64097 NVARCHAR VSTRING 1 0 1 WONumberSerie Work Order Number Counter      
MP64098 NCHAR SWITCH 1 0 1 WIPAccounted WIP Accounted      
MP64099 INT INTEGER 0 0 4 ShortageNo Shortage Number      
MP64100 NCHAR STRING 10 0 10 VersionStock Version Stock Item      
MP64101 NCHAR STRING 10 0 10 VersionStructure Version BOM      
MP64102 NCHAR STRING 10 0 10 VersionOperation Version Operation      
MP64103 NVARCHAR VSTRING 20 0 20 DrawingNo Drawing Number      
MP64104 NCHAR STRING 4 0 4 DelLineNo Delivery Line Number      
MP64105 NVARCHAR VSTRING 1 0 1 ORCheck Check for Sales Order      
MP64106 NVARCHAR VSTRING 1 0 1 IncludedCriticalPath Included in Critical Path      
MP64107 NVARCHAR VSTRING 3 0 3 Spare (obsolete)      
MP64108 NVARCHAR VSTRING 3 0 3 Spare (obsolete)      
MP64109 NVARCHAR VSTRING 3 0 3 Spare (obsolete)      
MP64110 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
MP64111 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
MP64112 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
MP64113 NUMERIC MONEY 28 8 20 WIPAmount WIP Amount      
MP64114 NUMERIC MONEY 28 8 20 StandardCost Standard Cost      
MP64115 NVARCHAR VSTRING 12 0 12 ProjectNumber Project Number      
MP64116 NVARCHAR VSTRING 6 0 6 SubProjectNumber Sub-Project      
MP64117 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number      
MP64118 NVARCHAR VSTRING 6 0 6 ActivityStructLine Activity Sub-line Number      
MP64119 NCHAR STRING 10 0 10 WONumber Work Order Number      
MP64120 NCHAR STRING 10 0 10 ReportNo Report Number      
MP64121 NCHAR STRING 4 0 4 Number Number      
MP64122 NCHAR STRING 12 0 12 PlannedBatch Planned Batch      
MP64123 NCHAR STRING 10 0 10 RequestNo Customer Request Number      
MP64124 DATETIME DATE 0 0 8 ReminderDateFPO Reminder Date FPO      
MP64125 NUMERIC X_NUMERIC 20 8 12 StartDateTimeFactor Start Date Time Factor      
MP64126 NUMERIC X_NUMERIC 20 8 12 DueDateTimeFactor Due Date Time Factor      
MP64127 NVARCHAR VSTRING 35 0 35 Address5 Address Line 5      
MP64128 NVARCHAR VSTRING 35 0 35 Address6 Address Line 6      
MP64129 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      
MP64130 NVARCHAR VSTRING 35 0 35 Address7 Address Line 7      
MP64131 NVARCHAR VSTRING 10 0 10 RMAReference RMA Reference      
MP64132 NVARCHAR VSTRING 50 0 50 RMAComment RMA Comment      
MP64133 NVARCHAR VSTRING 10 0 10 RMAReferenceNo RMA Reference No.      

Навигация: