The COSY import file contains accounting records that are imported into ITAS using ERPIMP.

The COSY import is available to ITAS companies that have Operating Interface ‘COSY’ nominated in S01. There is the option in S01 to choose to automatically authorise documents that are imported {ctrl02_sapautopost}.

The import file location is specified in S01>Overall Control>ITAS/SAP File Path. This file location is universal to all ITAS companies that use the COSY import process. The naming of the import files is structured to allow different companies to process only the files applicable to them. COSY import files begin ‘IS Performis_XX_’ where ‘XX’ is the unique company code which is nominated in S01>View>COSY Import Parameters>Company Code.

The COSY import file is a comma delimited file with a .TXT extension. An individual document is made up of three different record types. The record type is determined by the character stored in the first column of each line in the import file.

Record Type B = Document Header

H = P&L Leg

N = CLI Leg

The end of a document is indicated by ‘;’ on the CLI Leg.

The format of each record type can be seen below.

Header Record
Seq	COSY Field Name	ITAS Field Name	Description	Format	Comment
1	Record Type		B for Voucher record	Text 1
2	Visum		Responsible Person	Text 3
3	Company Number		Company Number	Number 6
4	Voucher Type	dhl21_doctype	Invoice Type (IPu, ISa, ICo, ISe)	Text 3	Document Type(dhl21_doctype) If IPu or ISa or ICo then 1 If ISe then 2 Nominated Expence Code(dhlxx_expcode) If IPu then ctrl06_purchaseinv If ISa then ctrl06_saleinv If ICo then ctrl06_physcomsn If ISe then ctrl06_accrualcosts Document Reference(dhl21_docref) If IPu or ISa or ICo then next PI DocRef If ISe then next SI DocRef
5	Voucher Number	dhl21_secref	Voucher No. from COSY	Text 10
6	Period		Booking period		Always Blank
7	Booking Date	dhl21_ddate	Booking Date	Number 8	YYYYMMDD
8	Value Date		Issue Date	Number 8	YYYYMMDD
9	Budget Code		Budget Code	Text 1	Always I
10	Currency	dhl21_ccy	Payment currency = voucher currency	Text 3
11	ROE		Exchange Rate		Ignored by ITAS
12	Accounting Circle		Debit/Credit	Text 1	D for Debit K for Credit
13	Origin of the Voucher		Origin of voucher (VOW)	Text 3
14	BRW_VERB_ STATUS				Always Blank
15	BRW_VERB_ JOURNAL				Always Blank

P&L Leg
Seq	COSY Field Name	ITAS Field Name	Description	Format	Comment
1	Record Type	dhlxx_ledger	H for general ledger	Text 1	dhlxx_ledger = "N"
2	Account	dhlxx_account	Profit/Loss/Tax Account	Text 10	Do not read last 2 chars of code as refers to ccy code. Maps with ITAS Alternate NOM code
3	TEXT	dhlxx_narr	Booking text	Text n
4	ROE		Exchange Rate		Ignored by ITAS
5	Debit Amount	dhlxx_amount		Number 12,2
6	Credit Amount	dhlxx_amount		Number 12,2
7	KSTNR				Always Blank
8	KTR_AUFNR				Always Blank
9	Asset Nr				Always Blank
10	Country Code				Always Blank
11	Org. Unit/Department	dhlxx_dept	Organization Unit/Department	Text 8	Use only the last 2 chars. Maps with ITAS Alternate Department code
12	Tax Code	dhlxx_vatcd		Text 7	Tax Code to use if Tax Booking = “S” If Vat leg then dhlxx_dhltype = 2 Else dhlxx_dhltype = 20
13	Base for tax				Ignored by ITAS
14	Tax Rate		Tax Rate	Number 3,2	Ignored by ITAS
15	ROE for Tax		Tax Exchange Rate		Ignored by ITAS
16	Tax booking			Text 1	Tax booking = "S" if Tax Code Exported = True
17	Tax-Quote				Always Blank

CLI Leg
Seq	COSY Field Name	ITAS Field Name	Description	Format	Comment
1	Record Type	dhlxx_ledger	N for CLI Accounts	Text 1	dhlxx_ledger = C
2	Account	dhlxx_account	Debit or Credit Account of partner	Text 10	Maps with CLI SIB CODE (do not read last 2 characters of COSY account code)
3	TEXT	dhlxx_narr	Booking text	Text n
4	ROE		Exchange Rate		Ignored by ITAS
5	Debit	dhlxx_amount		Number 12,2
6	Credit	dhlxx_amount		Number 12,2
7	Collect Account				Always Blank
8	Reference Creditor	dhlxx_cliref	Reference of Creditor
9	OP_BETRAG				Always Blank
10	REFERENZ (ESR)				Always Blank
11	Payment Term		Payment Term Code	Text 5	Ignored by ITAS
12	Due Date 1	dhl21_vdate/ dhlxx_vdate	Due Date	Number 8	YYYYMMDD
13	Discount				Always Blank
14	Due Date 2		Due date 2		Ignored by ITAS
15	Discount 2				Always Blank
16	Due Date 3		Due date 3		Ignored by ITAS
17	Discount 3				Always Blank
18	Voucher Type of cancelled invoice		Invoice type if cancellation of an invoice		Ignored by ITAS
19	Voucher number of cancellation		Voucher no if of cancellation		Ignored by ITAS
20	OP_KRIT1				Always Blank
21	OP_KRIT2				Always Blank
22	OP_KRIT3				Always Blank
23	OP_KRIT4				Always Blank
24	ESR_NR				Always Blank