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