AUC_ATTCH_LN_VW

(SQL View)
 Index Back

Sourcing Attachment Line

Sourcing Attachment Line

SELECT BUSINESS_UNIT , AUC_ID , AUC_ROUND , AUC_VERSION , LINE_NBR , BID_FACTOR_NBR , AUC_ATTACH_NUM , SCM_ATTACH_ID , ATT_VERSION , SEND_TO_VENDOR , AWARD_VIEW_FLG , EMAIL_FLG , AUC_EVENT_PDF_FLG , AUC_EVENT_XML_FLG , AUC_EVENT_RFX_FLG , AUC_BDR_VER , BIDDER_SETID , BIDDER_ID , BIDDER_TYPE , BIDDER_LOC FROM PS_AUC_ATTCH WHERE LINE_NBR > 0 AND BID_FACTOR_NBR = 0

  • 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
    7 AUC_ATTACH_NUM Number(5,0) INTEGER NOT NULL Attachment Number
    8 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
    9 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
    10 SEND_TO_VENDOR Character(1) VARCHAR2(1) NOT NULL Send to Vendor

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    12 EMAIL_FLG Character(1) VARCHAR2(1) NOT NULL When the email flag is checked, the user will notified a specific user regarding an activity.
    N=No
    Y=Yes

    Default Value: Y

    13 AUC_EVENT_PDF_FLG Character(1) VARCHAR2(1) NOT NULL Event PDF File Flag

    Default Value: N

    14 AUC_EVENT_XML_FLG Character(1) VARCHAR2(1) NOT NULL Event PDF File Flag

    Default Value: N

    15 AUC_EVENT_RFX_FLG Character(1) VARCHAR2(1) NOT NULL Event RFx Doc

    Default Value: N

    16 AUC_BDR_VER Number(3,0) SMALLINT NOT NULL Bidder Revision Nbr
    17 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
    18 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
    19 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
    B=Bidder
    C=Customer
    P=Public
    U=Uploaded
    V=Supplier
    20 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location