ALTX_ALT_BL_VW

(SQL View)
Index Back

SELECT DISTINCT a.setid , a.account , a.altacct FROM ps_altacct_xref a , PS_GL_ACCOUNT_TBL b WHERE a.account = b.account AND b.statistics_account = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 ALT_ACCT_SUSPENSE Character(10) VARCHAR2(10) NOT NULL Alt->Acct Suspense
3 ACCT_ALT_SUSPENSE Character(10) VARCHAR2(10) NOT NULL Acct->Alt Suspense