CS_AUC_LBFLS_VW

(SQL View)
Index Back

Bind MapEvent Line Factor List

Used to access bind mappings for RFX Event Line List factors

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.LINE_NBR , A.BID_FACTOR_NBR , A.AUC_BF_LIST_LINE , A.BID_LIST_ITEM , A.WEIGHTING , A.AUC_COST_UNIT FROM PS_AUC_LN_FCTR_LST A , PS_AUC_LN_BID_FCTR B WHERE B.BID_FACTOR_TYPE = 'L' AND 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 A.LINE_NBR = B.LINE_NBR

  • 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