WM_CINQ_CAP_DT

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW
5	SHOP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shop Identification Prompt Table: WM_SHOP_HDR
6	WO_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Work Order Type
7	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Prompt Table: SP_BU_AM_NONVW
8	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
9	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
10	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	Asset Subtype Prompt Table: AM_SUBTYPE
11	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID Prompt Table: MANUFACTURER
12	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model Prompt Table: AM_MODEL_VW
13	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Prompt Table: WM_WO_HDR
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURR_CD_EFF_VW
15	CAPITALIZE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount to be Capitalized
16	ACTL_COST_TOT	Number(27,3)	DECIMAL(26,3) NOT NULL	Actual Total Cost