Таблица: 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 - 2.03.3363 | Material Production Control | Work Centers