OFAC_VNDR_RPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	REQUEST_DT	Date(10)	DATE	Request Date
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
6	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success Default Value: N
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
9	ALL_SETID_FLG	Character(1)	VARCHAR2(1) NOT NULL	All Set IDs Y/N Table Edit Default Value: Y
10	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
11	FROM_VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Supplier ID Prompt Table: VENDOR
12	TO_VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	New Supplier ID Prompt Table: VENDOR
13	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
14	AE_WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Dynamic where clause
15	SERVERNAME	Character(8)	VARCHAR2(8) NOT NULL	Server Name
16	PREPROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Pre-Process in chunks Y/N Table Edit Default Value: N
17	AE_CHUNK_SIZE	Number(6,0)	INTEGER NOT NULL	Chunk
18	EXACT_MATCH	Character(1)	VARCHAR2(1) NOT NULL	Exact Matching