GPIN_IT_PAN_NBRGPIN_IT_TAN_NBRGPIN_PERIOD_IDCAL_PRD_IDPrompt Table: GP_CAL_PRD
Default Value: IND
Prompt Table: GPIN_YE_BNK_VW
Prompt Table: GPIN_YE_BKBR_VW
GPIN_YE_F24_F16(SQL Table) |
Index Back |
|---|---|
Form 16 & Form 24 setupThis Record is for the Form 16 and Form 24 Setup |
| # | 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 | CAL_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table: GP_CAL_PRD |
| 5 | GPIN_VCHR_NBR | Character(10) | VARCHAR2(10) NOT NULL | Voucher Number |
| 6 | GPIN_VCHR_DT | Date(10) | DATE | Voucher Date |
| 7 | GPIN_VCHR_AMT | Character(30) | VARCHAR2(30) NOT NULL | The remittance amount to the central government on a monthly basis. |
| 8 | COUNTRY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Country Code
Default Value: IND |
| 9 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL |
Bank ID
Prompt Table: GPIN_YE_BNK_VW |
| 10 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL |
Bank Branch ID
Prompt Table: GPIN_YE_BKBR_VW |
| 11 | GPIN_CHEQUE_NO | Character(10) | VARCHAR2(10) NOT NULL | This field holds the Cheque Number |