CNTRCT_COMM_FS

(SQL View)
 Index Back

Contract Comments


SELECT A.SETID , A.CNTRCT_ID , A.VERSION_NBR , 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.COPY_TO_PO , A.CNTRCT_LINE_NBR , %subrec(LAST_UPDATE_SBR, A) FROM PS_CNTRCT_COMMENTS A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

Default Value: 1

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
6 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
7 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor

Y/N Table Edit

Default Value: N

8 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
9 SOURCE_BU_SETID Character(5) VARCHAR2(5) NOT NULL Source BU/SETID
10 SOURCE_ID Character(25) VARCHAR2(25) NOT NULL Source Key ID
11 SOURCE_LINE_NBR Number(5,0) INTEGER NOT NULL Source Line Nbr
12 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default Value: A

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

Y/N Table Edit

Default Value: Y

14 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
15 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension
16 RECV_VIEW_FLG Character(1) VARCHAR2(1) NOT NULL Shown at Receipt

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

18 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.
19 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.
20 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.
21 PUBLIC_FLG_ATTACH Character(1) VARCHAR2(1) NOT NULL Email to Supplier

Default Value: N

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

Y/N Table Edit

Default Value: N

23 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
24 COPY_TO_PO Character(1) VARCHAR2(1) NOT NULL Copy to Purchase Order

Y/N Table Edit

Default Value: N

25 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
26 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
27 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.