SPF_WO_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PM_NONVW
4	SP_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Request ID
5	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT Set Control Field: BUSINESS_UNIT_PC
6	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
7	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID Default Value: NEXT
10	LINKEDWORDER	Character(15)	VARCHAR2(15) NOT NULL	Linked Work Order Prompt Table: SPF_LNKWO_VW
11	WO_CONID	Character(15)	VARCHAR2(15) NOT NULL	Service Provider's ID assigned on work order Prompt Table: SPF_CNDIDATE_VW
12	TE_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets. Prompt Table: SPA_TE_TMPL_VW
13	SPF_REQ_LN_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Stores the supplier's total rate.