Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: MP67 - «WO Routings» («Заказы на работу, Маршруты»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| MP67001 | STRING | 10 | WorkOrderNo | Да |
| MP67002 | STRING | 10 | RportingNo | Да |
| MP67003 | STRING | 3 | OperationNo | Да |
| MP67004 | INTEGER | 1 | OpType | |
| MP67005 | VSTRING | 20 | Description | |
| MP67006 | VSTRING | 8 | WorkCenter | |
| MP67007 | VSTRING | 15 | ToolNumber | |
| MP67008 | X_NUMERIC | 6 | SetupTime1 | |
| MP67009 | X_NUMERIC | 10 | ProductionRate1 | |
| MP67010 | X_NUMERIC | 20 | RunTime1 | |
| MP67011 | VSTRING | 9 | Spare | |
| MP67012 | STRING | 3 | CodeOpenRunTime | |
| MP67013 | VSTRING | 3 | Spare | |
| MP67014 | X_NUMERIC | 5 | QueueTime | |
| MP67015 | X_NUMERIC | 5 | MoveTime | |
| MP67016 | X_NUMERIC | 7 | Overlap | |
| MP67017 | MONEY | 20 | SubcontractCost | |
| MP67018 | VSTRING | 3 | CostCode | |
| MP67019 | X_NUMERIC | 5 | SetupCrew | |
| MP67020 | X_NUMERIC | 5 | RunCrew | |
| MP67021 | INTEGER | 2 | NumbersOfTime | |
| MP67022 | X_NUMERIC | 6 | SetupTime2 | |
| MP67023 | X_NUMERIC | 10 | ProductionRate2 | |
| MP67024 | X_NUMERIC | 20 | RunTime2 | |
| MP67025 | VSTRING | 1 | TextCode | |
| MP67026 | ACCSTR | 50 | AccountingString | |
| MP67027 | VSTRING | 6 | Spare | |
| MP67028 | VSTRING | 6 | Spare | |
| MP67029 | VSTRING | 6 | Spare | |
| MP67030 | INTEGER | 2 | AccountingCode | |
| MP67031 | INTEGER | 10 | LeadTime | |
| MP67032 | DATE | 8 | StartDate | |
| MP67033 | DATE | 8 | DueDate | |
| MP67034 | X_NUMERIC | 6 | IssuedSetupTime | |
| MP67035 | X_NUMERIC | 10 | IssuedRuntime | |
| MP67036 | INTEGER | 1 | OperationClosed | |
| MP67037 | X_NUMERIC | 12 | PreviousScrap | |
| MP67038 | X_NUMERIC | 12 | Scrap | |
| MP67039 | X_NUMERIC | 12 | WorkOrderQuantity | |
| MP67040 | X_NUMERIC | 12 | ManufacturedQuant | |
| MP67041 | INTEGER | 1 | Priority | |
| MP67042 | VSTRING | 2 | Calender | |
| MP67043 | INTEGER | 1 | Released | |
| MP67044 | INTEGER | 2 | Level | |
| MP67045 | X_NUMERIC | 4 | NOResources | |
| MP67046 | INTEGER | 1 | OpenTimeRegistered | |
| MP67047 | VSTRING | 35 | ParentItem | |
| MP67048 | X_NUMERIC | 6 | BreakTime | |
| MP67049 | VSTRING | 1 | RunPlanned | |
| MP67050 | VSTRING | 8 | ActualCostWC | |
| MP67051 | VSTRING | 3 | ActualCostCC | |
| MP67052 | X_NUMERIC | 5 | ActualCostSetup | |
| MP67053 | X_NUMERIC | 5 | ActualCostRunCrew | |
| MP67054 | VSTRING | 15 | ActualCostToolNo | |
| MP67055 | MONEY | 20 | ActualCostSubCost | |
| MP67056 | SWITCH | 1 | ActualCostItem | |
| MP67057 | DATE | 8 | ActualStartDate | |
| MP67058 | INTEGER | 2 | Status1 | |
| MP67059 | INTEGER | 2 | Status2 | |
| MP67060 | X_NUMERIC | 4 | ScrapFactor | |
| MP67061 | MONEY | 20 | PlannedSetupCost | |
| MP67062 | MONEY | 20 | PlannedRunCost | |
| MP67063 | MONEY | 20 | PlanWCVaraibleCost | |
| MP67064 | MONEY | 20 | PlanWCFixedCost | |
| MP67065 | MONEY | 20 | PlanToolVarCost | |
| MP67066 | MONEY | 20 | PlanToolFixCost | |
| MP67067 | MONEY | 20 | WIPAmount | |
| MP67068 | VSTRING | 10 | Person | |
| MP67069 | STRING | 10 | ReportingNumber2 | |
| MP67070 | VSTRING | 3 | ProductionCode | |
| MP67071 | VSTRING | 6 | Spare | |
| MP67072 | VSTRING | 35 | ReturnItem | |
| MP67073 | VSTRING | 1 | WeightType | |
| MP67074 | VSTRING | 1 | PrintingRules | |
| MP67075 | X_NUMERIC | 10 | Quantity | |
| MP67076 | INTEGER | 1 | StatusFlag | |
| MP67077 | MONEY | 20 | StandardCost1 | |
| MP67078 | MONEY | 20 | StandardCost2 | |
| MP67079 | X_NUMERIC | 12 | ScrapMP67 | |
| MP67080 | DATE | 8 | LatestReportDate | |
| MP67081 | DATE | 8 | DueDate | |
| MP67082 | INTEGER | 1 | OperationType | |
| MP67083 | X_NUMERIC | 6 | Yield | |
| MP67084 | INTEGER | 2 | CompSetupTime | |
| MP67085 | INTEGER | 2 | compRunningTime | |
| MP67086 | X_NUMERIC | 6 | SetupTimeInner | |
| MP67087 | SWITCH | 1 | ShowOperation | |
| MP67088 | SWITCH | 1 | DependVolume | |
| MP67089 | SWITCH | 1 | CriticalOperation | |
| MP67090 | VSTRING | 1 | Spare | |
| MP67091 | VSTRING | 1 | Spare | |
| MP67092 | VSTRING | 12 | Spare | |
| MP67093 | VSTRING | 10 | Spare | |
| MP67094 | VSTRING | 9 | Spare | |
| MP67095 | VSTRING | 4 | Spare |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | MPC (Управление Производством) | WO Routings (Заказы на работу, Маршруты)
/* */