ACCOUNTALTACCTAP_ALTACCT_VW(SQL View) |
Index Back |
|---|
| SELECT X.ACCOUNT , X.ALTACCT , MAX(A.DESCR) FROM PS_ALTACCT_XREF X , PS_ALTACCT_TBL A WHERE A.SETID = X.ALTACCT_SETID AND A.ALTACCT = X.ALTACCT AND A.EFFDT = ( SELECT MAX(T.EFFDT) FROM PS_ALTACCT_TBL T WHERE T.SETID = A.SETID AND T.ALTACCT = A.ALTACCT AND T.EFFDT <= %CurrentDateIn AND T.EFF_STATUS = 'A') GROUP BY X.ACCOUNT, X.ALTACCT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 2 | ALTACCT |
Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |