CAN_TAX_PST_VW

index back

Translate Value


SELECT A.FIELDNAME , A.FIELDVALUE , A.XLATSHORTNAME , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'DED_SLSTX_CLASS' AND A.FIELDVALUE NOT IN ('B', 'G', 'H') AND %EffdtCheck(PSXLATITEM, A, %CurrentDateIn) AND EFF_STATUS = 'A'

  • Related language record: CAN_TAX_PST_LNG
  • 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
    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 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19