CAPTURE_IDUID20Prompt Table: RO_DEFN_HOLD
DENY=Override Denied
FIXE=Fixed
INPR=In Process
OPEN=Requires Action
PASS=Resolved
REMV=Override Hold
OCD_HOLD_VW(SQL View) |
Index Back |
|---|---|
View of holdsThis is an order management dashboard view of a hold instance. |
| SELECT A.CAPTURE_ID , A.UID20 , A.UID20F , %Coalesce(C.LINE_NBR ,0) , R.SETID , A.HOLD_CD , A.HOLD_STATUS , A.ROW_ADDED_DTTM , CASE WHEN A.HOLD_STATUS IN ('REMV' ,'PASS' ,'FIXE') THEN A.ROW_LASTMANT_DTTM ELSE NULL END FROM PS_RO_HOLD A LEFT OUTER JOIN PS_RO_LINE C ON A.CAPTURE_ID=C.CAPTURE_ID AND C.UID20=A.UID20F , PS_RO_HEADER B , PS_SET_CNTRL_REC R WHERE A.CAPTURE_ID=B.CAPTURE_ID AND R.SETCNTRLVALUE = B.BUSINESS_UNIT AND R.RECNAME='RO_DEFN_HOLD' |
| # | 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 | UID20 |
Character(20) | VARCHAR2(20) NOT NULL | This field is for UID of 20 characters long. |
| 3 | UID20F | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID................................................................... |
| 4 | HOLD_LINE_NBR | Number(5,0) | INTEGER NOT NULL | The line number of the hold. |
| 5 | SETID_HOLD_CD | Character(5) | VARCHAR2(5) NOT NULL | SETID for the hold code |
| 6 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL |
This field determine the hold code of an item.
Prompt Table: RO_DEFN_HOLD |
| 7 | HOLD_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Hold status that are displayed on the hold page of order capture when an order is on hold.
DENY=Override Denied FIXE=Fixed INPR=In Process OPEN=Requires Action PASS=Resolved REMV=Override Hold |
| 8 | START_DTTM | DateTime(26) | TIMESTAMP | start date time |
| 9 | END_DTTM | DateTime(26) | TIMESTAMP | end date time |