One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Материалами в Производстве»/List of tables of module «Material Production Control»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table MP63 — Routings

Таблица / Table: MP63 — «Routings». Маска имени таблицы / Table name mask: «MP63%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP63001 NCHAR STRING 1 0 1 OperationType Operation Type   1 Да / Yes
MP63002 NCHAR STRING 35 0 35 ParentItem Parent Stock Item   2 Да / Yes
MP63003 NCHAR STRING 2 0 2 Alternate Alternate Routing   3 Да / Yes
MP63004 NCHAR STRING 3 0 3 OperationNo Operation Number   4 Да / Yes
MP63005 INT INTEGER 0 0 1 OPType Work Centre Is Sub Contractor      
MP63006 NVARCHAR VSTRING 20 0 20 Description Description      
MP63007 NVARCHAR VSTRING 8 0 8 WorkCenter Work Centre      
MP63008 NVARCHAR VSTRING 15 0 15 ToolNumber Tool Number      
MP63009 NUMERIC X_NUMERIC 14 8 6 SetupTime1 Setup Time 1      
MP63010 NUMERIC X_NUMERIC 16 8 8 ProductRate1 Production Rate 1      
MP63011 NUMERIC X_NUMERIC 17 8 9 RunTime1 Run Time 1      
MP63012 NVARCHAR VSTRING 9 0 9 Spare (obsolete)      
MP63013 NCHAR STRING 3 0 3 CodeOpenRunTime Open Time Code      
MP63014 NVARCHAR VSTRING 3 0 3 Spare (obsolete)      
MP63015 NUMERIC X_NUMERIC 13 8 5 QueueTime Queue Time      
MP63016 NUMERIC X_NUMERIC 13 8 5 MoveTime Move Time      
MP63017 NUMERIC X_NUMERIC 15 8 7 Overlap Overlapping Time      
MP63018 NUMERIC MONEY 28 8 20 SubcontrCost Sub-contractor Cost      
MP63019 NVARCHAR VSTRING 3 0 3 CostCode Cost Code      
MP63020 NUMERIC X_NUMERIC 13 8 5 SetupCrew Setup Crew Number      
MP63021 NUMERIC X_NUMERIC 13 8 5 RunCrew Run Crew Number      
MP63022 INT INTEGER 0 0 2 NumberOfTime Job Tickets      
MP63023 NUMERIC X_NUMERIC 14 8 6 SetupTime2 Setup Time 2      
MP63024 NUMERIC X_NUMERIC 16 8 8 ProductRate2 Production Rate 2      
MP63025 NUMERIC X_NUMERIC 17 8 9 RunTime2 Run Time 2      
MP63026 INT INTEGER 0 0 1 TextCode Text Code Exist      
MP63027 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
MP63028 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP63029 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP63030 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP63031 INT INTEGER 0 0 2 AccCode Accounting Code      
MP63032 NUMERIC X_NUMERIC 12 8 4 NoResources Number of Resources      
MP63033 INT INTEGER 0 0 5 LeadTime Lead Time      
MP63034 NUMERIC X_NUMERIC 14 8 6 ScrapFactor Scrap %      
MP63035 NVARCHAR VSTRING 3 0 3 ProductiCode Production Code      
MP63036 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP63037 NVARCHAR VSTRING 35 0 35 ReturnItem Return Stock Item      
MP63038 NVARCHAR VSTRING 1 0 1 WeightType Weight Type      
MP63039 NVARCHAR VSTRING 1 0 1 RulePrinting Printing Rule      
MP63040 NUMERIC X_NUMERIC 18 8 10 Quantity Quantity      
MP63041 NVARCHAR VSTRING 1 0 1 OperType Type      
MP63042 NUMERIC X_NUMERIC 14 8 6 YieldFactor Yield Factor      
MP63043 NVARCHAR VSTRING 2 0 2 CompSetupTime Competence — Setup Time      
MP63044 NVARCHAR VSTRING 2 0 2 CompetRunTime Competence — Run Time      
MP63045 NUMERIC X_NUMERIC 14 8 6 SetupTimeInner Setup Time Inner      
MP63046 NCHAR SWITCH 1 0 1 Dispatching Dispatching      
MP63047 NUMERIC MONEY 28 8 20 StandardCost Standard Cost      
MP63048 NCHAR SWITCH 1 0 1 NotDependVolume Volume Independent      
MP63049 NVARCHAR VSTRING 1 0 1 CriticalOperation Is Critical Operation      
MP63050 NCHAR SWITCH 1 0 1 GRPMainOP GRP Main Operation      
MP63051 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
MP63052 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      

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