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 :: Таблица MP78 — Actual Cost Operations

Таблица: MP78 — «Actual Cost Op.». Маска имени таблицы: «MP78%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
MP78001 NCHAR STRING 10 0 10 WorkOrderNo Work Order Number   1 Да
MP78002 NCHAR STRING 10 0 10 ReportNo Report Number   2 Да
MP78003 NCHAR STRING 3 0 3 OperationNo Operation Number   3 Да
MP78004 NCHAR STRING 8 0 8 Workcentre Work Centre   4 Да
MP78005 NCHAR STRING 15 0 15 ToolNo Tool Number   5 Да
MP78006 INT INTEGER 0 0 1 OpType Work Centre Is Sub Contractor      
MP78007 NVARCHAR VSTRING 20 0 20 Description Description      
MP78008 NUMERIC X_NUMERIC 14 8 6 SetupTime1 Setup Time 1      
MP78009 NUMERIC X_NUMERIC 28 8 20 RunTime1 Run Time 1      
MP78010 NUMERIC X_NUMERIC 13 8 5 MoveTime Move Time      
MP78011 NUMERIC MONEY 28 8 20 SubcontrCost Sub-contractor Cost      
MP78012 NVARCHAR VSTRING 3 0 3 CostCode Cost Code      
MP78013 NUMERIC X_NUMERIC 13 8 5 SetupCrew Setup Crew Number      
MP78014 NUMERIC X_NUMERIC 13 8 5 RunCrew Run Crew Number      
MP78015 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
MP78016 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP78017 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP78018 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP78019 INT INTEGER 0 0 2 AccCode Accounting Code      
MP78020 NUMERIC X_NUMERIC 14 8 6 IssuSetupTime Setup Time Issued      
MP78021 NUMERIC X_NUMERIC 28 8 20 IssuedRuntime Run Time Issued      
MP78022 NUMERIC X_NUMERIC 20 8 12 Scrap Scrap      
MP78023 NUMERIC X_NUMERIC 20 8 12 WorkorderQty Quantity Work Order      
MP78024 NUMERIC X_NUMERIC 20 8 12 ManQuantity Quantity Manufactured      
MP78025 NUMERIC X_NUMERIC 12 8 4 NoResources Number of Resources      
MP78026 NVARCHAR VSTRING 35 0 35 ParentItem Parent Stock Item      
MP78027 NCHAR SWITCH 1 0 1 ActCostItem Actual Cost Item      
MP78028 NUMERIC MONEY 28 8 20 PlanSetupCst Planned Setup Cost      
MP78029 NUMERIC MONEY 28 8 20 PlanRunCost Planned Run Cost      
MP78030 NUMERIC MONEY 28 8 20 PlanWCVarCst Planned Work Centre Variable Cost      
MP78031 NUMERIC MONEY 28 8 20 PlanWCFixCst Planned Work Centre Fixed Cost      
MP78032 NUMERIC MONEY 28 8 20 PlToolVarCst Planned Tool Variable Cost      
MP78033 NUMERIC MONEY 28 8 20 PlToolFixCst Planned Tool Fixed Cost      
MP78034 NUMERIC MONEY 28 8 20 SetupCost Setup Cost      
MP78035 NUMERIC MONEY 28 8 20 RunCost Actual Run Cost      
MP78036 NUMERIC MONEY 28 8 20 WcVariabCost Actual Work Centre Variable Cost      
MP78037 NUMERIC MONEY 28 8 20 WcFixedCost Actual Work Centre Fixed Cost      
MP78038 NUMERIC MONEY 28 8 20 ToolVariCost Actual Tool Variable Cost      
MP78039 NUMERIC MONEY 28 8 20 ToolFixeCost Actual Tool Fixed Cost      
MP78040 NUMERIC MONEY 28 8 20 ActCostSCont Actual Sub-contractor Cost      
MP78041 NUMERIC X_NUMERIC 14 8 6 StopTime Stop Time      
MP78042 NUMERIC X_NUMERIC 14 8 6 WCOverhead Work Centre Overhead      
MP78043 NUMERIC MONEY 28 8 20 StdCost1 Standard Cost 1      
MP78044 NUMERIC MONEY 28 8 20 StdCost2 Standard Cost 2      
MP78045 NUMERIC X_NUMERIC 14 8 6 SetupTimeInner Setup Time Inner      
MP78046 NCHAR SWITCH 1 0 1 NotDependVol Volume Independent      
MP78047 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
MP78048 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
MP78049 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      

Навигация: