RO_HDR_STAT_VW (SQL View)	Index Back
Order status Retrive the current status for an order.

RO_HDR_STAT_VW

(SQL View)

Order status

Retrive the current status for an order.

SELECT capture_id , status_code FROM PS_RO_HEADER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

2 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	STATUS_CODE	Number(5,0)	INTEGER NOT NULL	Status Code