PYGL_FTXCL_L_VW

(SQL View)
 Index Back

Rel. Lang. for PYGL_FEDTXCL_VW


SELECT A.PYGL_TAX_COUNTRY , A.PYGL_GROUP_TYPE , A.PYGL_TAX_CLASS , B.LANGUAGE_CD , B.DESCR FROM PS_PY_TAX_GL_CLASS A , PS_PY_TAX_GLCL_LNG B WHERE A.PY_LIABEXPFLG = B.PY_LIABEXPFLG AND A.PYGL_TAX_COUNTRY = B.PYGL_TAX_COUNTRY AND A.PYGL_GROUP_TYPE = B.PYGL_GROUP_TYPE AND A.PYGL_TAX_CLASS = B.PYGL_TAX_CLASS AND A.PY_LIABEXPFLG = 'E'

  • Related Language Record for PYGL_FEDTXCL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PYGL_TAX_COUNTRY Character(3) VARCHAR2(3) NOT NULL Federal Tax Country
    CAN=Canada
    USA=United States
    2 PYGL_GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Activity Grouping Type
    F=Federal
    L=Local
    P=Provincial
    S=State
    3 PYGL_TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Class Description
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description