RESP_LN_PROXY

(SQL Table)
Index Back

Response Line Factors

Response Line Factors

# 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 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
6 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
7 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
8 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
9 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
10 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
11 GRP_LINE_NBR Number(5,0) INTEGER NOT NULL Group Line Number
12 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
13 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
14 PXY_STATUS Character(1) VARCHAR2(1) NOT NULL Proxy Row Status
A=Active
W=Disallowed
X=Canceled
15 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
16 PXY_BEST_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Price
17 PXY_NEW_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Price
18 PXY_OLD_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Price
19 PXY_TRIGGER_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Price
20 RESP_DTTM_POST DateTime(26) TIMESTAMP Response Date Time
21 RESP_DTTM_LAST DateTime(26) TIMESTAMP Last Entry Date Time