STATELOCALITYEFFDTDefault Value: %date
TAX_GRP_TYPETAX_CLASSPrompt Table: PY_TAX_CLASS
LOCL_TX_CLS_TBL(SQL Table) |
Index Back |
|---|---|
Local Tax Class TableContains tax classes grouped by tax type for a state and locality. Used by the US Tax Extract program. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 2 | LOCALITY |
Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | TAX_GRP_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Tax Type |
| 5 | TAX_CLASS |
Character(3) | VARCHAR2(3) NOT NULL |
Tax Balance Class
Prompt Table: PY_TAX_CLASS |