GPJP_IH_PYE_TX2 (SQL Table)	Index Back
EE Inhabitant Tax detail data This record could contain one record with an Inhabitant Tax amount for each month during the year for each employee. For Tokyo, it will contain a record for the amount to be paid in June and a record for the amount to be paid in July through May.

GPJP_IH_PYE_TX2

(SQL Table)

EE Inhabitant Tax detail data

This record could contain one record with an Inhabitant Tax amount for each month during the year for each employee. For Tokyo, it will contain a record for the amount to be paid in June and a record for the amount to be paid in July through May.

Parent record: GPJP_IH_PYE_TAX

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 BEGIN_DT Date(10) DATE NOT NULL Begin Date

4 END_DATE Date(10) DATE NOT NULL End Date

5 TAX_AMT Number(11,2) DECIMAL(10,2) NOT NULL One-Time Tax Amount

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: JPY
Prompt Table: CURRENCY_CD_TBL

7 GPJP_IH_STATUS Character(1) VARCHAR2(1) NOT NULL Load IH tax JPN
P=System Modified
U=User Modified
Default Value: U

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
4	END_DATE	Date(10)	DATE NOT NULL	End Date
5	TAX_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	One-Time Tax Amount
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: JPY Prompt Table: CURRENCY_CD_TBL
7	GPJP_IH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Load IH tax JPN P=System Modified U=User Modified Default Value: U