WTHD_ENTITY_VW6

(SQL View)
 Index Back

Withholding Entity TIN Match


SELECT A.WTHD_ENTITY , A.DESCR FROM PS_WTHD_ENTITY_DFN 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: WTHD_ENT_VW6_LG

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