| View Name: | MARISupportIssueApproval |
| Based on table: | MPHotlineAnfrageFreigabe |
| Group: | Group: SupportIssue |
| Description: | Support Module: Store the approval steps for a ticket |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| AnfrageID | AnfrageID INT Primary |
||
| Schritt | Schritt INT Primary |
||
| ApprovalType | FreigabeTyp INT |
||
| ApprovalSubType | FreigabeTypSub INT |
MARIDocApprovalRessources.ApprovalSubType | |
| ApprovalSubTypeClearer | FreigabeTypClearer INT |
||
| Approver | Freigebender NVARCHAR (20) Index |
MARIEmployeeMaster.Approver | |
| ApprovalMode | Freigabe SMALLINT (0=false,-1=true) Index |
||
| ApprovedDate | FreigegebenAm Datetime |
||
| ApprovedUser | FreigegebenID NVARCHAR (4) |
MARIUser.ApprovedUser (WHERE BenutzerTyp=1) | |
| ApprovedPending | FreigabeWartend SMALLINT (0=false,-1=true) |
||
| ApprovalText | Freigabetext NTEXT |
||
| NumberOfApprovers | AnzahlFreigebender INT |
||
| UpdateStamp | UpdateStamp INT |