RESP_COMM_HF_AT

(SQL Table)
Index Back

RespHdr Bid Factor Attachments

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
6 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
7 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
8 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
9 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
10 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
11 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
12 AUC_ATTACH_NUM Number(5,0) INTEGER NOT NULL Attachment Number
13 RESP_COMMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Response Comment Type
H=Header
L=Line
14 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
15 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.
16 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.