PMT_LANGUAGE_VW

(SQL View)
Index Back

SELECT LANGUAGE_CD , XLATSHORTNAME , XLATLONGNAME FROM PSLANGUAGES A , PSXLATITEM B WHERE B.FIELDNAME ='LANGUAGE_CD' AND B.FIELDVALUE = A.LANGUAGE_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PMT_PRIMARY_LANG Character(3) VARCHAR2(3) NOT NULL Mandate direct debit
2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name