PMT_PAYEE_ID_VW(SQL View) |
Index Back |
---|---|
Payee ID Vw |
SELECT DISTINCT A.PARTY_SETID , A.PARTY_ID , B.XLATLONGNAME , A.NAME1 FROM PS_PMT_DETAIL_TBL A , PSXLATITEM B WHERE B.FIELDNAME='PARTY_ID_TYPE' AND B.FIELDVALUE=A.PARTY_ID_TYPE AND B.EFF_STATUS='A' AND B.EFFDT=( SELECT MAX(EFFDT) FROM PSXLATITEM WHERE FIELDNAME=B.FIELDNAME AND FIELDVALUE=B.FIELDVALUE AND EFFDT<=%CurrentDateIn) AND A.PARTY_ID <> ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PARTY_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | PARTY_ID | Character(30) | VARCHAR2(30) NOT NULL | Payee ID |
3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
4 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |