PeopleSoft 9
Account Payables

Table Name AP_MTH_RULETYPE

Table Description
AP_MTH_RULETYPE
Columns
Name Datatype Is PK Is FK
MTCH_RULE_TYPE VARCHAR(15) Yes No
DESCR VARCHAR(30) No No
AP_DM_ACTION VARCHAR(1) No No
AP_EXCPT_ACTION VARCHAR(1) No No
AP_MATCH_ACTION VARCHAR(1) No No
AP_OVERRIDE_ACTION VARCHAR(1) No No
AP_LOG_ACTION VARCHAR(1) No No
AP_MTCH_OVRD 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 VARCHAR(30) No No
QRYNAME VARCHAR(30) No No
Index
Name Type Unique Member
PS_AP_MTH_RULETYPE PK Yes
Member(s) of "PS_AP_MTH_RULETYPE" Index
MTCH_RULE_TYPE

Published June 06, 2007