| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 2 |
GPIN_YEAR_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Year-Character
|
| 3 |
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
|
| 4 |
GPIN_SR_NBR |
Number(6,0) |
INTEGER NOT NULL |
Serial Number
|
| 5 |
GPIN_MONTH |
Character(3) |
VARCHAR2(3) NOT NULL |
This is the month for which the Professional Tax is deducted.
APR=April
AUG=August
DEC=December
FEB=February
JAN=January
JUL=July
JUN=June
MAR=March
MAY=May
NOV=November
OCT=October
SEP=September
|
| 6 |
GPIN_TDS_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Tax Amount Detail
|
| 7 |
GPIN_TDS_SUR_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Surcharge
|
| 8 |
GPIN_TDS_CESS_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Educational Cess
|
| 9 |
GPIN_TDS_INT_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Field that holds the value of intrest
|
| 10 |
GPIN_TDS_OTH_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Field that holds Others amount
|
| 11 |
GPIN_VCHR_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Voucher Number
|
| 12 |
GPIN_VCHR_DT |
Date(10) |
DATE |
Voucher Date
|
| 13 |
GPIN_CHEQUE_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
This field holds the Cheque Number
|
| 14 |
GPIN_BSR_CODE |
Character(17) |
VARCHAR2(17) NOT NULL |
BDR Code of bank branch
Prompt Table:
GPIN_YE_BKBR_VW
|
| 15 |
GPIN_BK_ENT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Book Entry
B=Book Entry
C=Challan
Default Value: C
|
| 16 |
GPIN_TOTAL_CNT |
Number(6,0) |
INTEGER NOT NULL |
This field holds the total number of Employees
|
| 17 |
GPIN_SECTION_DTL |
Character(10) |
VARCHAR2(10) NOT NULL |
This field gives the section under which payment is being made.
|
| 18 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table:
GP_CAL_PRD
|
| 19 |
COUNTRY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
Default Value: IND
|
| 20 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
Prompt Table:
GPIN_YE_BNK_VW
|
| 21 |
GPIN_TDS_SECT_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Form 24Q - Tax Payment Section Codes
92A=Employees other than Union Gov
92B=Employees other than Gov
92C=Union Gov Employees
|
| 22 |
GPIN_LATE_FEE |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Late Fee
|
| 23 |
GPIN_MRHD_CHLN |
Character(3) |
VARCHAR2(3) NOT NULL |
Minor Head of Challan
200=TDS Payable by Taxpayer
400=TDS Regular Assessment(IT Dep)
|