GPNL_NRP_PSACVW

(SQL View)
Index Back

Export View.- Payslip Acum.

Export View.- Payslip Acumulator

SELECT GPNL_PAYSLIP_ID , GPNL_ELEMENT_ORD , GPNL_PIN_PS1_NUM + 50000000 , GPNL_ELEM_DESCR , DESCR FROM PS_GPNL_PSLIP_ACUM

  • Related Language Record: GPNL_PSLPAC_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPNL_PAYSLIP_ID Character(6) VARCHAR2(6) NOT NULL Pay Slip Identification
    2 GPNL_ELEMENT_ORD Number(9,2) DECIMAL(8,2) NOT NULL Print Order of the element in payslip
    3 GPNL_PIN_PS1_NUM Number(8,0) INTEGER NOT NULL Pay slip Pin Number
    4 GPNL_ELEM_DESCR Character(1) VARCHAR2(1) NOT NULL Source for the description of an element in payslip
    E=Element
    T=User Text

    Default Value: E

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description