SPF_BDFTR_LST

(SQL Table)
Index Back

Requisition Bid Factor List

Service Procurement Requisition Bid Factor List. Child table of SPF_BDFTR_REQLN

  • Parent record: SPF_BDFTR_REQLN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    4 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
    5 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
    6 AUC_BF_LIST_LINE Signed Number(6,0) DECIMAL(5) NOT NULL List Line number
    7 BID_LIST_ITEM Character(60) VARCHAR2(60) NOT NULL List Item
    8 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
    9 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number