GPIN_TDS_SETUP(SQL Table) |
Index Back |
---|---|
Tax setup pin table - IndiaTax 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 |