MPWorkItem

Table Name:

MPWorkItem

View Name:

Group:

Description:

The table is used basically for service task and other tasks. For each dimension using this table, special views have been created. See also the description of the field WorkItemType.

Dimension	ClassID/WorkItemType	View
Service Task	364	MARIWorkItem_ServiceTask
Internal Service Task	365	MARIWorkItem_InternalServiceTask
Result Task	456	MARIWorkItem_ResultTask
Service Plan	379	MARIWorkItem_ServicePlan
Service Plan Template	378	MARIWorkItem_ServicePlanTemplate
Qualification	493	MARIWorkItem_Qualification
Qualification Plan	494	MARIWorkItem_QualificationPlan
Qualification Task	495	MARIWorkItem_QualificationTask
Business Partner Audit Template	496	MARIWorkItem_BPAuditTemplate
Business Partner Audit Plan	497	MARIWorkItem_BPAuditPlan
Business Partner Audit	498	MARIWorkItem_BPAuditTask
Trainings Course/Event/Meeting	492	MARIWorkItem_TrainingCourse
Part List	401
Check List Limit	471
Production Task	522

ClassID:

364. See Overview of ClassIDs by table.

Field	View(engl.field)/Type	Description	Related
WorkItemID	WorkItemID INT Primary	Unique ID (via MPTAN)
WorkItemDocNum	WorkItemDocNum INT	Visible ID based on Number Series
WorkItemDocSeries	WorkItemDocSeries INT	ID of the number series
CompanyID	Company SMALLINT	Link to company (SBO Database)	MPSysConnections.CompanyID (WHERE ConnectionType=6)
WorkItemType	WorkItemType INT	ClassID: 364=ServiceTask 364=InternalServiceTask 378=PlanTemplate 379=Plan 401=PartsList and more..	clsImportWorkItemBase_eWorkItemType
WorkItemSubType	WorkItemSubType INT	Used for events
Matchcode	Matchcode NVARCHAR (200)	Name of the Service Task
SourceType	SourceType INT	Reference Type (ClassID)
SourceKey	SourceKey NVARCHAR (20) Index	Reference Key
PMTicketID	PMTicketID INT Index	Link to PM Support Ticket	MPHotlineAnfrage.AnfrageID
PMTicketHotlineClassType	PMTicketHotlineClassType INT		MPHotlineAnfrage.HotlineClassType
OSCLCallID	OSCLCallID INT Index	Link to SBO Service Call	OSCL.callID
OWORDocEntry	OWORDocEntry INT	Link to SBO Production Order	OWOR.DocEntry
CardCode	CardCode NVARCHAR (20)	Link to Customer	OCRD.CardCode
Priority	Priority INT	Internal Priority
RiskType	RiskType INT	not used
WorkItemStart	WorkItemStart Datetime	Start of task
WorkItemEnd	WorkItemEnd Datetime	End of Task
AppointmentRules	AppointmentRules INT	Approval Rules
AppointmentRulesD1	AppointmentRulesD1 Datetime	Approval Rules Dates
AppointmentRulesD2	AppointmentRulesD2 Datetime	Approval Rules Dates
AppointmentRulesV1	AppointmentRulesV1 NUMERIC(19,6)	Approval Rules Values
AppointmentRulesV2	AppointmentRulesV2 NUMERIC(19,6)	Approval Rules Values
AppointmentText	AppointmentText NTEXT	Memo for Hints
RessourceType	ResourceType INT	not used
ResponsibleEmployee	ResponsibleEmployee NVARCHAR (20)	Link to Employee	MPPersonenstamm.Personalnummer
ServicePlanTemplate	ServicePlanTemplate INT	Link to Template (For Plan)	MPWorkItem.WorkItemID (WHERE WorkItemType=378)
WorkItemStatus	WorkItemStatus INT	Status (depending on type)	MPHotlineSettings.ID (WHERE Setting IN (8,9,10))
WorkFlowID	WorkFlowID INT		MPHotlineWorkFlow.WorkFlowID
ProjectNumber	ProjectNumber NVARCHAR (20) Index	Link to Project (Plan, Task)	MPProjektstamm.Projektnummer
ContractID	ContractID INT Index	Link to Contract (Plan, Task)	MPVKVertraege.VertragsID
PhaseID	PhaseID INT Index	Link to Phase Plan, Task)	MPProjektPhasen.PhasenID
ContractPositionID	ContractPositionID INT Index	0=New positions as "at cost", Link to fixed price psoition	MPVKVertraegePositionen.Vertragsposition
StandardWarehouse	DefaultWarehouse NVARCHAR (20)	warehouse for new positions / vehicles warehouse	OWHS.WhsCode
SourceDocumentType	SourceDocumentType INT
SourceDocumentID	SourceDocumentID INT		MPVKVertraegeBelege.MPBelID
SalesOrderID	SalesOrderID INT Index	Sales order for MRP Status	MPVKVertraegeBelege.MPBelID
CurrencySys	CurrencySys NVARCHAR (3)	EUR/USD
CurrencyLoc	CurrencyLoc NVARCHAR (3)	EUR/USD
CurrencyFC	CurrencyFC NVARCHAR (3)	EUR/USD
CurrencyRateLoc	CurrencyRateLoc Float	Exchange rate
CurrencyRateFc	CurrencyRateFC Float	Exchange rate
CustomerLocationTreeElementID	CustomerLocationTreeElementID INT Index		MPCustomerLocationTreeElement.CustomerLocationTreeElementID
CustomerLocationContactPerson	CustomerLocationContactPerson INT		OCPR.CntctCode
CustomerLocationRemark	CustomerLocationRemark NVARCHAR (100)
A0AdressNr	A0AddressNr INT
A0Empfaenger	A0CardCode NVARCHAR (20)		OCRD.CardCode
A0Anrede	A0Salutation NVARCHAR (50)
A0Name1	A0Name1 NVARCHAR (100)
A0Name2	A0Name2 NVARCHAR (50)
A0Zusatz	A0Name3 NVARCHAR (50)
A0Einmalkunde	A0OneTimeCustomer SMALLINT
A0Matchcode	A0Matchcode NVARCHAR (100)
A0Strasse	A0Street NVARCHAR (100)
A0Hausnummer	A0StreetNumber NVARCHAR (100)
A0Land	A0Country NVARCHAR (3)
A0PLZ	A0ZIP NVARCHAR (20)
A0Ort	A0City NVARCHAR (100)
A0Bezirk	A0County NVARCHAR (100)
A0Bundesland	A0State NVARCHAR (3)
A0Gebaeude	A0Block NVARCHAR (100)
A0AnsprechpartnerID	A0ContactPerson INT		OCPR.CntctCode
A0AdressName	A0AddressName1 NVARCHAR (50)
A0AdressName2	A0AddressName2 NVARCHAR (50)
A0AdressName3	A0AddressName3 NVARCHAR (50)
A0GebaeudeStockwerk	A0Building NTEXT
A0AdressMemo	A0AddressMemo NTEXT
A0CardFName	A0CardFName NVARCHAR (100)
A0AddrType	A0AddrType NVARCHAR (100)
A0AdressLineNum	A0AddressLineNum INT
A0GlbLocNum	A0GlbLocNum NVARCHAR (50)
A0Longitude	A0Longitude Float
A0Latitude	A0Latitude Float
ContactPersonText	ContactPersonText NVARCHAR (100)
WorkDescription	WorkDescription NTEXT	Memo What to do
WorkNotes	WorkNotes NTEXT	Memo for notes on site
SignaturePic	SignaturePic INT	Link to picture table for the signature	MPBilder.BildID
GroupID	GroupID INT	Internal Groups
WorkItemIDPrevious	WorkItemIDPrevious INT	Link to other task. On Plans link to last closed days	MPWorkItem.WorkItemID
WorkItemIDNext	WorkItemIDNext INT	Link to other task. On Plans link to first open days	MPWorkItem.WorkItemID
ScheduleType	ScheduleType INT	Template+Plan: Method	clsImportWorkItemServicePlan_eScheduleType
SchedulePeriodic	SchedulePeriodic INT	Template+Plan: Year, Monthly..	clsImportWorkItemServicePlan_eCycleType
ScheduleStart	ScheduleStart Datetime	Template+Plan: start
ScheduleEnd	ScheduleEnd Datetime	Template+Plan: End
ScheduleContractEnd	ScheduleContractEnd Datetime	Template+Plan: End of recurring
ScheduleOffset	ScheduleOffset INT	Template+Plan: Value
QualityProcess	QualityProcess INT	Link to Quality Process	MPQualityProcess.QualityProcess
Reference1	Reference1 NVARCHAR (50)
Reference2	Reference2 NVARCHAR (50)
Reference3	Reference3 NVARCHAR (50)
HandlingOnMovementMode	HandlingOnMovementMode INT	Handling on returned Material from renting. Max Participants	clsImportWorkItemServicePlan_eHandlingOnMovementMode
NotificationSchedule	NotificationSchedule INT
MaxParticipants	MaxParticipants INT
MinParticipants	MinParticipants INT
RegistrationOptions	RegistrationOptions INT
RegisterProcess	RegisterProcess INT
VisibilityPortal	VisibilityPortal INT
InvoiceOptions	InvoiceOptions INT
Group1	Group1 INT	The GroupType (GruppenArt) depends on the WorkItemType	MPGruppen.GruppenID (WHERE GruppenArt=10054)
Group2	Group2 INT	The GroupType (GruppenArt) depends on the WorkItemType	MPGruppen.GruppenID (WHERE GruppenArt=10055)
Group3	Group3 INT	The GroupType (GruppenArt) depends on the WorkItemType	MPGruppen.GruppenID (WHERE GruppenArt=10056)
CreateDate	CreateDate Datetime	Create User
CreateUser	CreateUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ChangeDate	ChangeDate Datetime
ChangeUser	ChangeUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Memo	Memo NTEXT
MemoLevel	MemoLevel SMALLINT
InActive	InActive SMALLINT (0=false,-1=true)
HidePageFlag	HidePageFlag BIGINT
UpdateStamp	UpdateStamp INT
CreationDate	CreationDate Datetime

MARIProject Database Structure