CS_AUC_HDRFC_VW

(SQL View)
 Index Back

Event Hdr Factors Bind maps

Used to get bind mappings for Event Header Factors

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BID_FACTOR_NBR , A.SETID , A.BID_FACTOR_CD , A.BID_FACTOR_TYPE , A.SEQ_NBR , A.UNIT_OF_MEASURE , A.BID_INCREMENT , A.MIN_QTY , A.MAX_QTY , A.IDEAL_QTY , A.MIN_DT , A.MAX_DT , A.IDEAL_DT , A.IDEAL_TXT , A.IDEAL_YN , A.WEIGHTING , A.AUC_BF_DFLT , A.AUC_BF_DISPLAY_FLG , A.AUC_BF_ORIGIN_FLG , A.REQUIRED_FLAG , A.IDEAL_REQD , A.AUC_MULTI_SEL_FLG , A.AUC_SOURCE_BUSETID , A.AUC_SOURCE_ID , A.AUC_SOURCE_RND , A.AUC_SOURCE_VER , A.AUC_SOURCE_LINE , A.AUC_COST_BASE , A.AUC_COST_APPLY , A.AUC_COST_UNIT , A.AUC_COST_VAL1 , A.AUC_COST_VAL2 , A.CNTRCT_FCTR_FLG FROM PS_AUC_HDR_FACTORS A

  • Parent record: AUC_HDR

    • # 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 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
    6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    7 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

    Prompt Table: BID_FACTOR_VW

    8 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
    9 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    10 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

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

    Y/N Table Edit

    20 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
    21 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

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

    Y/N Table Edit

    Default Value: Y

    23 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

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    27 AUC_SOURCE_BUSETID Character(5) VARCHAR2(5) NOT NULL Business Unit Setid
    28 AUC_SOURCE_ID Character(25) VARCHAR2(25) NOT NULL Source ID
    29 AUC_SOURCE_RND Number(5,0) INTEGER NOT NULL Event Round
    30 AUC_SOURCE_VER Number(5,0) INTEGER NOT NULL Event Version
    31 AUC_SOURCE_LINE Number(5,0) INTEGER NOT NULL Source Line Number
    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 CNTRCT_FCTR_FLG Character(1) VARCHAR2(1) NOT NULL Include on Contract

    Y/N Table Edit

    Default Value: N