RO_TYPE_DYEV_VW(SQL View) |
Index Back |
|---|---|
Dynamic EventsThis record is a view used for dynamic events |
| SELECT A.SETID , A.CAPTURE_TYPE_CD , A.ENABLED , A.SEQ_NUM , %subrec(RB_APPCLASS_SB2,B) FROM %Table(RO_TYPE_DYEVENT) A , %Table(RO_DEFN_DYEVENT) B WHERE A.SETID=B.SETID AND A.UID20F=B.UID20 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | CAPTURE_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Capture Type
QUO=Quote SO=Order |
| 3 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL | A flag indicates whether this row is enabled or not. |
| 4 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: RBC_APPCLASS_VW |
| 6 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table: RBC_APPRTPATH_V |