CS_DOC_ATTH_SRC (SQL Table)	Index Back
Source Attachment History Date Initials Issue Description ============================================ 08/2007 CEL F-AHAYT-25EQ8 History of Source Attachments

CS_DOC_ATTH_SRC

(SQL Table)

Source Attachment History

Date Initials Issue Description ============================================ 08/2007 CEL F-AHAYT-25EQ8 History of Source Attachments

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CS_DOC_ATT_VER Number(3,0) SMALLINT NOT NULL This is the cycle/seq nbr that indicates the change interation/version that the normal attachments are on. Since we want to save them off in history

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

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

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

6 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

7 SOURCE_LINE_NBR Number(5,0) INTEGER NOT NULL Source Line Nbr

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

9 PUBLIC_FLG_ATTACH Character(1) VARCHAR2(1) NOT NULL Email to Supplier
Y/N Table Edit
Default Value: N

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
2	CS_DOC_ATT_VER	Number(3,0)	SMALLINT NOT NULL	This is the cycle/seq nbr that indicates the change interation/version that the normal attachments are on. Since we want to save them off in history
3	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.
4	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.
5	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
6	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
7	SOURCE_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Source Line Nbr
8	PUBLIC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Send to Vendor Y/N Table Edit
9	PUBLIC_FLG_ATTACH	Character(1)	VARCHAR2(1) NOT NULL	Email to Supplier Y/N Table Edit Default Value: N
10	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name