AUC_LN_FCTR_LST

(SQL Table)
Index Back

Event Line Factor List

Used to store Event Line List factors

  • Parent record: AUC_LN_BID_FCTR
  • # 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 AUC_BF_LIST_LINE Signed Number(6,0) DECIMAL(5) NOT NULL List Line number
    8 BID_LIST_ITEM Character(60) VARCHAR2(60) NOT NULL List Item
    9 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
    10 AUC_COST_UNIT Signed Number(14,2) DECIMAL(12,2) NOT NULL Sourcing Costing Unit Field