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.
Expense payments columns
|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)|