PeopleSoft 9
Account Payables

Table Name AP_MTCH_RULES

Table Description
AP_MTCH_RULES
Columns
Name Datatype Is PK Is FK
MATCH_RULE_ID VARCHAR(10) Yes No
DESCR50 VARCHAR(50) No No
MTCH_RULE_TYPE VARCHAR(15) No No
MTCH_RULE_LEVEL VARCHAR(2) No No
MESSAGE_SET_NBR INT No No
MESSAGE_NBR INT No No
SQLID VARCHAR(30) No No
DESCR254 VARCHAR(254) No No
OVERRIDE_FLAG VARCHAR(1) No No
WORKFLOW_FLG VARCHAR(1) No No
SEND_EMAIL VARCHAR(1) No No
DAYS_NOTIFY SMALLINT No No
USER_SOURCE VARCHAR(1) No No
ROLENAME VARCHAR(30) No No
SQLID_WHERE VARCHAR(30) No No
ASSTN_SQLID VARCHAR(30) No No
QRYNAME VARCHAR(30) No No
AP_LABEL_NAME VARCHAR(50) No No
SHOW_LABEL VARCHAR(1) No No
DM_CATEGORY VARCHAR(1) No No
TOLERANCE_LEVEL VARCHAR(1) No No
AP_TOL_TYPE VARCHAR(1) No No
Index
Name Type Unique Member
PS_AP_MTCH_RULES PK Yes
Member(s) of "PS_AP_MTCH_RULES" Index
MATCH_RULE_ID

Published June 06, 2007