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 | 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  |