PV_ECONN_CMM_VW(SQL View) |
Index Back |
|---|---|
ePro Connect Comments ViewePro Connect Comments View |
| SELECT A.business_unit , A.req_id , A.oprid , A.COMMENT_ID , A.random_cmmt_nbr , A.public_flg , A.source_from , A.source_bu_setid , A.source_id , A.source_line_nbr , A.status , A.allow_modify , A.filename , A.file_extension , A.recv_view_flg , A.vchr_view_flg , A.scm_attach_id , A.attach_descr , A.att_version , A.public_flg_attach , A.appr_justify_flg , A.comment_type , A.shipto_id , A.line_nbr , B.shared_flg , B.comments_2000 FROM PS_REQ_COMMENTS A , PS_COMMENTS_TBL B WHERE A.COMMENT_ID = B.COMMENT_ID AND A.OPRID = B.OPRID AND A.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | COMMENT_ID |
DateTime(26) | TIMESTAMP | DtTm Entered |
| 5 | RANDOM_CMMT_NBR |
Number(4,0) | SMALLINT NOT NULL | Random Comments Number |
| 6 | PUBLIC_FLG |
Character(1) | VARCHAR2(1) NOT NULL | Send to Vendor |
| 7 | SOURCE_FROM |
Character(3) | VARCHAR2(3) NOT NULL |
Source From
CNT=Supplier Contracts DOC=Document INV=Inventory ORD=Order Management PO=Purchase Order RCV=Receiving REQ=Requisition RFQ=Request For Quote RTV=Return To Vendor (Supplier) SSE=Strategic Sourcing Event WO=Work Order |
| 8 | SOURCE_BU_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Source BU/SETID |
| 9 | SOURCE_ID |
Character(25) | VARCHAR2(25) NOT NULL | Source Key ID |
| 10 | SOURCE_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Source Line Nbr |
| 11 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 12 | ALLOW_MODIFY | Character(1) | VARCHAR2(1) NOT NULL | Allow Modify Comments |
| 13 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 14 | FILE_EXTENSION | Character(4) | VARCHAR2(4) NOT NULL | File Extension |
| 15 | RECV_VIEW_FLG | Character(1) | VARCHAR2(1) NOT NULL | Shown at Receipt |
| 16 | VCHR_VIEW_FLG | Character(1) | VARCHAR2(1) NOT NULL | Shown at Voucher |
| 17 | SCM_ATTACH_ID | Character(64) | VARCHAR2(64) NOT NULL | The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications. |
| 18 | ATTACH_DESCR | Character(100) | VARCHAR2(100) NOT NULL | A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application. |
| 19 | ATT_VERSION | Number(3,0) | SMALLINT NOT NULL | The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files. |
| 20 | PUBLIC_FLG_ATTACH | Character(1) | VARCHAR2(1) NOT NULL | Email to Supplier |
| 21 | APPR_JUSTIFY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Approval Justification |
| 22 | COMMENT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Comment Type
BF=Bid Factor CBF=Analysis Collab Bid Factor HDR=Header LIN=Line SHP=Ship To Location |
| 23 | SHIPTO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 24 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 25 | SHARED_FLG | Character(1) | VARCHAR2(1) NOT NULL | Shared Comments |
| 26 | COMMENTS_2000 | Long Character | CLOB | Comment Text |