EOCM_UNSPS_AET (SQL Table)	Index Back
State record for UNSPSC State record for UNSPSC used by Application Engine

EOCM_UNSPS_AET

(SQL Table)

State record for UNSPSC

State record for UNSPSC used by Application Engine

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 EOCM_CAT_HIER_ID Character(32) VARCHAR2(32) NOT NULL Catalog Hierarchy ID

4 EOCM_CAT_HIER_NM Character(32) VARCHAR2(32) NOT NULL Category Hierarchy Name

5 EOCM_INDUS_CAT Character(1) VARCHAR2(1) NOT NULL Industry standard hierarchies
P=PS Tree
U=UNSPSC

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

7 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

8 EOCM_CATEGORY_CD Character(32) VARCHAR2(32) NOT NULL Category Code

9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EOCM_CAT_HIER_ID	Character(32)	VARCHAR2(32) NOT NULL	Catalog Hierarchy ID
4	EOCM_CAT_HIER_NM	Character(32)	VARCHAR2(32) NOT NULL	Category Hierarchy Name
5	EOCM_INDUS_CAT	Character(1)	VARCHAR2(1) NOT NULL	Industry standard hierarchies P=PS Tree U=UNSPSC
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
7	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
8	EOCM_CATEGORY_CD	Character(32)	VARCHAR2(32) NOT NULL	Category Code
9	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.