PeopleSoft 9
Account Payables

Table Name AP_MTCH_EXCPTN

Table Description
AP_MTCH_EXCPTN
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VOUCHER_LINE_NUM INT Yes Yes
MATCH_RULE_ID VARCHAR(10) Yes No
MTCH_EXCPTN_TYPE VARCHAR(4) No No
ASSTN_NAME VARCHAR(30) No No
SETID VARCHAR(5) No No
MATCH_CNTRL_ID VARCHAR(10) No No
VCHR_FLDVALUE VARCHAR(30) No No
PO_FLDVALUE VARCHAR(30) No No
RECV_FLDVALUE VARCHAR(30) No No
NOTIFY_DATE datetime No No
CREATION_DT datetime No No
PROCESS_INSTANCE DECIMAL(10) No No
Index
Name Type Unique Member
PS_AP_MTCH_EXCPTN PK Yes
Member(s) of "PS_AP_MTCH_EXCPTN" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
MATCH_RULE_ID

Published June 06, 2007