GPDE_TX_XMLFILE (SQL Table)	Index Back
Tax Statement File Attachment This record stores up to 4 rows for each tax file which is sent to and receieved from the Ministry of Finance for Global Payroll Germany. The first file is the Tax Statement. The second is the incoming file with the Ticket Number. The third file is the outgoing request for the Status file. The fourth file is the incoming Status file.

GPDE_TX_XMLFILE

(SQL Table)

Tax Statement File Attachment

This record stores up to 4 rows for each tax file which is sent to and receieved from the Ministry of Finance for Global Payroll Germany. The first file is the Tax Statement. The second is the incoming file with the Ticket Number. The third file is the outgoing request for the Status file. The fourth file is the incoming Status file.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPDE_ELSTER_TKT Character(20) VARCHAR2(20) NOT NULL Ticket number returned from ELSTER messaging process representing a particular group of tax statement data sent to ELSTER.

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

3 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

4 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

5 GPDE_XML_TAX_INFO Long Character CLOB This field represents a push button to view the XML tax data info for the Global Payroll Germany's new ELSTER tax process.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPDE_ELSTER_TKT	Character(20)	VARCHAR2(20) NOT NULL	Ticket number returned from ELSTER messaging process representing a particular group of tax statement data sent to ELSTER.
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
4	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
5	GPDE_XML_TAX_INFO	Long Character	CLOB	This field represents a push button to view the XML tax data info for the Global Payroll Germany's new ELSTER tax process.