EOCM_CATVRP2_VW

(SQL View)
 Index Back

Browse Prod Ent Partner

Browse Prod Enterprise Partner

SELECT A.SETID , A.EOCM_CATALOG_ID , A.EOCM_CAT_VER_ID , B.EOCM_ACCESS_ID , B.EOCM_TP_VER_ID , C.EOCM_OFFER_ID , C.EOCM_ROW_ID , C.EFFDT , C.EOCM_SUP_OFFER_NM , C.EOCM_SUP_OFFER_SKU , C.EOCM_SUP_CAT_CD , C.EOCM_SUP_CAT_NM , C.EOCM_SUP_OFFER_UOM , C.EOCM_SUP_OFFER_D , C.EOCM_SUP_OFFER_PR , C.CURRENCY_CD , C.EOCM_EPRO_FILENAME , C.EOCM_FILEEXTENSION , C.EOCM_FILEPATH , C.URL , %subrec(EOCM_EPRO_SBR, C) , %subrec(EOCM_CRM_SBR, C) , %subrec(EOCM_ELM_SBR, C) , %subrec(EOCM_PROP_SBR, C) FROM PS_EOCM_CAT_VER A , PS_EOCM_CAT_TP_VER B , PS_EOCM_GEN_TBL C WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND A.EOCM_CAT_VER_ID = B.EOCM_CAT_VER_ID AND A.EOCM_CATVER_STATUS = 'P' AND B.SETID = C.SETID AND B.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND B.EOCM_ACCESS_ID = C.EOCM_ACCESS_ID AND B.EOCM_TP_VER_ID= C.EOCM_TP_VER_ID

# 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_CAT_VER_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Version Id

Prompt Table: EOCM_CAT_VER_VW

4 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID
5 EOCM_TP_VER_ID Number(3,0) SMALLINT NOT NULL trading partner version id
6 EOCM_OFFER_ID Character(32) VARCHAR2(32) NOT NULL Offering ID
7 EOCM_ROW_ID Number(10,0) DECIMAL(10) NOT NULL Row ID
8 EFFDT Date(10) DATE Effective Date

Default Value: %date

9 EOCM_SUP_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Supplier Offering Name
10 EOCM_SUP_OFFER_SKU Character(50) VARCHAR2(50) NOT NULL Supplier Offering SKU
11 EOCM_SUP_CAT_CD Character(32) VARCHAR2(32) NOT NULL Supplier Category Code
12 EOCM_SUP_CAT_NM Character(254) VARCHAR2(254) NOT NULL Supplier Category Name
13 EOCM_SUP_OFFER_UOM Character(32) VARCHAR2(32) NOT NULL Supplier Offering UOM
14 EOCM_SUP_OFFER_D Character(64) VARCHAR2(64) NOT NULL Supplier Offering Description
15 EOCM_SUP_OFFER_PR Number(16,5) DECIMAL(15,5) NOT NULL Supplier Offering Price
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
17 EOCM_EPRO_FILENAME Character(80) VARCHAR2(80) NOT NULL Epro file name
18 EOCM_FILEEXTENSION Character(3) VARCHAR2(3) NOT NULL Epro File Extension
19 EOCM_FILEPATH Character(30) VARCHAR2(30) NOT NULL Epro File path
20 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
21 EOCM_MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Part ID
22 EOCM_MFG_PART_NUM Character(50) VARCHAR2(50) NOT NULL Manufacturer Part Number
23 EOCM_CONVERSION_RT Signed Number(17,8) DECIMAL(15,8) NOT NULL ePro field
24 EOCM_DISCONTINU_DT Date(10) DATE Distcontinue Date for epro
25 EOCM_MIN_QTY Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity epro
26 EOCM_LEAD_TIME Number(11,0) DECIMAL(11) NOT NULL Lead Time epro
27 EOCM_ITMVPRIORITY Number(3,0) SMALLINT NOT NULL epro item vendor priority
28 EOCM_EPRO_DESCR Character(254) VARCHAR2(254) NOT NULL epro specific field
29 EOCM_VNDR_PART_NUM Character(50) VARCHAR2(50) NOT NULL Epro specific field
30 EOCM_VNDR_PART_EXT Character(50) VARCHAR2(50) NOT NULL epro specific field
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_ELM_CEU Number(3,0) SMALLINT NOT NULL Continuing Education Units
38 EOCM_ELM_KEYWORDS Character(30) VARCHAR2(30) NOT NULL ELM keywords
39 EOCM_LEARN_OBJ_ID Number(10,0) DECIMAL(10) NOT NULL ELM Learning Objectives ID
40 EOCM_REQUISITE_ID Number(10,0) DECIMAL(10) NOT NULL ELM Requisite ID
41 EOCM_ELM_NOTES Character(80) VARCHAR2(80) NOT NULL ELM Notes
42 EOCM_PROP_NAME_1 Character(32) VARCHAR2(32) NOT NULL Property 1 Name
43 EOCM_PROP_VAL_1 Character(64) VARCHAR2(64) NOT NULL Property 1 Value
44 EOCM_PROP_NAME_2 Character(32) VARCHAR2(32) NOT NULL Property 2 Name
45 EOCM_PROP_VAL_2 Character(64) VARCHAR2(64) NOT NULL Property Value 2
46 EOCM_PROP_NAME_3 Character(32) VARCHAR2(32) NOT NULL Property 3 Name
47 EOCM_PROP_VAL_3 Character(64) VARCHAR2(64) NOT NULL Property 3 Value
48 EOCM_PROP_NAME_4 Character(32) VARCHAR2(32) NOT NULL Property Name 4
49 EOCM_PROP_VAL_4 Character(64) VARCHAR2(64) NOT NULL Property 4 Value
50 EOCM_PROP_NAME_5 Character(32) VARCHAR2(32) NOT NULL Property 5 Name
51 EOCM_PROP_VAL_5 Character(64) VARCHAR2(64) NOT NULL Property 5 Value