GPES_PMTRTO_DEF

(SQL Table)
Index Back

FAN retro override setup

FAN payment retro override setup

  • Related Language Record: GPES_PMTRTO_LNG
  • # 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