AUC_DISP_HDR

(SQL Table)
Index Back

Dispatch Header

Dispatch Header

  • Parent Record Of AUC_AWARD_ADDR AUC_DISP_ADDR AUC_DISP_ADDR_V AUC_DISP_ADR_VW AUC_DISP_CNTCT
  • # 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 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
    6 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
    7 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
    B=Bidder
    C=Customer
    P=Public
    U=Uploaded
    V=Supplier
    8 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
    9 AUC_DISPATCH_MTHD Character(1) VARCHAR2(1) NOT NULL Dispatch Method
    E=Email
    F=Fax
    P=Print
    10 AUC_INVITE_ALL Character(1) VARCHAR2(1) NOT NULL Invite to Event

    Default Value: Y

    11 BID_INV_SOURCE Character(1) VARCHAR2(1) NOT NULL Invitation Source
    S=Self Invited
    U=Invited by User

    Default Value: U

    12 BID_INV_RESPONSE Character(1) VARCHAR2(1) NOT NULL Invite Status
    A=Accepted
    D=Declined
    N=---

    Default Value: N

    13 BID_INV_SEND_EMAIL Character(1) VARCHAR2(1) NOT NULL Receive Updates to Event
    N=Don't send updates
    Y=Send updates

    Default Value: Y

    14 AUC_RENOTIFY_FLG Character(1) VARCHAR2(1) NOT NULL Renotify Bidders

    Y/N Table Edit

    Default Value: Y

    15 VENDOR_STATUS Character(1) VARCHAR2(1) NOT NULL Vendor Status
    A=Approved
    D=Denied
    E=Unapproved
    I=Inactive
    X=To Be Archived