PMT_DET_SRCH_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Payment id Prompt Table: PMT_DETAIL_TBL
2	SRC_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Source ref id Prompt Table: PMT_SRC_REF_VW
3	FROM_BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	From Bank ID Number Prompt Table: BANK_ID_VW
4	FROM_BNK_ACCT_NUM	Character(35)	VARCHAR2(35) NOT NULL	From Bank Account # Prompt Table: BANK_ACCTNUM_VW
5	PMT_SOURCE	Character(10)	VARCHAR2(10) NOT NULL	Source System Name Prompt Table: PMT_SRC_DEFN
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_FS_NONVW
7	PYMNT_DT	Date(10)	DATE	Payment Date
8	PMT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Payment status C=Canceled CM=Cancelled with Message E=Error H=Flagged for Hold L=Awaiting Dispatch N=Not Processed P=Paid PC=Pending Cancellation PR=Pending Reversal R=Received by Bank RM=Reversed with Message S=Dispatched to Bank SC=In Process
9	PMT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Payment type BAX=Bank Transfer BON=Bonus COLL=Collection DEAL=Deal Cash Flow EFTR=EFT Request EXAD=Exp Advance EXPN=Expense Sheet FEE=Fee GR=General Recipient Deduction IR=Individual Recipient Deduction NP=Net Pay Distribution OTHR=Other SAL=Salary VCHR=Voucher
10	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