Таблица: MP50 - «Work Centers». Маска имени таблицы: «MP50%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP50001 | NCHAR | STRING | 8 | 0 | 8 | WorkcentCode | Work Centre | 1 | Да | |
MP50002 | NVARCHAR | VSTRING | 30 | 0 | 30 | Description | Description | |||
MP50003 | NVARCHAR | VSTRING | 20 | 0 | 20 | OperationDescr | Description Operation | |||
MP50004 | NVARCHAR | VSTRING | 1 | 0 | 1 | TypeWorkCenter | Work Centre Type | 0 - Machine resource
1 - Personnel resource 2 - Sub-contractor |
||
MP50005 | NVARCHAR | VSTRING | 8 | 0 | 8 | Family | Family | |||
MP50006 | NVARCHAR | VSTRING | 6 | 0 | 6 | ForemanArea | Foreman Area | |||
MP50007 | NVARCHAR | VSTRING | 8 | 0 | 8 | Department | Department | |||
MP50008 | INT | INTEGER | 0 | 0 | 2 | DocumentCode | Document Layout | |||
MP50009 | NVARCHAR | VSTRING | 10 | 0 | 10 | Location | Location | |||
MP50010 | NUMERIC | X_NUMERIC | 12 | 8 | 4 | ResourcesNo | Number of Resources | |||
MP50011 | NUMERIC | X_NUMERIC | 12 | 8 | 4 | ResourceJob | Number of Resources per Job | |||
MP50012 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | Utilization | Utilization % | |||
MP50013 | NUMERIC | X_NUMERIC | 12 | 8 | 4 | NoShiftsDay | Number of Shifts per Day | |||
MP50014 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | NoHoursShft | Number of Hours per Shift | |||
MP50015 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | QueueTime | Queue Time | |||
MP50016 | NVARCHAR | VSTRING | 10 | 0 | 10 | Spare | (obsolete) | |||
MP50017 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | MoveTime | Move Time | |||
MP50018 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | SetupTime | Setup Time | |||
MP50019 | NVARCHAR | VSTRING | 3 | 0 | 3 | CstCodeLabor | Cost Code Labour | |||
MP50020 | NUMERIC | X_NUMERIC | 19 | 8 | 11 | FixCostHour | Fixed Machine Cost per Hour | |||
MP50021 | NUMERIC | X_NUMERIC | 19 | 8 | 11 | VarCostHour | Variable Machine Cost per Hour | |||
MP50022 | NVARCHAR | VSTRING | 5 | 0 | 5 | Spare | (obsolete) | |||
MP50023 | NVARCHAR | VSTRING | 5 | 0 | 5 | Spare | (obsolete) | |||
MP50024 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | SetupCrew | Persons in Setup Crew per Hour | |||
MP50025 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RunCrew | Persons in Run Crew per Hour | |||
MP50026 | NVARCHAR | VSTRING | 10 | 0 | 10 | Spare | (obsolete) | |||
MP50027 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
MP50028 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP50029 | NVARCHAR | VSTRING | 12 | 0 | 12 | Spare | (obsolete) | |||
MP50030 | NCHAR | SWITCH | 1 | 0 | 1 | LoadingYN | Loading | |||
MP50031 | NVARCHAR | VSTRING | 1 | 0 | 1 | ReportingCode | Reporting Code | 0 - Reporting of actual time used
1 - The time used is set to the product costing time |
||
MP50032 | NVARCHAR | VSTRING | 2 | 0 | 2 | MaterialCode | Material Code | |||
MP50033 | NVARCHAR | VSTRING | 2 | 0 | 2 | LoadCode | Loading Code | |||
MP50034 | NVARCHAR | VSTRING | 10 | 0 | 10 | Spare | (obsolete) | |||
MP50035 | INT | INTEGER | 0 | 0 | 3 | TimeInterval | Maintenance Time Interval | |||
MP50036 | NVARCHAR | VSTRING | 3 | 0 | 3 | MaintInstruct | Maintenance Instructions | |||
MP50037 | DATETIME | DATE | 0 | 0 | 8 | LatestMaintDt | Last Maintenance Date | |||
MP50038 | NVARCHAR | VSTRING | 20 | 0 | 20 | FreeText7 | User Defined Field 7 | |||
MP50039 | NVARCHAR | VSTRING | 20 | 0 | 20 | FreeText8 | User Defined Field 8 | |||
MP50040 | NVARCHAR | VSTRING | 20 | 0 | 20 | FreeText9 | User Defined Field 9 | |||
MP50041 | NVARCHAR | VSTRING | 20 | 0 | 20 | FreeText10 | User Defined Field 10 | |||
MP50042 | NVARCHAR | VSTRING | 10 | 0 | 10 | Spare | (obsolete) | |||
MP50043 | NVARCHAR | VSTRING | 20 | 0 | 20 | FreeText1 | User Defined Field 1 | |||
MP50044 | NVARCHAR | VSTRING | 20 | 0 | 20 | FreeText2 | User Defined Field 2 | |||
MP50045 | NVARCHAR | VSTRING | 20 | 0 | 20 | FreeText3 | User Defined Field 3 | |||
MP50046 | NVARCHAR | VSTRING | 20 | 0 | 20 | FreeText4 | User Defined Field 4 | |||
MP50047 | NVARCHAR | VSTRING | 20 | 0 | 20 | FreeText5 | User Defined Field 5 | |||
MP50048 | NVARCHAR | VSTRING | 20 | 0 | 20 | FreeText6 | User Defined Field 6 | |||
MP50049 | NVARCHAR | VSTRING | 60 | 0 | 60 | Description1 | Description Line 1 | |||
MP50050 | NVARCHAR | VSTRING | 60 | 0 | 60 | Description2 | Description Line 2 | |||
MP50051 | NVARCHAR | VSTRING | 60 | 0 | 60 | Description3 | Description Line 3 | |||
MP50052 | NVARCHAR | VSTRING | 60 | 0 | 60 | Description4 | Description Line 4 | |||
MP50053 | NCHAR | SWITCH | 1 | 0 | 1 | QtyReportYN | Only Quantity Reporting | |||
MP50054 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP50055 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP50056 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP50057 | INT | INTEGER | 0 | 0 | 2 | AccCode | Accounting Code | |||
MP50058 | NCHAR | SWITCH | 1 | 0 | 1 | StatisticsYN | Save Statistics | |||
MP50059 | NVARCHAR | VSTRING | 1 | 0 | 1 | DispTermCode | Dispatch Code | 0 - No dispatch order
1 - From stock code 2 - Stock code 3 - Tool number |
||
MP50060 | INT | INTEGER | 0 | 0 | 2 | WrkOrderDoc1 | Work Order Document 1 | Indicates the type of document that shall be printed for work orders
0 - No document selected 1 - Job ticket 2 - Picking list by operation 3 - Labels 4 - Pallet labels |
||
MP50061 | INT | INTEGER | 0 | 0 | 1 | WODoc1Print | Work Order Document 1 Print Option | Indicates when the selected document shall be printed:
1 - At start of reporting 2 - At partial reporting 3 - At - end of reporting |
||
MP50062 | INT | INTEGER | 0 | 0 | 1 | QtyPrintCod1 | Work Order Document 1 Quantity Option | Indicates how number of print-outs is controlled.
1 - According to quantity field 2 - Reported quantity 3 - Total reported quantity 4 - Planned quantity 5 - Remaining quantity |
||
MP50063 | INT | INTEGER | 0 | 0 | 2 | NoPrintfWOD1 | Work Order Document 1 Number of Print-outs | |||
MP50064 | INT | INTEGER | 0 | 0 | 2 | WrkOrderDoc2 | Work Order Document 2 | Indicates the type of document that shall be printed for work orders
0 - No document selected 1 - Job ticket 2 - Picking list by operation 3 - Labels 4 - Pallet labels |
||
MP50065 | INT | INTEGER | 0 | 0 | 1 | WODoc2Print | Work Order Document 2 Print Option | Indicates when the selected document shall be printed:
1 - At start of reporting 2 - At partial reporting 3 - At - end of reporting |
||
MP50066 | INT | INTEGER | 0 | 0 | 1 | QtyPrintCod2 | Work Order Document 2 Quantity Option | Indicates how number of print-outs is controlled.
1 - According to quantity field 2 - Reported quantity 3 - Total reported quantity 4 - Planned quantity 5 - Remaining quantity |
||
MP50067 | INT | INTEGER | 0 | 0 | 2 | NoPrintfWOD2 | Work Order Document 2 Number of Print-outs | |||
MP50068 | INT | INTEGER | 0 | 0 | 2 | WrkOrderDoc3 | Work Order Document 3 | Indicates the type of document that shall be printed for work orders
0 - No document selected 1 - Job ticket 2 - Picking list by operation 3 - Labels 4 - Pallet labels |
||
MP50069 | INT | INTEGER | 0 | 0 | 1 | WODoc3Print | Work Order Document 3 Print Option | Indicates when the selected document shall be printed:
1 - At start of reporting 2 - At partial reporting 3 - At - end of reporting |
||
MP50070 | INT | INTEGER | 0 | 0 | 1 | QtyPrintCod3 | Work Order Document 3 Quantity Option | Indicates how number of print-outs is controlled.
1 - According to quantity field 2 - Reported quantity 3 - Total reported quantity 4 - Planned quantity 5 - Remaining quantity |
||
MP50071 | INT | INTEGER | 0 | 0 | 2 | NoPrintfWOD3 | Work Order Document 3 Number of Print-outs | |||
MP50072 | INT | INTEGER | 0 | 0 | 2 | WrkOrderDoc4 | Work Order Document 4 | Indicates the type of document that shall be printed for work orders
0 - No document selected 1 - Job ticket 2 - Picking list by operation 3 - Labels 4 - Pallet labels |
||
MP50073 | INT | INTEGER | 0 | 0 | 1 | WODoc4Print | Work Order Document 4 Print Option | Indicates when the selected document shall be printed:
1 - At start of reporting 2 - At partial reporting 3 - At - end of reporting |
||
MP50074 | INT | INTEGER | 0 | 0 | 1 | QtyPrintCod4 | Work Order Document 4 Quantity Option | Indicates how number of print-outs is controlled.
1 - According to quantity field 2 - Reported quantity 3 - Total reported quantity 4 - Planned quantity 5 - Remaining quantity |
||
MP50075 | INT | INTEGER | 0 | 0 | 2 | NoPrintfWOD4 | Work Order Document 4 Number of Print-outs | |||
MP50076 | INT | INTEGER | 0 | 0 | 2 | WrkOrderDoc5 | Work Order Document 5 | Indicates the type of document that shall be printed for work orders
0 - No document selected 1 - Job ticket 2 - Picking list by operation 3 - Labels 4 - Pallet labels |
||
MP50077 | INT | INTEGER | 0 | 0 | 1 | WODoc5Print | Work Order Document 5 Print Option | Indicates when the selected document shall be printed:
1 - At start of reporting 2 - At partial reporting 3 - At - end of reporting |
||
MP50078 | INT | INTEGER | 0 | 0 | 1 | QtyPrintCod5 | Work Order Document 5 Quantity Option | Indicates how number of print-outs is controlled.
1 - According to quantity field 2 - Reported quantity 3 - Total reported quantity 4 - Planned quantity 5 - Remaining quantity |
||
MP50079 | INT | INTEGER | 0 | 0 | 2 | NoPrintfWOD5 | Work Order Document 5 Number of Print-outs | |||
MP50080 | NVARCHAR | VSTRING | 3 | 0 | 3 | ProductCode | Production Code | |||
MP50081 | NVARCHAR | VSTRING | 2 | 0 | 2 | CapacFactor | Capacity Factor | |||
MP50082 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Yield | Yield % | |||
MP50083 | NVARCHAR | VSTRING | 35 | 0 | 35 | ReturnItem | Return Stock Item | |||
MP50084 | NVARCHAR | VSTRING | 1 | 0 | 1 | WeightType | Weight Type | |||
MP50085 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TimeUsedPer | Time Used Period | |||
MP50086 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TimeUsedAccu | Time Used Accumulated | |||
MP50087 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HrsInBudget | Budgeted Number of Hours | |||
MP50088 | NVARCHAR | VSTRING | 1 | 0 | 1 | CriticalRes | Critical Resource | |||
MP50089 | NVARCHAR | VSTRING | 8 | 0 | 8 | Flowgroup | Flow Group | |||
MP50090 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
MP50091 | INT | INTEGER | 0 | 0 | 9 | Calendar_Collection_Reference_Calculated | Calendar Collection Calculated | |||
MP50092 | INT | INTEGER | 0 | 0 | 9 | Calendar_Collection_Reference_Actual | Calendar Collection Actual | |||
MP50093 | DATETIME | DATE | 0 | 0 | 8 | Calculation Date of Number of Hours | Calculation Date of Number of Hours | |||
MP50094 | NCHAR | STRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
MP50095 | NCHAR | STRING | 1 | 0 | 1 | FlagSendMaterial | Flag Send Material | |||
MP50096 | NCHAR | STRING | 1 | 0 | 1 | FlagCreatePOForLabour | Flag Create PO For Labour | |||
MP50097 | NCHAR | STRING | 1 | 0 | 1 | PONumberSerie | PO Number Serie | |||
MP50098 | NVARCHAR | VSTRING | 1 | 0 | 1 | PartialDeliveryPermitted | defines whether to report partial delivery for Subcontract Labour at this Work Centre or not | |||
MP50099 | NVARCHAR | VSTRING | 1 | 0 | 1 | OverDeliveryPermitted | defines whether to report over delivery for Subcontract Labour at this Work Centre or not | |||
MP50100 | NVARCHAR | VSTRING | 1 | 0 | 1 | QtyForPayment | defines the possibility to report actual quantity for payment Subcontract Labour at this Work Centre |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Material Production Control | Work Centers