| View Name: | MARICustomerServiceObject |
| Based on table: | MPCustomerEquipmentCard |
| Group: | Group: CustomerServiceObject |
| Description: | Advanced table to sbo standard customer equipment card |
| ClassID: | 326. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| MPinsID | MPinsID INT Primary |
||
| CompanyID | CompanyID SMALLINT Index |
MARISysConnections.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 |
MARICustomerLocationTreeElement.CustomerLocationTreeElementID | |
| CustomerLocationContactPerson | CustomerLocationContactPerson INT |
OCPR.CntctCode | |
| CustomerLocationRemark | CustomerLocationRemark NVARCHAR (100) |
||
| CECGroupID | CECGroupID INT Index |
Customer Service Object Category | MARICustomerServiceObjectCategory.CECGroupID |
| Responsible | Responsible NVARCHAR (20) |
Responsible Employee | MARIEmployeeMaster.Responsible |
| Group1 | Group1 INT |
||
| Group2 | Group2 INT |
||
| ProductionContractID | ProductionContractID INT |
MARIContract.ProductionContractID | |
| ProductionContractPositionID | ProductionContractPositionID INT |
MARIContractPositions.ProductionContractPositionID | |
| PictureID | PictureID INT |
MARIPictures.PictureID | |
| SLA_ID | SLA_ID INT Index |
MARISupportSLA.SLA_ID | |
| ServicePlanOverAllStatus | ServicePlanOverAllStatus INT |
||
| ServicePlanOverAllNextRelevantDate | ServicePlanOverAllNextRelevantDate Datetime |
||
| ServicePlanOverAllRef2NextRelevantPlan | ServicePlanOverAllRef2NextRelevantPlan INT |
MARIWorkItem.ServicePlanOverAllRef2NextRelevantPlan | |
| ParentMPinsID | ParentMPinsID INT Index |
MARICustomerServiceObject.ParentMPinsID | |
| ProductID | ProduktID INT Index |
MARISupportProduct.ProductID | |
| ProductModuleID | ProduktModulID INT Index |
MARISupportProductModules.ProductModuleID | |
| CreateDate | CreateDate Datetime |
||
| 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 |
| Table | Description |
|---|---|
| MARISupportProductCustomer | Support Module: Support Product: Customer Product Link |
| MARITempReportDocumentPosSerialNumbers | Reporting: Temporary Table: Document Positions Serial Numbers |
| MARIPurchaseProcessDocumentPositionsSerialNumbers | Purchase Process: Purchase Document (Positions+Serial) |
| MARIContractDocumentPositionsSerialNumbers | Contract Management: Document Positions Serial Numbers |
| MARIDocumentDraftPosition | Positions based on the order of the paper document |
| MARIDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MARIDocumentDraftPositionLinkSerial | Used/reserved serial numbers |
| MARIWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |
| MARIWorkItemPositionSerial | Serialnumbers, Batchnumbers for work item positions |
| MARICustomerServiceObject | Advanced table to sbo standard customer equipment card |
| MARICustomerServiceObjectLocation | Current location of a CSO at the client/Project |
| MARIPurchaseProcessPos2Service | Purchase Process: Link Position to Customer Service Object or parts |
| MARIContractPosition2Service | Contract Management: Contract position to Customer Service Object and parts |