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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table MP67 — Work Order Routings

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP67001 NCHAR STRING 10 0 10 WorkOrderNo Work Order Number   1 Да / Yes
MP67002 NCHAR STRING 10 0 10 RportingNo Report Number   2 Да / Yes
MP67003 NCHAR STRING 3 0 3 OperationNo Operation Number   3 Да / Yes
MP67004 INT INTEGER 0 0 1 OpType Work Centre Is Sub Contractor      
MP67005 NVARCHAR VSTRING 20 0 20 Description Description      
MP67006 NVARCHAR VSTRING 8 0 8 WorkCenter Work Centre      
MP67007 NVARCHAR VSTRING 15 0 15 ToolNumber Tool Number      
MP67008 NUMERIC X_NUMERIC 14 8 6 SetupTime1 Setup Time 1      
MP67009 NUMERIC X_NUMERIC 18 8 10 ProductionRate1 Production Rate 1      
MP67010 NUMERIC X_NUMERIC 28 8 20 RunTime1 Run Time 1      
MP67011 NVARCHAR VSTRING 9 0 9 Spare (obsolete)      
MP67012 NCHAR STRING 3 0 3 CodeOpenRunTime Open Time Code      
MP67013 NVARCHAR VSTRING 3 0 3 Spare (obsolete)      
MP67014 NUMERIC X_NUMERIC 13 8 5 QueueTime Queue Time      
MP67015 NUMERIC X_NUMERIC 13 8 5 MoveTime Move Time      
MP67016 NUMERIC X_NUMERIC 15 8 7 Overlap Overlapping Time      
MP67017 NUMERIC MONEY 28 8 20 SubcontractCost Sub-contractor Cost      
MP67018 NVARCHAR VSTRING 3 0 3 CostCode Cost Code      
MP67019 NUMERIC X_NUMERIC 13 8 5 SetupCrew Setup Crew Number      
MP67020 NUMERIC X_NUMERIC 13 8 5 RunCrew Run Crew Number      
MP67021 INT INTEGER 0 0 2 NumbersOfTime Job Tickets      
MP67022 NUMERIC X_NUMERIC 14 8 6 SetupTime2 Setup Time 2      
MP67023 NUMERIC X_NUMERIC 18 8 10 ProductionRate2 Production Rate 2      
MP67024 NUMERIC X_NUMERIC 28 8 20 RunTime2 Run Time 2      
MP67025 NVARCHAR VSTRING 1 0 1 TextCode Text Code Exist      
MP67026 NVARCHAR ACCSTR 120 0 120 AccountingString Accounting String      
MP67027 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP67028 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP67029 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP67030 INT INTEGER 0 0 2 AccountingCode Accounting Code      
MP67031 INT INTEGER 0 0 10 LeadTime Lead Time      
MP67032 DATETIME DATE 0 0 8 StartDate Start Date      
MP67033 DATETIME DATE 0 0 8 DueDate Due Date      
MP67034 NUMERIC X_NUMERIC 14 8 6 IssuedSetupTime Issued Setup Time      
MP67035 NUMERIC X_NUMERIC 28 8 20 IssuedRuntime Issued Run Time      
MP67036 INT INTEGER 0 0 1 OperationClosed Operation Closed      
MP67037 NUMERIC X_NUMERIC 20 8 12 PreviousScrap Previous Scrap      
MP67038 NUMERIC X_NUMERIC 20 8 12 Scrap Scrap      
MP67039 NUMERIC X_NUMERIC 20 8 12 WorkOrderQuantity Quantity Work Order      
MP67040 NUMERIC X_NUMERIC 20 8 12 ManufacturedQuant Quantity Manufactured      
MP67041 INT INTEGER 0 0 1 Priority Priority      
MP67042 NVARCHAR VSTRING 2 0 2 Calender Calendar      
MP67043 INT INTEGER 0 0 1 Released Released      
MP67044 INT INTEGER 0 0 2 Level Level      
MP67045 NUMERIC X_NUMERIC 12 8 4 NOResources Number of Resources      
MP67046 INT INTEGER 0 0 1 OpenTimeRegistered Open Time Entered      
MP67047 NVARCHAR VSTRING 35 0 35 ParentItem Parent Stock Item      
MP67048 NUMERIC X_NUMERIC 14 8 6 BreakTime Break Time      
MP67049 NVARCHAR VSTRING 1 0 1 RunPlanned Run Planned      
MP67050 NVARCHAR VSTRING 8 0 8 ActualCostWC Actual Cost Work Centre      
MP67051 NVARCHAR VSTRING 3 0 3 ActualCostCC Actual Cost Cost Code      
MP67052 NUMERIC X_NUMERIC 13 8 5 ActualCostSetup Actual Cost Setup Crew      
MP67053 NUMERIC X_NUMERIC 13 8 5 ActualCostRunCrew Actual Cost Run Crew      
MP67054 NVARCHAR VSTRING 15 0 15 ActualCostToolNo Actual Cost Tool Number      
MP67055 NUMERIC MONEY 28 8 20 ActualCostSubCost Actual Cost Sub-contract Cost      
MP67056 NCHAR SWITCH 1 0 1 ActualCostItem Actual Cost Item      
MP67057 DATETIME DATE 0 0 8 ActualStartDate Actual Start Date      
MP67058 INT INTEGER 0 0 2 Status1 Status 1 0 — Created

1 — Scheduled

2 — Dispatched

3 — Started

4 — Stopped

5 — Finished		    
MP67059 INT INTEGER 0 0 2 Status2 Status 2 0 — Production statistics has not been update

1 — Production statistics updated		    
MP67060 NUMERIC X_NUMERIC 14 8 6 ScrapFactor Scrap %      
MP67061 NUMERIC MONEY 28 8 20 PlannedSetupCost Planned Setup Cost      
MP67062 NUMERIC MONEY 28 8 20 PlannedRunCost Planned Run Cost      
MP67063 NUMERIC MONEY 28 8 20 PlanWCVaraibleCost Planned Work Centre Variable Cost      
MP67064 NUMERIC MONEY 28 8 20 PlanWCFixedCost Planned Work Centre Fixed Cost      
MP67065 NUMERIC MONEY 28 8 20 PlanToolVarCost Planned Tool Variable Cost      
MP67066 NUMERIC MONEY 28 8 20 PlanToolFixCost Planned Tool Fixed Cost      
MP67067 NUMERIC MONEY 28 8 20 WIPAmount WIP Amount      
MP67068 NVARCHAR VSTRING 10 0 10 Person Person      
MP67069 NCHAR STRING 10 0 10 ReportingNumber2 Report Number Reversed Used internally as a reversed index    
MP67070 NVARCHAR VSTRING 3 0 3 ProductionCode Production Code      
MP67071 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP67072 NVARCHAR VSTRING 35 0 35 ReturnItem Return Stock Item      
MP67073 NVARCHAR VSTRING 1 0 1 WeightType Weight Type      
MP67074 NVARCHAR VSTRING 1 0 1 PrintingRules Printing Rules      
MP67075 NUMERIC X_NUMERIC 18 8 10 Quantity Quantity      
MP67076 INT INTEGER 0 0 1 StatusFlag Status Flag      
MP67077 NUMERIC MONEY 28 8 20 StandardCost1 Standard Cost 1      
MP67078 NUMERIC MONEY 28 8 20 StandardCost2 Standard Cost 2      
MP67079 NUMERIC X_NUMERIC 20 8 12 ScrapMP67 Scrap      
MP67080 DATETIME DATE 0 0 8 LatestReportDate Last Report Date      
MP67081 DATETIME DATE 0 0 8 ActDueDate Due Date      
MP67082 INT INTEGER 0 0 1 OperationType Operation Type      
MP67083 NUMERIC X_NUMERIC 14 8 6 Yield Yield %      
MP67084 INT INTEGER 0 0 2 CompSetupTime Competence — Setup Time      
MP67085 INT INTEGER 0 0 2 compRunningTime Competence — Run Time      
MP67086 NUMERIC X_NUMERIC 14 8 6 OrigSetupTime Original setup time      
MP67087 NCHAR SWITCH 1 0 1 ShowOperation Show Operation      
MP67088 NCHAR SWITCH 1 0 1 DependVolume Depend Volume      
MP67089 NCHAR SWITCH 1 0 1 CriticalOperation Critical Operation      
MP67090 NCHAR SWITCH 1 0 1 GRPMainOP GRP Main Operation      
MP67091 NCHAR STRING 1 0 1 OpEvenLoaded Operation Even Loaded      
MP67092 NUMERIC X_NUMERIC 20 8 12 StartDateCapacity Start Date Capacity      
MP67093 NUMERIC X_NUMERIC 20 8 12 DueDateCapacity Due Date Capacity      
MP67094 NVARCHAR VSTRING 9 0 9 Spare (obsolete)      
MP67095 NVARCHAR VSTRING 4 0 4 SetupChanged Setup changed      
MP67096 NUMERIC X_NUMERIC 20 8 12 StartDateTimeFactor Start Date Time Factor      
MP67097 NUMERIC X_NUMERIC 20 8 12 DueDateTimeFactor Due Date Time Factor      
MP67098 NUMERIC X_NUMERIC 28 8 20 AccessoryRunTime Accessory Run Time      

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