| Table Name: | MPWorkItemPosition |
| View Name: | MARIWorkItemPosition |
| Group: | Group: WorkItem |
| Description: | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |
| ClassID: | 366. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| WorkItemPosID | WorkItemPosID INT Primary |
||
| WorkItemID | WorkItemID INT Index |
MPWorkItem.WorkItemID | |
| PositionOrder | PositionOrder INT Index |
||
| Position | PositionText NVARCHAR (20) |
||
| ParentContactPos | ParentContactPos INT |
MPVKVertraegePositionen.Vertragsposition | |
| SourceWorkItemPosition | SourceWorkItemPosition INT |
MPWorkItemPosition.WorkItemPosID | |
| ContractPosition | ContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| PosType | PosType INT |
2= ItemToDeliver, 3=ItemToReturn, 4=Base Line CSO, 10=Base Line Equipment,20=Service, .. and more | clsImportWorkItemBase_eWorkItemPosType |
| PosStatus | PosStatus INT |
MPHotlineSettings.ID (WHERE Setting=13 OR Setting=14) | |
| TransactionStatus | TransactionStatus INT Index |
||
| CompanyID | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| ItemCode | ItemCode NVARCHAR (50) |
OITM.ItemCode | |
| ItemGroup | ItemGroup INT |
OITB.ItmsGrpCod | |
| ServiceCode | ServiceCode NVARCHAR (20) |
MPLeistung.Leistungsnummer | |
| EquipmentSubject | EquipmentSubject NVARCHAR (20) |
MPEquipmentCategorySubject.EquipmentSubject | |
| EquipmentCode | EquipmentCode NVARCHAR (20) Index |
MPEquipment.EquipmentCode | |
| EquipmentCategory | EquipmentCategory INT |
MPEquipmentCategory.EquipmentCategory | |
| CustomerEquipmentCard | CustomerEquipmentCard INT |
MPCustomerEquipmentCard.MPinsID | |
| EmployeeNumber | EmployeeNumber NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| ParticipantNumber | ParticipantNumber NVARCHAR (20) |
MPTrainingParticipant.ParticipantNumber | |
| WarehouseCode | WarehouseCode NVARCHAR (20) |
OWHS.WhsCode | |
| BinLocations | BinLocations NTEXT |
||
| ContainerBins | ContainerBins NTEXT |
||
| Quantity | Quantity NUMERIC(19,6) |
||
| QuantityInvoicable | QuantityInvoicable NUMERIC(19,6) |
||
| QuantityContractSynced | QuantityContractSynced NUMERIC(19,6) |
||
| BaseQuantity | BaseQuantity NUMERIC(19,6) |
||
| QuantityType | QuantityType INT |
||
| QuantityCount | QuantityCount NUMERIC(19,6) |
||
| BaseCount | BaseCount NUMERIC(19,6) |
||
| CountText | CountText NVARCHAR (100) |
||
| QuantityFormularID | QuantityFormularID INT Index |
||
| Matchcode | Matchcode NVARCHAR (200) Index |
||
| Description1 | Description1 NVARCHAR (200) |
||
| Description2 | Description2 NVARCHAR (200) |
||
| UnitOfMesurnment | UnitOfMesurnment NVARCHAR (100) |
||
| PriceStatus | PriceStatus INT |
||
| ServicePlanID | ServicePlanID INT Index |
Link to ScheduledDay | MPWorkItemScheduleDates.WorkItemScheduleID |
| SalesOrderPositionID | SalesOrderPositionID INT Index |
Sales order Position for MRP reference | MPVKVertraegeBelegePositionen.MPBelPosID |
| QualityProcess | QualityProcess INT |
MPQualityProcess.QualityProcess | |
| QualityResult | QualityResult INT |
MPQualityStatus.QualityStatus | |
| QualitySuggestion | QualitySuggestion INT |
MPHotlineSettings.ID (WHERE Setting=12) | |
| QualityFeedbackText | QualityFeedbackText NTEXT |
||
| QualityProcessQuestion | QualityProcessQuestion INT |
||
| QualityProcessApprovalType | QualityProcessApprovalType INT |
||
| NetUnitPriceSys | NetUnitPriceSys NUMERIC(19,6) |
||
| NetUnitPriceLoc | NetUnitPriceLoc NUMERIC(19,6) |
||
| NetUnitPriceFC | NetUnitPriceFC NUMERIC(19,6) |
||
| NetTotalSys | NetTotalSys NUMERIC(19,6) |
||
| NetTotalLoc | NetTotalLoc NUMERIC(19,6) |
||
| NetTotalFC | NetTotalFC NUMERIC(19,6) |
||
| RebatePercent | RebatePercent NUMERIC(19,6) |
||
| RebateValueSys | RebateValueSys NUMERIC(19,6) |
||
| RebateValueLoc | RebateValueLoc NUMERIC(19,6) |
||
| RebateValueFC | RebateValueFC NUMERIC(19,6) |
||
| CurrencySys | CurrencySys NVARCHAR (3) |
||
| CurrencyLoc | CurrencyLoc NVARCHAR (3) |
||
| CurrencyFC | CurrencyFC NVARCHAR (3) |
||
| CurrencyRateLoc | CurrencyRateLoc Float |
||
| CurrencyRateFc | CurrencyRateFC Float |
||
| SerialNumberType | SerialNumberType INT |
||
| IssueMethod | IssueMethod INT |
||
| LongText | LongText NTEXT |
||
| PositionInfo | PositionInfo NTEXT |
||
| InvoiceMode | InvoiceMode INT |
||
| PortalMode | PortalMode INT |
||
| WOR1LineNum | WOR1LineNum INT |
WOR1.LineNum | |
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| Height1 | Height1 NUMERIC(19,6) |
||
| Hght1Unit | Hght1Unit SMALLINT |
||
| Width1 | Width1 NUMERIC(19,6) |
||
| Wdth1Unit | Wdth1Unit SMALLINT |
||
| Length1 | Length1 NUMERIC(19,6) |
||
| Len1Unit | Len1Unit SMALLINT |
||
| Volume | Volume NUMERIC(19,6) |
||
| VolUnit | VolUnit SMALLINT |
||
| Weight1 | Weight1 NUMERIC(19,6) |
||
| Wght1Unit | Wght1Unit SMALLINT |
||
| Option1 | Option1 INT |
||
| Option2 | Option2 INT |
||
| Link1 | Link1 NVARCHAR (20) |
||
| Link2 | Link2 NVARCHAR (20) |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MPEKVertraegePos2Service | Purchase Process: Link Position to Customer Service Object or parts |
| MPTrainingRegistrationContractLink | Training Module: Selection of billable contract positions (Contract from registration) |
| MPVKVertraegePos2EKPos | Contract Management: Contract position to PO position link |
| MPVKVertraegePos2Service | Contract Management: Contract position to Customer Service Object and parts |
| MPWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |
| MPWorkItemPositionSerial | Serialnumbers, Batchnumbers for work item positions |
| MPWorkItemResults | Results of quality process questionnaire |