TDS_QRETURN_ACK(SQL Table) |
Index Back |
|---|---|
TDS Quarterly ReturnTDS Quarterly Return Run control record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_AP_VW |
| 2 | WTHD_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Entity
Prompt Table: WTHD_ENTITY_DFN |
| 3 | CALENDAR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Calendar SetID
Prompt Table: SP_SETID_NONVW |
| 4 | CALENDAR_ID |
Character(2) | VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table: WTHD_CAL_VW3 |
| 5 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: WTHD_CAL_VW1 |
| 6 | PERIOD |
Number(3,0) | SMALLINT NOT NULL |
Period
Prompt Table: WTHD_CAL_VW2 |
| 7 | Q1_ACK_NUM | Character(20) | VARCHAR2(20) NOT NULL | Field to store the acknowledgement number for first quarter |
| 8 | Q2_ACK_NUM | Character(20) | VARCHAR2(20) NOT NULL | Field to store the acknowledgement number for 2nd quarter |
| 9 | Q3_ACK_NUM | Character(20) | VARCHAR2(20) NOT NULL | Field to store acknowledgement number for third quarter |
| 10 | Q4_ACK_NUM | Character(20) | VARCHAR2(20) NOT NULL | Field to Store acknowledgement number for fourth quarter |
| 11 | Q1_TAX_DED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deducted in Quarter 1.
Default Value: 0 |
| 12 | Q1_TAX_DEP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deposited in Quarter 1.
Default Value: 0 |
| 13 | Q2_TAX_DED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deducted in Quarter 2.
Default Value: 0 |
| 14 | Q2_TAX_DEP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount depositedin Quarter 2.
Default Value: 0 |
| 15 | Q3_TAX_DED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deducted in Quarter 3.
Default Value: 0 |
| 16 | Q3_TAX_DEP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deposited in Quarter 3.
Default Value: 0 |
| 17 | Q4_TAX_DED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deducted in Quarter 4.
Default Value: 0 |
| 18 | Q4_TAX_DEP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deposited in Quarter 4.
Default Value: 0 |