• Last edited on: 15 May 2020

Expense Payment Import

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

Overview

The Expense Payments Import process read files from the ./Incoming/ExpensePayments/ folder in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/ExpensePayments/ before being processed in Alphanumeric order.  Flat Files are then transformed to Coupa's XML format.

Payment records for expenses must have an Expense Report Id value.

Note

While Expense payments can be created using CSV integration, all updates must be done through the Expense Report UI. 

Column Name Description Req'd Unique Type Allowable Values
Expense Report Id* This is the Coupa generated Expense Number Yes integer
Paid-in-Full Date* This is the date the payment was completed in the payment system. Yes datetime YYYY-MM-DDTHH:MM:SS+HH:MM
Paid-in-Full Note This is an optional free form note regarding the payment that was made (paid by who, transaction number, etc) No string(255)

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.