CS_DOC_ACLF_SVW

(SQL View)
 Index Back

PTSF Event Line Bid Factor

PTSF View for event line bid factor details

SELECT '0008' , AUC.CS_DOC_ID , ALF.BUSINESS_UNIT , ALF.AUC_ID , ALF.AUC_ROUND , ALF.AUC_VERSION , ALF.LINE_NBR , ALF.BID_FACTOR_NBR , ALF.SETID , ALF.BID_FACTOR_CD , ALF.BID_FACTOR_TYPE , ALF.SEQ_NBR , ALF.UNIT_OF_MEASURE , ALF.BID_INCREMENT , ALF.MIN_QTY , ALF.MAX_QTY , ALF.IDEAL_QTY , ALF.MIN_DT , ALF.MAX_DT , ALF.IDEAL_DT , ALF.IDEAL_TXT , ALF.IDEAL_YN , ALF.WEIGHTING , ALF.PRICE_FLG , ALF.AUC_BF_DFLT , ALF.AUC_BF_DISPLAY_FLG , ALF.AUC_BF_ORIGIN_FLG , ALF.REQUIRED_FLAG , ALF.IDEAL_REQD , ALF.HEADER_FLG , ALF.AUC_MULTI_SEL_FLG , ALF.AUC_COST_BASE , ALF.AUC_COST_APPLY , ALF.AUC_COST_UNIT , ALF.AUC_COST_VAL1 , ALF.AUC_COST_VAL2 , ALF.GRP_LINE_NBR , ALF.GRP_LN_BF_NBR , ALF.GRP_LN_SEQ_NBR , ALF.CNTRCT_FCTR_FLG , ALF.AUC_GRP_LBL_FLG FROM PS_CS_DOC_AUC_KEYS AUC ,PS_CS_DOC_HDR H ,PS_AUC_LN_BID_FCTR ALF WHERE AUC.CS_DOC_ID = H.CS_DOC_ID AND AUC.BUSINESS_UNIT = ALF.BUSINESS_UNIT AND AUC.AUC_ID = ALF.AUC_ID AND AUC.AUC_ROUND = ALF.AUC_ROUND AND AUC.AUC_VERSION = ALF.AUC_VERSION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_CONTENT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0009=Contract Agreement
0010=Bid Factor
0011=Contract
0012=Sourcing Event
0013=Question Group
0014=Document Type
0015=Word Template
0016=Document Format and Options
2 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
5 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
6 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
8 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
9 SETID Character(5) VARCHAR2(5) NOT NULL SetID
10 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

Prompt Table: BID_FACTOR_VW

11 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
12 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
13 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

14 BID_INCREMENT Number(13,2) DECIMAL(12,2) NOT NULL Bid Increment
15 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
16 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
17 IDEAL_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Ideal Quantity
18 MIN_DT Date(10) DATE Minimum Date
19 MAX_DT Date(10) DATE Max Date
20 IDEAL_DT Date(10) DATE Ideal DateTime
21 IDEAL_TXT Character(254) VARCHAR2(254) NOT NULL Ideal Text
22 IDEAL_YN Character(1) VARCHAR2(1) NOT NULL Ideal Yes/No

Y/N Table Edit

23 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
24 PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Price Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

25 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

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

Y/N Table Edit

Default Value: Y

27 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

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

32 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

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

Default Value: N

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

Y/N Table Edit

Default Value: N

41 AUC_GRP_LBL_FLG Character(1) VARCHAR2(1) NOT NULL Group Label Flag

Y/N Table Edit

Default Value: N