Approvals Export
- Last updated
- Save as PDF
Explains why an approver was added as an approver for the document.
Export of these records is limited to those customers with the Additional SFTP Exports license.
Approval columns
| Position | Column Name | Description | Type | Req/Unique | Allowable Values |
|---|---|---|---|---|---|
| 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 ID of the delegate approval when there is only a single approval delegate | integer(11) | No/No | |
| 10 | Delegate Approval Ids | The IDs of all the delegate approvals when there are multiple approval delegates | string(255) | No/No | |
| 11 | Delegate Approver Names | Names of users who are delegates of the approver on the approval | text | No/No | |
| 12 | Override Approver | Name of the user who bypassed the approval | string(255) | No/No | |
| 13 | Approval Date (UTC) | The date the approval occurred | datetime | No/No | |
| 14 | Position | The position in the approval chain this approval occurred | integer(11) | No/No | |
| 15 | Approval Method | The method in which this approval occurred | string(255) | No/No | |
| 16 | Approver Type | How the approval occured (override approval, approval chain approval, etc) | string(255) | No/No | |
| 17 | Approval Key | The key used to authenticate email approvals | string(100) | No/No | |
| 18 | Status | The status of the approval (approved, escalated, rejected, etc) | string(50) | No/No | |
| 19 | Approval Reason | Explains why an approver was added as an approver for the document | text | No/No | |
| 20 | Document Currency | The currency of the document that was approved | string(6) | No/No | |
| 21 | Created By ID | The user ID that created the approval | integer(11) | No/No | |
| 22 | Created By Login | The user login that created the approval | string(255) | No/No | |
| 23 | Created Date | The date the user create the approval | datetime | No/No | |
| 24 | Last Updated By ID | The user ID that most recently updated the approval | integer(11) | No/No | |
| 25 | Updated By Login | Ther user login that most recently updated the approval | string(255) | No/No | |
| 26 | Last Updated Date | The date the approval was most recently updated | datetime | No/No | |
| 27 | Owned By ID | The owner of the approval | integer(11) | No/No | |
| 28 | Owned By Login | The user login that owns the approval | string(255) | No/No | |
| 29 | Assigned By ID | Who the approval was assigned to | integer(11) | No/No | |
| 30 | Assigned By Login | The user login that is assigned to the approval | string(255) | No/No | |
| 31 | Assigned Date | The date the approval was assigned to the user | datetime | No/No | |
| 32 | First Notification (UTC) | The date the user was first notified that they can approve | datetime | No/No | |
| 33 | Last Reminded Date | The date the user was last reminded that they can approve | datetime | No/No | |
| 34 | Skip Escalation | If the approval was a skip escalation (Y/N) | boolean | No/No | |
| 35 | Submission Date | The date the document was submitted | datetime | No/No |