VCHR_WTHD_UPDT

(SQL Table)
Index Back

Request parameters for AE

Holds the request parameters used by application engine

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WITHHOLD_UPDATE_ID Character(30) VARCHAR2(30) NOT NULL Withhold update id
2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: SETID_VW

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUS_AP_NONVW

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_NAME_VW1

5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_AP_VW2

6 START_DATE Date(10) DATE Start Date for Gen Standing PO
7 END_DATE Date(10) DATE End Date
8 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity

Prompt Table: VWTHD_ENTITY_VW

9 CURRENT_WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding applicable flag
10 NEW_WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding applicable flag
N=No
Y=Yes
11 NEW_WTHD_SETID Character(5) VARCHAR2(5) NOT NULL Setid for the Withholding Code
12 NEW_WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withhold class

Prompt Table: VWTHD_CLASS_VW

13 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type

Prompt Table: VWTHD_TYPE_VW

14 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

Default Value: 0

15 UPDATE_STATUS_FLG Character(1) VARCHAR2(1) NOT NULL Gives status of the withholding update. When a user saves a request to update withholding the status will be PENDING until the Withhold Update AE is run at which point the status is set to UPDATED.
P=Pending Database Update
U=Database Updated
16 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction

Prompt Table: VWTHD_JUR_VW