GPES_PMTRTO_DEF(SQL Table) |
Index Back |
---|---|
FAN retro override setupFAN payment retro override setup |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPES_RTR_OVRD_ID | Character(8) | VARCHAR2(8) NOT NULL | Retro override definition ID |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: GPES_PMTRTO_DEF.DESCR |
4 | GPES_RTR_OVRD_PRTY | Number(3,0) | SMALLINT NOT NULL | FAN file payment type override priority |
5 | GPES_PIN_RO1_NUM | Number(8,0) | INTEGER NOT NULL |
Retro override value 1
Prompt Table: %GP_EDIT_FLD1 |
6 | GPES_RTR_ENT_TYPE1 | Character(3) | VARCHAR2(3) NOT NULL |
FAN retro override element type 1
Prompt Table: GPES_ENT_RTO_VW |
7 | GPES_RTO_CFG_EDT1 | Character(18) | VARCHAR2(18) NOT NULL |
Retro override prompt record 1
Prompt Table: PSRECDEFN_VW |
8 | GPES_PIN_RO2_NUM | Number(8,0) | INTEGER NOT NULL |
Retro override value 2
Prompt Table: %GP_EDIT_FLD2 |
9 | GPES_RTR_ENT_TYPE2 | Character(3) | VARCHAR2(3) NOT NULL |
FAN retro override element type 2
Prompt Table: GPES_ENT_RTO_VW |
10 | GPES_RTO_CFG_EDT2 | Character(18) | VARCHAR2(18) NOT NULL |
Retro override prompt record 2
Prompt Table: PSRECDEFN_VW |
11 | GPES_PIN_RO3_NUM | Number(8,0) | INTEGER NOT NULL |
Retro override value 3
Prompt Table: %GP_EDIT_FLD3 |
12 | GPES_RTR_ENT_TYPE3 | Character(3) | VARCHAR2(3) NOT NULL |
FAN retro override element type 3
Prompt Table: GPES_ENT_RTO_VW |
13 | GPES_RTO_CFG_EDT3 | Character(18) | VARCHAR2(18) NOT NULL |
Retro override prompt record 3
Prompt Table: PSRECDEFN_VW |
14 | GPES_PIN_RO4_NUM | Number(8,0) | INTEGER NOT NULL |
Retro override value 4
Prompt Table: %GP_EDIT_FLD4 |
15 | GPES_RTR_ENT_TYPE4 | Character(3) | VARCHAR2(3) NOT NULL |
FAN retro override element type 4
Prompt Table: GPES_ENT_RTO_VW |
16 | GPES_RTO_CFG_EDT4 | Character(18) | VARCHAR2(18) NOT NULL |
Retro override prompt record 4
Prompt Table: PSRECDEFN_VW |
17 | GPES_PIN_RO5_NUM | Number(8,0) | INTEGER NOT NULL |
Retro override value 5
Prompt Table: %GP_EDIT_FLD5 |
18 | GPES_RTR_ENT_TYPE5 | Character(3) | VARCHAR2(3) NOT NULL |
FAN retro override element type 5
Prompt Table: GPES_ENT_RTO_VW |
19 | GPES_RTO_CFG_EDT5 | Character(18) | VARCHAR2(18) NOT NULL |
Retro override prompt record 5
Prompt Table: PSRECDEFN_VW |
20 | GPES_PIN_RO6_NUM | Number(8,0) | INTEGER NOT NULL |
Retro override value 6
Prompt Table: %GP_EDIT_FLD6 |
21 | GPES_RTR_ENT_TYPE6 | Character(3) | VARCHAR2(3) NOT NULL |
FAN retro override element type 6
Prompt Table: GPES_ENT_RTO_VW |
22 | GPES_RTO_CFG_EDT6 | Character(18) | VARCHAR2(18) NOT NULL |
Retro override prompt record 6
Prompt Table: PSRECDEFN_VW |