BUSINESS_UNITPrompt Table: SP_BU_AP_NONVW
WTHD_ENTITYPrompt Table: WTHD_ENTITY_DFN
CALENDAR_SETIDPrompt Table: SP_SETID_NONVW
CALENDAR_IDPrompt Table: WTHD_CAL_VW3
FISCAL_YEARPrompt Table: WTHD_CAL_VW1
PERIODPrompt Table: WTHD_CAL_VW2
TDS_QRET_ACK_VW(SQL View) |
Index Back |
|---|---|
TDS Quarterly ReturnTDS Quarterly Return Run control record |
| SELECT BUSINESS_UNIT , WTHD_ENTITY , CALENDAR_SETID , CALENDAR_ID , FISCAL_YEAR , PERIOD FROM PS_TDS_QRETURN_ACK |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 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 |