ESTABIDPrompt Table: ESTAB_TBL_GPIN
CAL_PRD_IDPrompt Table: GP_CAL_PRD
GPIN_YE_HDR_F5(SQL Table) |
Index Back |
|---|---|
Form 5 PT ReturnForm 5 PT Return |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL_GPIN |
| 2 | CAL_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table: GP_CAL_PRD |
| 3 | GPIN_TX_MON_SMT | Number(13,2) | DECIMAL(12,2) NOT NULL | Tax paid as per monthly Statement |
| 4 | GPIN_TX_PAYBL_YE | Number(13,2) | DECIMAL(12,2) NOT NULL | Total Tax Payable for the year ending |
| 5 | GPIN_BAL_TX_CHAL | Number(13,2) | DECIMAL(12,2) NOT NULL | Stores the Balance of Tax |
| 6 | GPIN_BAL_TX_PBLE | Number(13,2) | DECIMAL(12,2) NOT NULL | Balance Tax payable |
| 7 | GPIN_F5_DT | Date(10) | DATE | Challan Date |