GPIN_ITCS_CALC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPIN_ITCS_TMPL_ID	Character(20)	VARCHAR2(20) NOT NULL	Used to store Template ID for IT Computaion Sheet Template.
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	GPIN_COMP_CD	Character(4)	VARCHAR2(4) NOT NULL	IT Computation calulation codes 10=Perquisites 100=Capital Gain 110=Capital Loss 120=Income from Other Sources 125=Section 80EE 130=Gross Total Income 140=Less Deduction U/c VIA 150=Taxable Income(Rounded) 160=Tax Payable on Total Income 170=Tax Payable 180=Add Surcharge 185=Less Tax Credit 87A 190=Add Cess 191=Total Tax Payable 192=Less: Tax borne by Employer 20=Previous Employer Income 200=Total Tax Payable 210=Less Tax Recovered 220=Current Month TDS 30=Gross Salary 40=Less Exemptions U/s 10 50=Net Salary 60=Tax on Employment 70=Net Taxable Salary 80=Income from House Prope 90=Loss from House Proprty
4	KEY_SERIAL_NBR	Number(5,0)	INTEGER NOT NULL	This is an internal serial number for a Configurable Matrix key, used to indirectly associate a key combination with a data pointer.
5	GPIN_ITCS_LBL	Character(60)	VARCHAR2(60) NOT NULL	IT Computaion Sheet Customizable Labels
6	GPIN_ENTRY_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Elements entry type for India used in IT Computaion Sheet. AC=Accumulators DD=Deductions ER=Earnings FM=Formulas VR=Variables Default Value: ER
7	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPIN_IT_ACUM_VW