Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: MP50 - «Work Centers» («Центры Работ»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| MP50001 | STRING | 8 | WorkcentCode | Да |
| MP50002 | VSTRING | 30 | Description | |
| MP50003 | VSTRING | 20 | OperationDescr | |
| MP50004 | VSTRING | 1 | TypeWorkCenter | |
| MP50005 | VSTRING | 8 | Family | |
| MP50006 | VSTRING | 6 | ForemanArea | |
| MP50007 | VSTRING | 8 | Department | |
| MP50008 | INTEGER | 2 | DocumentCode | |
| MP50009 | VSTRING | 10 | Location | |
| MP50010 | INTEGER | 2 | ResourcesNo | |
| MP50011 | INTEGER | 2 | ResourceJob | |
| MP50012 | X_NUMERIC | 5 | Utilization | |
| MP50013 | X_NUMERIC | 4 | NoShiftsDay | |
| MP50014 | X_NUMERIC | 4 | NoHoursShft | |
| MP50015 | X_NUMERIC | 5 | QueueTime | |
| MP50016 | VSTRING | 10 | Spare | |
| MP50017 | X_NUMERIC | 5 | MoveTime | |
| MP50018 | X_NUMERIC | 5 | SetupTime | |
| MP50019 | VSTRING | 3 | CstCodeLabor | |
| MP50020 | X_NUMERIC | 11 | FixCostHour | |
| MP50021 | X_NUMERIC | 11 | VarCostHour | |
| MP50022 | VSTRING | 5 | Spare | |
| MP50023 | VSTRING | 5 | Spare | |
| MP50024 | X_NUMERIC | 5 | SetupCrew | |
| MP50025 | X_NUMERIC | 5 | RunCrew | |
| MP50026 | VSTRING | 10 | Spare | |
| MP50027 | ACCSTR | 50 | AccString | |
| MP50028 | VSTRING | 6 | Spare | |
| MP50029 | VSTRING | 12 | Spare | |
| MP50030 | SWITCH | 1 | LoadingYN | |
| MP50031 | VSTRING | 1 | ReportingCode | |
| MP50032 | VSTRING | 2 | MaterialCode | |
| MP50033 | VSTRING | 2 | LoadCode | |
| MP50034 | VSTRING | 10 | Spare | |
| MP50035 | INTEGER | 3 | TimeInterval | |
| MP50036 | VSTRING | 3 | MaintInstruct | |
| MP50037 | DATE | 8 | LatestMaintDt | |
| MP50038 | VSTRING | 20 | FreeText7 | |
| MP50039 | VSTRING | 20 | FreeText8 | |
| MP50040 | VSTRING | 20 | FreeText9 | |
| MP50041 | VSTRING | 20 | FreeText10 | |
| MP50042 | VSTRING | 10 | Spare | |
| MP50043 | VSTRING | 20 | FreeText1 | |
| MP50044 | VSTRING | 20 | FreeText2 | |
| MP50045 | VSTRING | 20 | FreeText3 | |
| MP50046 | VSTRING | 20 | FreeText4 | |
| MP50047 | VSTRING | 20 | FreeText5 | |
| MP50048 | VSTRING | 20 | FreeText6 | |
| MP50049 | VSTRING | 60 | Description1 | |
| MP50050 | VSTRING | 60 | Description2 | |
| MP50051 | VSTRING | 60 | Description3 | |
| MP50052 | VSTRING | 60 | Description4 | |
| MP50053 | SWITCH | 1 | QtyReportYN | |
| MP50054 | VSTRING | 3 | Spare | |
| MP50055 | VSTRING | 6 | Spare | |
| MP50056 | VSTRING | 6 | Spare | |
| MP50057 | INTEGER | 2 | AccCode | |
| MP50058 | SWITCH | 1 | StatisticsYN | |
| MP50059 | VSTRING | 1 | DispTermCode | |
| MP50060 | INTEGER | 2 | WrkOrderDoc1 | |
| MP50061 | INTEGER | 1 | WODoc1Print | |
| MP50062 | INTEGER | 1 | QtyPrintCod1 | |
| MP50063 | INTEGER | 2 | NoPrintfWOD1 | |
| MP50064 | INTEGER | 2 | WrkOrderDoc2 | |
| MP50065 | INTEGER | 1 | WODoc2Print | |
| MP50066 | INTEGER | 1 | QtyPrintCod2 | |
| MP50067 | INTEGER | 2 | NoPrintfWOD2 | |
| MP50068 | INTEGER | 2 | WrkOrderDoc3 | |
| MP50069 | INTEGER | 1 | WODoc3Print | |
| MP50070 | INTEGER | 1 | QtyPrintCod3 | |
| MP50071 | INTEGER | 2 | NoPrintfWOD3 | |
| MP50072 | INTEGER | 2 | WrkOrderDoc4 | |
| MP50073 | INTEGER | 1 | WODoc4Print | |
| MP50074 | INTEGER | 1 | QtyPrintCod4 | |
| MP50075 | INTEGER | 2 | NoPrintfWOD4 | |
| MP50076 | INTEGER | 2 | WrkOrderDoc5 | |
| MP50077 | INTEGER | 1 | WODoc5Print | |
| MP50078 | INTEGER | 1 | QtyPrintCod5 | |
| MP50079 | INTEGER | 2 | NoPrintfWOD5 | |
| MP50080 | VSTRING | 3 | ProductCode | |
| MP50081 | VSTRING | 2 | CapacFactor | |
| MP50082 | X_NUMERIC | 6 | Yield | |
| MP50083 | VSTRING | 35 | ReturnItem | |
| MP50084 | VSTRING | 1 | WeightType | |
| MP50085 | X_NUMERIC | 12 | TimeUsedPer | |
| MP50086 | X_NUMERIC | 12 | TimeUsedAccu | |
| MP50087 | X_NUMERIC | 12 | HrsInBudget | |
| MP50088 | VSTRING | 1 | CriticalRes | |
| MP50089 | VSTRING | 8 | Flowgroup | |
| MP50090 | VSTRING | 6 | Warehouse |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | MPC (Управление Производством) | Work Centers (Центры Работ)
/* */