GPIN_NRP_TDS_AD(SQL Table) |
Index Back |
---|---|
Tax setup pin table - IndiaTax setup pin table - India |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GP_PKG_ID | Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
2 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
3 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
4 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
5 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Element Entry Type ID |
6 | GPIN_SS_TD_ENABLE | Character(1) | VARCHAR2(1) NOT NULL |
Enable Self service.
N=No Y=Yes |
7 | 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 |
8 | GPIN_DESCR_LONG | Character(100) | VARCHAR2(100) NOT NULL | Long Description of the Element shown on the SS. |
9 | 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 |