GPES_NRP_RO1_VW

(SQL View)
 Index Back

FAN payment retro override

FAN payment retro override data

SELECT GPES_RTR_OVRD_ID , DESCR , DESCRSHORT , GPES_RTR_OVRD_PRTY , GPES_PIN_RO1_NUM + 50000000 , GPES_RTR_ENT_TYPE1 , GPES_RTO_CFG_EDT1 , GPES_PIN_RO2_NUM + 50000000 , GPES_RTR_ENT_TYPE2 , GPES_RTO_CFG_EDT2 , GPES_PIN_RO3_NUM + 50000000 , GPES_RTR_ENT_TYPE3 , GPES_RTO_CFG_EDT3 , GPES_PIN_RO4_NUM + 50000000 , GPES_RTR_ENT_TYPE4 , GPES_RTO_CFG_EDT4 , GPES_PIN_RO5_NUM + 50000000 , GPES_RTR_ENT_TYPE5 , GPES_RTO_CFG_EDT5 , GPES_PIN_RO6_NUM + 50000000 , GPES_RTR_ENT_TYPE6 , GPES_RTO_CFG_EDT6 FROM PS_GPES_PMTRTO_DEF

# 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