| View Name: | MARIWorkItem | ||||||||||||||||||||||||||||||||||||||||||||||||
| Based on table: | MPWorkItem | ||||||||||||||||||||||||||||||||||||||||||||||||
| Group: | Group: WorkItem | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ClassID: | 364. See Overview of ClassIDs by table. |
| Field | Table(Germ.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 | |
| Company | CompanyID SMALLINT |
Link to company (SBO Database) | MARISysConnections.Company (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 | MARISupportIssue.PMTicketID |
| PMTicketHotlineClassType | PMTicketHotlineClassType INT |
MARISupportIssue.PMTicketHotlineClassType | |
| 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 | |
| ResourceType | RessourceType INT |
not used | |
| ResponsibleEmployee | ResponsibleEmployee NVARCHAR (20) |
Link to Employee | MARIEmployeeMaster.ResponsibleEmployee |
| ServicePlanTemplate | ServicePlanTemplate INT |
Link to Template (For Plan) | MARIWorkItem.ServicePlanTemplate (WHERE WorkItemType=378) |
| WorkItemStatus | WorkItemStatus INT |
Status (depending on type) | MARISupportSettings.WorkItemStatus (WHERE Setting IN (8,9,10)) |
| WorkFlowID | WorkFlowID INT |
MARISupportWorkflow.WorkFlowID | |
| ProjectNumber | ProjectNumber NVARCHAR (20) Index |
Link to Project (Plan, Task) | MARIProjectMaster.ProjectNumber |
| ContractID | ContractID INT Index |
Link to Contract (Plan, Task) | MARIContract.ContractID |
| PhaseID | PhaseID INT Index |
Link to Phase Plan, Task) | MARIProjectPhases.PhaseID |
| ContractPositionID | ContractPositionID INT Index |
0=New positions as "at cost", Link to fixed price psoition | MARIContractPositions.ContractPositionID |
| DefaultWarehouse | StandardWarehouse NVARCHAR (20) |
warehouse for new positions / vehicles warehouse | OWHS.WhsCode |
| SourceDocumentType | SourceDocumentType INT |
||
| SourceDocumentID | SourceDocumentID INT |
MARIContractDocument.SourceDocumentID | |
| SalesOrderID | SalesOrderID INT Index |
Sales order for MRP Status | MARIContractDocument.SalesOrderID |
| 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 |
MARICustomerLocationTreeElement.CustomerLocationTreeElementID | |
| CustomerLocationContactPerson | CustomerLocationContactPerson INT |
OCPR.CntctCode | |
| CustomerLocationRemark | CustomerLocationRemark NVARCHAR (100) |
||
| A0AddressNr | A0AdressNr INT |
||
| A0CardCode | A0Empfaenger NVARCHAR (20) |
OCRD.CardCode | |
| A0Salutation | A0Anrede NVARCHAR (50) |
||
| A0Name1 | A0Name1 NVARCHAR (100) |
||
| A0Name2 | A0Name2 NVARCHAR (50) |
||
| A0Name3 | A0Zusatz NVARCHAR (50) |
||
| A0OneTimeCustomer | A0Einmalkunde SMALLINT |
||
| A0Matchcode | A0Matchcode NVARCHAR (100) |
||
| A0Street | A0Strasse NVARCHAR (100) |
||
| A0StreetNumber | A0Hausnummer NVARCHAR (100) |
||
| A0Country | A0Land NVARCHAR (3) |
||
| A0ZIP | A0PLZ NVARCHAR (20) |
||
| A0City | A0Ort NVARCHAR (100) |
||
| A0County | A0Bezirk NVARCHAR (100) |
||
| A0State | A0Bundesland NVARCHAR (3) |
||
| A0Block | A0Gebaeude NVARCHAR (100) |
||
| A0ContactPerson | A0AnsprechpartnerID INT |
OCPR.CntctCode | |
| A0AddressName1 | A0AdressName NVARCHAR (50) |
||
| A0AddressName2 | A0AdressName2 NVARCHAR (50) |
||
| A0AddressName3 | A0AdressName3 NVARCHAR (50) |
||
| A0Building | A0GebaeudeStockwerk NTEXT |
||
| A0AddressMemo | A0AdressMemo NTEXT |
||
| A0CardFName | A0CardFName NVARCHAR (100) |
||
| A0AddrType | A0AddrType NVARCHAR (100) |
||
| A0AddressLineNum | A0AdressLineNum 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 | MARIPictures.SignaturePic |
| GroupID | GroupID INT |
Internal Groups | |
| WorkItemIDPrevious | WorkItemIDPrevious INT |
Link to other task. On Plans link to last closed days | MARIWorkItem.WorkItemIDPrevious |
| WorkItemIDNext | WorkItemIDNext INT |
Link to other task. On Plans link to first open days | MARIWorkItem.WorkItemIDNext |
| 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 | MARIQualityProcess.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 | MARIGroups.Group1 (WHERE GruppenArt=10054) |
| Group2 | Group2 INT |
The GroupType (GruppenArt) depends on the WorkItemType | MARIGroups.Group2 (WHERE GruppenArt=10055) |
| Group3 | Group3 INT |
The GroupType (GruppenArt) depends on the WorkItemType | MARIGroups.Group3 (WHERE GruppenArt=10056) |
| CreateDate | CreateDate Datetime |
Create User | |
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (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 |
| Table | Description | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MARIContractPosition2POPosition | Contract Management: Contract position to PO position link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEquipmentMaster | Equipment: Master Data for each individual Equipment | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingParticipantExams | Training Module: Passed exams of participants | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingParticipantGrades | Training Module: Grades of participants | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingRegistration | Training Module: Registratrion to training cources | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIDocumentDraftHeadLink | Linked contracts and purchase processes | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIWorkItem | 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.
|
||||||||||||||||||||||||||||||||||||||||||||||||
| MARIWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIWorkItemResources | Employees or Equipment necessary for the tasks | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIWorkItemSettings | Additional Properties for a service order | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARICustomerServiceObject | Advanced table to sbo standard customer equipment card | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIWorkItemScheduleDates | Recurring service tasks | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIWorkItemDocumentLink | Service Task Link created documents | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingRegistrationTeam | Training Module: Team for the training |