PeopleSoft 9
Account Payables

Table Name MISMTCH_RPT

Table Description
MISMTCH_RPT
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes No
VOUCHER_ID VARCHAR(8) Yes No
VOUCHER_LINE_NUM INT Yes No
VENDOR_ID VARCHAR(10) No No
VENDOR_NAME1 VARCHAR(40) No No
INVOICE_ID VARCHAR(30) No No
GROSS_AMT DECIMAL(26,3) No No
MERCHANDISE_AMT DECIMAL(26,3) No No
INVOICE_DT datetime No No
WTHD_SW VARCHAR(1) No No
Index
Name Type Unique Member
PS_MISMTCH_RPT PK Yes
Member(s) of "PS_MISMTCH_RPT" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM

Published June 06, 2007