WTHD_RPT_IDDefault Value: WTHD_RPT_DFN.WTHD_RPT_ID
Prompt Table: WTHD_RPT_DFN
LINE_NOPrompt Table: WTHD_RPT_LN
WTHD_TYPEPrompt Table: WTHD_TYPE_TBL
WTHD_JUR_CDPrompt Table: WTHD_JUR_TBL
WTHD_CLASSPrompt Table: WTHD_CLASS_TBL
Y/N Table Edit
WTHD_RPT_DTL(SQL Table) |
Index Back |
|---|---|
Withholding Report Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WTHD_RPT_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Withholding Report ID
Default Value: WTHD_RPT_DFN.WTHD_RPT_ID Prompt Table: WTHD_RPT_DFN |
| 2 | LINE_NO |
Number(3,0) | SMALLINT NOT NULL |
Line Number
Prompt Table: WTHD_RPT_LN |
| 3 | WTHD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Type
Prompt Table: WTHD_TYPE_TBL |
| 4 | WTHD_JUR_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
Prompt Table: WTHD_JUR_TBL |
| 5 | WTHD_CLASS |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Class
Prompt Table: WTHD_CLASS_TBL |
| 6 | INCLUDE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
include flag
Y/N Table Edit |