Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица | Table: MP64 - «Work Orders». Маска имени таблицы | Table Name Mask: «MP64%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
MP64001 | NCHAR | STRING | 10 | 0 | 10 | WorkorderNo | Work Order Number | 1 | Да / Yes | |
MP64002 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
MP64003 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
MP64004 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PlannedQty | Quantity Planned | |||
MP64005 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ManufactQty | Quantity Manufactured | |||
MP64006 | NVARCHAR | VSTRING | 2 | 0 | 2 | Alternate | Alternate Routing | |||
MP64007 | NVARCHAR | VSTRING | 1 | 0 | 1 | SchedulCode | Schedule Code | 0 - Forward scheduling
1 - Backwards scheduling 2 - Locked scheduling |
||
MP64008 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerNo | Customer Code | |||
MP64009 | NCHAR | STRING | 10 | 0 | 10 | SalesOrderNo | Sales Order Number | |||
MP64010 | NCHAR | STRING | 6 | 0 | 6 | SalesOrdLine | Sales Order Line Number | |||
MP64011 | DATETIME | DATE | 0 | 0 | 8 | ReqDelDate | Date Requested | |||
MP64012 | DATETIME | DATE | 0 | 0 | 8 | PlnStartDate | Planned Start Date | |||
MP64013 | DATETIME | DATE | 0 | 0 | 8 | PlanDueDate | Planned Due Date | |||
MP64014 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | |||
MP64015 | INT | INTEGER | 0 | 0 | 1 | WorkorderType | Work Order Type | 0 - Normal work order
1 - Work order created for sales order |
||
MP64016 | DATETIME | DATE | 0 | 0 | 8 | MatReservDate | Material Reservation Date | |||
MP64017 | NVARCHAR | VSTRING | 25 | 0 | 25 | text1 | Text Line 1 | |||
MP64018 | NVARCHAR | VSTRING | 25 | 0 | 25 | text2 | Text Line 2 | |||
MP64019 | NVARCHAR | VSTRING | 25 | 0 | 25 | text3 | Text Line 3 | |||
MP64020 | NVARCHAR | VSTRING | 1 | 0 | 1 | OptionExist | Option Exist | |||
MP64021 | NVARCHAR | VSTRING | 1 | 0 | 1 | ExtrDesExist | Extra Description Exist | |||
MP64022 | NVARCHAR | VSTRING | 1 | 0 | 1 | OpenQtyExist | Open Quantity Exist | |||
MP64023 | NVARCHAR | VSTRING | 1 | 0 | 1 | OpenTimeExist | Open Time Exist | |||
MP64024 | NVARCHAR | VSTRING | 15 | 0 | 15 | Planner | Planner | |||
MP64025 | NVARCHAR | VSTRING | 15 | 0 | 15 | SelectionTerm | Selection Term | |||
MP64026 | DATETIME | DATE | 0 | 0 | 8 | RegistDate | Date Entered | |||
MP64027 | DATETIME | DATE | 0 | 0 | 8 | OptionRegistered | Option Entered | |||
MP64028 | DATETIME | DATE | 0 | 0 | 8 | ReleaseDate | Release Date | |||
MP64029 | DATETIME | DATE | 0 | 0 | 8 | LastChngDate | Last Date Changed | |||
MP64030 | NVARCHAR | VSTRING | 15 | 0 | 15 | ResponsChng | Changed By | |||
MP64031 | INT | INTEGER | 0 | 0 | 2 | ChngVersion | Change Version | |||
MP64032 | DATETIME | DATE | 0 | 0 | 8 | ScheduleDate | Schedule Date | |||
MP64033 | DATETIME | DATE | 0 | 0 | 8 | StopDate | Stop Date | |||
MP64034 | INT | INTEGER | 0 | 0 | 1 | Priority | Priority | |||
MP64035 | NVARCHAR | VSTRING | 15 | 0 | 15 | ResponsPriority | Priority Set By | |||
MP64036 | NCHAR | SWITCH | 1 | 0 | 1 | Staging | Material Availability Test | |||
MP64037 | DATETIME | DATE | 0 | 0 | 8 | StagingDate | Staging Date | |||
MP64038 | DATETIME | DATE | 0 | 0 | 8 | WOCloseDate | Work Order Close Date | |||
MP64039 | INT | INTEGER | 0 | 0 | 3 | PlanLeadtime | Planned Lead Time | |||
MP64040 | INT | INTEGER | 0 | 0 | 3 | Leadtime | Lead Time | |||
MP64041 | NCHAR | STRING | 10 | 0 | 10 | CopiedFromWO | Work Order Copied From | |||
MP64042 | NVARCHAR | VSTRING | 1 | 0 | 1 | RoutingExist | Routing Exist | |||
MP64043 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Lot | Lot | |||
MP64044 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddressName | Address Name | |||
MP64045 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address1 | Address Line 1 | |||
MP64046 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address2 | Address Line 2 | |||
MP64047 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address3 | Address Line 3 | |||
MP64048 | DATETIME | DATE | 0 | 0 | 8 | PickListDate | Date Picking List Printed | |||
MP64049 | DATETIME | DATE | 0 | 0 | 8 | MatReqDate | Material Requisition Date | |||
MP64050 | DATETIME | DATE | 0 | 0 | 8 | TravelerDate | Traveller Date | |||
MP64051 | DATETIME | DATE | 0 | 0 | 8 | LabelDate | Label Date 1 | |||
MP64052 | DATETIME | DATE | 0 | 0 | 8 | Label2Date | Label Date 2 | |||
MP64053 | DATETIME | DATE | 0 | 0 | 8 | TravVendDate | Traveller Supplier Date | |||
MP64054 | DATETIME | DATE | 0 | 0 | 8 | RepVendDate | Reporting Supplier Date | |||
MP64055 | DATETIME | DATE | 0 | 0 | 8 | JobTicketDate | Job Ticket Date | |||
MP64056 | DATETIME | DATE | 0 | 0 | 8 | OperListDate | Operation List Date | |||
MP64057 | NCHAR | SWITCH | 1 | 0 | 1 | ProductCost | Production Cost | |||
MP64058 | NCHAR | SWITCH | 1 | 0 | 1 | ActualCost | Create Actual Cost | |||
MP64059 | NCHAR | SWITCH | 1 | 0 | 1 | SummActCost | Summarized Actual Cost | |||
MP64060 | DATETIME | DATE | 0 | 0 | 8 | ActCostDate | Actual Cost Date | |||
MP64061 | DATETIME | DATE | 0 | 0 | 8 | MaterialIssued | Material Issue Date | |||
MP64062 | DATETIME | DATE | 0 | 0 | 8 | AllMatIssued | Date All Material Issued | |||
MP64063 | NVARCHAR | VSTRING | 1 | 0 | 1 | Only2Or3Comp | Only 2 or 3 Components | |||
MP64064 | DATETIME | DATE | 0 | 0 | 8 | OperatStarted | Operation Started | |||
MP64065 | DATETIME | DATE | 0 | 0 | 8 | OperatFinished | Operation Finished | |||
MP64066 | NCHAR | SWITCH | 1 | 0 | 1 | AutoMakeOperation | Automatically Create Operation List | |||
MP64067 | INT | INTEGER | 0 | 0 | 6 | MatShortage | Material Shortage | |||
MP64068 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
MP64069 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP64070 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP64071 | INT | INTEGER | 0 | 0 | 2 | AccCode | Accounting Code | |||
MP64072 | INT | INTEGER | 0 | 0 | 2 | NoPickList | Picking List by Operation Copies | |||
MP64073 | INT | INTEGER | 0 | 0 | 2 | NoMatReq | Picking List Copies | |||
MP64074 | INT | INTEGER | 0 | 0 | 2 | NoTraveler | Traveller Document Copies | |||
MP64075 | INT | INTEGER | 0 | 0 | 2 | NoLabel | Label Type 1 Copies | |||
MP64076 | INT | INTEGER | 0 | 0 | 2 | NoLabel2 | Label Type 2 Copies | |||
MP64077 | INT | INTEGER | 0 | 0 | 2 | NoTravVendor | Traveller Vendor Document Copies | |||
MP64078 | INT | INTEGER | 0 | 0 | 2 | NoRepVendor | Report Work Order Receipt Copies | |||
MP64079 | INT | INTEGER | 0 | 0 | 2 | NoJobTicket | Job Ticket Copies | |||
MP64080 | INT | INTEGER | 0 | 0 | 2 | NoOperatList | Operation List Copies | |||
MP64081 | DATETIME | DATE | 0 | 0 | 8 | ActStartDate | Actual Start Date | |||
MP64082 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address4 | Address Line 4 | |||
MP64083 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResponsStop | Stopped By | |||
MP64084 | NCHAR | SWITCH | 1 | 0 | 1 | BoMExist | BOM Exist | |||
MP64085 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | OldQuantity | Quantity Old | |||
MP64086 | DATETIME | DATE | 0 | 0 | 8 | OldDueDate | Due Date Old | |||
MP64087 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TotalScrap | Total Scrap Quantity | |||
MP64088 | INT | INTEGER | 0 | 0 | 2 | Status1 | Status 1 | 0 - Work order entered
1 - Work order entered and in batch queue 2 - Bill of material and operation list created 3 - Work order released 7 - Work order provisionally closed. This work order cannot be closed. 8 - Closed 9 - Saved |
||
MP64089 | INT | INTEGER | 0 | 0 | 2 | Status2 | Status 2 | 0 - No batch in progress
1/2 - Batch in progress |
||
MP64090 | NCHAR | STRING | 6 | 0 | 6 | SOStructLineNo | Sales Order Sub-line Number | |||
MP64091 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | NoUnitsLot | Number of Units per Lot | |||
MP64092 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | SizeOfLot | Size of Lot | |||
MP64093 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | RestQty | Rest Quantity | |||
MP64094 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | OldSizeOfLot | Old Size of Lot | |||
MP64095 | NVARCHAR | VSTRING | 1 | 0 | 1 | ShopScheduled | Shop Scheduled | |||
MP64096 | NCHAR | SWITCH | 1 | 0 | 1 | MakeWOMatList | Create Work Order from Material List | |||
MP64097 | NVARCHAR | VSTRING | 1 | 0 | 1 | WONumberSerie | Work Order Number Counter | |||
MP64098 | NCHAR | SWITCH | 1 | 0 | 1 | WIPAccounted | WIP Accounted | |||
MP64099 | INT | INTEGER | 0 | 0 | 4 | ShortageNo | Shortage Number | |||
MP64100 | NCHAR | STRING | 10 | 0 | 10 | VersionStock | Version Stock Item | |||
MP64101 | NCHAR | STRING | 10 | 0 | 10 | VersionStructure | Version BOM | |||
MP64102 | NCHAR | STRING | 10 | 0 | 10 | VersionOperation | Version Operation | |||
MP64103 | NVARCHAR | VSTRING | 20 | 0 | 20 | DrawingNo | Drawing Number | |||
MP64104 | NCHAR | STRING | 4 | 0 | 4 | DelLineNo | Delivery Line Number | |||
MP64105 | NVARCHAR | VSTRING | 1 | 0 | 1 | Test for sales order | Check for Sales Order | |||
MP64106 | NVARCHAR | VSTRING | 1 | 0 | 1 | Included in critical path | Included in Critical Path | |||
MP64107 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP64108 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP64109 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP64110 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | (obsolete) | |||
MP64111 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | (obsolete) | |||
MP64112 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | (obsolete) | |||
MP64113 | NUMERIC | MONEY | 28 | 8 | 20 | WIPAmount | WIP Amount | |||
MP64114 | NUMERIC | MONEY | 28 | 8 | 20 | StandardCost | Standard Cost | |||
MP64115 | NVARCHAR | VSTRING | 12 | 0 | 12 | ProjectNumber | Project Number | |||
MP64116 | NVARCHAR | VSTRING | 6 | 0 | 6 | SubProjectNumber | Sub-Project | |||
MP64117 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityLine | Activity Line Number | |||
MP64118 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityStructLine | Activity Sub-line Number | |||
MP64119 | NCHAR | STRING | 10 | 0 | 10 | WONumber | Work Order Number | |||
MP64120 | NCHAR | STRING | 10 | 0 | 10 | ReportNo | Report Number | |||
MP64121 | NCHAR | STRING | 4 | 0 | 4 | Number | Number | |||
MP64122 | NCHAR | STRING | 12 | 0 | 12 | PlannedBatch | Planned Batch | |||
MP64123 | NCHAR | STRING | 10 | 0 | 10 | RequestNo | Customer Request Number | |||
MP64124 | DATETIME | DATE | 0 | 0 | 8 | ReminderDateFPO | Reminder Date FPO | |||
MP64125 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | StartDateTimeFactor | Start Date Time Factor | |||
MP64126 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | DueDateTimeFactor | Due Date Time Factor | |||
MP64127 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address5 | Address Line 5 | |||
MP64128 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address6 | Address Line 6 | |||
MP64129 | NVARCHAR | VSTRING | 3 | 0 | 3 | CountryCode | Country Code | |||
MP64130 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address7 | Address Line 7 | |||
MP64131 | NVARCHAR | VSTRING | 10 | 0 | 10 | RMA Reference | RMA Reference | |||
MP64132 | NVARCHAR | VSTRING | 50 | 0 | 50 | RMA Comment | RMA Comment | |||
MP64133 | NVARCHAR | VSTRING | 10 | 0 | 10 | RMA Reference No. | RMA Reference No. |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Material Production Control | Work Orders