| Table Name: | MPDocumentDraftHeadApproval |
| View Name: | MARIDocumentDraftHeadApproval |
| Group: | Group: DocumentDraftHead |
| Description: | Approval or workflow list for the draft document |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| DocumentDraftID | DocumentDraftID INT Primary |
MPDocumentDraftHead.DocumentDraftID | |
| Step | Step INT Primary |
||
| ApprovalType | ApprovalType INT |
||
| ApprovalTypeSub | ApprovalTypeSub INT |
||
| ApprovalTypeClearer | ApprovalTypeClearer INT |
||
| Approver | Approver NVARCHAR (20) Index |
||
| Approved | Approved SMALLINT Index |
||
| ApprovedOn | ApprovedOn Datetime |
||
| ApprovedBy | ApprovedBy NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ApprovedByEmployee | ApprovedByEmployee NVARCHAR (20) |
||
| ApprovedPending | ApprovedPending SMALLINT |
||
| ApprovalText | ApprovalText NTEXT |
||
| UpdateStamp | UpdateStamp INT |