RESP_GRP_LBF_VW

(SQL View)
 Index Back

SELECT LBF.BUSINESS_UNIT , LBF.AUC_ID , LBF.AUC_ROUND , LBF.AUC_VERSION , LBF.LINE_NBR , LBF.BID_FACTOR_NBR , LBF.SETID , LBF.BID_FACTOR_CD , LBF.BID_FACTOR_TYPE , LBF.SEQ_NBR , LBF.UNIT_OF_MEASURE , LBF.BID_INCREMENT , LBF.MIN_QTY , LBF.MAX_QTY , LBF.IDEAL_QTY , LBF.MIN_DT , LBF.MAX_DT , LBF.IDEAL_DT , LBF.IDEAL_TXT , LBF.IDEAL_YN , %Round(%DecMult(AL.WEIGHTING , LBF.WEIGHTING ) ,3) , LBF.PRICE_FLG , LBF.AUC_BF_DFLT , LBF.AUC_BF_DISPLAY_FLG , LBF.AUC_BF_ORIGIN_FLG , LBF.REQUIRED_FLAG , LBF.IDEAL_REQD , LBF.HEADER_FLG , LBF.AUC_MULTI_SEL_FLG , LBF.AUC_COST_BASE , LBF.AUC_COST_APPLY , LBF.AUC_COST_UNIT , LBF.AUC_COST_VAL1 , LBF.AUC_COST_VAL2 , LBF.LINE_NBR AS GRP_LINE_NBR , LBF.BID_FACTOR_NBR AS GRP_LN_BF_NBR , LBF.SEQ_NBR AS GRP_LN_SEQ_NBR , LBF.CNTRCT_FCTR_FLG , LBF.COMMENTS_2000 FROM PS_AUC_LINE AL , PS_AUC_LN_BID_FCTR LBF WHERE AL.BUSINESS_UNIT = LBF.BUSINESS_UNIT AND AL.AUC_ID = LBF.AUC_ID AND AL.AUC_ROUND = LBF.AUC_ROUND AND AL.AUC_VERSION = LBF.AUC_VERSION AND AL.LINE_NBR = LBF.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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
8 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
9 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
10 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
12 BID_INCREMENT Number(13,2) DECIMAL(12,2) NOT NULL Bid Increment
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 IDEAL_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Ideal Quantity
16 MIN_DT Date(10) DATE Minimum Date
17 MAX_DT Date(10) DATE Max Date
18 IDEAL_DT Date(10) DATE Ideal DateTime
19 IDEAL_TXT Character(254) VARCHAR2(254) NOT NULL Ideal Text
20 IDEAL_YN Character(1) VARCHAR2(1) NOT NULL Ideal Yes/No
21 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
22 PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Price Flag
N=No
Y=Yes

Default Value: N

23 AUC_BF_DFLT Character(1) VARCHAR2(1) NOT NULL Bid Factor Default
B=Bid Factor Rule Default
E=Event Line Defaults
F=File Import
G=Bid Factor Group Rule Default
I=Initial Price Bid Factor
O=Operator Added

Default Value: O

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

Y/N Table Edit

Default Value: Y

25 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

Default Value: C

26 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

27 IDEAL_REQD Character(1) VARCHAR2(1) NOT NULL Mandatory Response

Y/N Table Edit

Default Value: N

28 HEADER_FLG Character(1) VARCHAR2(1) NOT NULL Header Flag

Y/N Table Edit

Default Value: N

29 AUC_MULTI_SEL_FLG Character(1) VARCHAR2(1) NOT NULL Allow Multiple Selections

Y/N Table Edit

Default Value: N

30 AUC_COST_BASE Character(1) VARCHAR2(1) NOT NULL Sourcing Costing Base
F=Fixed Cost
N=N\A
P=Bid Price
Q=Bid Quantity
R=Cost Range
U=User Defined

Default Value: N

31 AUC_COST_APPLY Character(1) VARCHAR2(1) NOT NULL Sourcing Costing
C=Total Cost
N=N\A
U=Per Unit

Default Value: N

32 AUC_COST_UNIT Signed Number(14,2) DECIMAL(12,2) NOT NULL Sourcing Costing Unit Field
33 AUC_COST_VAL1 Signed Number(14,2) DECIMAL(12,2) NOT NULL Sourcing Costing Field
34 AUC_COST_VAL2 Signed Number(14,2) DECIMAL(12,2) NOT NULL Sourcing Costing Field
35 GRP_LINE_NBR Number(5,0) INTEGER NOT NULL Group Line Number
36 GRP_LN_BF_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number for group line member
37 GRP_LN_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Group Member BF Seq Nbr
38 CNTRCT_FCTR_FLG Character(1) VARCHAR2(1) NOT NULL Include on Contract

Y/N Table Edit

Default Value: N

39 COMMENTS_2000 Long Character CLOB Comment Text