CS_AUC_COMNT_VW (SQL View)	Index Back
PO Contracts attachments view Date Initials Issue Description ============================================ 08/2007 CEL F-AHAYT-25EQ8 Modified view to include filename for use when we pull the transactional attachments

CS_AUC_COMNT_VW

(SQL View)

PO Contracts attachments view

Date Initials Issue Description ============================================ 08/2007 CEL F-AHAYT-25EQ8 Modified view to include filename for use when we pull the transactional attachments

SELECT AUC.CS_DOC_ID , AUC.BUSINESS_UNIT , C.COMMENT_TYPE , AUC.AUC_ID , AUC.AUC_ROUND , AUC.AUC_VERSION , C.LINE_NBR , C.BID_FACTOR_NBR , D.CS_SOURCE_TRANS , C.RANDOM_CMMT_NBR , C.PUBLIC_FLG , A.ATTACHUSERFILE , A.SCM_ATTACH_ID , A.ATT_VERSION FROM PS_AUC_COMMENTS C , PS_CS_DOC_HDR D , PS_CS_DOC_AUC_KEYS AUC , PS_PV_ATTACHMENTS A WHERE AUC.CS_DOC_ID = D.CS_DOC_ID AND AUC.BUSINESS_UNIT = C.BUSINESS_UNIT AND AUC.AUC_ID = C.AUC_ID AND AUC.AUC_ROUND = C.AUC_ROUND AND AUC.AUC_VERSION = C.AUC_VERSION AND C.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID

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

3 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

4 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID

5 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

6 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

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

8 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number

9 CS_SOURCE_TRANS Character(2) VARCHAR2(2) NOT NULL Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
01=Ad Hoc
02=Purchasing Contracts
03=Purchase Orders
04=Sourcing Events
97=All Sources
98=Multiple Sources
99=Not Transactional

10 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number

11 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor
Y/N Table Edit

12 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

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

14 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	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	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
4	AUC_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID
5	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round
6	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
7	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
8	BID_FACTOR_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Bid Factor Number
9	CS_SOURCE_TRANS	Character(2)	VARCHAR2(2) NOT NULL	Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring) 01=Ad Hoc 02=Purchasing Contracts 03=Purchase Orders 04=Sourcing Events 97=All Sources 98=Multiple Sources 99=Not Transactional
10	RANDOM_CMMT_NBR	Number(4,0)	SMALLINT NOT NULL	Random Comments Number
11	PUBLIC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Send to Vendor Y/N Table Edit
12	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
13	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.
14	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.