AP_WC_TSEVCH_VW (SQL View)	Index Back
AP Workcenter Vchr Error Count AP Workcenter Voucher Error Count

AP_WC_TSEVCH_VW

(SQL View)

AP Workcenter Vchr Error Count

AP Workcenter Voucher Error Count

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , COUNT(B.VOUCHER_ID) FROM PS_VOUCHER A , PS_TSE_VCHR_FLD B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT (+) AND A.VOUCHER_ID = B.VOUCHER_ID (+) GROUP BY A.BUSINESS_UNIT , A.VOUCHER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

3 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter