CAPTURE_IDUID20QUO=Quote
SO=Order
RO_LN_PROPSL_VW(SQL View) |
Index Back |
|---|---|
Order Capture AssociationsThis table stores references to objects in the system that are related to orders & quotes. |
| SELECT A.CAPTURE_ID , A.UID20 , A.ASSOC_BUS_UNIT , A.PROPOSAL_ID , A.TYPE , A.UID20F_LINE , A.VERSION_ID , B.STATUS_CODE ,C.CAPTURE_TYPE_CD FROM PS_RO_ASSOCIATION A , PS_RO_LINE B , PS_RO_HEADER C WHERE A.CAPTURE_ID=B.CAPTURE_ID AND A.CAPTURE_ID=C.CAPTURE_ID AND A.UID20F_LINE = B.UID20 AND A.TYPE='PROP' |
| # | 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 | ASSOC_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Association Business unit for related objects |
| 4 | PROPOSAL_ID | Character(25) | VARCHAR2(25) NOT NULL | This field is used to store the proposal ID. |
| 5 | TYPE | Character(4) | VARCHAR2(4) NOT NULL | Association Types |
| 6 | UID20F_LINE | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID................................................................... |
| 7 | VERSION_ID | Character(7) | VARCHAR2(7) NOT NULL | Version ID of Proposal |
| 8 | STATUS_CODE | Number(5,0) | INTEGER NOT NULL | Status Code |
| 9 | CAPTURE_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Capture Type
QUO=Quote SO=Order |