GLRN_RECONS_VW2

(SQL View)
Index Back

GL Acct Recon drilldown view

GL Acct Recon drilldown view

SELECT DISTINCT A.DESCR , B.USERID ,B.GLRN_SET ,B.GLRN_RULE ,B.BUSINESS_UNIT ,B.AS_OF_DATE ,B.SEQUENCE_NBR_9 FROM PS_GLRN_CONFIG_USR A , PS_GLRN_RECON_ASGN B WHERE A.GLRN_USER_FUNCTION = B.GLRN_USER_FUNCTION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DESCR Character(30) VARCHAR2(30) NOT NULL Description
2 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
3 GLRN_SET Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Set
4 GLRN_RULE Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Rule ID
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 AS_OF_DATE Date(10) DATE As of Date
7 SEQUENCE_NBR_9 Number(9,0) DECIMAL(9) NOT NULL Sequence