RFQ_COMMENTS

(SQL Table)
Index Back

RFQ Header Comments

# 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

Default Value: NEXT

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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]