SPR_EXPCYCVS_VW (SQL View)	Index Back
Expense Life Cycle by Supplier sPro Expense Life Cycle by Supplier Summary View

SPR_EXPCYCVS_VW

(SQL View)

Expense Life Cycle by Supplier

sPro Expense Life Cycle by Supplier Summary View

SELECT A.OPRID ,A.BUSINESS_UNIT ,A.VENDOR_ID ,B.SP_SUPPLIER_NAME ,SUM(A.SPR_TOTAL_AMT) ,A.CURRENCY_CD FROM PS_SPR_EXPCYC_FACT A ,PS_SPR_SUPPLR_DIM B ,PS_SPB_METRIC_DFN C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VENDOR_ID = B.VENDOR_ID AND A.SPR_METRIC_CD = C.SPB_METRIC_CODE AND A.SPR_METRIC_CD IN ('ENT', 'SUB', 'APR', 'INA', 'ISA', 'INP', 'PRO') GROUP BY A.OPRID ,A.BUSINESS_UNIT, A.VENDOR_ID ,B.SP_SUPPLIER_NAME, A.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_SP_NONVW

3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

4 SP_SUPPLIER_NAME Character(40) VARCHAR2(40) NOT NULL Supplier Name

5 SPR_TOTAL_AMT Number(27,3) DECIMAL(26,3) NOT NULL sPro Total Amount Calculated from Hours Worked

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
Prompt Table: CURRENCY_CD_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	SP_SUPPLIER_NAME	Character(40)	VARCHAR2(40) NOT NULL	Supplier Name
5	SPR_TOTAL_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	sPro Total Amount Calculated from Hours Worked
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL