AP_WC_VCHKKE_V2 (SQL View)	Index Back
AP Workcenter Comm Ctrl Errors AP Workcenter Committment Control Errors

AP_WC_VCHKKE_V2

(SQL View)

AP Workcenter Comm Ctrl Errors

AP Workcenter Committment Control Errors

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , SUM(1) FROM PS_APWC_KKXCPTRAN2 A WHERE A.KK_PROCESS_STATUS = 'E' 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