пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Material Production Control»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table MP50 — Work Centers

Таблица / Table: MP50 — «Work Centers». Маска имени таблицы / Table name mask: «MP50%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP50001 NCHAR STRING 8 0 8 WorkcentCode Work Centre   1 Да / Yes
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 120 0 120 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 CalendarColRefCalc Calendar Collection Calculated      
MP50092 INT INTEGER 0 0 9 CalendarColRefActual Calendar Collection Actual      
MP50093 DATETIME DATE 0 0 8 CalcDateNumHours 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      
MP50101 NCHAR STRING 1 0 1 PickingRequest Picking Request      
MP50102 INT INTEGER 0 0 9 GenericCalendarPM Generic Calendar PM      
MP50103 NCHAR STRING 10 0 10 InternalCustomer Internal Customer      
MP50104 NCHAR STRING 4 0 4 Site Site      
MP50105 NCHAR STRING 35 0 35 MasterAssetCode Master Asset Code      
MP50106 NCHAR STRING 10 0 10 AssetValueComponentNumber Asset Value Component Number      

Навигация / Navigation: