пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table MP78 — Actual Cost Operations

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP78001 NCHAR STRING 10 0 10 WorkOrderNo Work Order Number   1 Да / Yes
MP78002 NCHAR STRING 10 0 10 ReportNo Report Number   2 Да / Yes
MP78003 NCHAR STRING 3 0 3 OperationNo Operation Number   3 Да / Yes
MP78004 NCHAR STRING 8 0 8 Workcentre Work Centre   4 Да / Yes
MP78005 NCHAR STRING 15 0 15 ToolNo Tool Number   5 Да / Yes
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)      

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