WM_CINQ_ASSET_R

(SQL Table)
Index Back

Cost Inquiry Asset Result

# 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_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

6 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_ASSET_VWA

7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

8 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
9 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: WM_WO_HDR

10 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
11 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: WM_AREA_PMT_VW

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURR_CD_EFF_VW

13 EST_COST_TOT Number(27,3) DECIMAL(26,3) NOT NULL Total Estimated Cost
14 ACTL_COST_TOT Number(27,3) DECIMAL(26,3) NOT NULL Actual Total Cost
15 VARIANCE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Variance Percent
16 REPLACEMENT_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Replacement Cost
17 REPLACE_COST_DT Date(10) DATE Last Update
18 INSURE_AMOUNT Number(30,3) DECIMAL(29,3) NOT NULL Insured Value
19 NET_BOOK_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Book Value
20 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset
21 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type
22 ACTL_START_DT Date(10) DATE Actual Start Date