CS_DOC_ACHF_SVW

(SQL View)
 Index Back

PTSF Event Hdr Factors VW

View on Event Header Factors for PTSF queries

SELECT '0008' , AUC.CS_DOC_ID , AHF.BUSINESS_UNIT , AHF.AUC_ID , AHF.AUC_ROUND , AHF.AUC_VERSION , AHF.BID_FACTOR_NBR , AHF.SETID , AHF.BID_FACTOR_CD , AHF.BID_FACTOR_TYPE , AHF.SEQ_NBR , AHF.UNIT_OF_MEASURE , AHF.BID_INCREMENT , AHF.MIN_QTY , AHF.MAX_QTY , AHF.IDEAL_QTY , AHF.MIN_DT , AHF.MAX_DT , AHF.IDEAL_DT , AHF.IDEAL_TXT , AHF.IDEAL_YN , AHF.WEIGHTING , AHF.AUC_BF_DFLT , AHF.AUC_BF_DISPLAY_FLG , AHF.AUC_BF_ORIGIN_FLG , AHF.REQUIRED_FLAG , AHF.IDEAL_REQD , AHF.AUC_MULTI_SEL_FLG , AHF.AUC_SOURCE_BUSETID , AHF.AUC_SOURCE_ID , AHF.AUC_SOURCE_RND , AHF.AUC_SOURCE_VER , AHF.AUC_SOURCE_LINE , AHF.AUC_COST_BASE , AHF.AUC_COST_APPLY , AHF.AUC_COST_UNIT , AHF.AUC_COST_VAL1 , AHF.AUC_COST_VAL2 , AHF.CNTRCT_FCTR_FLG FROM PS_CS_DOC_AUC_KEYS AUC ,PS_CS_DOC_HDR H ,PS_AUC_HDR_FACTORS AHF WHERE AUC.CS_DOC_ID = H.CS_DOC_ID AND AUC.BUSINESS_UNIT = AHF.BUSINESS_UNIT AND AUC.AUC_ID = AHF.AUC_ID AND AUC.AUC_ROUND = AHF.AUC_ROUND AND AUC.AUC_VERSION = AHF.AUC_VERSION

  • Parent record: AUC_HDR

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

    Prompt Table: BID_FACTOR_VW

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

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

    Y/N Table Edit

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

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

    Y/N Table Edit

    Default Value: Y

    25 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

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    29 AUC_SOURCE_BUSETID Character(5) VARCHAR2(5) NOT NULL Business Unit Setid
    30 AUC_SOURCE_ID Character(25) VARCHAR2(25) NOT NULL Source ID
    31 AUC_SOURCE_RND Number(5,0) INTEGER NOT NULL Event Round
    32 AUC_SOURCE_VER Number(5,0) INTEGER NOT NULL Event Version
    33 AUC_SOURCE_LINE Number(5,0) INTEGER NOT NULL Source Line Number
    34 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

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

    Default Value: N

    36 AUC_COST_UNIT Signed Number(14,2) DECIMAL(12,2) NOT NULL Sourcing Costing Unit Field
    37 AUC_COST_VAL1 Signed Number(14,2) DECIMAL(12,2) NOT NULL Sourcing Costing Field
    38 AUC_COST_VAL2 Signed Number(14,2) DECIMAL(12,2) NOT NULL Sourcing Costing Field
    39 CNTRCT_FCTR_FLG Character(1) VARCHAR2(1) NOT NULL Include on Contract

    Y/N Table Edit

    Default Value: N