GM_PROP_VNDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_GL
2	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID Prompt Table: GM_PROP_ID_VW
3	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID Prompt Table: GM_PROPOSAL
4	SUB_PROP_NBR	Character(15)	VARCHAR2(15) NOT NULL	SUB_PROP_NBR
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 10
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: GM_VNDR_APRV_VW
7	THIRD_PRTY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Third Party Amount
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: VENDOR_ADDR_VW
10	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VNDR_CNTCT_SCR
11	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
12	SUBCONTRACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Subcontract Type C=Cost Reimbursement F=Fixed Price N=Not Applicable O=Other P=Fixed Price Plus Fee
13	SPONSOR_APPROVAL	Character(1)	VARCHAR2(1) NOT NULL	Sponsor Approval Required D=Not Yet Determined N=No Y=Yes
14	EXPENSE_AUTH	Character(1)	VARCHAR2(1) NOT NULL	Authorization for Expenses? Y/N Table Edit
15	START_DT	Date(10)	DATE	Start Date
16	END_DT	Date(10)	DATE	End Date
17	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
18	SUBRECIPIENT_ST	Character(1)	VARCHAR2(1) NOT NULL	Subrecipient Status C=Not Accepted F=Fully Executed H=Holding O=Other P=Pending T=Terminated W=Not Awarded
19	SUB_METHOD_CHOSEN	Character(30)	VARCHAR2(30) NOT NULL	Method Chosen