ESTABIDPrompt Table: GPIN_YE_HDR_F5
CAL_PRD_IDPrompt Table: GPIN_YE_HDR_F5
GPIN_MONTHAPR=April
AUG=August
DEC=December
FEB=February
JAN=January
JUL=July
JUN=June
MAR=March
MAY=May
NOV=November
OCT=October
SEP=September
GPIN_VCHR_DTGPIN_YE_F5(SQL Table) |
Index Back |
|---|---|
Form 5 Setup detailsForm 5 Setup details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: GPIN_YE_HDR_F5 |
| 2 | CAL_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table: GPIN_YE_HDR_F5 |
| 3 | 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 |
| 4 | GPIN_VCHR_DT |
Date(10) | DATE | Voucher Date |
| 5 | GPIN_TAX_DED | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Tax Deducted For Month |
| 6 | GPIN_TAX_PAID | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Sal Package - Tax Monthly |
| 7 | GPIN_BAL_TAX | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | This field holds the difference between the actual Tax paid till date and the Projected Tax. |
| 8 | GPIN_VCHR_NBR | Character(10) | VARCHAR2(10) NOT NULL | Voucher Number |