• Last edited on: 04 February 2019

Expense Import User Map Import

The Expense Import User Map loader uses only a single set of header columns.

Overview

The Expense Import User Map Import process read files from the ./Incoming/ExpenseImportUserMaps/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/ExpenseImportUserMaps/ before being processed in Alpha-Numeric order.

Expense import user map columns

Column Name Description Req'd Unique Type Allowable Values
Corp Card Integration Name Corporate Card Integration Name TRUE FALSE Must match the name of the integration on the Setup > Integrations page.
Account Type Account Type FALSE FALSE

For Employee Id mapping, use EMPLOYEE_ID. When mapping with account number, use one of AMEX, VISA, or MCC.

Account Number Account Number FALSE FALSE any
Email Email FALSE FALSE Valid email of the Coupa user
Reimbursement Type FALSE FALSE VARCHAR(255) Corporate Bill; Individual Bill

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.