EOCM_S_OFF_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	EOCM_CATALOG_ID	Character(32)	VARCHAR2(32) NOT NULL	Catalog ID
3	EOCM_OFFER_ID	Character(32)	VARCHAR2(32) NOT NULL	Offering ID Prompt Table: EOCM_OFFER_TBL
4	EOCM_ACCESS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Field for storing the Partner ID Prompt Table: EOCM_TRDPARTNER
5	EOCM_SUP_OFFER_SKU	Character(50)	VARCHAR2(50) NOT NULL	Supplier Offering SKU
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
8	EOCM_SUP_OFFER_NM	Character(64)	VARCHAR2(64) NOT NULL	Supplier Offering Name
9	EOCM_SUP_OFFER_D	Character(64)	VARCHAR2(64) NOT NULL	Supplier Offering Description
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_EPRO_FILENAME	Character(80)	VARCHAR2(80) NOT NULL	Epro file name
13	EOCM_FILEEXTENSION	Character(3)	VARCHAR2(3) NOT NULL	Epro File Extension
14	EOCM_FILEPATH	Character(30)	VARCHAR2(30) NOT NULL	Epro File path
15	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
16	EOCM_MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Part ID
17	EOCM_MFG_PART_NUM	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer Part Number
18	EOCM_CONVERSION_RT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	ePro field
19	EOCM_DISCONTINU_DT	Date(10)	DATE	Distcontinue Date for epro
20	EOCM_MIN_QTY	Number(16,4)	DECIMAL(15,4) NOT NULL	Minimum Quantity epro
21	EOCM_LEAD_TIME	Number(11,0)	DECIMAL(11) NOT NULL	Lead Time epro
22	EOCM_ITMVPRIORITY	Number(3,0)	SMALLINT NOT NULL	epro item vendor priority
23	EOCM_EPRO_DESCR	Character(254)	VARCHAR2(254) NOT NULL	epro specific field
24	EOCM_VNDR_PART_NUM	Character(50)	VARCHAR2(50) NOT NULL	Epro specific field
25	EOCM_VNDR_PART_EXT	Character(50)	VARCHAR2(50) NOT NULL	epro specific field
26	EOCM_ELM_CEU	Number(3,0)	SMALLINT NOT NULL	Continuing Education Units
27	EOCM_ELM_KEYWORDS	Character(30)	VARCHAR2(30) NOT NULL	ELM keywords
28	EOCM_LEARN_OBJ_ID	Number(10,0)	DECIMAL(10) NOT NULL	ELM Learning Objectives ID
29	EOCM_REQUISITE_ID	Number(10,0)	DECIMAL(10) NOT NULL	ELM Requisite ID
30	EOCM_ELM_NOTES	Character(80)	VARCHAR2(80) NOT NULL	ELM Notes
31	EOCM_MODEL_NBR	Character(18)	VARCHAR2(18) NOT NULL	CRM specific field
32	EOCM_CRM_CAT_NBR	Character(18)	VARCHAR2(18) NOT NULL	CRM specific field
33	EOCM_PROD_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	CRM specific field Y/N Table Edit
34	EOCM_CRM_SERVICE	Character(1)	VARCHAR2(1) NOT NULL	CRM specific field Y/N Table Edit
35	EOCM_PROD_BRAND	Character(15)	VARCHAR2(15) NOT NULL	CRM specific field
36	EOCM_CRM_ORDERABLE	Character(1)	VARCHAR2(1) NOT NULL	CRM specific field Y/N Table Edit
37	EOCM_PROP_NAME_1	Character(32)	VARCHAR2(32) NOT NULL	Property 1 Name
38	EOCM_PROP_VAL_1	Character(64)	VARCHAR2(64) NOT NULL	Property 1 Value
39	EOCM_PROP_NAME_2	Character(32)	VARCHAR2(32) NOT NULL	Property 2 Name
40	EOCM_PROP_VAL_2	Character(64)	VARCHAR2(64) NOT NULL	Property Value 2
41	EOCM_PROP_NAME_3	Character(32)	VARCHAR2(32) NOT NULL	Property 3 Name
42	EOCM_PROP_VAL_3	Character(64)	VARCHAR2(64) NOT NULL	Property 3 Value
43	EOCM_PROP_NAME_4	Character(32)	VARCHAR2(32) NOT NULL	Property Name 4
44	EOCM_PROP_VAL_4	Character(64)	VARCHAR2(64) NOT NULL	Property 4 Value
45	EOCM_PROP_NAME_5	Character(32)	VARCHAR2(32) NOT NULL	Property 5 Name
46	EOCM_PROP_VAL_5	Character(64)	VARCHAR2(64) NOT NULL	Property 5 Value
47	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
48	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.
49	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.