VCHR_LINE_WTHD(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 | OVERRIDE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Override Rule Type Parameters
Default Value: N |
| 10 | WTHD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 11 | WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099 G=Global T=1099 Y/N Table Edit |
| 12 | WTHD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Apply Withholding
P=Withhold at Payment V=Withhold at Voucher Posting Default Value: VCHR_PANELS_WRK.WTHD_APPL_FLG |
| 13 | WTHD_CONT_REF | Character(15) | VARCHAR2(15) NOT NULL | Contract Reference |
| 14 | WTHD_CALC_BASIS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Calculated Basis Amount |
| 15 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Currency
Default Value: VOUCHER.TXN_CURRENCY_CD |