Skip to main content

 

 

Coupa Success Portal

Approvals Export

Approval Columns

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.

# Column Name Description Type Req'd/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 delegate ID that made the approval (if applicable) 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  
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  
  • Was this article helpful?