VCHR_LN_WTHD_WS(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
2 | WTHD_ENTITY | Character(5) | VARCHAR2(5) NOT NULL |
Withholding Entity
Prompt Table: WTHD_ENTITY_DFN |
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 | WTHD_RULE | Character(5) | VARCHAR2(5) NOT NULL |
Withholding Rule
Prompt Table: WTHD_RULE_HDR |
7 | WTHD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
8 | WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099 G=Global T=1099 Y/N Table Edit |