TTContract Leasing Payment Plan Import

Format Description

#	Name	Type	Mandatory	Comment
1	ID / Leasing number	integer / char - 20	Yes	Either the unique identifier, as defined by Coupa Treasury, or the alphanumerical value for the Leasing Number field.
2	Date	date	Yes	Due date of the amount(s).
3	Interest amount	decimal	Yes
4	Amortization amount	decimal	No
5	Leasing rate (net)	decimal	No
6	Leasing rate (gross)	decimal	No
7	VAT	decimal	No
8	Interest calculated from	decimal	*
9	Interest calculated to	date	*
10	Residual value (net)	date	Yes
11	Residual value (gross)	decimal	Yes

* Mandatory with interest repayments

The import function is under Special Functions on Treasury > Financial Instruments > Leases.

The import function processes files in standard text formats:

Use the Identification dropdown to choose whether field 1 selects the deal ID or the Loan Number.

For each deal, the file must contain the complete leasing payment plan. Each imported data set overwrites any existing data sets.

If the file contains data about multiple leasing deals, the data for each deal must be grouped into a single block.

All cash flows for the same leasing deal must be in chronological order.

The file cannot contain any headers or format descriptions. Do not enclose text in quotation marks.

One file may contain multiple data sets. Each row contains exactly one data set.

In the table above, the value for “char” shows how many characters is the maximum length for that field in the imported file.

Days and months are always 2-digit values, whereas years are 4 digits. Date separator, date sequence, and file format must match your user settings.

Field delimiter: ; I Date delimiter: / I Date sequence: mdy I Decimal separator:

LNR54;01/29/2010;25.12;24.88;50;59.5;19 .0;12/31/2009;01/01/2010;100;689

LNR54;01/29/2010;0;50;50;59.5;19.0;;;50;589