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