PeopleSoft 9
Account Payables

Table Name MTCH_VCHR_MSG

Table Description
MTCH_VCHR_MSG
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
BUSINESS_UNIT_PO VARCHAR(5) Yes No
PO_ID VARCHAR(10) Yes No
LINE_NBR INT Yes No
BUSINESS_UNIT_RECV VARCHAR(5) Yes No
RECEIVER_ID VARCHAR(10) Yes No
RECV_LN_NBR INT Yes No
MATCH_CNTRL_ID VARCHAR(10) Yes No
MATCH_RULE_ID VARCHAR(10) Yes No
OPRID VARCHAR(30) Yes No
MATCH_LEVEL VARCHAR(3) No No
EXCEPTION_ROUTE VARCHAR(3) No No
BUYER_ID VARCHAR(30) No No
Index
Name Type Unique Member
PS_MTCH_VCHR_MSG PK Yes
Member(s) of "PS_MTCH_VCHR_MSG" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
BUSINESS_UNIT_PO
PO_ID
LINE_NBR
BUSINESS_UNIT_RECV
RECEIVER_ID
RECV_LN_NBR
MATCH_CNTRL_ID
MATCH_RULE_ID
OPRID

Published June 06, 2007