index back

Translate Value

SELECT a.fieldname ,a.fieldvalue ,a.language_cd ,a.xlatshortname ,a.xlatlongname FROM PSXLATITEMLANG a WHERE a.fieldname = 'TAX_CLASS_CAN' AND a.fieldvalue NOT IN ('ALL', 'CBT','CPA','QBT','TRV','TT4','HTX','PYT') AND %EffdtCheck(PSXLATITEMLANG, a, %CurrentDateIn)

  • Related language record for CAN_TAX_CLSS_VW
  • PeopleSoft Field Name Field Type Column Type Description
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20