WTHD_CD_VNDR_LG

(SQL View)
Index Back

Withholding Code Header


select b.wthd_entity, a.setid, a.wthd_cd, a.language_cd, a.descr from ps_wthdcd_lang a, PS_WTHD_CD_DTL b where a.setid = b.setid and a.wthd_cd = b.wthd_cd

  • Related Language Record for WTHD_CD_VNDR_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    3 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description