WM_PM_PJC_TLSRQ

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PJC_ID	Character(10)	VARCHAR2(10) NOT NULL	Projection ID
4	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
5	RQMT_LN_NBR	Number(5,0)	INTEGER NOT NULL	Requirement Line Number Default Value: 1
6	ASSET_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Asset Type 010=IT Hardware 020=IT Software 040=Equipment 050=Property 060=Fleet 070=Machinery 080=Furniture 090=Facility 100=Intangible 200=Asset Retirement Obligations 999=Other
7	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	Asset Subtype Prompt Table: AM_SUBTYPE
8	MANUFACTURER	Character(60)	VARCHAR2(60) NOT NULL	Manufacturer Name Prompt Table: %EDITTABLE
9	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model Prompt Table: %EDITTABLE2
10	RQMT_QTY	Signed Number(12,0)	DECIMAL(11) NOT NULL	Required Quantity
11	RQMT_UOM	Character(3)	VARCHAR2(3) NOT NULL	Unit of Measure for requirement
12	REQ_DURATION	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Schedule Duration
13	REQ_USAGE	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Estimated Usage
14	REQ_START_DT	Date(10)	DATE	Required Start Default Value: WM_WO_TSK.REQ_START_DT
15	REQ_END_DT	Date(10)	DATE	Required End Default Value: WM_WO_TSK.REQ_END_DT
16	TOOL_COST_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Rate
17	TOOL_BILL_RATE	Number(27,3)	DECIMAL(26,3) NOT NULL	Billing Rate
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY
19	TOOL_UOM	Character(3)	VARCHAR2(3) NOT NULL	Tools Unit of Measure Prompt Table: UNITS_TBL
20	EST_COST_TLS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Tools Cost
21	EST_BILL_TLS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Billing Amount