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.

When specifying a ship-to address, Coupa first looks for Ship to Id and then Ship to Country Location Code. If neither field is found, then a new ship-to address is created.

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.

No

No

string(50)

Ship To Id

Unique ID of the address. If specified, must exist in Coupa, but no other address fields required.

No

No

integer(11)

If specified, must exist in Coupa

Ship To 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)

Must exist in Coupa

Ship to Country Name

Ship to Address Country Name

No

No

string(255)

Ship to Location Code

If specified and exists in Coupa, no other address fields required. If doesn't exist in Coupa, a new address is created.

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.