EOCM_CUP_VW

(SQL View)
 Index Back

Run Control

Run Control

SELECT A.SETID , A.EOCM_CATALOG_ID , B.EOCM_ACCESS_ID , A.TREE_NAME , A.PV_CP_IMAGE_LOC , A.PV_MS_DOC_TYPE , A.PV_INACTIVE_LEVEL , A.PV_CM_CATALOG_ID , A.ACCOUNT , A.PV_CO_AUTO_ITMS , A.PV_CO_BY_DATE , A.CURRENCY_CD , A.PV_CM_HIER_ID_NODE , A.INVENTORY_ITEM , A.PV_CAT_DEST_OPTN , A.LANGUAGE_CD , A.PV_CP_INDEX , A.VENDOR_SETID , C.VENDOR_ID , C.VNDR_LOC , A.PV_CM_CAT_HIER_ID FROM PS_EOCM_PV_LOADOPT A , PS_EOCM_CATALOG_TP B , PS_PV_MS_SUPPLIER C WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND B.SETID = C.SETID AND C.PV_MS_SUP_TYPE = '3' AND B.EOCM_ACCESS_ID = C.EOTP_PARTNERID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
3 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID
4 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: PV_CP_TREE_VW

5 PV_CP_IMAGE_LOC Character(40) VARCHAR2(40) NOT NULL Item Image Sub Folder
6 PV_MS_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Input Source Type
1=CUP File (Access Database)
2=xCBL 3.0 XML File
3=Cohera
4=Catalog Management
5=Express Catalog
6=Item PriceList

Default Value: 4

7 PV_INACTIVE_LEVEL Character(1) VARCHAR2(1) NOT NULL Inactive level
P=Item Supplier Price
V=Item Supplier

Default Value: P

8 PV_CM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID

Prompt Table: PV_CM_CAT_SRC

9 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: PO_ACCT_SET_VW

10 PV_CO_AUTO_ITMS Character(1) VARCHAR2(1) NOT NULL Run Item Load

Y/N Table Edit

Default Value: Y

11 PV_CO_BY_DATE Character(1) VARCHAR2(1) NOT NULL Process by date/time

Y/N Table Edit

Default Value: N

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

13 PV_CM_HIER_ID_NODE Character(1) VARCHAR2(1) NOT NULL Add Hierarchy ID as Node

Y/N Table Edit

Default Value: Y

14 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
N=No
Y=Yes

Y/N Table Edit

Default Value: N

15 PV_CAT_DEST_OPTN Character(1) VARCHAR2(1) NOT NULL Destination for the Catalog Items being loaded e.g. Master Items
1=Master
2=Express

Default Value: 1

16 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Default Value: ENG

17 PV_CP_INDEX Character(1) VARCHAR2(1) NOT NULL Add Items to Search Index

Y/N Table Edit

Default Value: Y

18 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: SP_SETID_NONVW

19 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: PV_CM_SUPP_VW

20 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: PV_CM_VNDR_VW

21 PV_CM_CAT_HIER_ID Character(32) VARCHAR2(32) NOT NULL Category Hierarchy ID

Prompt Table: PV_CM_CAT_SRC1