ORDENT_PROD_MSG (SQL View)	Index Back
Order Entry Product Messages This is a view on the record which stores the message codes associated with a Product ID. Use of this record is optional. The view is used by order entry.

ORDENT_PROD_MSG

(SQL View)

Order Entry Product Messages

This is a view on the record which stores the message codes associated with a Product ID. Use of this record is optional. The view is used by order entry.

select setid, product_id, seq_num, message_cd, start_dt, end_dt from PS_PROD_MSG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

4 MESSAGE_CD Character(6) VARCHAR2(6) NOT NULL Message Code

5 START_DT Date(10) DATE Start Date

6 END_DT Date(10) DATE End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	MESSAGE_CD	Character(6)	VARCHAR2(6) NOT NULL	Message Code
5	START_DT	Date(10)	DATE	Start Date
6	END_DT	Date(10)	DATE	End Date