WTHD_ENT_VW6_LG

(SQL View)
 Index Back

Withholding Entity TIN Match


SELECT A.WTHD_ENTITY , A.LANGUAGE_CD , A.DESCR FROM PS_WTHDENTITY_LANG A , PS_WTHD_ENT_FIELDS B WHERE B.WTHD_ENTITY = A.WTHD_ENTITY AND B.FIELDNAME = 'AP_TIN_STATUS_CD' AND (B.REQUIRED_FLAG = 'Y' OR B.OPTIONAL_FLG = 'Y')

  • Related Language Record for WTHD_ENTITY_VW6

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description