VENDOR_WTHD_75X

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
6 PRCNT_WTHHLD Number(6,2) DECIMAL(5,2) NOT NULL Percent Withheld
7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
8 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
10 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
11 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
12 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
13 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
14 CITY Character(30) VARCHAR2(30) NOT NULL City
15 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
16 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
17 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
18 COUNTY Character(30) VARCHAR2(30) NOT NULL County
19 STATE Character(6) VARCHAR2(6) NOT NULL State
20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
21 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
22 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

23 WTHD_IND Character(1) VARCHAR2(1) NOT NULL Withhold Rule Indicator
D=Default from Entity Definition
S=Specify at this Level
24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
25 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
26 BIRTHDATE Date(10) DATE Date of Birth
27 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location

Prompt Table: STATE_TBL

28 NUM_CHILDREN Number(3,0) SMALLINT NOT NULL Number of children
29 COMPANY_FLG Character(1) VARCHAR2(1) NOT NULL Company

Y/N Table Edit

Default Value: N

30 TAX_DIST_REF Character(13) VARCHAR2(13) NOT NULL Tax District Reference
31 CERTIFICATE_TYPE Character(1) VARCHAR2(1) NOT NULL Certificate type
32 CERTIFICATE_NUM Character(15) VARCHAR2(15) NOT NULL Certificate Number
33 CERTIFICATE_EXP_DT Date(10) DATE Certificate Expiration
34 DIRECT_SALES Character(1) VARCHAR2(1) NOT NULL Direct Sales of $5000 or More

Y/N Table Edit

Default Value: N

35 SECOND_TIN Character(1) VARCHAR2(1) NOT NULL IRS Notified Twice of Invalid

Y/N Table Edit

Default Value: N

36 STATE_TAX_WH Number(16,2) DECIMAL(15,2) NOT NULL State Income Tax Withheld
37 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL TIN Type
F=Federal Employer ID Number
S=Social Security Number
38 TIN Character(20) VARCHAR2(20) NOT NULL Taxpayer Identification Number
39 WTHD_CONTROL_NAME Character(4) VARCHAR2(4) NOT NULL Withholding Control Name
40 PROFESSION Character(30) VARCHAR2(30) NOT NULL Profession
41 PENALTY_FLG Character(1) VARCHAR2(1) NOT NULL Penalty Applicable
42 WTHD_FLG Character(1) VARCHAR2(1) NOT NULL Withhold if missing
N=Don't withholding
Y=Withholdeable