EOCM_CTLG_SY_VW(SQL View) |
Index Back |
|---|---|
Syndication Layout ViewSyndication Layout View |
| SELECT A.EOCM_CATALOG_ID , B.EOCM_CATALOG_NM , A.EOCM_CAT_VER_ID , C.EOCM_ACCESS_ID , C.EOCM_TP_VER_ID , E.EOCM_CATEGORY_ID , F.EOCM_CATEGORY_NM , D.EOCM_SUP_OFFER_SKU , D.EOCM_SUP_OFFER_NM , ' ' , ' ' , D.EOCM_SUP_OFFER_D , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , D.EOCM_SUP_OFFER_PR , 0 , D.CURRENCY_CD , D.EOCM_SUP_OFFER_UOM , 0 FROM PS_EOCM_CAT_VER A , PS_EOCM_CATALOG B , PS_EOCM_CAT_TP_VER C , PS_EOCM_GEN_TBL D , PS_EOCM_OFFER_CAT E , PS_EOCM_CATEGORY F WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND A.SETID = C.SETID AND A.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND A.EOCM_CAT_VER_ID = C.EOCM_CAT_VER_ID AND C.SETID = D.SETID AND C.EOCM_CATALOG_ID = D.EOCM_CATALOG_ID AND C.EOCM_ACCESS_ID = D.EOCM_ACCESS_ID AND C.EOCM_TP_VER_ID = D.EOCM_TP_VER_ID AND D.SETID = E.SETID AND D.EOCM_CATALOG_ID = E.EOCM_CATALOG_ID AND D.EOCM_OFFER_ID = E.EOCM_OFFER_ID AND E.EOCM_CATEGORY_ID = F.EOCM_CATEGORY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOCM_CATALOG_ID | Character(32) | VARCHAR2(32) NOT NULL | Catalog ID |
| 2 | EOCM_CATALOG_NM | Character(32) | VARCHAR2(32) NOT NULL | Catalog Name |
| 3 | EOCM_CAT_VER_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Version Id |
| 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_CATEGORY_ID | Character(32) | VARCHAR2(32) NOT NULL | Category ID |
| 7 | EOCM_CATEGORY_NM | Character(150) | VARCHAR2(150) NOT NULL | Category Name |
| 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_MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Part ID |
| 11 | EOCM_MFG_PART_NUM | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer Part Number |
| 12 | EOCM_SUP_OFFER_D | Character(64) | VARCHAR2(64) NOT NULL | Supplier Offering Description |
| 13 | EOCM_PROP_NAME_1 | Character(32) | VARCHAR2(32) NOT NULL | Property 1 Name |
| 14 | EOCM_PROP_VAL_1 | Character(64) | VARCHAR2(64) NOT NULL | Property 1 Value |
| 15 | EOCM_PROP_NAME_2 | Character(32) | VARCHAR2(32) NOT NULL | Property 2 Name |
| 16 | EOCM_PROP_VAL_2 | Character(64) | VARCHAR2(64) NOT NULL | Property Value 2 |
| 17 | EOCM_PROP_NAME_3 | Character(32) | VARCHAR2(32) NOT NULL | Property 3 Name |
| 18 | EOCM_PROP_VAL_3 | Character(64) | VARCHAR2(64) NOT NULL | Property 3 Value |
| 19 | EOCM_PROP_NAME_4 | Character(32) | VARCHAR2(32) NOT NULL | Property Name 4 |
| 20 | EOCM_PROP_VAL_4 | Character(64) | VARCHAR2(64) NOT NULL | Property 4 Value |
| 21 | EOCM_PROP_NAME_5 | Character(32) | VARCHAR2(32) NOT NULL | Property 5 Name |
| 22 | EOCM_PROP_VAL_5 | Character(64) | VARCHAR2(64) NOT NULL | Property 5 Value |
| 23 | EOCM_SUP_OFFER_PR | Number(16,5) | DECIMAL(15,5) NOT NULL | Supplier Offering Price |
| 24 | EOCM_MIN_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Minimum Quantity epro |
| 25 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 26 | EOCM_SUP_OFFER_UOM | Character(32) | VARCHAR2(32) NOT NULL | Supplier Offering UOM |
| 27 | EOCM_LEAD_TIME | Number(11,0) | DECIMAL(11) NOT NULL | Lead Time epro |