VLN_WTHD_TMP(SQL Table) |
Index Back |
|---|---|
Voucher Line Withhold Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL |
Voucher Line Number
Default Value: VOUCHER_LINE.VOUCHER_LINE_NUM |
| 4 | WTHD_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Entity
Prompt Table: VWTHD_ENTITY_VW |
| 5 | WTHD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Type
Prompt Table: VWTHD_TYPE_VW |
| 6 | WTHD_JUR_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
Prompt Table: VWTHD_JUR_VW |
| 7 | WTHD_CLASS |
Character(5) | VARCHAR2(5) NOT NULL |
Withholding Class
Prompt Table: VWTHD_CLASS_VW |
| 8 | WTHD_RULE | Character(5) | VARCHAR2(5) NOT NULL |
Withholding Rule
Prompt Table: WTHD_RULE_HDR |
| 9 | WTHD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 10 | WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099 G=Global T=1099 Y/N Table Edit |
| 11 | WTHD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Apply Withholding
P=Withhold at Payment V=Withhold at Voucher Posting Default Value: P |
| 12 | WTHD_CONT_REF | Character(15) | VARCHAR2(15) NOT NULL | Contract Reference |