Expense Payment Import
The Expense Payments integration loader uses only a single set of header columns.
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.
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)|