AP_PMTMASS_TMP1 (SQL Table)	Index Back
AP Payment Mass Maint Wrk

AP_PMTMASS_TMP1

(SQL Table)

AP Payment Mass Maint Wrk

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: AP_PMT_FLD_VW

2 SRCH_OPER Character(1) VARCHAR2(1) NOT NULL Search operator
===
B=between
Default Value: =

3 FROM_MIXED_P Character(50) VARCHAR2(50) NOT NULL Equal To

4 TO_MIXED_P Character(50) VARCHAR2(50) NOT NULL To Value

5 FROM_VALUE_DATE Date(10) DATE Equal To

6 TO_VALUE_DATE Date(10) DATE To Date

7 AND_LABEL Character(1) VARCHAR2(1) NOT NULL And

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: AP_PMT_FLD_VW
2	SRCH_OPER	Character(1)	VARCHAR2(1) NOT NULL	Search operator === B=between Default Value: =
3	FROM_MIXED_P	Character(50)	VARCHAR2(50) NOT NULL	Equal To
4	TO_MIXED_P	Character(50)	VARCHAR2(50) NOT NULL	To Value
5	FROM_VALUE_DATE	Date(10)	DATE	Equal To
6	TO_VALUE_DATE	Date(10)	DATE	To Date
7	AND_LABEL	Character(1)	VARCHAR2(1) NOT NULL	And