PV_OS_ERRLOG_VW (SQL View)	Index Back
Order Sheet Error logs Order Sheet validation errors table

PV_OS_ERRLOG_VW

(SQL View)

Order Sheet Error logs

Order Sheet validation errors table

SELECT A.SETID , A.PV_ORD_SHEET_ID , A.LINE_NBR , A.DISTRIB_LINE_NUM , A.SEQ_NBR , B.ITM_SETID , B.INV_ITEM_ID , A.RUN_CNTL_ID , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.MESSAGE_PARM , A.MESSAGE_PARM1 , A.MESSAGE_PARM2 , A.MESSAGE_PARM3 , A.OPRID , A.LAST_DTTM_UPDATE FROM PS_PV_OS_ERROR_LOG A, PS_PV_OS_LINE B WHERE A.SETID = B.SETID AND A.PV_ORD_SHEET_ID = B.PV_ORD_SHEET_ID AND A.LINE_NBR = B.LINE_NBR

# 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 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

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

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

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

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

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

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

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

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

16 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	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
7	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
8	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	MESSAGE_PARM	Character(254)	VARCHAR2(254) NOT NULL	Message Parameter Text
12	MESSAGE_PARM1	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 1
13	MESSAGE_PARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 2
14	MESSAGE_PARM3	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 3
15	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
16	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.