EOCM_GEN_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EOCM_ROW_ID	Number(10,0)	DECIMAL(10) NOT NULL	Row ID
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	EOCM_OFFER_ID	Character(32)	VARCHAR2(32) NOT NULL	Offering ID
6	EOCM_OFFER_NM	Character(64)	VARCHAR2(64) NOT NULL	Offer Name
7	EOCM_SUP_OFFER_NM	Character(64)	VARCHAR2(64) NOT NULL	Supplier Offering Name
8	EOCM_SUP_OFFER_SKU	Character(50)	VARCHAR2(50) NOT NULL	Supplier Offering SKU
9	EOCM_SUP_OFFER_UOM	Character(32)	VARCHAR2(32) NOT NULL	Supplier Offering UOM
10	EOCM_SUP_CAT_NM	Character(254)	VARCHAR2(254) NOT NULL	Supplier Category Name
11	EOCM_SUP_CAT_CD	Character(32)	VARCHAR2(32) NOT NULL	Supplier Category Code
12	EOCM_SUP_OFFER_PR	Number(16,5)	DECIMAL(15,5) NOT NULL	Supplier Offering Price
13	EOCM_SUP_OFFER_D	Character(64)	VARCHAR2(64) NOT NULL	Supplier Offering Description
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	EOCM_EPRO_FILENAME	Character(80)	VARCHAR2(80) NOT NULL	Epro file name
16	EOCM_FILEEXTENSION	Character(3)	VARCHAR2(3) NOT NULL	Epro File Extension
17	EOCM_FILEPATH	Character(30)	VARCHAR2(30) NOT NULL	Epro File path
18	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
19	EOCM_MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Part ID
20	EOCM_MFG_PART_NUM	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer Part Number
21	EOCM_CONVERSION_RT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	ePro field
22	EOCM_DISCONTINU_DT	Date(10)	DATE	Distcontinue Date for epro
23	EOCM_MIN_QTY	Number(16,4)	DECIMAL(15,4) NOT NULL	Minimum Quantity epro
24	EOCM_LEAD_TIME	Number(11,0)	DECIMAL(11) NOT NULL	Lead Time epro
25	EOCM_ITMVPRIORITY	Number(3,0)	SMALLINT NOT NULL	epro item vendor priority
26	EOCM_EPRO_DESCR	Character(254)	VARCHAR2(254) NOT NULL	epro specific field
27	EOCM_VNDR_PART_NUM	Character(50)	VARCHAR2(50) NOT NULL	Epro specific field
28	EOCM_VNDR_PART_EXT	Character(50)	VARCHAR2(50) NOT NULL	epro specific field
29	EOCM_ELM_CEU	Number(3,0)	SMALLINT NOT NULL	Continuing Education Units
30	EOCM_ELM_KEYWORDS	Character(30)	VARCHAR2(30) NOT NULL	ELM keywords
31	EOCM_LEARN_OBJ_ID	Number(10,0)	DECIMAL(10) NOT NULL	ELM Learning Objectives ID
32	EOCM_REQUISITE_ID	Number(10,0)	DECIMAL(10) NOT NULL	ELM Requisite ID
33	EOCM_ELM_NOTES	Character(80)	VARCHAR2(80) NOT NULL	ELM Notes
34	EOCM_MODEL_NBR	Character(18)	VARCHAR2(18) NOT NULL	CRM specific field
35	EOCM_CRM_CAT_NBR	Character(18)	VARCHAR2(18) NOT NULL	CRM specific field
36	EOCM_PROD_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	CRM specific field Y/N Table Edit
37	EOCM_CRM_SERVICE	Character(1)	VARCHAR2(1) NOT NULL	CRM specific field Y/N Table Edit
38	EOCM_PROD_BRAND	Character(15)	VARCHAR2(15) NOT NULL	CRM specific field
39	EOCM_CRM_ORDERABLE	Character(1)	VARCHAR2(1) NOT NULL	CRM specific field Y/N Table Edit
40	EOCM_PROP_NAME_1	Character(32)	VARCHAR2(32) NOT NULL	Property 1 Name
41	EOCM_PROP_VAL_1	Character(64)	VARCHAR2(64) NOT NULL	Property 1 Value
42	EOCM_PROP_NAME_2	Character(32)	VARCHAR2(32) NOT NULL	Property 2 Name
43	EOCM_PROP_VAL_2	Character(64)	VARCHAR2(64) NOT NULL	Property Value 2
44	EOCM_PROP_NAME_3	Character(32)	VARCHAR2(32) NOT NULL	Property 3 Name
45	EOCM_PROP_VAL_3	Character(64)	VARCHAR2(64) NOT NULL	Property 3 Value
46	EOCM_PROP_NAME_4	Character(32)	VARCHAR2(32) NOT NULL	Property Name 4
47	EOCM_PROP_VAL_4	Character(64)	VARCHAR2(64) NOT NULL	Property 4 Value
48	EOCM_PROP_NAME_5	Character(32)	VARCHAR2(32) NOT NULL	Property 5 Name
49	EOCM_PROP_VAL_5	Character(64)	VARCHAR2(64) NOT NULL	Property 5 Value
50	EOCM_OFFER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Offering Status C=Categorized E=Error L=Loaded N=Rejected S=Staged
51	EOCM_OFFER_STATE	Character(1)	VARCHAR2(1) NOT NULL	State of the suppl product A=New/Unapproved C=Unchanged D=Deleted E=Error N=New U=Updated
52	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
53	LASTUPDDTTM	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.
54	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.