DUP_VND_SRT_TAO

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
5 WTHD_NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
6 WTHD_NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
7 VNDR_NAME_SHRT_USR Character(10) VARCHAR2(10) NOT NULL Short Vendor Name
8 TIN Character(20) VARCHAR2(20) NOT NULL Taxpayer Identification Number
9 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
10 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
11 CITY Character(30) VARCHAR2(30) NOT NULL City
12 STATE Character(6) VARCHAR2(6) NOT NULL State
13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
14 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description
15 SORTFIELD1 Character(40) VARCHAR2(40) NOT NULL Sort Field
16 VENDOR_STATUS Character(1) VARCHAR2(1) NOT NULL Vendor Status
A=Approved
D=Denied
E=Unapproved
I=Inactive
X=To Be Archived