PY_TXGLCL_VW_LN

(SQL View)
 Index Back

Rel Lan Table for GL Tax Class

Related Language Table for GL Tax Classes View

SELECT A.PY_LIABEXPFLG ,A.PYGL_TAX_COUNTRY ,A.PYGL_GROUP_TYPE ,A.PYGL_TAX_CLASS ,A.LANGUAGE_CD ,A.DESCR FROM PS_PY_TAX_GLCL_LNG A

  • Related Language Record for PY_TAX_GL_CL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PY_LIABEXPFLG Character(1) VARCHAR2(1) NOT NULL Liability / Expense Flag
    E=GL Expense
    L=GL Liability
    R=GL Employer's Liability
    2 PYGL_TAX_COUNTRY Character(3) VARCHAR2(3) NOT NULL Federal Tax Country
    CAN=Canada
    USA=United States
    3 PYGL_GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Activity Grouping Type
    F=Federal
    L=Local
    P=Provincial
    S=State
    4 PYGL_TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Class Description
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description