Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: MP64 - «Work Orders» («Заказы на работу»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| MP64001 | STRING | 10 | WorkorderNo | Да |
| MP64002 | VSTRING | 35 | StockCode | |
| MP64003 | VSTRING | 6 | Warehouse | |
| MP64004 | X_NUMERIC | 12 | PlannedQty | |
| MP64005 | X_NUMERIC | 12 | ManufactQty | |
| MP64006 | VSTRING | 2 | Alternate | |
| MP64007 | VSTRING | 1 | SchedulCode | |
| MP64008 | VSTRING | 10 | CustomerNo | |
| MP64009 | STRING | 10 | SalesOrderNo | |
| MP64010 | STRING | 6 | SalesOrdLine | |
| MP64011 | DATE | 8 | ReqDelDate | |
| MP64012 | DATE | 8 | PlnStartDate | |
| MP64013 | DATE | 8 | PlanDueDate | |
| MP64014 | DATE | 8 | DueDate | |
| MP64015 | INTEGER | 1 | WorkorderType | |
| MP64016 | DATE | 8 | MatReservDate | |
| MP64017 | VSTRING | 25 | text1 | |
| MP64018 | VSTRING | 25 | text2 | |
| MP64019 | VSTRING | 25 | text3 | |
| MP64020 | VSTRING | 1 | OptionExist | |
| MP64021 | VSTRING | 1 | ExtrDesExist | |
| MP64022 | VSTRING | 1 | OpenQtyExist | |
| MP64023 | VSTRING | 1 | OpenTimeExist | |
| MP64024 | VSTRING | 15 | Planner | |
| MP64025 | VSTRING | 15 | SelectionTerm | |
| MP64026 | DATE | 8 | RegistDate | |
| MP64027 | DATE | 8 | OptionRegistered | |
| MP64028 | DATE | 8 | ReleaseDate | |
| MP64029 | DATE | 8 | LastChngDate | |
| MP64030 | VSTRING | 15 | ResponsChng | |
| MP64031 | INTEGER | 2 | ChngVersion | |
| MP64032 | DATE | 8 | ScheduleDate | |
| MP64033 | DATE | 8 | StopDate | |
| MP64034 | INTEGER | 1 | Priority | |
| MP64035 | VSTRING | 15 | ResponsPriority | |
| MP64036 | SWITCH | 1 | Staging | |
| MP64037 | DATE | 8 | StagingDate | |
| MP64038 | DATE | 8 | WOCloseDate | |
| MP64039 | INTEGER | 3 | PlanLeadtime | |
| MP64040 | INTEGER | 3 | Leadtime | |
| MP64041 | STRING | 10 | CopiedFromWO | |
| MP64042 | VSTRING | 1 | RoutingExist | |
| MP64043 | X_NUMERIC | 12 | Lot | |
| MP64044 | VSTRING | 25 | Adress1 | |
| MP64045 | VSTRING | 25 | Adress2 | |
| MP64046 | VSTRING | 25 | Adress3 | |
| MP64047 | VSTRING | 25 | Adress4 | |
| MP64048 | DATE | 8 | PickListDate | |
| MP64049 | DATE | 8 | MatReqDate | |
| MP64050 | DATE | 8 | TravelerDate | |
| MP64051 | DATE | 8 | LabelDate | |
| MP64052 | DATE | 8 | Label2Date | |
| MP64053 | DATE | 8 | TravVendDate | |
| MP64054 | DATE | 8 | RepVendDate | |
| MP64055 | DATE | 8 | JobTicketDate | |
| MP64056 | DATE | 8 | OperListDate | |
| MP64057 | SWITCH | 1 | ProductCost | |
| MP64058 | SWITCH | 1 | ActualCost | |
| MP64059 | SWITCH | 1 | SummActCost | |
| MP64060 | DATE | 8 | ActCostDate | |
| MP64061 | DATE | 8 | MaterialIssued | |
| MP64062 | DATE | 8 | AllMatIssued | |
| MP64063 | VSTRING | 1 | Only2Or3Comp | |
| MP64064 | DATE | 8 | OperatStarted | |
| MP64065 | DATE | 8 | OperatFinished | |
| MP64066 | SWITCH | 1 | AutoMakeOperation | |
| MP64067 | INTEGER | 6 | MatShortage | |
| MP64068 | ACCSTR | 50 | AccString | |
| MP64069 | VSTRING | 6 | Spare | |
| MP64070 | VSTRING | 6 | Spare | |
| MP64071 | INTEGER | 2 | AccCode | |
| MP64072 | INTEGER | 2 | NoPickList | |
| MP64073 | INTEGER | 2 | NoMatReq | |
| MP64074 | INTEGER | 2 | NoTraveler | |
| MP64075 | INTEGER | 2 | NoLabel | |
| MP64076 | INTEGER | 2 | NoLabel2 | |
| MP64077 | INTEGER | 2 | NoTravVendor | |
| MP64078 | INTEGER | 2 | NoRepVendor | |
| MP64079 | INTEGER | 2 | NoJobTicket | |
| MP64080 | INTEGER | 2 | NoOperatList | |
| MP64081 | DATE | 8 | ActStartDate | |
| MP64082 | VSTRING | 25 | Adress5 | |
| MP64083 | VSTRING | 10 | ResponsStop | |
| MP64084 | SWITCH | 1 | BoMExist | |
| MP64085 | X_NUMERIC | 12 | OldQuantity | |
| MP64086 | DATE | 8 | OldDueDate | |
| MP64087 | X_NUMERIC | 12 | TotalScrap | |
| MP64088 | INTEGER | 2 | Status1 | |
| MP64089 | INTEGER | 2 | Status2 | |
| MP64090 | STRING | 3 | SOStructLineNo | |
| MP64091 | X_NUMERIC | 12 | NoUnitsLot | |
| MP64092 | X_NUMERIC | 12 | SizeOfLot | |
| MP64093 | X_NUMERIC | 12 | RestQty | |
| MP64094 | X_NUMERIC | 12 | OldSizeOfLot | |
| MP64095 | VSTRING | 1 | ShopScheduled | |
| MP64096 | SWITCH | 1 | MakeWOMatList | |
| MP64097 | VSTRING | 1 | WONumberSerie | |
| MP64098 | SWITCH | 1 | WIPAccounted | |
| MP64099 | INTEGER | 4 | ShortageNo | |
| MP64100 | STRING | 10 | VersionStock | |
| MP64101 | STRING | 10 | VersionStructure | |
| MP64102 | STRING | 10 | VersionOperation | |
| MP64103 | VSTRING | 20 | DrawingNo | |
| MP64104 | STRING | 4 | DelLineNo | |
| MP64105 | VSTRING | 3 | Spare | |
| MP64106 | VSTRING | 3 | Spare | |
| MP64107 | VSTRING | 3 | Spare | |
| MP64108 | VSTRING | 3 | Spare | |
| MP64109 | VSTRING | 3 | Spare | |
| MP64110 | VSTRING | 20 | Spare | |
| MP64111 | VSTRING | 20 | Spare | |
| MP64112 | VSTRING | 20 | Spare | |
| MP64113 | MONEY | 20 | WIPAmount | |
| MP64114 | MONEY | 20 | StandardCost | |
| MP64115 | VSTRING | 12 | ProjectNumber | |
| MP64116 | VSTRING | 6 | SubProjectNumber | |
| MP64117 | VSTRING | 6 | ActivityLine | |
| MP64118 | VSTRING | 3 | ActivityStructLine | |
| MP64119 | STRING | 10 | WONumber | |
| MP64120 | STRING | 10 | ReportNo | |
| MP64121 | STRING | 4 | Number | |
| MP64122 | STRING | 12 | PlannedBatch |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | MPC (Управление Производством) | Work Orders (Заказы на работу)
/* */