Skip to main content

 

 

Coupa Success Portal

Requisitions Import

Overview

The Requisition Import process reads files from the ./Incoming/Requisitions/ in the SFTP. These files are moved to the archive folder located at ./Incoming/Archive/Requisitions/ before being processed in alphanumeric order.

Coupa can't update a requisition using flat file Integration.

Requisition Header Columns

Column Name Description Req'd Unique Type Allowable Values
Requisition Field indicating record type (Header) Yes No string Requisition
Record Identifier Used to identify record to associate header & lines. Only used in load, not sent to Coupa. Yes No string(255)  
Submit For Approval? Should the requisition be immediately submitted for approval (otherwise it will be left in Draft mode) Yes No boolean Yes, No/True,False/T,F/Y,N
Need By Date Item Need By Date No No datetime YYYY-MM-DDTHH:MM:SS+HH:MM
Justification Requisition Justification Comments No No string(65535)  
Department Name Requisition Department No No string(255)  
Buyer Note Any comments or notes from the Buyer No No string(65535)  
Requested By (Email)

User email of requisition requester (will be the 'on behalf of' user if requisition is on behalf of another user)

Yes No string(60)  
Requested By (Login) User login of requisition requester (will be the 'on behalf of' user if requisition is on behalf of another user) Yes No string(80)  
PCard Name Name of PCard No No string(255)  
Ship To Name Name of Address. Must exist in Coupa. No No string(50)  
Ship To Id Ship to Address id. Coupa internal address ID. No No integer(11)  
Ship To Attention Ship to Address attention. Either the Requester or the attention linked to Address in Coupa (defaults to the requester). No No string(255)  
Ship To Street 1

Ship to Address Line1. Provide if the address does not exist in Coupa.

No No string(255)  
Ship To Street 2 Ship to Address Line2. Provide if the address does not exist in Coupa. No No string(255)  
Ship To City Ship to Address City. Provide if the address does not exist in Coupa. No No string(255)  
Ship To State Ship to Address state. Provide if the address does not exist in Coupa. No No string(255)  
Ship To Postal Code Ship to Address Postal code. Provide if the address does not exist in Coupa. No No string(255)  
Ship to Country Code Ship to Address Country Code. Must exist in Coupa. No No string(255)  
Ship to Country Name Ship to Address Country Name No No string(255)  
Ship to Country Location Code Ship to Address Country Location Code No No string(255)  

Requisition Line Columns

Column Name Description Req'd Unique Type Allowable Values
Requisition Line Field indicating record type (Line) Yes   string Requisition Line
Record Identifier Used to identify record to associate header & lines. Only used in load, not sent to Coupa. Yes   string(255)  
Line Number Line Number No No integer(11)  
Catalog Item Number Catalog Item Number (blank if Non Catalog Item) No No string(255)  
Catalog Item Name Catalog Item Name (blank if Non Catalog Item) No No string(255)  
Non Catalog Item Description Item Description for Non Catalog Items No No string(255)  
Supplier Part Number Supplier Part Number No No string(255)  
Quantity Line Qty Amount (blank for Service-based line) No* No decimal(30,6)  
Price Item Unit Price Yes No decimal(30,3)  
Need By Date Item Need By Date No No datetime YYYY-MM-DDTHH:MM:SS+HH:MM
Supplier Name Supplier Name (required unless Supplier Number is provided) Yes** No string(100)  
Supplier Number Supplier Number (required unless Supplier Name is provided) Yes** No string(255)  
Supplier Site Code ID of Supplier Site No No integer(11)  
UOM Code Unit of Measure Code No* No string(6)  
Commodity Name Commodity Name No  No string(255)  
Contract Name Name of Contract used for purchase No  No string(100)  
Currency Code Currency Code Yes No string(6) Any ISO 4217 three letter currency code
Asset Tags Not currently used No No string(255)  
Chart of Account Name Chart of Accounts for Line. Although this field isn't required, you should enter something in this field. If this value is left blank, your integration may not work. No No string(50)  
Account Name Account Name No  No string(100)  
Account Code Account Code (can be provided instead of Account Segments below) No  No string(2020)  
Account Segment 1..20 Account Billing Code Segment for Line No  No string(100)  
Account Allocation Amount Not currently used No No float  
Account Allocation Percent Not currently used No No    
Payment Term Code Payment Term Code No No string(255)  
Shipping Term Code Shipping Term Code No No string(255)  
Budget Period Name Name fo budget period No No string(255)  
Account Allocation   No      

* Service based lines don't have a quantity or UOM

** Requires one of Supplier Name or Supplier Number

  • Was this article helpful?