| 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 |
|
