APOP_DELVCHR_MV

(SQL View)
Index Back

Deleted Voucher summarized MV

Deleted Voucher summarized MV

SELECT A.DELETE_DT , A.BUSINESS_UNIT , %Sql(AP_FUNCLIB_DATE_YEAR_UPD, A.DELETE_DT) %Concat '-' %Concat %Sql(AP_FUNCLIB_DATE_MONTH_UPD, A.DELETE_DT) , A.OPRID_LAST_UPDT , A.VCHR_SRC , A.VOUCHER_STYLE , A.TXN_CURRENCY_CD , A.ORIGIN , COUNT(*) , SUM(A.GROSS_AMT) FROM %Table(APOD_DELVCHR_MV) A GROUP BY A.DELETE_DT , A.BUSINESS_UNIT , A.OPRID_LAST_UPDT , A.VCHR_SRC , A.VOUCHER_STYLE , A.TXN_CURRENCY_CD , A.ORIGIN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DELETE_DT Date(10) DATE Deletion 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 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
9 INVOICE_COUNT Number(12,0) DECIMAL(12) NOT NULL Invoice Count
10 AP_SUM_AMT Signed Number(33,3) DECIMAL(31,3) NOT NULL Total Amount