SPF_FILL_REQ_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR , A.BID_ID , A.LINE_ROW , A.SPF_RATE_FILL , A.SPF_LN_FILL_TOTAL , A.CURRENCY_CD_VNDR , A.SPF_RATE_FILL_BSE , A.SPF_LN_FIL_TOT_BSE , A.CURRENCY_CD_BASE , A.START_DATE , A.END_DATE , A.DURATION , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.SRVC_PROVIDER_ID , A.PROVIDER_CONTACT , A.SP_MSP_PERCENT , A.RATE_MULT , A.RATE_DIV , A.RATE_EFFDT , A.RT_TYPE , %subrec(SPB_AUDIT_SBR,A) , B.SPF_RATE , B.SPF_REQ_LN_TOTAL , B.CURRENCY_CD , B.SP_REQ_STATUS , B.JOB_TITLE , B.SP_NUM_OF_POSITION ,B.SPF_RATE_FILL_BSE , B.SPF_LN_FILL_TOTAL , A.LINKEDWORDER FROM PS_SPF_BID_LN_FILL A , PS_SPF_REQ_LINE B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.SP_REQ_ID = A.SP_REQ_ID AND B.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 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_ID Number(10,0) DECIMAL(10) NOT NULL Bid Id
5 LINE_ROW Number(5,0) INTEGER NOT NULL Line Row
6 SPF_RATE_FILL Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate
7 SPF_LN_FILL_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total
8 CURRENCY_CD_VNDR Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
9 SPF_RATE_FILL_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate in Base currency
10 SPF_LN_FIL_TOT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total in Base currency
11 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
12 START_DATE Date(10) DATE Start Date for Gen Standing PO
13 END_DATE Date(10) DATE End Date
14 DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
15 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
16 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
17 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
18 SRVC_PROVIDER_ID Character(15) VARCHAR2(15) NOT NULL Service Provider
19 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT
20 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
21 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
22 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
23 RATE_EFFDT Date(10) DATE Rate Effective Date
24 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.
25 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

Default Value: %DateTime

26 ROW_MODIFY_DATE DateTime(26) TIMESTAMP Modified Date Time

Default Value: %DateTime

27 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
28 ROW_MODIFY_USER Character(30) VARCHAR2(30) NOT NULL Modified User
29 SPF_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate
30 SPF_REQ_LN_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Stores the supplier's total rate.
31 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
32 SP_REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Requisition Status for Service Procurement
A=Approved
C=Complete
D=Denied
F=Filled
O=Open
P=Pending
R=On Hold
S=Sourced
X=Canceled
33 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
34 SP_NUM_OF_POSITION Number(5,0) INTEGER NOT NULL Number of Positions
35 SPF_AVG_RATE_FILL Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate
36 SPF_LN_AVFILL_TOT Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line average Filled total per position.
37 LINKEDWORDER Character(15) VARCHAR2(15) NOT NULL Linked Work Order