EOCM_SOFF_PR_VW

(SQL View)
 Index Back

Partner Offering Price View

Partner Offering Price View

SELECT A.SETID , A.EOCM_CATALOG_ID , A.EOCM_OFFER_ID , A.EOCM_ACCESS_ID , C.EOCM_OFFER_NM , A.EFFDT , A.EFF_STATUS , A.EOCM_SUP_OFFER_SKU , A.EOCM_SUP_OFFER_NM , A.EOCM_SUP_OFFER_D , A.EOCM_SUP_CAT_NM , A.EOCM_SUP_CAT_CD , A.EOCM_EPRO_FILENAME , A.EOCM_FILEEXTENSION , A.EOCM_FILEPATH , A.URL , %subrec(EOCM_EPRO_SBR, A) , %subrec(EOCM_ELM_SBR, A) ,%subrec(EOCM_CRM_SBR,A) ,%subrec(EOCM_PROP_SBR,A) , B.EOCM_SUP_OFFER_UOM , B.EOCM_SUP_OFFER_PR , B.CURRENCY_CD FROM PS_EOCM_S_OFF_TBL A , PS_EOCM_SOFF_PR B , PS_EOCM_OFFER_TBL C WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND A.EOCM_OFFER_ID = B.EOCM_OFFER_ID AND A.EOCM_ACCESS_ID = B.EOCM_ACCESS_ID AND A.EFFDT = B.EFFDT AND A.EOCM_SUP_OFFER_SKU = B.EOCM_SUP_OFFER_SKU AND A.SETID = C.SETID AND A.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND A.EOCM_OFFER_ID = C.EOCM_OFFER_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_OFFER_ID Character(32) VARCHAR2(32) NOT NULL Offering ID
4 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID

Prompt Table: EOCM_TRDPARTNER

5 EOCM_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Offer Name
6 EFFDT Date(10) DATE Effective Date
7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
8 EOCM_SUP_OFFER_SKU Character(50) VARCHAR2(50) NOT NULL Supplier Offering SKU
9 EOCM_SUP_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Supplier Offering Name
10 EOCM_SUP_OFFER_D Character(64) VARCHAR2(64) NOT NULL Supplier Offering Description
11 EOCM_SUP_CAT_NM Character(254) VARCHAR2(254) NOT NULL Supplier Category Name
12 EOCM_SUP_CAT_CD Character(32) VARCHAR2(32) NOT NULL Supplier Category Code
13 EOCM_EPRO_FILENAME Character(80) VARCHAR2(80) NOT NULL Epro file name
14 EOCM_FILEEXTENSION Character(3) VARCHAR2(3) NOT NULL Epro File Extension
15 EOCM_FILEPATH Character(30) VARCHAR2(30) NOT NULL Epro File path
16 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
17 EOCM_MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Part ID
18 EOCM_MFG_PART_NUM Character(50) VARCHAR2(50) NOT NULL Manufacturer Part Number
19 EOCM_CONVERSION_RT Signed Number(17,8) DECIMAL(15,8) NOT NULL ePro field
20 EOCM_DISCONTINU_DT Date(10) DATE Distcontinue Date for epro
21 EOCM_MIN_QTY Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity epro
22 EOCM_LEAD_TIME Number(11,0) DECIMAL(11) NOT NULL Lead Time epro
23 EOCM_ITMVPRIORITY Number(3,0) SMALLINT NOT NULL epro item vendor priority
24 EOCM_EPRO_DESCR Character(254) VARCHAR2(254) NOT NULL epro specific field
25 EOCM_VNDR_PART_NUM Character(50) VARCHAR2(50) NOT NULL Epro specific field
26 EOCM_VNDR_PART_EXT Character(50) VARCHAR2(50) NOT NULL epro specific field
27 EOCM_ELM_CEU Number(3,0) SMALLINT NOT NULL Continuing Education Units
28 EOCM_ELM_KEYWORDS Character(30) VARCHAR2(30) NOT NULL ELM keywords
29 EOCM_LEARN_OBJ_ID Number(10,0) DECIMAL(10) NOT NULL ELM Learning Objectives ID
30 EOCM_REQUISITE_ID Number(10,0) DECIMAL(10) NOT NULL ELM Requisite ID
31 EOCM_ELM_NOTES Character(80) VARCHAR2(80) NOT NULL ELM Notes
32 EOCM_MODEL_NBR Character(18) VARCHAR2(18) NOT NULL CRM specific field
33 EOCM_CRM_CAT_NBR Character(18) VARCHAR2(18) NOT NULL CRM specific field
34 EOCM_PROD_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL CRM specific field

Y/N Table Edit

35 EOCM_CRM_SERVICE Character(1) VARCHAR2(1) NOT NULL CRM specific field

Y/N Table Edit

36 EOCM_PROD_BRAND Character(15) VARCHAR2(15) NOT NULL CRM specific field
37 EOCM_CRM_ORDERABLE Character(1) VARCHAR2(1) NOT NULL CRM specific field

Y/N Table Edit

38 EOCM_PROP_NAME_1 Character(32) VARCHAR2(32) NOT NULL Property 1 Name
39 EOCM_PROP_VAL_1 Character(64) VARCHAR2(64) NOT NULL Property 1 Value
40 EOCM_PROP_NAME_2 Character(32) VARCHAR2(32) NOT NULL Property 2 Name
41 EOCM_PROP_VAL_2 Character(64) VARCHAR2(64) NOT NULL Property Value 2
42 EOCM_PROP_NAME_3 Character(32) VARCHAR2(32) NOT NULL Property 3 Name
43 EOCM_PROP_VAL_3 Character(64) VARCHAR2(64) NOT NULL Property 3 Value
44 EOCM_PROP_NAME_4 Character(32) VARCHAR2(32) NOT NULL Property Name 4
45 EOCM_PROP_VAL_4 Character(64) VARCHAR2(64) NOT NULL Property 4 Value
46 EOCM_PROP_NAME_5 Character(32) VARCHAR2(32) NOT NULL Property 5 Name
47 EOCM_PROP_VAL_5 Character(64) VARCHAR2(64) NOT NULL Property 5 Value
48 EOCM_SUP_OFFER_UOM Character(32) VARCHAR2(32) NOT NULL Supplier Offering UOM
49 EOCM_SUP_OFFER_PR Number(16,5) DECIMAL(15,5) NOT NULL Supplier Offering Price
50 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code