GPIN_IT_PAN_NBRGPIN_IT_TAN_NBRGPIN_PERIOD_IDGPIN_QUARTER_ID10=Q1
20=Q2
30=Q3
40=Q4
GPIN_F16_AK_DTL(SQL Table) |
Index Back |
|---|---|
Form 16 Acknowledgement DetailThis Record is to store the Acknowledgement Details for Form 16 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPIN_IT_PAN_NBR |
Character(30) | VARCHAR2(30) NOT NULL | This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Permanent Account Number. |
| 2 | GPIN_IT_TAN_NBR |
Character(30) | VARCHAR2(30) NOT NULL | This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Tax Deduction Account Number. |
| 3 | GPIN_PERIOD_ID |
Character(10) | VARCHAR2(10) NOT NULL | This Field Defines the Period ID for India Specific |
| 4 | GPIN_QUARTER_ID |
Character(2) | VARCHAR2(2) NOT NULL |
This field specifies which quarter of the year payment is being made
10=Q1 20=Q2 30=Q3 40=Q4 |
| 5 | GPIN_ACK_NUM | Character(15) | VARCHAR2(15) NOT NULL | This record is used to store the Acknowledgement details of each Quarter for Form16 |