AUC_EXT_HD_CMTS

(SQL View)
 Index Back

External Comments View

View to obtain auction comments

SELECT a.business_unit , a.auc_id , a.auc_round , a.auc_version , a.public_flg , a.allow_modify , a.award_view_flg , b.comments_2000 FROM ps_auc_comments a , PS_COMMENTS_TBL b WHERE a.line_nbr = 0 AND a.bid_factor_nbr = 0 AND b.oprid = a.oprid AND b.comment_id = a.comment_id AND b.random_cmmt_nbr = a.random_cmmt_nbr

  • 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 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

    8 COMMENTS_2000 Long Character CLOB Comment Text