Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table MP50 — Work Centers — О системах планирования ресурсов предприятия Scala, iScala

Таблица / 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:

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список системных таблиц / System Tables
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Asset Management»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Contract Management»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Direct Invoicing»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «General Ledger»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Resourse Management»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Market Database»
Структура таблиц / 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 :: Список таблиц модуля /List of tables of module «Sales Order»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Payroll»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Purchase Order»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Purchase Ledger»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Promissory Notes»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Project Management»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Stock Control»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Sales Ledger»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Service Order Management»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Statistics»
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «System Utilities/Office Autom.»