EOCM_CTLG_TP_VW

(SQL View)
 Index Back

List of catalog partners

List of catalog partners

SELECT A.SETID , A.EOCM_CATALOG_ID , A.EOCM_ACCESS_ID , B.DESCR FROM PS_EOCM_CATALOG_TP A , PS_EOCM_TRDPARTNER B WHERE A.SETID = B.SETID AND A.EOCM_ACCESS_ID = B.EOCM_ACCESS_ID AND A.EOCM_ACTIVE_FLAG = 'A'

  • Parent record: EOCM_CATALOG

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

    Prompt Table: SETID_TBL

    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

    Prompt Table: EOCM_TRDPARTNER

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description