AUC_DFLT_BF_TBL

(SQL Table)
Index Back

Event Bid Factor Defaults Tbl

Bid factor defaults for event lines.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: AUC_HDR.BUSINESS_UNIT

2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID

Default Value: AUC_HDR.AUC_ID

3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

Prompt Table: BID_FACTOR_VW

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
8 AUC_BF_DISPLAY_FLG Character(1) VARCHAR2(1) NOT NULL Display Bid factor

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

10 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals