Skip to main content

 

 

Coupa Success Portal

Requisitions Export

Overview

The expense report export process from Coupa queries for all approved Expense Reports that have NOT been exported. The frequency of the integration run is once every hour. The generated files will be placed into ./Outgoing/Requisitions. Once the files are successfully placed into the sFTP folder the expense reports will be marked as exported.

Requisition Header Columns

Column Name Description Req'd Unique Type Allowable Values
Record Type Indicates record type FALSE FALSE string(255) Requisition Header
Requisition Id Coupa Internal Requisition ID FALSE FALSE integer(11) any
Submitted At Date Date the Requisition was Submitted FALSE FALSE datetime any
Status Requisition Status TRUE FALSE string(50) any
Buyer Note Buyer Note FALSE FALSE text any
Justification Justification for requisition FALSE FALSE text any
Reject Reason rejection reason FALSE FALSE text any
Total Total Amount for Request FALSE FALSE decimal any
Currency Code 3 digit Currency Code for Total FALSE FALSE string(6) Any ISO 4217 three letter currency code
Requested By Employee Number Employee Number of user who requisition is on behalf of cart/requisition FALSE FALSE string(255) any
Requested by Login Login of user who requisition is on behalf of cart/requisition FALSE FALSE string(255) any
Requested by Email Email of user who requisition is on behalf of cart/requisition FALSE FALSE string(255) Must be in the format of a valid email address.
Department Name of the Department for the requisition FALSE FALSE string(255) any
Ship To Address Street 1 Ship To Address Street Line 1 FALSE FALSE string(100) any
Ship To Address Street 2 Ship To Address Street Line 2 FALSE FALSE string(100) any
Ship To Address City Ship To Address City FALSE FALSE string(50) any
Ship To Address State Ship To Address State/Provience FALSE FALSE string(50) any
Ship To Address Postal Code Ship To Address Postal Code FALSE FALSE string(50) any
Ship To Address Country Code Ship To Address Country Code FALSE FALSE string(4) any
Ship To Address Attention Ship To Address Attention Field FALSE FALSE string(255) any
Ship To Address Id Ship To Address Internal Address ID FALSE FALSE integer(11) any
Ship To Address Name Ship To Address Name FALSE FALSE string(255) any
Ship To Address Location Code Ship To Address Location Code FALSE FALSE string(255) any
Created At Date Date the shopping cart/requisition was first created FALSE FALSE datetime any
Updated At Date Date the requisition was last updated FALSE FALSE datetime any
Approved By Employee Number Approved By Employee Numbers FALSE FALSE string(255) any
Approved by Login Approved by Logins FALSE FALSE string(255) any
Approved by Email Approved by Emails FALSE FALSE string(255) any
Created By Employee Number Employee Number of user who created cart/requisition FALSE FALSE string(255) any
Created by Login Login of user who created cart/requisition FALSE FALSE string(255) any
Created by Email Email of user who created cart/requisition FALSE FALSE string(255) any
Updated By Employee Number Employee Number of person who last updated the requisition FALSE FALSE string(255) any
Updated by Login Login of person who last updated the requisition FALSE FALSE string(255) any
Updated by Email Email of person who last updated the requisition FALSE FALSE string(255) any
custom-field-1 Integration Custom Field 1 FALSE FALSE string(255) any
custom-field-2 Integration Custom Field 2 FALSE FALSE string(255) any
custom-field-3 Integration Custom Field 3 FALSE FALSE string(255) any
custom-field-4 Integration Custom Field 4 FALSE FALSE string(255) any
custom-field-5 Integration Custom Field 5 FALSE FALSE string(255) any
custom-field-6 Integration Custom Field 6 FALSE FALSE string(255) any
custom-field-7 Integration Custom Field 7 FALSE FALSE string(255) any
custom-field-8 Integration Custom Field 8 FALSE FALSE string(255) any
custom-field-9 Integration Custom Field 9 FALSE FALSE string(255) any
custom-field-10 Integration Custom Field 10 FALSE FALSE string(255) any

Requisition Line Columns

Column Name Description Req'd Unique Type Allowable Values
Record Type Indicates record type FALSE FALSE string(255) Requisition Lines, Line Split
Requisition Header Id Requisition Header Id FALSE FALSE integer(11) any
Line Number Line Number FALSE FALSE integer(11) any
Description Line Description TRUE FALSE string(255) any
Item Name Item Name FALSE FALSE string(255) any
Item Number Item Number FALSE FALSE string(255) any
Supplier Auxiliary Part Number Supplier Auxiliary Part Number FALSE FALSE string(255) any
Source Part Number Source Part Number FALSE FALSE string(255) any
Need By Date Need By Date FALSE FALSE datetime any
Price Unit Price of Item FALSE FALSE decimal(30,6) any
Total Quantity Total Quantity Ordered FALSE FALSE decimal(30,6) any
Line Total Line Total Amount FALSE FALSE decimal(32,4) any
Request Type Request Type FALSE FALSE string(100) any
Currency Code Currency Code FALSE FALSE string(6) Any ISO 4217 three letter currency code
Supplier Number Supplier Number FALSE FALSE string(255) any
Supplier Name Supplier Name FALSE FALSE string(100) any
Payment Terms Payment Term Code FALSE FALSE string(255) Must match an existing payment term in Coupa
Shipping Terms Shipping Term Code FALSE FALSE string(255) Must match an existing shipping term in Coupa
Unit of Measure Unit of Measure FALSE FALSE string(6) any
Assets Tags Assets Tags FALSE FALSE string(255) any
Commodity Name Commodity Name FALSE FALSE string(255) any
Chart of Account Name Chart of Account Name FALSE FALSE string(50) any
Account Code Account Code FALSE FALSE string(255) any
Account Name Account Name FALSE FALSE string(255) any
Segment 1 Account Segment 1 FALSE FALSE string(100) any
Segment 2 Account Segment 2 FALSE FALSE string(100) any
Segment 3 Account Segment 3 FALSE FALSE string(100) any
Segment 4 Account Segment 4 FALSE FALSE string(100) any
Segment 5 Account Segment 5 FALSE FALSE string(100) any
Segment 6 Account Segment 6 FALSE FALSE string(100) any
Segment 7 Account Segment 7 FALSE FALSE string(100) any
Segment 8 Account Segment 8 FALSE FALSE string(100) any
Segment 9 Account Segment 9 FALSE FALSE string(100) any
Segment 10 Account Segment 10 FALSE FALSE string(100) any
Segment 11 Account Segment 11 FALSE FALSE string(100) any
Segment 12 Account Segment 12 FALSE FALSE string(100) any
Segment 13 Account Segment 13 FALSE FALSE string(100) any
Segment 14 Account Segment 14 FALSE FALSE string(100) any
Segment 15 Account Segment 15 FALSE FALSE string(100) any
Segment 16 Account Segment 16 FALSE FALSE string(100) any
Segment 17 Account Segment 17 FALSE FALSE string(100) any
Segment 18 Account Segment 18 FALSE FALSE string(100) any
Segment 19 Account Segment 19 FALSE FALSE string(100) any
Segment 20 Account Segment 20 FALSE FALSE string(100) any
Created At Date line was created FALSE FALSE datetime any
Updated At Date line was last updated FALSE FALSE datetime any
Created By Employee Number Employee Number of user who created line FALSE FALSE string(255) any
Created by Login Login of user who created line FALSE FALSE string(255) any
Created by Email Email of user who created line FALSE FALSE string(255) any
Updated By Employee Number Employee Number of user who last updated line FALSE FALSE string(255) any
Updated by Login Login of user who last updated line FALSE FALSE string(255) any
Updated by Email email of user who last updated line FALSE FALSE string(255) any

Requisition Line Allocation Columns

Column Name Description Req'd Unique Type Allowable Values
RecordType Describes the type of row. Possible values are Header, Line, or Line Split. FALSE FALSE string(255) Line Split
Requisition Header ID Coupa's Requisition Report ID FALSE FALSE integer(11) any
Requsition Line ID Coupa's Requisition Report Line ID FALSE FALSE integer(11) any
Requisition Line Number Requisition Line Number FALSE FALSE integer(11) any
Purchase Order Header Number If a PO was created, Coupa's Order Header Number FALSE FALSE integer(11) any
Purchase Order Line ID If a PO was created, Coupa's Order Line ID FALSE FALSE integer(11) any
Purchase Order Line Number If a PO was created, Coupa's Order Line Number FALSE FALSE integer(11) any
Account Allocation ID Account Allocation ID FALSE FALSE integer(11) any
Allocation Number Position in the Account Allocation Sequence FALSE FALSE integer(11) any
Allocation Amount Amount allocated to the account FALSE FALSE decimal(30,6) any
Allocation Percent Percentage allocated to the account FALSE FALSE decimal(8,2) any
Account Code The whole account code of the account FALSE FALSE string(255) any
Account Active Flag indicating if the account is active. True or False. FALSE FALSE string(4) True/False
Account Segment 1 Account Segment 1 FALSE FALSE string(100) any
Account Segment 2 Account Segment 2 FALSE FALSE string(100) any
Account Segment 3 Account Segment 3 FALSE FALSE string(100) any
Account Segment 4 Account Segment 4 FALSE FALSE string(100) any
Account Segment 5 Account Segment 5 FALSE FALSE string(100) any
Account Segment 6 Account Segment 6 FALSE FALSE string(100) any
Account Segment 7 Account Segment 7 FALSE FALSE string(100) any
Account Segment 8 Account Segment 8 FALSE FALSE string(100) any
Account Segment 9 Account Segment 9 FALSE FALSE string(100) any
Account Segment 10 Account Segment 10 FALSE FALSE string(100) any
Account Segment 11 Account Segment 11 FALSE FALSE string(100) any
Account Segment 12 Account Segment 12 FALSE FALSE string(100) any
Account Segment 13 Account Segment 13 FALSE FALSE string(100) any
Account Segment 14 Account Segment 14 FALSE FALSE string(100) any
Account Segment 15 Account Segment 15 FALSE FALSE string(100) any
Account Segment 16 Account Segment 16 FALSE FALSE string(100) any
Account Segment 17 Account Segment 17 FALSE FALSE string(100) any
Account Segment 18 Account Segment 18 FALSE FALSE string(100) any
Account Segment 19 Account Segment 19 FALSE FALSE string(100) any
Account Segment 20 Account Segment 20 FALSE FALSE string(100) any
Account Name Nickname for the account FALSE FALSE string(255) any
Currency Code Currency Code FALSE FALSE string(3) Any ISO 4217 three letter currency code
custom-field-1 Integration Custom Field 1 FALSE FALSE string(255) any
custom-field-2 Integration Custom Field 2 FALSE FALSE string(255) any
custom-field-3 Integration Custom Field 3 FALSE FALSE string(255) any
custom-field-4 Integration Custom Field 4 FALSE FALSE string(255) any
custom-field-5 Integration Custom Field 5 FALSE FALSE string(255) any
custom-field-6 Integration Custom Field 6 FALSE FALSE string(255) any
custom-field-7 Integration Custom Field 7 FALSE FALSE string(255) any
custom-field-8 Integration Custom Field 8 FALSE FALSE string(255) any
custom-field-9 Integration Custom Field 9 FALSE FALSE string(255) any
custom-field-10 Integration Custom Field 10 FALSE FALSE string(255) any
  • Was this article helpful?