PO_CMSUTCLC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	PO_STG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used in conjunction with PO_STG_ID to make a unique key on the stage tables. O=Other R=Requisition
6	PO_STG_ID	Character(10)	VARCHAR2(10) NOT NULL	Uniqye key to the PO Staging table
7	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
9	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
10	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
11	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
12	TAX_VENDOR	Character(1)	VARCHAR2(1) NOT NULL	Tax Provider A=Taxware N=None V=Vertex
13	EXCEPTIONS_AVP	Character(1)	VARCHAR2(1) NOT NULL	Using STEP
14	TAX_RC_MATCHING	Character(1)	VARCHAR2(1) NOT NULL	Reason Code Matching 1=Only Exact Reason Code Match 2=Use Default Record
15	TAX_CERT_LVL	Character(1)	VARCHAR2(1) NOT NULL	Certificate Level 1=Individual Certificate Levels 2=State Level Only
16	EXCEPTIONS_VERTEX	Character(1)	VARCHAR2(1) NOT NULL	Using TDM
17	VER_VERTEX	Character(1)	VARCHAR2(1) NOT NULL	Version I=ISAM
18	SERVER_VERTEX	Character(20)	VARCHAR2(20) NOT NULL	Server Name
19	USER_VERTEX	Character(10)	VARCHAR2(10) NOT NULL	User Name
20	PSWD_VERTEX	Character(254)	VARCHAR2(254) NOT NULL	11/04 - Increased to 44 bytes to allow for encryption. Vertex passwords must be 6-16 characters.