SPF_WO_ATTACH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW
2	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID Default Value: NEXT
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	SPF_ATTACH_NUM	Number(5,0)	INTEGER NOT NULL	Attachment Number
6	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
7	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
8	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
9	COMMENT_ID	DateTime(26)	TIMESTAMP	DtTm Entered
10	RANDOM_CMMT_NBR	Number(4,0)	SMALLINT NOT NULL	Random Comments Number
11	SPF_COMM_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Comment Line Number
12	SEND_TO_VENDOR	Character(1)	VARCHAR2(1) NOT NULL	Send to Vendor