WM_CINQ_CAP_D

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
2	SEARCH_ID	Character(10)	VARCHAR2(10) NOT NULL	Search ID
3	SEARCH_RES_KEY	Character(20)	VARCHAR2(20) NOT NULL	Search Key
4	LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Level
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW
6	SHOP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shop Identification Prompt Table: WM_SHOP_HDR
7	WO_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Work Order Type
8	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Prompt Table: SP_BU_AM_NONVW
9	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
10	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
11	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	Asset Subtype Prompt Table: AM_SUBTYPE
12	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID Prompt Table: MANUFACTURER
13	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model Prompt Table: AM_MODEL_VW
14	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Prompt Table: WM_WO_HDR
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURR_CD_EFF_VW
16	CAPITALIZE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount to be Capitalized
17	ACTL_COST_TOT	Number(27,3)	DECIMAL(26,3) NOT NULL	Actual Total Cost