APOP_PMNTTYS_MV

(SQL View)
Index Back

Payments Summarized MV

Payments Summarized MV

SELECT A.PYMNT_DT , %Sql(AP_FUNCLIB_DATE_YEAR_UPD, A.PYMNT_DT) %Concat '-' %Concat %Sql(AP_FUNCLIB_DATE_MONTH_UPD, A.PYMNT_DT) , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_METHOD , A.CURRENCY_PYMNT , COUNT(*) , SUM(A.PYMNT_AMT) FROM %Table(APOP_PYMNTDT_MV) A GROUP BY A.PYMNT_DT , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_METHOD , A.CURRENCY_PYMNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PYMNT_DT Date(10) DATE Payment Date
2 AP_PERIOD_NAME Character(35) VARCHAR2(35) NOT NULL Period Name
3 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
4 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
5 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
6 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
7 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
8 AP_PYMNT_COUNT Number(12,0) DECIMAL(12) NOT NULL Total Count
9 AP_SUM_AMT Signed Number(33,3) DECIMAL(31,3) NOT NULL Total Amount