APOP_VCHRSUM_MV (SQL View)	Index Back
Voucher summarized MV Voucher summarized MV

APOP_VCHRSUM_MV

(SQL View)

Voucher summarized MV

SELECT A.INVOICE_DT , A.BUSINESS_UNIT , %Sql(AP_FUNCLIB_DATE_YEAR_UPD, A.INVOICE_DT) %Concat '-' %Concat %Sql(AP_FUNCLIB_DATE_MONTH_UPD, A.INVOICE_DT) , A.OPRID , A.VCHR_SRC , A.VOUCHER_STYLE , A.TXN_CURRENCY_CD , A.ENTRY_STATUS , A.ORIGIN , COUNT(*) , SUM(A.GROSS_AMT) FROM %Table(APOP_INVOICE_MV) A GROUP BY A.INVOICE_DT , A.BUSINESS_UNIT , A.OPRID , A.VCHR_SRC , A.VOUCHER_STYLE , A.TXN_CURRENCY_CD , A.ENTRY_STATUS , A.ORIGIN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INVOICE_DT Date(10) DATE Invoice Date

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

3 AP_PERIOD_NAME Character(35) VARCHAR2(35) NOT NULL Period Name

4 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID

5 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source

6 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher

7 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

8 ENTRY_STATUS Character(1) VARCHAR2(1) NOT NULL If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Reviewed through Maintenance
M=Modified
O=Open
P=Postable
R=Recycle
S=Scheduled for Payment
T=Template Voucher
X=Deleted

9 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

10 INVOICE_COUNT Number(12,0) DECIMAL(12) NOT NULL Invoice Count

11 AP_SUM_AMT Signed Number(33,3) DECIMAL(31,3) NOT NULL Total Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INVOICE_DT	Date(10)	DATE	Invoice Date
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	AP_PERIOD_NAME	Character(35)	VARCHAR2(35) NOT NULL	Period Name
4	OPRID2	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
5	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
6	VOUCHER_STYLE	Character(4)	VARCHAR2(4) NOT NULL	Voucher Style ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher TMPL=Template Voucher
7	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
8	ENTRY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down. C=Complete D=Through batch defaults E=Edited by Batch Voucher Module L=Reviewed through Maintenance M=Modified O=Open P=Postable R=Recycle S=Scheduled for Payment T=Template Voucher X=Deleted
9	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
10	INVOICE_COUNT	Number(12,0)	DECIMAL(12) NOT NULL	Invoice Count
11	AP_SUM_AMT	Signed Number(33,3)	DECIMAL(31,3) NOT NULL	Total Amount