APOP_BSEPYMT_MV (SQL View)	Index Back
Base Payment MV MV based on the Payment transactional data (PAYMENT_TBL).

APOP_BSEPYMT_MV

(SQL View)

Base Payment MV

MV based on the Payment transactional data (PAYMENT_TBL).

SELECT PYMNT.BANK_SETID , PYMNT.BANK_CD , PYMNT.BANK_ACCT_KEY , PYMNT.PYMNT_ID , PYMNT.PYMNT_ID_REF , PYMNT.PYMNT_DT , PYMNT.PYMNT_METHOD , PYMNT.PYMNT_AMT , PYMNT.CURRENCY_PYMNT , PYMNT.REMIT_SETID , PYMNT.REMIT_VENDOR , PYMNT.PYMNT_HANDLING_CD , PYMNT.ACCOUNTING_DT , PYMNT.CANCEL_DT , PYMNT.OPRID , PYMNT.PYMNT_STATUS FROM %Table(PAYMENT_TBL) PYMNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

3 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

4 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number

5 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference

6 PYMNT_DT Date(10) DATE Payment Date

7 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

8 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount

9 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency

10 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

11 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

12 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling

13 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

14 CANCEL_DT Date(10) DATE Date Cancelled

15 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

16 PYMNT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Alignment
E=ACH/EFT Prenote
L=Stale Dated Payment
N=Reprinted with same ref number
O=Overflow
P=Paid
R=Replaced
S=Stopped
T=Undo Escheatment
U=Undo Cancel
V=Void
W=Escheated Check
X=Deleted

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
3	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
4	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
5	PYMNT_ID_REF	Character(20)	VARCHAR2(20) NOT NULL	Payment Reference
6	PYMNT_DT	Date(10)	DATE	Payment Date
7	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
8	PYMNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
9	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
10	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
11	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
12	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
13	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
14	CANCEL_DT	Date(10)	DATE	Date Cancelled
15	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
16	PYMNT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted