REQ_COMMENTS_VW

(SQL View)
 Index Back

Req Comments View For RFQ

<* 11/21/2014 JOHAN 20061660 We ensured that the data confliction issue is fixed after copying REQ into RFQ. *>

SELECT A.BUSINESS_UNIT , A.REQ_ID , A.OPRID , A.COMMENT_ID , A.RANDOM_CMMT_NBR , A.PUBLIC_FLG , A.SOURCE_FROM , A.BUSINESS_UNIT , A.REQ_ID , A.SOURCE_LINE_NBR , A.STATUS , A.ALLOW_MODIFY , A.FILENAME , A.FILE_EXTENSION , A.RECV_VIEW_FLG , A.VCHR_VIEW_FLG , (CASE WHEN A.SCM_ATTACH_ID = ' ' THEN (CASE WHEN B.SCM_ATTACH_ID IS NULL THEN ' ' ELSE B.SCM_ATTACH_ID END ) ELSE A.SCM_ATTACH_ID END ) , A.ATTACH_DESCR , (CASE WHEN A.ATT_VERSION = 0 THEN (CASE WHEN B.ATT_VERSION IS NULL THEN 0 ELSE B.ATT_VERSION END) ELSE A.ATT_VERSION END ) , A.PUBLIC_FLG_ATTACH , A.APPR_JUSTIFY_FLG , A.COMMENT_TYPE , A.SHIPTO_ID , A.LINE_NBR FROM PS_REQ_COMMENTS A LEFT OUTER JOIN PS_PV_REQ_ATTCH B ON A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.COMMENT_ID = B.COMMENT_ID 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

Y/N Table Edit

Default Value: N

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

Default Value: A

12 ALLOW_MODIFY Character(1) VARCHAR2(1) NOT NULL Allow Modify Comments

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

16 VCHR_VIEW_FLG Character(1) VARCHAR2(1) NOT NULL Shown at Voucher

Y/N Table Edit

Default Value: N

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

Default Value: N

21 APPR_JUSTIFY_FLG Character(1) VARCHAR2(1) NOT NULL Approval Justification

Y/N Table Edit

Default Value: N

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

Prompt Table: SHIPTO_TBL

24 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]