DNP_PAYEE_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
5	DUNS_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
6	STD_ID_NUM_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Standard ID Number
7	STD_ID_NUM	Character(35)	VARCHAR2(35) NOT NULL	ID Number
8	DNP_RECORD_CD	Character(1)	VARCHAR2(1) NOT NULL	Record Code
9	DNP_PAYEE_ID	Character(50)	VARCHAR2(50) NOT NULL	Payee ID
10	DNP_AG_LOC_CD	Character(8)	VARCHAR2(8) NOT NULL	Agency Location Code
11	DNP_TIN_CD	Character(4)	VARCHAR2(4) NOT NULL	TIN Code
12	DNP_TIN_ID	Character(9)	VARCHAR2(9) NOT NULL	Identifier
13	DNP_PARTY_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Party Type
14	DNP_PARTY_NAME	Character(150)	VARCHAR2(150) NOT NULL	Business Name
15	DNP_PRTY_ALIAS_NM	Character(150)	VARCHAR2(150) NOT NULL	Party Alias Name
16	DNP_FRST_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used in DO NOT PAY File
17	DNP_MID_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used in DO NOT PAY File
18	DNP_SUR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sur Name
19	DNP_SUFFIX	Character(5)	VARCHAR2(5) NOT NULL	Name Suffix
20	DNP_ADDR1	Character(40)	VARCHAR2(40) NOT NULL	Address Line 1
21	DNP_ADDR2	Character(40)	VARCHAR2(40) NOT NULL	Address Line 2
22	DNP_ADDR3	Character(40)	VARCHAR2(40) NOT NULL	Address Line 3
23	DNP_ADDR4	Character(40)	VARCHAR2(40) NOT NULL	Address Line 4
24	DNP_CITY_NAME	Character(50)	VARCHAR2(50) NOT NULL	City Name
25	DNP_POSTAL_CD	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
26	DNP_STATE_CD	Character(2)	VARCHAR2(2) NOT NULL	State Code
27	DNP_REGION	Character(50)	VARCHAR2(50) NOT NULL	Region Name
28	COUNTRY_2CHAR	Character(2)	VARCHAR2(2) NOT NULL	2-Char Country Code
29	DNP_BIRTH_DT	Character(10)	VARCHAR2(10) NOT NULL	Birth Date
30	DNP_PORSON_SEX	Character(6)	VARCHAR2(6) NOT NULL	Person Sex
31	DNP_PARTY_STATUS	Character(30)	VARCHAR2(30) NOT NULL	Party Status Code
32	DNP_PHONE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Phone Type
33	DNP_PHONE_NUM	Character(20)	VARCHAR2(20) NOT NULL	Phone Number
34	DNP_FAX_NUM	Character(20)	VARCHAR2(20) NOT NULL	Fax Number
35	DNP_EMAIL	Character(80)	VARCHAR2(80) NOT NULL	Email Address
36	DNP_ACTIVE_DT	Character(10)	VARCHAR2(10) NOT NULL	Party Active Date
37	DNP_EXP_DT	Character(10)	VARCHAR2(10) NOT NULL	Party Expiration Date
38	DNP_REC_GRP1	Character(30)	VARCHAR2(30) NOT NULL	Agency Record Group
39	DNP_REC_GRP2	Character(30)	VARCHAR2(30) NOT NULL	Agency Record Group
40	DNP_OTH_AG_DATA	Character(250)	VARCHAR2(250) NOT NULL	Other Agency Data