| Table Name: | MPHotlineAnfrageAnhang |
| View Name: | MARISupportIssueLine |
| Group: | Group: SupportIssue |
| Description: | Support Module: Issue tracking: Issue line for comments, documents, emails, etc. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| AnfragePosID | RequestPosID INT Primary |
||
| AnfrageID | IssueID INT Unique |
MPHotlineAnfrage.AnfrageID | |
| AnfragePosTyp | RequestPosType INT |
||
| AnhangBetreff | RequestPosSubject NVARCHAR (255) |
||
| AnfrageText | RequestText NTEXT |
||
| DokumentenID | DocumentID NVARCHAR (120) Index |
MPDokumente.DocID, MPBilder.BildID | |
| DokumentenLink | DocumentLink NVARCHAR (250) |
||
| ParentAnfragePosID | ParentAnfragePosID INT Index |
||
| Status | Status INT |
||
| PosInfo | PosInfo NVARCHAR (50) |
||
| Ersteller | Originator NVARCHAR (50) |
||
| ErstellerTyp | OriginatorType INT Index |
||
| Bearbeiter | HandledBy NVARCHAR (50) |
OUSR.USER_Code | |
| BearbeiterTyp | EditorType INT |
||
| ErstelltAm | CreateDate Datetime |
||
| GelesenDatum | ReadFlagDate Datetime |
||
| VisibleInternOnly | VisibleInternOnly SMALLINT (0=false,-1=true) |
||
| SyncDate | SyncDate Datetime |
||
| SyncPosID | SyncPosID INT |
||
| SLATimeStamp | SLATimeStamp Datetime |
||
| SLATimeMethod | SLATimeMethod INT |
||
| Sprache | LanguageCode INT |
MPSysKundenSprachen.CustomerLanguageID | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |