What can we help you find?
Products
Total Spend Management Platform
Integration Playbooks and Resources
Other Integration Playbooks
Additional CSV Exports
Approvals Export
Approvals Export
Revised: 28 May 2019
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.
| 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 |