CNTRCT_EVT_WS1

(SQL Table)
Index Back

Contract Event Lines

06/25/2008 PKL F-AHAYT-S60K7 Contract Enhancements

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
4 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
8 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
9 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
10 EVENT_DT Date(10) DATE The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
11 EVENT_STATUS Character(2) VARCHAR2(2) NOT NULL Event Status
A=Active
C=Closed
I=Ineligible
X=Canceled
12 RELEASE_DTTM DateTime(26) TIMESTAMP Release Date/Time
13 MILESTONE_NBR Number(5,0) INTEGER NOT NULL Milestone Line Number
14 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
15 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number

Default Value: 0

16 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number