PeopleSoft 9
Account Payables

Table Name CNTRCT_EVT_VCHR

Table Description
CNTRCT_EVT_VCHR
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
CNTRCT_ID VARCHAR(25) Yes Yes
CNTRCT_LINE_NBR int Yes Yes
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VOUCHER_LINE_NUM int Yes Yes
EVENT_DT PSDATE No No
EVENT_STATUS VARCHAR(2) No No
Index
Name Type Unique Member
PS_CNTRCT_EVT_VCHR PK Yes
Member(s) of "PS_CNTRCT_EVT_VCHR" Index
SETID
CNTRCT_ID
CNTRCT_LINE_NBR
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM

Published June 06, 2007