AP_MECCL_FLTR

(SQL Table)
 Index Back

AP MECC - Filter Page Table

AP MECC - Filter Page Table - Stores the Filter Criteria for each User

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
5 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
6 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
7 MATCH_RULE_ID Character(10) VARCHAR2(10) NOT NULL Match Rule ID
8 AP_MECC_ASSIGNTO Character(30) VARCHAR2(30) NOT NULL UserID of the person exception is assigned to
9 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
10 SUPPLIER_ID Character(10) VARCHAR2(10) NOT NULL Supplier ID
11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
12 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
13 AP_MEC_AGE_DAYS Number(5,0) INTEGER NOT NULL Aged Days
14 AP_MECC_STATUS Character(1) VARCHAR2(1) NOT NULL Match Exception Status
A=Assigned
M=Match Ready
O=Open
R=Resolved
U=Unassigned
15 DSCNT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Discount
16 NAME1_OPERATOR Character(1) VARCHAR2(1) NOT NULL OperatorName
C=Contains
E=Equal to
N=Not equal to
17 FROM_DT Date(10) DATE From Date
18 TO_DT Date(10) DATE To Date
19 AP_MEC_DT_SELCT Character(1) VARCHAR2(1) NOT NULL Date Selection Option
R=Relative Dates
S=Specific Dates
20 COMPARE_RULE Character(3) VARCHAR2(3) NOT NULL Rule
<=Less than
<==Less than or equal to
==Equal to
>=Greater than
>==Greater than or equal to
ANY=Any