GPDE_RPA71_NRVW (SQL View)	Index Back
Temporary Table AL07 enthaelt die Accumulatoren fuer den Report:'GPDEAL07' enthaelt Calendar Run ID's fur den Report :'GPDEAL09'

GPDE_RPA71_NRVW

(SQL View)

Temporary Table AL07

enthaelt die Accumulatoren fuer den Report:'GPDEAL07' enthaelt Calendar Run ID's fur den Report :'GPDEAL09'

SELECT GPDE_AC_PNR+ 50000000 , GPDE_AC_SEQ , CAL_RUN_ID , GPDE_AC_SIG FROM PS_GPDE_RP_AL07_1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPDE_AC_PNR Number(8,0) INTEGER NOT NULL PIN Number

2 GPDE_AC_SEQ Number(8,0) INTEGER NOT NULL Sequence

3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

4 GPDE_AC_SIG Number(2,0) SMALLINT NOT NULL Sign

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPDE_AC_PNR	Number(8,0)	INTEGER NOT NULL	PIN Number
2	GPDE_AC_SEQ	Number(8,0)	INTEGER NOT NULL	Sequence
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	GPDE_AC_SIG	Number(2,0)	SMALLINT NOT NULL	Sign