GPDE_AL_PE_TX05

(SQL Table)
 Index Back

Tax Registration XML details

This record stores the tax Registration information sent to Elster sorted by Pay Entity and Month. It also stores additional tax information which can be entered on the run control page when values exist from other systems.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT

2 MONTH_XLAT Character(2) VARCHAR2(2) NOT NULL Month
01=01- January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
3 GPDE_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL For Year
4 GPDE_RP_TAX_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
5 GPDE_RP_SLDRTY_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
6 GPDE_RP_CHTXLE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
7 GPDE_RP_CHTXLC_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
8 GPDE_RP_CHTXLJ_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
9 GPDE_RP_LMP_TXPMKN Signed Number(20,6) DECIMAL(18,6) NOT NULL Lumpsum Tax Payment in Kind
10 GPDE_AL_SEQCE_NBR Number(2,0) SMALLINT NOT NULL Sequence
11 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
12 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.
13 GPDE_RP_CHTX_LMPS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result