AUC_COMMENTS_VW

(SQL View)
 Index Back

Comments View

View to obtain auction comments

SELECT business_unit , auc_id , auc_round , auc_version , line_nbr , bid_factor_nbr , oprid , comment_id , random_cmmt_nbr , public_flg , status , allow_modify , comment_type , award_view_flg FROM PS_AUC_COMMENTS WHERE line_nbr > 0 AND bid_factor_nbr = 0 AND comment_type = 'LIN'

  • Parent record: AUC_LINE

    • # 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

    Default Value: 0

    7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    8 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
    9 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
    10 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor

    Y/N Table Edit

    Default Value: N

    11 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    12 ALLOW_MODIFY Character(1) VARCHAR2(1) NOT NULL Allow Modify Comments

    Y/N Table Edit

    Default Value: Y

    13 COMMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Comment Type
    BF=Bid Factor
    CBF=Analysis Collab Bid Factor
    HDR=Header
    LIN=Line
    SHP=Ship To Location

    Default Value: LIN

    14 AWARD_VIEW_FLG Character(1) VARCHAR2(1) NOT NULL Award View

    Y/N Table Edit

    Default Value: N