SPF_BIDFIL_WO_V

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.BID_ID , A.LINE_ROW , A.SP_REQ_ID , A.LINE_NBR ,A.WORK_ORDER_ID ,A.SEQNBR , 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.COMPUNIT , 0 , C.WO_EXP_RATE_UOM , C.SP_UTILIZATION , A.SP_MSP_PERCENT , A.RATE_MULT , A.RATE_DIV , A.RATE_EFFDT , A.RT_TYPE , 0 , %subrec(SPB_AUDIT_SBR,A) FROM PS_SPF_BID_LINE A , PS_SPF_BID_HDR B , PS_SPF_WO_SERVICE1 C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.BID_ID = A.BID_ID AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.WORK_ORDER_ID = A.WORK_ORDER_ID AND C.SEQNBR = A.SEQNBR

# 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 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
7 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
8 SPF_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate
9 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
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 SPF_RATE_VNDR Signed Number(16,4) DECIMAL(14,4) NOT NULL Field for the Vendor rate
12 SPF_RATE_FILL Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate
13 SPF_LN_FILL_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total
14 CURRENCY_CD_VNDR Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
15 SPF_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Base Rate field for sPro Requisitions
16 SPF_RATE_FILL_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate in Base currency
17 SPF_LN_FIL_TOT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total in Base currency
18 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
19 START_DATE Date(10) DATE Start Date for Gen Standing PO
20 END_DATE Date(10) DATE End Date
21 DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
22 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
23 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
24 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
25 SRVC_PROVIDER_ID Character(15) VARCHAR2(15) NOT NULL Service Provider
26 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT
27 SP_RATE_UOM Character(3) VARCHAR2(3) NOT NULL Rate Unit of Measure
28 SPF_EXP_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Expense Rate in base currency
29 SP_EXP_RATE_UOM Character(3) VARCHAR2(3) NOT NULL stores the supplier's rate uom
30 SP_UTILIZATION Number(3,0) SMALLINT NOT NULL Utilization%
31 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
32 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
33 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
34 RATE_EFFDT Date(10) DATE Rate Effective Date
35 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.
36 SPF_EXPENSE_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Expense Rate
37 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

Default Value: %DateTime

38 ROW_MODIFY_DATE DateTime(26) TIMESTAMP Modified Date Time

Default Value: %DateTime

39 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
40 ROW_MODIFY_USER Character(30) VARCHAR2(30) NOT NULL Modified User