PeopleSoft 9
Account Payables

Table Name CNTRCT_EVT_PO

Table Description
CNTRCT_EVT_PO
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
PO_ID VARCHAR(10) Yes Yes
LINE_NBR int Yes Yes
EVENT_DT PSDATE No No
EVENT_STATUS VARCHAR(2) No No
RELEASE_NBR int No No
RELEASE_DTTM PSDATETIME No No
MILESTONE_NBR int No No
Index
Name Type Unique Member
PS_CNTRCT_EVT_PO PK Yes
PSACNTRCT_EVT_PO IE1 No
Member(s) of "PS_CNTRCT_EVT_PO" Index
SETID
CNTRCT_ID
CNTRCT_LINE_NBR
BUSINESS_UNIT
PO_ID
LINE_NBR
Member(s) of "PSACNTRCT_EVT_PO" Index
SETID
CNTRCT_ID
BUSINESS_UNIT
PO_ID
LINE_NBR

Published June 06, 2007