RO_DEFN_STAT_VW (SQL View)	Index Back
Header Statuses Header Status View for ACE Order Capture reports

RO_DEFN_STAT_VW

(SQL View)

Header Statuses

Header Status View for ACE Order Capture reports

SELECT SETID , %NumToChar(STATUS_CODE) , DESCR50 FROM PS_RO_DEFN_HDSTAT UNION SELECT 'AAST' , 'ALLST' , %Substring(MESSAGE_TEXT, 1, 50) FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 17834 AND MESSAGE_NBR = 4035

Related Language Record: RO_DEFN_ST_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID_STATUS Character(5) VARCHAR2(5) NOT NULL MOC SETID Field

2 STATUS_CD_STR Character(5) VARCHAR2(5) NOT NULL Status Code

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_STATUS	Character(5)	VARCHAR2(5) NOT NULL	MOC SETID Field
2	STATUS_CD_STR	Character(5)	VARCHAR2(5) NOT NULL	Status Code
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50