GPIN_TDS_SETUP

(SQL Table)
Index Back

Tax setup pin table - India

Tax setup pin table - India

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %GP_EDIT_FLD7

2 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
4 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

Prompt Table: GP_ENT_GRPIN_VW

5 GPIN_SS_TD_ENABLE Character(1) VARCHAR2(1) NOT NULL Enable Self service.
N=No
Y=Yes

Default Value: N

6 GPIN_ITD_CATEGORY Character(2) VARCHAR2(2) NOT NULL The field is used to store the Income tax category.
10=CHAPTER VI A - 80CCC
20=CHAPTER VI A - 80C
30=CHAPTER VI A - Other
40=Other Income
50=Previous Employment Income
7 GPIN_DESCR_LONG Character(100) VARCHAR2(100) NOT NULL Long Description of the Element shown on the SS.
8 GPIN_TAX_REG_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Regime type i wil have Old, New or Both. this should ge assigned to the Earning/ Deduction. by default the valueis Old
B=Both
N=New Regime
O=Old Regime

Default Value: O