PV_CP_LOAD_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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
6	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
7	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
9	PV_CP_PROD_FILE	Character(100)	VARCHAR2(100) NOT NULL	CUP Product Input File
10	PV_CP_PRICE_FILE	Character(100)	VARCHAR2(100) NOT NULL	CUP Price Input File
11	PV_CP_ATTACH_FILE	Character(100)	VARCHAR2(100) NOT NULL	CUP Attach Input File
12	PV_CP_APPROVE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Build as Approved A=Approve MarketSite Item P=Pending Approval
13	PV_CP_SUPPLIER_ID	Number(3,0)	SMALLINT NOT NULL	CUP Supplier ID
14	PV_MS_SUP_MPID	Character(50)	VARCHAR2(50) NOT NULL	e
15	PV_CP_RERUN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Re-Process Errors
16	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
17	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
18	ERROR_VALUE	Character(1)	VARCHAR2(1) NOT NULL	Error Status value Y/N Table Edit Default Value: N
19	PV_MS_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Input Source Type 1=CUP File (Access Database) 2=xCBL 3.0 XML File 3=Cohera 4=Catalog Management 5=Express Catalog 6=Item PriceList
20	PV_CP_XCBL_FILE	Character(100)	VARCHAR2(100) NOT NULL	CUP File Name
21	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
22	PV_CO_SCHEMA_NAME	Character(128)	VARCHAR2(128) NOT NULL	Cohera Catalog Name
23	FROMPHRASE	Character(254)	VARCHAR2(254) NOT NULL	From Phrase
24	PV_CO_CWB_PROD_CAT	Character(128)	VARCHAR2(128) NOT NULL	CWB_PRODUCT_CATEGORIES
25	PV_CO_CWB_PRODUCTS	Character(128)	VARCHAR2(128) NOT NULL	CWB_PRODUCTS
26	PV_CO_CWB_SUP	Character(128)	VARCHAR2(128) NOT NULL	CWB_SUPPLIERS
27	PV_CO_CWB_CAT_HIER	Character(128)	VARCHAR2(128) NOT NULL	CWB_CATEGORY_HIERARCHY
28	PV_DBLINK_NAME	Character(60)	VARCHAR2(60) NOT NULL	Database Link Name
29	PV_CO_DB_NAME	Character(50)	VARCHAR2(50) NOT NULL	Cohera Database Name
30	PV_SERVER_SW	Character(1)	VARCHAR2(1) NOT NULL	Same Server?
31	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
32	PV_CO_AUTO_ITMS	Character(1)	VARCHAR2(1) NOT NULL	Run Item Load
33	PV_CO_BY_DATE	Character(1)	VARCHAR2(1) NOT NULL	Process by date/time
34	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
35	ORIG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Original Process Instance
36	PV_CM_EXTERNAL	Character(1)	VARCHAR2(1) NOT NULL	Catalog Managment Exists
37	PV_CM_CATALOG_ID	Character(32)	VARCHAR2(32) NOT NULL	Catalog ID
38	PV_CM_CAT_HIER_ID	Character(32)	VARCHAR2(32) NOT NULL	Category Hierarchy ID
39	PV_CM_RUN_CAT	Character(1)	VARCHAR2(1) NOT NULL	Import categories only
40	PV_CP_FIELD_MAP1	Character(18)	VARCHAR2(18) NOT NULL	Field Map1
41	PV_CP_FIELD_MAP2	Character(18)	VARCHAR2(18) NOT NULL	Field Map2
42	PV_CAT_DEST_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Destination for the Catalog Items being loaded e.g. Master Items 1=Master 2=Express Default Value: 1
43	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
44	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
45	PV_INACTIVE_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Inactive level P=Item Supplier Price V=Item Supplier
46	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
47	PV_NONDYNAMICRANGE	Character(1)	VARCHAR2(1) NOT NULL	Non Dynamic Range
48	PV_OVERWRTE_CAT	Character(1)	VARCHAR2(1) NOT NULL	Overwrite Existing Categories