GLRN_SET_VW

(SQL View)
 Index Back

Account Recon Set

Account Reconciliation Set that links Business Units, Recon Rules, and Unit of Recon.

SELECT A.GLRN_SET , A.DESCR60 FROM PS_GLRN_SET_TBL A WHERE A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_GLRN_SET_TBL X WHERE A.GLRN_SET = X.GLRN_SET)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GLRN_SET Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Set
2 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description