EOCM_TP_VER (SQL Table)	Index Back
Trading Partner Versions Trading Partner Versions

EOCM_TP_VER

(SQL Table)

Trading Partner Versions

# 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_TP_VER_STATE Character(1) VARCHAR2(1) NOT NULL TP version state (loaded, categorized, etc)
A=Pending Approval
B=In Progress
C=Categorized
D=Error
E=Error
F=Error
K=Error
L=Loaded
N=Created
P=Production
S=Staged
W=Waiting Review
X=Purchasing/Errors
Z=Purchasing

6 EOCM_LOAD_OPTION Character(1) VARCHAR2(1) NOT NULL Load option Incremental/destructive
0=Full Load
1=Incremental Update

7 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time

8 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.

9 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	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_TP_VER_STATE	Character(1)	VARCHAR2(1) NOT NULL	TP version state (loaded, categorized, etc) A=Pending Approval B=In Progress C=Categorized D=Error E=Error F=Error K=Error L=Loaded N=Created P=Production S=Staged W=Waiting Review X=Purchasing/Errors Z=Purchasing
6	EOCM_LOAD_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Load option Incremental/destructive 0=Full Load 1=Incremental Update
7	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Date and time
8	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.
9	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.