PY_LIABEXPFLGE=GL Expense
L=GL Liability
R=GL Employer's Liability
PYGL_TAX_COUNTRYCAN=Canada
USA=United States
PYGL_GROUP_TYPEF=Federal
L=Local
P=Provincial
S=State
PYGL_TAX_CLASSPY_TAX_GL_CL_VW(SQL View) |
Index Back |
|---|---|
Tax Classes for GLGL Tax Class View |
| SELECT PY_LIABEXPFLG ,PYGL_TAX_COUNTRY ,PYGL_GROUP_TYPE ,PYGL_TAX_CLASS ,DESCR FROM PS_PY_TAX_GL_CLASS WHERE(%Substring(PYGL_TAX_CLASS, 1, 1) NOT IN ('Z')) |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |