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 <> ' '

  • Related Language Record: PMT_PAYEEIDVWLG
  • # 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