CNTRCT_EVT_WS

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	TRANSACTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Transaction ID
6	DOC_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Doc Status Value
7	RELEASE_NBR	Number(5,0)	INTEGER NOT NULL	Release Number
8	CNTRCT_EVENT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Event Type PO=PO Release RC=Receipt RQ=Requisition VC=Voucher
9	EVENT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Event Status A=Active C=Closed I=Ineligible X=Canceled
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
12	INVOICE_DT	Date(10)	DATE	Invoice Date
13	TTL_MERCH_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amount
14	CNTRCT_ID_DST	Character(25)	VARCHAR2(25) NOT NULL	Contract ID To
15	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
16	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
17	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name