EOCM_TPVER_HST (SQL Table)	Index Back
Trading Partner Versions Trading Partner Versions for history

EOCM_TPVER_HST

(SQL Table)

Trading Partner Versions

Trading Partner Versions for history

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

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

3 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID

4 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID

5 EOCM_TP_VER_ID Number(3,0) SMALLINT NOT NULL trading partner version id

6 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

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

8 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time

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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	EOCM_CATALOG_ID	Character(32)	VARCHAR2(32) NOT NULL	Catalog ID
4	EOCM_ACCESS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Field for storing the Partner ID
5	EOCM_TP_VER_ID	Number(3,0)	SMALLINT NOT NULL	trading partner version id
6	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
7	EOCM_LOAD_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Load option Incremental/destructive 0=Full Load 1=Incremental Update
8	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Date and time
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.