| Table Name: | MPDocApprovalRessource |
| View Name: | MARIDocApprovalRessources |
| Group: | Group: DocApproval |
| Description: | Steps in the approval process. Rule Lines (Steps) for each approval prioritry. The rules are used from top (Priority=0) to button. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| DocApprovalIDRessourceID | DocApprovalIDRessourceID INT Primary |
||
| DocApprovalID | DocApprovalID INT Unique |
MPDocApproval.DocApprovalID | |
| CreatorRessourceType | CreatorRessourceType INT Primary |
33=Employee, ProjectManager = 10002, EveryBody = 10017 | ClassID |
| CreatorRessource | CreatorRessource NVARCHAR (20) Primary |
EmployeeNumber for CreatorRessourceType=33 | MPPersonenstamm.Personalnummer |
| Priority | Priority INT Primary |
Order of the rule | |
| RuleType | RuleType INT |
0=No Rule, 1=Larger Than, 2=LargerOrEqual, 3=SQL Query, 4=CreditLimit, 5=ItemGroupMargin | |
| RuleValue | RuleValue NUMERIC(19,6) |
Amount or MARISysUserQuery.UserQueryID | MPSysUserQuery.UserQueryID |
| RuleText | RuleText NVARCHAR (255) |
||
| RuleType2 | RuleType2 INT |
not used | |
| RuleValue2 | RuleValue2 NUMERIC(19,6) |
not used | |
| RuleType3 | RuleType3 INT |
not used | |
| RuleValue3 | RuleValue3 NUMERIC(19,6) |
not used | |
| ApprovalType | ApprovalType INT |
Type: 0=Undefined, 1=Single Approval, 3=Multiple Approval, 4=Chain Approval, 5=RequestType Request 6=RequestType Approval, 7= n out of list | |
| ApprovalRessourceType1 | ApprovalRessourceType1 INT |
14=Business Unit(s), 28=Company(s), 33=Employee, 10020=List of employees, 10002=Project Manager, 10018=2nd PM(s), 10019 All PM(s), 10026=PMs with planning for the Request employee, 10024=Superior, 10025=2nd Superior | ClassID |
| ApprovalRessourceTypeMulti1 | ApprovalRessourceTypeMulti1 SMALLINT |
not used | |
| ApprovalRessourceClearanceType1 | ApprovalRessourceClearanceType1 INT |
Approval Type: 1=Single, 3=Multi, 4=Chain, 7=n of | |
| ApprovalRessource1 | ApprovalRessource1 NVARCHAR (20) |
||
| ApprovalRessourceType2 | ApprovalRessourceType2 INT |
ClassID | |
| ApprovalRessourceTypeMulti2 | ApprovalRessourceTypeMulti2 SMALLINT |
||
| ApprovalRessourceClearanceType2 | ApprovalRessourceClearanceType2 INT |
||
| ApprovalRessource2 | ApprovalRessource2 NVARCHAR (20) |
||
| NumberOfApprovers | NumberOfApprovers INT Index |
n for ApprovalRessourceClearanceType1=7 | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPDocApprovalRessourceSub | Store 1:n the Receipients for serial or chain approvals |
| MPEKVertraegeBelegeFreigabe | Purchase Process: Document Approval Employee Link |
| MPHotlineAnfrageFreigabe | Support Module: Store the approval steps for a ticket |
| MPPersonenUrlaubsAntragFreigabe | Vacation Management: Link to steps of approval process |
| MPReise2Freigabe | Travel Expenses Module: Approval for travel requests |
| MPVKVertraegeBelegeFreigabe | Contract Management: Document Approval |