RESP_LN_PCBRK

(SQL Table)
Index Back

Response Line PC Price Break

Response Line PC Price Break

# 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 AUC_TIER_NBR Number(5,0) INTEGER NOT NULL Tier Number
12 BID_PBK_RESP_TYPE Character(1) VARCHAR2(1) NOT NULL Price Break Response Type
B=Bidder Defined Price Breaks
N=No Price Breaks
T=Both User/Bidder Price Breaks
U=User Defined Price Breaks
13 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
14 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
15 BID_PBK_ADJ_TYPE Character(1) VARCHAR2(1) NOT NULL Price Break Adjustment Type
A=Amount Adjustment
B=Net Unit Price Adjustment
P=Percent Adjustment
16 BID_PBK_ADJ_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Adjustment Amount
17 BID_PBK_ADJ_PCT Signed Number(20,6) DECIMAL(18,6) NOT NULL Adjustment Percent
18 BID_PBK_PRICE Signed Number(20,6) DECIMAL(18,6) NOT NULL Adjusted Price
19 BPU_MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
20 BPU_MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
21 BPU_PBK_ADJ_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Adjustment Amount
22 BPU_PBK_ADJ_PCT Signed Number(20,6) DECIMAL(18,6) NOT NULL Adjustment Percent
23 BPU_PBK_PRICE Signed Number(20,6) DECIMAL(18,6) NOT NULL Adjusted Price