| Table Name: | MPAnsprechpartner |
| View Name: | MARIContactPerson |
| Group: | |
| Description: | Contact Person: Used only for synchronization with other databases |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Nummer | Number INT Primary |
||
| Mandant | Company SMALLINT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Adresse | Address INT Index |
||
| Ansprechpartner | ContactPerson NVARCHAR (50) |
||
| Gruppe | GroupId NVARCHAR (10) |
||
| Titel | Title NVARCHAR (50) |
||
| Vorname | FirstName NVARCHAR (50) |
||
| Nachname | Surname NVARCHAR (50) |
||
| Position | PositionText NVARCHAR (50) |
||
| Abteilung | Division NVARCHAR (50) |
||
| Anrede | Salutation NVARCHAR (50) |
||
| Briefanrede | Salutation2 NVARCHAR (50) |
||
| ZuHaendenText | AttentionText NVARCHAR (50) |
||
| Telefon | Phone NVARCHAR (25) |
||
| Telefax | Fax NVARCHAR (25) |
||
| Mobilfunk | Mobile NVARCHAR (25) |
||
| TelefonPrivat | PrivatePhone NVARCHAR (25) |
||
| Autotelefon | CarPhone NVARCHAR (25) |
||
| Email NVARCHAR (50) |
|||
| Geburtsdatum | DateOfBirth Datetime |
||
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |