Skip to main content

 

 

Coupa Success Portal

Approvals Export

Approval Columns

# 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 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  
  • Was this article helpful?