RFQ_ATTCHST_VW (SQL View)	Index Back
SS eRFQ Response. Used to extract comments from the RFQ being responded to. Found in PO_SSRFQ_LINES page. 09/21/2009 SCC 1868771000 Fix attachments

RFQ_ATTCHST_VW

(SQL View)

SS eRFQ Response.

Used to extract comments from the RFQ being responded to. Found in PO_SSRFQ_LINES page. 09/21/2009 SCC 1868771000 Fix attachments

SELECT BUSINESS_UNIT , RFQ_ID , DTTM_RESP , LINE_NBR , COMMENT_TYPE , PUBLIC_FLG , FILENAME , FILE_EXTENSION , ' ' , SCM_ATTACH_ID , ATT_VERSION FROM PS_RFQ_COMMENT_HST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID

3 DTTM_RESP DateTime(26) TIMESTAMP Date Time Responded

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

5 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

6 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor

7 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name

8 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension

9 GET_ATTACHMENT Character(1) VARCHAR2(1) NOT NULL Get Attachment

10 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.

11 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RFQ_ID	Character(10)	VARCHAR2(10) NOT NULL	RFQ ID
3	DTTM_RESP	DateTime(26)	TIMESTAMP	Date Time Responded
4	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
5	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
6	PUBLIC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Send to Vendor
7	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
8	FILE_EXTENSION	Character(4)	VARCHAR2(4) NOT NULL	File Extension
9	GET_ATTACHMENT	Character(1)	VARCHAR2(1) NOT NULL	Get Attachment
10	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.
11	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.