STATELANGUAGE_CDEFFDTDefault Value: %date
STATE_TAX_LANG(SQL Table) |
Index Back |
|---|---|
Related Lang for STATE_TAX_TBLThis record is used to identify the general type of withholding tax calculation employed by each jurisdiction and provides all the constants needed by the calculation routines for income tax withholding. This table is maintained by PeopleSoft. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | SPECIAL_DESCR_1 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 1 |
| 5 | SPECIAL_DESCR_2 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 2 |
| 6 | SPECIAL_DESCR_3 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 3 |
| 7 | SPECIAL_DESCR_4 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 4 |
| 8 | SPECIAL_DESCR_5 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 5 |
| 9 | SPECIAL_DESCR_6 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 6 |
| 10 | SPECIAL_DESCR_7 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 7 |
| 11 | SPECIAL_DESCR_8 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 8 |
| 12 | SPECIAL_DESCR_9 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 9 |
| 13 | SPECIAL_DESCR_10 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 10 |
| 14 | SPECIAL_DESCR_11 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 11 |
| 15 | SPECIAL_DESCR_12 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 12 |
| 16 | SPECIAL_DESCR_13 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 13 |
| 17 | SPECIAL_DESCR_14 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 14 |
| 18 | SPECIAL_DESCR_15 | Character(30) | VARCHAR2(30) NOT NULL | Special Tax Amount Descr 15 |