GPDE_TX_RELIGIO(SQL Table) |
Index Back |
---|---|
Church Tax TableChurch Tax table/religion |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPDE_TX_CHRCHSTATE | Character(2) | VARCHAR2(2) NOT NULL |
Church State
01=Schleswig-Holstein 02=Hamburg 03=Niedersachsen 9 % 04=Bremen 05=Nordrhein-Westfalen 06=Hessen 07=Rheinland-Pfalz 08=Baden-Wurtemberg 09=Bayern 10=Saarland 11=Berlin 12=Brandenburg 13=Mecklenburg-Vorpommern 14=Sachsen 15=Sachsen-Anhalt 16=Thuringen 17=Stadt Bremerhaven 18=Oberfinanzdirektion Kiel 93=Niedersachsen 8 % |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | GPDE_TX_RELIGION | Character(3) | VARCHAR2(3) NOT NULL |
Religion
00=No confession 01=Roman Catholic 02=Old Catholic 03=Evangical Lutheran 04=Evangical Ref. 05=French Reform i.0. 06=Free Religion Baden 07=Israelite 08=Religion Tax Rheinland Pfalz 09=Free Religion Offenbach 10=Free Religion Mainz 11=Israelite Religion Baden 12=Israelite Religion Wurttemberg 13=Israelite Religion Frankfurt/M 14=Israelite Religion Country 15=Free Religion Pfalz 16=Free Religion Comunity Alzey 17=Jewish Culture Tax HH 18=Jewish Culture Tax SH |
4 | GPDE_TX_RATE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Tax Rate |
5 | GPDE_TX_MIN_MONLY | Number(11,2) | DECIMAL(10,2) NOT NULL | Monthly Minimum Tax |
6 | GPDE_TX_MON_CUR | Character(3) | VARCHAR2(3) NOT NULL |
Monthly Min Tax Currency
Default Value: DEM Prompt Table: CURRENCY_CD_TBL |
7 | GPDE_TX_MIN_DAILY | Number(7,2) | DECIMAL(6,2) NOT NULL | Daily Minimum Tax |
8 | GPDE_TX_DAY_CUR | Character(3) | VARCHAR2(3) NOT NULL |
Daily Min Tax Currency
Default Value: DEM Prompt Table: CURRENCY_CD_TBL |
9 | GPDE_TX_MAX_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Percent |