SPF_BID_FILL_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.BID_ID , A.LINE_ROW , A.SP_REQ_ID , A.LINE_NBR , A.SPF_RATE , A.SPF_BID_LINE_TOTAL , A.CURRENCY_CD , A.SPF_RATE_VNDR , A.SPF_RATE_VNDR , A.SPF_BIDLN_TTL_VNDR , A.CURRENCY_CD_VNDR , A.SPF_RATE_BSE , A.SPF_RATE_BSE , A.SPF_BIDLN_TTL_BSE , A.CURRENCY_CD_BASE , C.START_DATE , C.END_DATE , C.DURATION , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , B.SRVC_PROVIDER_ID , B.PROVIDER_CONTACT , C.SP_RATE_UOM , C.SPF_EXP_RATE_BSE , C.SP_EXP_RATE_UOM , C.SP_UTILIZATION , A.SP_MSP_PERCENT , A.RATE_MULT , A.RATE_DIV , A.RATE_EFFDT , A.RT_TYPE , C.SPF_EXPENSE_RATE , %subrec(SPB_AUDIT_SBR,A) FROM PS_SPF_BID_LINE A , PS_SPF_BID_HDR B , PS_SPF_REQ_LINE C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.BID_ID = A.BID_ID AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.SP_REQ_ID = A.SP_REQ_ID AND C.LINE_NBR = A.LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BID_ID Number(10,0) DECIMAL(10) NOT NULL Bid Id
3 LINE_ROW Number(5,0) INTEGER NOT NULL Line Row
4 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 SPF_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate
7 SPF_BID_LINE_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL field used to store the total bid amount for deliverable based spro reqs
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 SPF_RATE_VNDR Signed Number(16,4) DECIMAL(14,4) NOT NULL Field for the Vendor rate
10 SPF_RATE_FILL Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate
11 SPF_LN_FILL_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total
12 CURRENCY_CD_VNDR Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
13 SPF_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Base Rate field for sPro Requisitions
14 SPF_RATE_FILL_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate in Base currency
15 SPF_LN_FIL_TOT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total in Base currency
16 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
17 START_DATE Date(10) DATE Start Date for Gen Standing PO
18 END_DATE Date(10) DATE End Date
19 DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
20 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
21 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
22 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
23 SRVC_PROVIDER_ID Character(15) VARCHAR2(15) NOT NULL Service Provider
24 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT
25 SP_RATE_UOM Character(3) VARCHAR2(3) NOT NULL Rate Unit of Measure
26 SPF_EXP_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Expense Rate in base currency
27 SP_EXP_RATE_UOM Character(3) VARCHAR2(3) NOT NULL stores the supplier's rate uom
28 SP_UTILIZATION Number(3,0) SMALLINT NOT NULL Utilization%
29 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
30 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
31 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
32 RATE_EFFDT Date(10) DATE Rate Effective Date
33 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
34 SPF_EXPENSE_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Expense Rate
35 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

Default Value: %DateTime

36 ROW_MODIFY_DATE DateTime(26) TIMESTAMP Modified Date Time

Default Value: %DateTime

37 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
38 ROW_MODIFY_USER Character(30) VARCHAR2(30) NOT NULL Modified User