Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: 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) |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Material Production Control | Actual Cost Operations