IC Recon - Invoice Export - CSV Format

Format Description

#	Name	Type	Comment
1	Invoice number	char - 50	Invoice number on the receivables side
2	Debitor account number	char - 20	Debitor account as it appears in Coupa Treasury
3	Invoice date	date
4	Due date	date
5	Amount	decimal
6	Currency	char - 3	ISO code of currency
7	Invoice flag	char - 50
8	Comment	char - 250
9	Delivery slip number	char - 50
10	XDoc no.	char - 50
11	Booking date	date
12	Remark	char - 250
13	Project	char - 50
14	Potfolio	char - 50

#	Name	Type	Comment
1	Invoice number	char - 50	Invoice number on the payables side
2	Creditor account number	char - 20	Creditor account as used for importing the confirmation file. For manual confirmation, the first creditor account number entered for the counterparty as ID counterparty.
3	Invoice date	date
4	Due date	date
5	Amount	decimal
6	Currency	char - 3	ISO code of currency
7	Invoice identifier	char - 50
8	Comment	char - 250
9	Delivery slip number	char - 50
10	XDoc no.	char - 50
11	Booking date	date
12	Remark	char - 250
13	Project	char - 50
14	Portfolio	char - 50

The export function is under Special Functions on Recon & Netting > AP/AR Recon > Payments.

The export function produces text files with the .csv file extension.

The export function uses the user-defined Export Format Settings under User Settings.

The file does not contain any headers or format descriptions.

One file can contain multiple data sets.

Each row in the file contains exactly one data set:

The field delimiter is the semicolon (;).

For decimal values, the period (.) is the decimal separator. There are no thousands separators.

For text values, there are no quotation marks. The char value is the maximum number of characters for that field.

Days and months are always 2-digit values and years are 4-digit values. There are no date separators and the date sequence is ymd.

745;104;05.01.2021;02.02.2021;1418258,41;EUR;;;;745;;

746;104;15.01.2021;12.02.2021;1892985,48;EUR;;;;746;;