MAINT_CONTRACT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VNDR_FS
3	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %Date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	CONTRACT_DT	Date(10)	DATE	Contract Date
8	END_DT	Date(10)	DATE	End Date
9	VENDOR_CONTACT	Character(30)	VARCHAR2(30) NOT NULL	Vendor Contact
10	RESPONSIBILITY	Character(30)	VARCHAR2(30) NOT NULL	Responsibility
11	CONTRACT_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Contract Cost
12	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
13	REFERENCE	Character(30)	VARCHAR2(30) NOT NULL	Field to show when a variable is a reference variable.
14	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
15	INVOICE_DT	Date(10)	DATE	Invoice Date
16	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
17	SERVICE_CONTACT	Character(30)	VARCHAR2(30) NOT NULL	Service Contact
18	SERVICE_PHONE	Character(12)	VARCHAR2(12) NOT NULL	Service Phone Number
19	COVERAGE	Long Character	CLOB	Coverage
20	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL