| Table Name: | MPCustomerEquipmentCard |
| View Name: | MARICustomerServiceObject |
| Group: | Group: CustomerServiceObject |
| Description: | Advanced table to sbo standard customer equipment card |
| ClassID: | 326. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPinsID | MPinsID INT Primary |
||
| CompanyID | CompanyID SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| insID | insID INT Index |
Link to SBO Customer Equipment Card | OINS.insID |
| customer | customer NVARCHAR (20) Index |
OCRD.CardCode | |
| custmrName | custmrName NVARCHAR (100) |
||
| contactCod | contactCod INT |
||
| directCsmr | directCsmr NVARCHAR (20) |
||
| drctCsmNam | drctCsmNam NVARCHAR (100) |
||
| manufSN | manufSN NVARCHAR (32) |
||
| internalSN | internalSN NVARCHAR (32) |
||
| warranty | warranty NVARCHAR (1) |
||
| wrrntyStrt | wrrntyStrt Datetime |
||
| wrrntyEnd | wrrntyEnd Datetime |
||
| responsVal | responsVal SMALLINT |
||
| responsUnt | responsUnt NVARCHAR (1) |
||
| itemCode | itemCode NVARCHAR (50) Index |
OITM.ItemCode | |
| itemName | itemName NVARCHAR (100) |
||
| itemGroup | itemGroup SMALLINT |
OITB.ItmsGrpCod | |
| manufDate | manufDate Datetime |
||
| cntctPhone | cntctPhone NVARCHAR (20) |
||
| AddrName | AddrName NVARCHAR (100) |
||
| AddrName2 | AddrName2 NVARCHAR (50) |
||
| AddrName3 | AddrName3 NVARCHAR (50) |
||
| AddrStreet | AddrStreet NVARCHAR (100) |
||
| AddrStreetNo | AddrStreetNo NVARCHAR (100) |
||
| AddrBlock | AddrBlock NVARCHAR (100) |
||
| AddrBuilding | AddrBuilding NTEXT |
||
| AddrZipCode | AddrZipCode NVARCHAR (20) |
||
| AddrCity | AddrCity NVARCHAR (100) |
||
| AddrCounty | AddrCounty NVARCHAR (100) |
||
| AddrCountry | AddrCountry NVARCHAR (3) |
||
| AddrState | AddrState NVARCHAR (3) |
||
| AddrType | AddrType NVARCHAR (100) |
||
| AddrGlbLocNum | AddrGlbLocNum NVARCHAR (50) |
||
| AddrLongitude | AddrLongitude Float |
||
| AddrLatitude | AddrLatitude Float |
||
| logInstanc | logInstanc INT |
||
| status | status NVARCHAR (1) |
clsImportCustomerServiceObject_eCSOStatus | |
| SyncDate | SyncDate Datetime |
||
| CustomerLocationTreeElementID | CustomerLocationTreeElementID INT Index |
MPCustomerLocationTreeElement.CustomerLocationTreeElementID | |
| CustomerLocationContactPerson | CustomerLocationContactPerson INT |
OCPR.CntctCode | |
| CustomerLocationRemark | CustomerLocationRemark NVARCHAR (100) |
||
| CECGroupID | CECGroupID INT Index |
Customer Service Object Category | MPCustomerEquipmentCardCategory.CECGroupID |
| Responsible | Responsible NVARCHAR (20) |
Responsible Employee | MPPersonenstamm.Personalnummer |
| Group1 | Group1 INT |
||
| Group2 | Group2 INT |
||
| ProductionContractID | ProductionContractID INT |
MPVKVertraege.VertragsID | |
| ProductionContractPositionID | ProductionContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| PictureID | PictureID INT |
MPBilder.BildID | |
| SLA_ID | SLA_ID INT Index |
MPHotlineSLA.SLA_ID | |
| ServicePlanOverAllStatus | ServicePlanOverAllStatus INT |
||
| ServicePlanOverAllNextRelevantDate | ServicePlanOverAllNextRelevantDate Datetime |
||
| ServicePlanOverAllRef2NextRelevantPlan | ServicePlanOverAllRef2NextRelevantPlan INT |
MPWorkItem.WorkItemID | |
| ParentMPinsID | ParentMPinsID INT Index |
MPCustomerEquipmentCard.MPinsID | |
| ProduktID | ProductID INT Index |
MPHotlineProdukt.ProduktID | |
| ProduktModulID | ProductModuleID INT Index |
MPHotlineProduktModul.ProduktModulID | |
| CreateDate | CreateDate Datetime |
||
| 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 |
| Table | Description |
|---|---|
| MPCustomerEquipmentCard | Advanced table to sbo standard customer equipment card |
| MPCustomerEquipmentLocation | Current location of a CSO at the client/Project |
| MPDocumentDraftPosition | Positions based on the order of the paper document |
| MPDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MPDocumentDraftPositionLinkSerial | Used/reserved serial numbers |
| MPEKVertraegeBelegePositionenSerie | Purchase Process: Purchase Document (Positions+Serial) |
| MPEKVertraegePos2Service | Purchase Process: Link Position to Customer Service Object or parts |
| MPHotlineProduktKunde | Support Module: Support Product: Customer Product Link |
| MPTmpRptPrintPositionenSerien | Reporting: Temporary Table: Document Positions Serial Numbers |
| MPVKVertraegeBelegePositionenSerie | Contract Management: Document Positions Serial Numbers |
| 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 |