SPF_BDFTR_LST_V

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR , A.BID_FACTOR_CD , A.BID_FACTOR_NBR , A.AUC_BF_LIST_LINE , A.BID_LIST_ITEM , A.WEIGHTING FROM PS_SPF_BDFTR_LST A , PS_SPF_BID_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SP_REQ_ID = B.SP_REQ_ID AND A.LINE_NBR = B.LINE_NBR

# 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