GPNZ_RCN_P_VW

(SQL View)
 Index Back

reconciliaiton pay entity

Pay Entity prompt record used in PDR reconciliaiton

SELECT A.PAY_ENTITY , B.DESCR FROM PS_GPNZ_PYENT_DTL A , PS_GP_PYENT B WHERE GPNZ_IRD_NUMBER <> ' ' AND A.PAY_ENTITY = B.PAY_ENTITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description