RO_NOTE_HIST_VW

(SQL View)
 Index Back

RO Note History View

This view gives the UID20 for order lines that have Notes in the History table, which need to be published to the fulfillment system

SELECT A.CAPTURE_ID , B.UID20F , B.UID20 , B.RO_NOTE_ORIG , B.RO_NOTE_TYPE , B.RO_SUMMARY , A.RO_HISTORY_TYPE FROM PS_RO_HISTORY A , PS_RO_NOTE B WHERE A.CAPTURE_ID=B.CAPTURE_ID AND A.RECNAME='RO_NOTE' AND A.RO_HISTORY_STATUS='OPEN' AND A.RO_HISTORY_TYPE<>'AUDT' AND A.UID20F = B.UID20

# 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 UID20F Character(20) VARCHAR2(20) NOT NULL Foreign UID...................................................................
3 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.
4 RO_NOTE_ORIG Character(4) VARCHAR2(4) NOT NULL Note Origin

Default Value: INT

Prompt Table: RO_DEFN_NOTORIG

5 RO_NOTE_TYPE Character(4) VARCHAR2(4) NOT NULL Field used as edit box to show Note Type

Prompt Table: RO_DEFN_NOTTYPE

6 RO_SUMMARY Character(80) VARCHAR2(80) NOT NULL Note Summary
7 RO_HISTORY_TYPE Character(4) VARCHAR2(4) NOT NULL Audit type
ADD=Add
AUDT=Audit
DELT=Delete
UPDT=Update