EM_PYMTINQ_FLTR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	ENTERED_DT	Date(10)	DATE	Entered on
3	PYMNT_ID_REF	Character(20)	VARCHAR2(20) NOT NULL	Payment Reference
4	EM_PYMNT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=All P=Paid R=Replaced V=Void Default Value: A
5	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty. Default Value: OPR_BANK_VW_AP.BANK_SETID Prompt Table: SP_SETBNK_NONVW
6	BENEFICIARY_BANK	Character(30)	VARCHAR2(30) NOT NULL	The bank/counterparty associated with a given beneficiary.
7	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
8	BENEF_BRANCH	Character(30)	VARCHAR2(30) NOT NULL	Beneficiary Branch field
9	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
10	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor Prompt Table: EM_S_RM_VNDR_VW
11	REMIT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Remit to Location Prompt Table: EM_RMVND_LC_VW2
12	FROM_DT	Date(10)	DATE	From Date
13	TO_DT	Date(10)	DATE	To Date
14	COMPARE_RULE	Character(3)	VARCHAR2(3) NOT NULL	Amount Reference <=Less than <==Less than or equal to ==Equal to >=Greater than >==Greater than or equal to ANY=Any Default Value: ANY
15	PYMNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
16	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency Prompt Table: CURR_PYMNT_VW
17	MAX_ROWS	Number(3,0)	SMALLINT NOT NULL	Maximum Rows retrieved Default Value: 300
18	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: EM_BU_VNAGRT_VW