| View Name: | MARIBookPageApproval |
| Based on table: | MPBuchSeitenFreigabe |
| Group: | Group: Book |
| Description: | Project Dokumentation: Book Page Approval Flow |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PageID | SeitenID INT Primary |
MARIBookPage.PageID | |
| ArchiveSetID | ArchivSatzID INT Primary |
||
| ApprovalStep | Schritt INT Primary |
||
| ApprovalType | FreigabeTyp INT Index |
||
| ApprovalSubType | FreigabeTypSub INT |
||
| 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 |