GPDE_ED_PNRGPDE_ED_SEAGPDE_RPA72_NRVW(SQL View) |
Index Back |
|---|---|
Temporary Table AL07enthaelt die Earnings/Deductions/Accumulatoren fuer den Report:'GPCHAL07' |
| SELECT GPDE_ED_PNR + 50000000 , GPDE_ED_SEA , GPDE_ED_SEQ , GPDE_ED_SIG , GPDE_ED_ORD , GPDE_ED_GRO , FROMDATE , TO_DATE FROM PS_GPDE_RP_AL07_2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPDE_ED_PNR |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | GPDE_ED_SEA |
Number(6,0) | INTEGER NOT NULL | Sequence |
| 3 | GPDE_ED_SEQ | Number(8,0) | INTEGER NOT NULL | Sequence |
| 4 | GPDE_ED_SIG | Number(2,0) | SMALLINT NOT NULL | Sign |
| 5 | GPDE_ED_ORD | Number(6,0) | INTEGER NOT NULL | Print Order |
| 6 | GPDE_ED_GRO | Number(2,0) | SMALLINT NOT NULL | Group Order |
| 7 | FROMDATE | Date(10) | DATE | From Date |
| 8 | TO_DATE | Date(10) | DATE | Latest Date to be sent to PYR |