What can we help you find? Products Coupa Product Documentation Integration Technical Documentation Coupa Core Flat Files (CSV) Flat File (CSV) Import Legal Payment Receipt Loader

Legal Payment Receipt Loader

The Legal Payment Receipt loader contains Legal Payment Receipt headers and Invoice Payment Receipt headers.

Overview

This Legal Payment Receipt loader is a CFDI XML file format specifically for suppliers doing business in and from Mexico so that they can load legally compliant payment receipts, Complementos de Pago, in a supported XML/CSV format.

We support the parsing and mapping of this CFDI XML only on supplier originated invoices via either CSP upload or SFTP. The XML file does not need to be converted into the Coupa CSV format by the supplier. For the buyer side, we do not currently support direct parsing of the XML.

The Forms import process reads files from ./Incoming/LegalPaymentReceipt/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/LegalPaymentReceipt/ before being processed in alphanumeric order.

Keys

UUID

Validations

Coupa uses the field UUID to lookup an existing record.

Column	Description	Hidden	Req'd	Unique	Type	Allowable Values
Legal Payment Receipt	Defines the type of row	false	true	false	-	Legal Payment Receipt
UUID	CFDI UUID	false	false	true	string(255)	any
Document Date	CFDI Document Date	false	false	false	dateTime	any
Payment Received Date	Payment Received Date	false	false	false	dateTime	any
Amount	Amount	false	false	false	decimal(32,6)	any
Currency	Currency Code	false	false	false	string(6)	any
Check Number	Any kind of identification number which identifies the payment	false	false	false	string(255)	any
Buyer Bank Name	Buyer Bank Name	false	false	false	string(255)	any
Buyer Bank Reference	Buyer Bank Reference	false	false	false	string(255)	any
Supplier Bank Reference	Supplier Bank Reference	false	false	false	string(255)	any
Form of Payment	Form of Payment	false	false	false	string(255)	any
Buyer Account Number	Buyer Account Number	false	false	false	string(100)	any
Supplier Account Number	Supplier Account Number	false	false	false	string(100)	any
Supplier Tax Number	Supplier Tax Number	false	false	false	string(255)	any
Buyer Tax Number	Buyer Tax Number	false	false	false	string(255)	any

Invoice payment receipt columns

Column	Description	Hidden	Req'd	Unique	Type	Allowable Values
Invoice Payment Receipt	Defines the type of row	false	true	false	-	Invoice Payment Receipt
Document UUID	Document UUID	false	false	false	string(255)	any
Amount	Amount	false	false	false	decimal(32,6)	any
Currency	Currency Code	false	false	false	string(6)	any
Exchange Rate	Exchange Rate	false	false	false	decimal(32,6)	any
Payment Method	Payment Method	false	false	false	string(255)	any