AP_VCHR_ATT_CNT (SQL View)	Index Back
Voucher Attachment count Attachment Count View

AP_VCHR_ATT_CNT

(SQL View)

Voucher Attachment count

Attachment Count View

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , COUNT(B.VOUCHER_ID) FROM PS_VOUCHER A LEFT OUTER JOIN PS_AP_VCHR_ATT B ON A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND B.SCM_ATTACH_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 ATTACHMENT_NUM Number(5,0) INTEGER NOT NULL Attachment Number

#	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	ATTACHMENT_NUM	Number(5,0)	INTEGER NOT NULL	Attachment Number