AUC_RFI_LNK_LST

(SQL Table)
 Index Back

Table with list of RFI's

  • 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 AUC_SOURCE_BUSETID Character(5) VARCHAR2(5) NOT NULL Business Unit Setid
    6 AUC_SOURCE_ID Character(25) VARCHAR2(25) NOT NULL Source ID
    7 AUC_SOURCE_RND Number(5,0) INTEGER NOT NULL Event Round
    8 AUC_SOURCE_VER Number(5,0) INTEGER NOT NULL Event Version
    9 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
    F=Sell
    I=RFI
    R=Buy
    S=Service
    10 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
    E=Auction
    S=RFx
    11 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
    12 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

    13 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish
    14 AUC_COL_NUM Character(1) VARCHAR2(1) NOT NULL Column Number