PYGL_TAX_COUNTRYCAN=Canada
USA=United States
PYGL_GROUP_TYPEF=Federal
L=Local
P=Provincial
S=State
PYGL_TAX_CLASSPYGL_FEDTXCL_VW(SQL View) |
Index Back |
|---|
| SELECT PYGL_TAX_COUNTRY , PYGL_GROUP_TYPE , PYGL_TAX_CLASS , DESCR FROM PS_PY_TAX_GL_CLASS WHERE PY_LIABEXPFLG = 'E' |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |