RESP_HDR_ERRFL

(SQL Table)
Index Back

Response Header View

Response Error Header View

  • Parent record: AUC_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
    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 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
    10 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
    11 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    12 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

    Prompt Table: BID_FACTOR_VW

    13 BID_FACTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
    A=Attachment
    C=Monetary
    D=Date
    L=List
    N=Numeric
    S=Separator
    T=Text
    Y=Yes/No
    14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    15 BID_INCREMENT Number(13,2) DECIMAL(12,2) NOT NULL Bid Increment
    16 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
    17 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
    18 IDEAL_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Ideal Quantity
    19 MIN_DT Date(10) DATE Minimum Date
    20 MAX_DT Date(10) DATE Max Date
    21 IDEAL_DT Date(10) DATE Ideal DateTime
    22 IDEAL_TXT Character(254) VARCHAR2(254) NOT NULL Ideal Text
    23 IDEAL_YN Character(1) VARCHAR2(1) NOT NULL Ideal Yes/No
    24 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
    25 AUC_BF_DISPLAY_FLG Character(1) VARCHAR2(1) NOT NULL Display Bid factor

    Y/N Table Edit

    Default Value: Y

    26 AUC_BF_ORIGIN_FLG Character(1) VARCHAR2(1) NOT NULL Bid Factor Origin
    A=Bid Factor Added During Award
    C=Bid Factor Added During Create

    Default Value: C

    27 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    28 IDEAL_REQD Character(1) VARCHAR2(1) NOT NULL Mandatory Response

    Y/N Table Edit

    Default Value: N

    29 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
    F=Sell
    I=RFI
    R=Buy
    S=Service
    30 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
    E=Auction
    S=RFx
    31 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
    A=Awarded
    C=Collaborating Event
    D=Collaborating Bid Analysis
    E=Evaluating
    F=RFI Reviewed
    I=Pending RFI Review
    N=Not Awarded
    O=Open
    P=Posted
    Q=Paused
    R=Pending Scheduled Review
    S=Pending Post Approval
    T=Pending Award
    U=Pending Award Approval
    W=Post to Third Party Failed
    X=Cancelled
    Z=Inactive Version

    Default Value: O

    32 AUC_ALL_LINES_FLG Character(1) VARCHAR2(1) NOT NULL Bid Required on all lines

    Y/N Table Edit

    Default Value: N

    33 MULTIPLE_BIDS_FLG Character(1) VARCHAR2(1) NOT NULL Multiple Bids Allowed
    N=Not Allowed
    Y=Allowed

    Y/N Table Edit

    Default Value: Y

    34 AUC_DISP_WEIGHTING Character(1) VARCHAR2(1) NOT NULL Display Weights

    Y/N Table Edit

    Default Value: Y

    35 AUC_MULTI_SEL_FLG Character(1) VARCHAR2(1) NOT NULL Allow Multiple Selections
    36 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    37 AUC_COMMENTS_2000 Long Character(32700) CLOB Question
    38 AUC_ERR_DESCR Long Character(32700) CLOB Error Message
    39 AUC_VIEWDETAIL_PB Character(1) VARCHAR2(1) NOT NULL View Detail push button
    40 AUC_EDIT_PB Character(1) VARCHAR2(1) NOT NULL Edit Event
    41 AUC_FIELD_NAME Character(150) VARCHAR2(150) NOT NULL Event ID
    42 AUC_RECORD_NAME Character(60) VARCHAR2(60) NOT NULL Event ID