RESP_AUCXAT_VW

(SQL View)
 Index Back

RFI Bid Factor attachments

RFI Bid Factor attachments

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 , AUC_EVENT_PDF_FLG , AUC_EVENT_XML_FLG , BIDDER_SETID , BIDDER_ID , BIDDER_TYPE , BIDDER_LOC FROM PS_AUC_ATTCH WHERE 1 = 2 AND LINE_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]

    Default Value: 0

    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 AUC_EVENT_PDF_FLG Character(1) VARCHAR2(1) NOT NULL Event PDF File Flag

    Default Value: N

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

    Default Value: N

    13 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
    14 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
    15 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
    B=Bidder
    C=Customer
    P=Public
    U=Uploaded
    V=Supplier
    16 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location