RESP_XL_CMNT_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 , COMMENTS_2000 FROM PS_AUC_COMMT_LN_VW WHERE 1 = 2

  • 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

    15 COMMENTS_2000 Long Character CLOB Comment Text