• Last edited on: 05 February 2019

Commodity Import

The Commodity integration loader uses only a single set of header columns.

Overview

The commodity import process reads files from the ./Incoming/Commodity/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/Commodity/ before being processed in alpha-numeric order.

Note

Name is the key.

Column Name Description Req'd Unique Type Allowable Values
Name* The name of the commodity TRUE TRUE string(255) any
ID This is the unique identifier (database ID) Coupa assigns when a new record is created. It can’t be modified, but can be used to update the record.
Active* If the commodity is active or not TRUE FALSE boolean true, false
Parent commodity The name of the Parent Commodity. Can also be left blank if this commodity is not a child. FALSE FALSE integer(11) any
Deductibility Deductibility FALSE FALSE string(255) fully_deductible, partially_deductible, not_deductible
Category Category FALSE FALSE string(255) goods, services, monetary, others
Subcategory Subcategory FALSE FALSE string(255) raw_materials, investment_goods, services_exceptions
Acct GL Account (for defaulting) FALSE FALSE string(1024) any
Preferred Commodity Preferred Commodity FALSE FALSE boolean any

Related Items


Budget Line Adjustment Import

01 February 2019

The Budget Line Adjustment integration loader uses only a single set of header columns.

Enterprise Import

03 February 2019

The Enterprises integration loader uses only a single set of header columns.

Exchange Rate Import

03 February 2019

The exchange rates integration loader uses only a single set of header columns.

Expense Category Import

03 February 2019

The Expense Category loader uses only a single set of header columns.