EOCM_NEW_CAT

(SQL Table)
Index Back

Store the New Categories

Store the New Categories generated by CZATION AE

# 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_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID
4 EOCM_TP_VER_ID Number(3,0) SMALLINT NOT NULL trading partner version id
5 EOCM_CATEGORY_ID Character(32) VARCHAR2(32) NOT NULL Category ID
6 EOCM_CATEGORY_NM Character(150) VARCHAR2(150) NOT NULL Category Name
7 EOCM_CATEGORY_CD Character(32) VARCHAR2(32) NOT NULL Category Code
8 EOCM_CAT_HIER_ID Character(32) VARCHAR2(32) NOT NULL Catalog Hierarchy ID

Prompt Table: EOCM_CATALOG_CH

9 EOCM_APPROVED Character(1) VARCHAR2(1) NOT NULL Used in New offer table as a flag for approved products

Y/N Table Edit

Default Value: N