AUC_AWARD_ADDR

(SQL Table)
Index Back

  • Parent record: AUC_DISP_HDR
  • # 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

    Default Value: 1

    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

    Default Value: 1

    5 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
    6 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
    7 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
    8 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
    B=Bidder
    C=Customer
    P=Public
    U=Uploaded
    V=Supplier
    9 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
    10 AUC_AWARD_NBR Number(3,0) SMALLINT NOT NULL Award Number
    11 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: %EDITTABLE15

    12 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number