TTGL Bookings Export CSV Format

Format Description

#	Name	Type	Comment
1	Receipt No.	char - 50
2	Receipt Date	date
3	Booking Date	date
4	Booking Period	char - 4
5	Company Code	char - 255
6	Contract Type	char - 10	MM, LD, etc
7	Contract Sub Type	char - 255	Abbreviation of contract subtypes as they appear in Coupa Treasury
8	Contract ID	integer	Contract ID in Coupa Treasury
9	Flow Type	char - 5	Long or Short
10	Type	char - 255	Start, End, Interest, Tax, Rebooking, Accrued interest, Special disbursement, Special repayment, or Principal
11	Flow Direction	char - 1	+ or -
12	Amount	decimal	Absolute values only, line 11 defines whether it is a negative or positive amount
13	Currency	char - 3	ISO code for the currency
14	Start Date	date
15	End Date	date
16	Value Date	date
17	Counterparty Short	char - 50
18	Counterparty Country	char - 2	ISO code for country
19	Counterparty Internal/External	char - 8	Internal or External
20	Underlying	char - 50
21	Add Text	char - 255
22	Account Debit	char - 255	Bookings account in Coupa Treasury
23	Account Credit	char - 255	Bookings account in Coupa Treasury
24	Rate	decimal
25	Reciprocal	decimal
26	Counter Value HW	decimal

The export generates an ASCII formatted text file. Configure the file extension and prefixes on System > System Settings > System Settings.

The exported file contains contract data for interface with an ERP system.

Bookings originate from various financial instruments in Coupa Treasury:

The file may also contain maturities, valuations, accruals, and deferrals.

The file does not contain any headers or format descriptions.

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.

For integer values, there are no thousands or decimal 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.

1;20090519;20090519;05;001;Staffel;TWAG-ABN-USD;9;Long;Zinsen;+;001;

USD;20090512;20090512;20090512;AMRODeu;DE;Extern;;;;;0;0;0