AUC_LINE

(SQL Table)
Index Back

Event Lines

Main event line table.

  • 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    7 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
    N=No
    Y=Yes

    Y/N Table Edit

    8 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
    G=Group Line
    L=Line Item

    Default Value: L

    9 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
    10 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    11 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Prompt Table: SP_BU_AM_NONVW

    12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: %EDITTABLE26

    13 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    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: %EDIT_UOM

    15 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    16 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

    Prompt Table: ITEM_MFG_ID_VW

    17 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    19 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    20 PRICE_RESERVE Number(16,5) DECIMAL(15,5) NOT NULL Reserve Price
    21 PRICE_CLOSE Number(16,5) DECIMAL(15,5) NOT NULL Close Price
    22 QTY_AUC_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Event Quantity
    23 QTY_AUC_MAX Number(16,4) DECIMAL(15,4) NOT NULL Quantity Max
    24 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
    25 AUC_PRICE Number(17,5) DECIMAL(16,5) NOT NULL Event Start price
    26 AUC_EXT_PRICE Number(18,5) DECIMAL(17,5) NOT NULL Auction Extended Price
    27 AUC_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length
    28 AUC_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width
    29 AUC_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight
    30 AUC_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Volume
    31 AUC_ITEM_SIZE Character(5) VARCHAR2(5) NOT NULL Item Size
    32 AUC_ITEM_COLOR Character(15) VARCHAR2(15) NOT NULL Sourcing Item Color
    33 AUC_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height
    34 AUC_WEIGHT_UOM Character(3) VARCHAR2(3) NOT NULL Weight UOM

    Prompt Table: UNITS_TBL

    35 AUC_VOLUME_UOM Character(3) VARCHAR2(3) NOT NULL Volume UOM

    Prompt Table: UNITS_TBL

    36 AUC_DIMENSION_UOM Character(3) VARCHAR2(3) NOT NULL Dimension UOM

    Prompt Table: UNITS_TBL

    37 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
    38 AUC_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Event Line Status
    C=Closed
    O=Open

    Default Value: O

    39 AUC_QTY_AWARDED Number(16,4) DECIMAL(15,4) NOT NULL Event Line Quantity Awarded

    Default Value: 0

    40 AUC_QTY_POSTED Number(16,4) DECIMAL(15,4) NOT NULL Event Line Quantity Posted

    Default Value: 0

    41 AUC_USER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL User Defined Price Breaks

    Y/N Table Edit

    Default Value: N

    42 AUC_BIDDER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL Bidder defined price breaks

    Y/N Table Edit

    Default Value: N

    43 AUC_DSP_START_PRC Character(1) VARCHAR2(1) NOT NULL Display Start Price

    Y/N Table Edit

    44 PREV_LINE_NBR Number(5,0) INTEGER NOT NULL Previous Line Number
    45 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    46 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
    1=Ship To Location
    2=Ship From Location
    3=Buyer's Location
    4=Supplier's Location
    47 AUC_ALT_UOM Character(1) VARCHAR2(1) NOT NULL Alternate Units of Measure
    A=Any UOM
    I=Only existing item/uom's
    N=Not Allowed
    48 AUC_BID_GRP_ONLY Character(1) VARCHAR2(1) NOT NULL Item Biddable Only if Grouped

    Y/N Table Edit

    Default Value: N

    49 AUC_BID_QTY_RULE Character(2) VARCHAR2(2) NOT NULL Bid Quantity Rule
    MQ=Bid Up to Maximum Quantity
    NA=Quantity Not Applicable
    RQ=Requested Quantity Required
    XQ=Allow Extra Quantity to be Bid
    50 BID_GROUP_SRC Character(1) VARCHAR2(1) NOT NULL Bid Group Source
    B=Bidder Defined
    U=User Defined
    51 AUC_AMT_ONLY_REQ Character(1) VARCHAR2(1) NOT NULL Amount Only Requistion reference - sourcing line originating from requisition.

    Y/N Table Edit

    Default Value: N

    52 AUC_ALLOW_GRP Character(1) VARCHAR2(1) NOT NULL Allow Groups

    Y/N Table Edit

    Default Value: N

    53 BID_LIN_STATUS_1 Character(1) VARCHAR2(1) NOT NULL Bid Line Status
    54 QTY_AUC_GRP_C Character(15) VARCHAR2(15) NOT NULL Qty Req String