CAN_TAX_CLSS_VW

index back

Translate Value


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

  • Related language record: CAN_TAX_CLSS_LN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    FIELDVALUECharacter(4)VARCHAR2(4) NOT NULLField Value
    XLATSHORTNAMECharacter(10)VARCHAR2(10) NOT NULLTranslate Value Short Name
    XLATLONGNAMECharacter(30)VARCHAR2(30) NOT NULLTranslate Long Name
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19