PV_OS_ERROR_LOG (SQL Table)	Index Back
Order Sheet Error logs Order Sheet validation errors table

PV_OS_ERROR_LOG

(SQL Table)

Order Sheet Error logs

Order Sheet validation errors table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 PV_ORD_SHEET_ID Character(20) VARCHAR2(20) NOT NULL Order Sheet ID

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
Default Value: 1

4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
Default Value: 1

5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
Default Value: 1

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

7 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

8 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

9 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text

10 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1

11 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2

12 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3

13 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

14 LAST_DTTM_UPDATE 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	PV_ORD_SHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Order Sheet ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
4	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Default Value: 1
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number Default Value: 1
6	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
7	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
8	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
9	MESSAGE_PARM	Character(254)	VARCHAR2(254) NOT NULL	Message Parameter Text
10	MESSAGE_PARM1	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 1
11	MESSAGE_PARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 2
12	MESSAGE_PARM3	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 3
13	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
14	LAST_DTTM_UPDATE	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.