RESP_LN_AUC_VW

(SQL View)
 Index Back

Response Line View

View for Response Line

SELECT C.BUSINESS_UNIT ,C.AUC_ID ,C.AUC_ROUND ,C.AUC_VERSION ,C.LINE_NBR ,C.BID_FACTOR_NBR ,C.GRP_LINE_NBR ,C.GRP_LN_BF_NBR ,A.AUC_FORMAT ,A.AUC_TYPE ,A.AUC_STATUS ,A.AUC_ALL_LINES_FLG ,A.MULTIPLE_BIDS_FLG ,A.AUC_BID_SCORE_OPT ,B.REQUIRED_FLAG ,B.AUC_LINE_TYPE ,B.ITM_SETID ,B.BUSINESS_UNIT_AM ,B.INV_ITEM_ID ,B.CATEGORY_ID ,B.MFG_ID ,B.MFG_ITM_ID ,B.SERIAL_ID ,B.DESCR254_MIXED ,B.PRICE_RESERVE ,B.PRICE_CLOSE ,B.QTY_AUC_MIN ,B.QTY_AUC_MAX ,B.QTY_AUC ,B.AUC_PRICE ,B.AUC_EXT_PRICE ,B.AUC_LINE_STATUS ,B.AUC_USER_PRC_BRK ,B.AUC_BIDDER_PRC_BRK ,A.AUC_START_PRC_RL ,B.PREV_LINE_NBR ,B.PHYSICAL_NATURE ,B.VAT_SVC_PERFRM_FLG ,C.SETID ,C.BID_FACTOR_CD ,C.BID_FACTOR_TYPE ,C.UNIT_OF_MEASURE ,C.BID_INCREMENT ,C.MIN_QTY ,C.MAX_QTY ,C.IDEAL_QTY ,C.MIN_DT ,C.MAX_DT ,C.IDEAL_DT ,C.IDEAL_TXT ,C.IDEAL_YN ,C.WEIGHTING ,C.PRICE_FLG ,C.AUC_BF_DISPLAY_FLG ,C.AUC_BF_ORIGIN_FLG ,C.REQUIRED_FLAG ,C.IDEAL_REQD ,C.HEADER_FLG , C.AUC_MULTI_SEL_FLG , C.SEQ_NBR ,C.COMMENTS_2000 AUC_COMMENTS_2000 FROM PS_AUC_HDR A ,PS_AUC_LINE B , PS_AUC_LN_BID_FCTR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID= B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND B.BUSINESS_UNIT =C.BUSINESS_UNIT AND B.AUC_ID= C.AUC_ID AND B.AUC_ROUND = C.AUC_ROUND AND B.AUC_VERSION = C.AUC_VERSION AND B.LINE_NBR = C.LINE_NBR

# 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
7 GRP_LINE_NBR Number(5,0) INTEGER NOT NULL Group Line Number
8 GRP_LN_BF_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number for group line member
9 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
10 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
11 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
A=Awarded
C=Collaborating Event
D=Collaborating Bid Analysis
E=Evaluating
F=RFI Reviewed
I=Pending RFI Review
N=Not Awarded
O=Open
P=Posted
Q=Paused
R=Pending Scheduled Review
S=Pending Post Approval
T=Pending Award
U=Pending Award Approval
W=Post to Third Party Failed
X=Cancelled
Z=Inactive Version

Default Value: O

12 AUC_ALL_LINES_FLG Character(1) VARCHAR2(1) NOT NULL Bid Required on all lines

Y/N Table Edit

Default Value: N

13 MULTIPLE_BIDS_FLG Character(1) VARCHAR2(1) NOT NULL Multiple Bids Allowed
N=Not Allowed
Y=Allowed

Y/N Table Edit

Default Value: Y

14 AUC_BID_SCORE_OPT Character(1) VARCHAR2(1) NOT NULL Bid Score Optimization
B=Own Bid
W=Winning Bid
15 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes

Default Value: Y

16 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
G=Group Line
L=Line Item

Default Value: N

17 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
18 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

19 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE26

20 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
21 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

22 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

Prompt Table: ITEM_MFG_ID_VW

23 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
24 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
25 PRICE_RESERVE Number(16,5) DECIMAL(15,5) NOT NULL Reserve Price
26 PRICE_CLOSE Number(16,5) DECIMAL(15,5) NOT NULL Close Price
27 QTY_AUC_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Event Quantity
28 QTY_AUC_MAX Number(16,4) DECIMAL(15,4) NOT NULL Quantity Max
29 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
30 AUC_PRICE Number(17,5) DECIMAL(16,5) NOT NULL Event Start price
31 AUC_EXT_PRICE Number(18,5) DECIMAL(17,5) NOT NULL Auction Extended Price
32 AUC_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Event Line Status
C=Closed
O=Open
33 AUC_USER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL User Defined Price Breaks

Y/N Table Edit

Default Value: N

34 AUC_BIDDER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL Bidder defined price breaks

Y/N Table Edit

Default Value: N

35 AUC_START_PRC_RL Character(1) VARCHAR2(1) NOT NULL Start Price
D=Display - Not Required to Beat
N=Do Not Display
Y=Display and Also Must Beat
36 PREV_LINE_NBR Number(5,0) INTEGER NOT NULL Previous Line Number
37 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
38 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
39 SETID Character(5) VARCHAR2(5) NOT NULL SetID
40 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

Prompt Table: BID_FACTOR_VW

41 BID_FACTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
A=Attachment
C=Monetary
D=Date
L=List
N=Numeric
S=Separator
T=Text
Y=Yes/No
42 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

43 BID_INCREMENT Number(13,2) DECIMAL(12,2) NOT NULL Bid Increment
44 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
45 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
46 IDEAL_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Ideal Quantity
47 MIN_DT Date(10) DATE Minimum Date
48 MAX_DT Date(10) DATE Max Date
49 IDEAL_DT Date(10) DATE Ideal DateTime
50 IDEAL_TXT Character(254) VARCHAR2(254) NOT NULL Ideal Text
51 IDEAL_YN Character(1) VARCHAR2(1) NOT NULL Ideal Yes/No
52 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
53 PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Price Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

54 AUC_BF_DISPLAY_FLG Character(1) VARCHAR2(1) NOT NULL Display Bid factor

Y/N Table Edit

Default Value: Y

55 AUC_BF_ORIGIN_FLG Character(1) VARCHAR2(1) NOT NULL Bid Factor Origin
A=Bid Factor Added During Award
C=Bid Factor Added During Create
56 REQUIRED_FLAG_BF Character(1) VARCHAR2(1) NOT NULL Required Flag
57 IDEAL_REQD Character(1) VARCHAR2(1) NOT NULL Mandatory Response
58 HEADER_FLG Character(1) VARCHAR2(1) NOT NULL Header Flag
59 AUC_MULTI_SEL_FLG Character(1) VARCHAR2(1) NOT NULL Allow Multiple Selections

Y/N Table Edit

Default Value: N

60 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
61 AUC_COMMENTS_2000 Long Character(32700) CLOB Question