| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GPJP_TAX_ESTAB |
Character(15) |
VARCHAR2(15) NOT NULL |
Salary Payer Reference Number
Prompt Table:
GPJP_TAXESIT_VW
|
| 2 |
YEAR_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Select Calendar Year
1994=1994
1995=1995
1996=1996
1997=1997
1998=1998
1999=1999
2000=2000
2001=2001
2002=2002
2003=2003
2004=2004
2005=2005
2006=2006
2007=2007
2008=2008
2009=2009
2010=2010
2011=2011
2012=2012
2013=2013
2014=2014
2015=2015
2016=2016
2017=2017
2018=2018
2019=2019
2020=2020
|
| 3 |
MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
|
| 4 |
SRC_BANK_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table:
SRC_BANK
|
| 5 |
MUNICIPAL_CD_JPN |
Character(6) |
VARCHAR2(6) NOT NULL |
Japanese Municipal Code
Prompt Table:
GPJP_IH_MUNIC
|
| 6 |
GPJP_IH_SPEC_CLC |
Character(12) |
VARCHAR2(12) NOT NULL |
Used in Inhabitant Tax Data for GP/Japan.
|
| 7 |
GPJP_IH_TRNSFR |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 8 |
GPJP_IH_SAL_REC |
Number(5,0) |
INTEGER NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 9 |
GPJP_IH_SAL_RECC |
Character(5) |
VARCHAR2(5) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 10 |
GPJP_IH_SAL_TOT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 11 |
GPJP_IH_SAL_TOTC |
Character(9) |
VARCHAR2(9) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 12 |
GPJP_IH_RET_REC |
Number(5,0) |
INTEGER NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 13 |
GPJP_IH_RET_RECC |
Character(5) |
VARCHAR2(5) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 14 |
GPJP_IH_RET_TOT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 15 |
GPJP_IH_RET_TOTC |
Character(9) |
VARCHAR2(9) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 16 |
GPJP_IH_TAX_REC |
Number(5,0) |
INTEGER NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 17 |
GPJP_IH_TAX_RECC |
Character(5) |
VARCHAR2(5) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 18 |
GPJP_IH_TAX_TOT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 19 |
GPJP_IH_TAX_TOTC |
Character(9) |
VARCHAR2(9) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 20 |
GPJP_IH_RETIREES |
Number(3,0) |
SMALLINT NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 21 |
GPJP_IH_RETIREESC |
Character(3) |
VARCHAR2(3) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 22 |
GPJP_IH_RET_AMT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 23 |
GPJP_IH_RET_AMTC |
Character(10) |
VARCHAR2(10) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 24 |
GPJP_IH_TAX_AMT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 25 |
GPJP_IH_TAX_AMTC |
Character(9) |
VARCHAR2(9) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 26 |
GPJP_IH_PRFCTR_AMT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 27 |
GPJP_IH_PRFCT_AMTC |
Character(9) |
VARCHAR2(9) NOT NULL |
Used in Inhabitant Tax File creation process.
|
| 28 |
CITY_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Character City
|