1 |
Approval Chain ID |
ID of the approval chain this approval is located in |
integer(11) |
No/No |
|
2 |
Approval Chain Name |
The name of the approval chain |
string(255) |
No/No |
|
3 |
Document Number |
The document ID that was approved |
integer(11) |
No/No |
|
4 |
Document Type |
The document type that was approved (requisition, purchase order, etc) |
string(255) |
No/No |
|
5 |
Document Status |
The document status |
string(255) |
No/No |
|
6 |
Approver ID |
The user ID that made the approval |
integer(11) |
No/No |
|
7 |
Approver Login |
The user name that made the approval |
string(255) |
No/No |
|
8 |
Approver Role |
The role of the approver |
string(255) |
No/No |
|
9 |
Delegate |
The delegate ID that made the approval (if applicable) |
integer(11) |
No/No |
|
10 |
Approval Date (UTC) |
The date the approval occurred |
datetime |
No/No |
|
11 |
Position |
The position in the approval chain this approval occurred |
integer(11) |
No/No |
|
12 |
Approval Method |
The method in which this approval occurred |
string(255) |
No/No |
|
13 |
Approver Type |
How the approval occured (override approval, approval chain approval, etc) |
string(255) |
No/No |
|
14 |
Approval Key |
The key used to authenticate email approvals |
string(100) |
No/No |
|
15 |
Status |
The status of the approval (approved, escalated, rejected, etc) |
string(50) |
No/No |
|
16 |
Document Currency |
The currency of the document that was approved |
string(6) |
No/No |
|
17 |
Created By ID |
The user ID that created the approval |
integer(11) |
No/No |
|
18 |
Created By Login |
The user login that created the approval |
string(255) |
No/No |
|
19 |
Created Date |
The date the user create the approval |
datetime |
No/No |
|
20 |
Last Updated By ID |
The user ID that most recently updated the approval |
integer(11) |
No/No |
|
21 |
Updated By Login |
Ther user login that most recently updated the approval |
string(255) |
No/No |
|
22 |
Last Updated Date |
The date the approval was most recently updated |
datetime |
No/No |
|
23 |
Owned By ID |
The owner of the approval |
integer(11) |
No/No |
|
24 |
Owned By Login |
The user login that owns the approval |
string(255) |
No/No |
|
25 |
Assigned By ID |
Who the approval was assigned to |
integer(11) |
No/No |
|
26 |
Assigned By Login |
The user login that is assigned to the approval |
string(255) |
No/No |
|
27 |
Assigned Date |
The date the approval was assigned to the user |
datetime |
No/No |
|
28 |
First Notification (UTC) |
The date the user was first notified that they can approve |
datetime |
No/No |
|
29 |
Last Reminded Date |
The date the user was last reminded that they can approve |
datetime |
No/No |
|
30 |
Skip Escalation |
If the approval was a skip escalation (Y/N) |
boolean |
No/No |
|