EOCM_OFR_CAT_VW

(SQL View)
Index Back

Relation between prods/cats

Relation between prods/cats

SELECT SETID , EOCM_CATALOG_ID , EOCM_OFFER_ID , EOCM_CATEGORY_ID , EOCM_PRIMARY_CATEG FROM PS_EOCM_OFFER_CAT

# 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_CATEGORY_ID Character(32) VARCHAR2(32) NOT NULL Category ID

Prompt Table: EOCM_CATEG_VW

5 EOCM_PRIMARY_CATEG Character(1) VARCHAR2(1) NOT NULL Primary category for Offering

Y/N Table Edit

Default Value: N