GPCH_TX_TMP(SQL Table) |
Index Back |
|---|---|
Source Tax Table CHESwiss Source Tax Table - Header record for each Canton - Temporary record. Filled by AE program GPCH_STX (automatic load of the tariff codes) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPCH_TX_CANTON |
Character(2) | VARCHAR2(2) NOT NULL |
Canton
Prompt Table: GPCH_SI_STCD_VW |
| 2 | GPCH_TX_PCT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Percent Type
0=General 1=Municipal Default Value: 0 |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | GPCH_TX_RPT | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Tax Cycle
J=Annually M=Monthly Q=Quarterly Default Value: M |
| 6 | GPCH_TX_MAX_CHLDRN | Character(1) | VARCHAR2(1) NOT NULL | Maximum Children |
| 7 | GPCH_TX_FRQ | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Tax Basis
J=Annually M=Monthly Default Value: M |