WM_ASSETBASE_VW

(SQL View)
 Index Back

Asset General Information


SELECT BUSINESS_UNIT , ASSET_ID , ASSET_TYPE , ASSET_SUBTYPE , PARENT_ID , COMPONENT_OF_ID , ASSET_ASSIGNED_TO , TAGGABLE_SW , TAG_NUMBER , DESCR , DESCRSHORT , ASSET_STATUS , FINANCIAL_ASSET_SW , REPLACE_SW , REPLACE_ASSET_ID , CONVERSION_ID , NEW_ASSET_SW , AVAIL_SW , AVAIL_CONTACT , AVAIL_PHONE , ACQUISITION_CD , ACQUISITION_DT , FINANCING_CD , REPLACEMENT_COST , REPLACE_COST_DT , LEASE_ASSET_ID , PROFILE_ID , ASSET_CLASS , CAP_NUM , CAP_SEQUENCE , MFG_ID , MANUFACTURER , MODEL , PROD_VERSION , SERIAL_ID , PRODUCTION_DT , PLANT , MANUFACTUR_CONTACT , BUSINESS_UNIT_JV , INDEX_NAME , INDEX_DETAIL_NAME , LAST_INDEX_VALUE , COMPOSITE_SW , COMPOSITE_ID , FERC_CD , GROUP_ASSET_FLAG , CURRENCY_CD , RD_PLANT_ASSET , RD_START_DT , RD_USE_NBV , IP_ADDRESS , IP_ALIAS , COLLATERAL_ASSET , CLUSTERED_ASSET , LIFE , LAST_REVIEW_DT , AM_AST_UD_CHAR1 , AM_AST_UD_CHAR2 , AM_AST_UD_DATE1 , AM_AST_UD_NUM1 , AM_AST_UD_NUM2 , LAST_CALC_RPL_COST , HAZARDOUS_SW , SS_STATUS , VIN , ASSET_RESOURCE_SW , ALLOW_OVERBOOK_SW , CHARGE_BACK_SW , SCHEDULABLE_SW , EPL_TMPL_ID , REPAIRABLE_FLG , REPAIR_STATUS , BUSINESS_UNIT_WO , SHOP_ID , UNOWNED_FLG , WO_LOCATION_FLG , OFFLINE_FLG , ASSET_CRITICALITY , CREW_ID , AVAIL_FOR_USE , IT_UD_CHAR1 , IT_UD_CHAR2 , IT_UD_DATE1 , IN_SERVICE_DT , REGION_CD , SKU , CRM_IPROD_ID , CRM_IPROD_SETID , CRM_IPROD_STATUS , CRM_DEPT_SETID , DESCR_LONG , LINEAR_ASSET_SW , NBR_OF_CPU , CAP_THRSHLD_ID , IN_PHY_USE , SYNCID , SYNCDTTM , ARO_SW , ARO_ID FROM PS_ASSET WHERE ASSET_TYPE <> '200'

  • Related Language Record: ASSET_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

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

    Default Value: NEXT

    3 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
    4 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

    5 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID

    Prompt Table: PARENT_ASSET

    6 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset

    Prompt Table: AM_COMPONENT

    7 ASSET_ASSIGNED_TO Character(12) VARCHAR2(12) NOT NULL Asset Assigned To
    8 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
    N=Non Taggable Asset
    Y=Taggable Asset
    9 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ASSET.DESCR

    12 ASSET_STATUS Character(1) VARCHAR2(1) NOT NULL Asset Status
    A=Received (Not in Service)
    B=Budgeted
    C=Commitment
    D=Disposed
    I=In Service
    M=Suspended
    R=Requisitioned
    T=Transferred
    W=Work In Progress

    Default Value: I

    13 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
    N=Non Cap
    Y=Capitalize

    Y/N Table Edit

    Default Value: N

    14 REPLACE_SW Character(1) VARCHAR2(1) NOT NULL Replacement Asset

    Y/N Table Edit

    Default Value: N

    15 REPLACE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Replaced Asset ID

    Prompt Table: ASSET

    16 CONVERSION_ID Character(15) VARCHAR2(15) NOT NULL Old Asset ID
    17 NEW_ASSET_SW Character(1) VARCHAR2(1) NOT NULL New Asset
    N=Used Asset
    Y=New Asset

    Default Value: Y

    18 AVAIL_SW Character(1) VARCHAR2(1) NOT NULL Asset is Available

    Y/N Table Edit

    Default Value: N

    19 AVAIL_CONTACT Character(30) VARCHAR2(30) NOT NULL Availability Contact
    20 AVAIL_PHONE Character(12) VARCHAR2(12) NOT NULL Availability Phone
    21 ACQUISITION_CD Character(1) VARCHAR2(1) NOT NULL Acquisition Code
    C=Constructed
    D=Donated
    I=Trade In
    K=Like Exchange
    L=Leased
    P=Purchased
    T=Transferred

    Default Value: P

    22 ACQUISITION_DT Date(10) DATE Acquisition Date
    23 FINANCING_CD Character(5) VARCHAR2(5) NOT NULL Financing Code

    Prompt Table: FINANCE_CD_TBL

    24 REPLACEMENT_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Replacement Cost
    25 REPLACE_COST_DT Date(10) DATE Last Update
    26 LEASE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Lease Asset ID

    Prompt Table: LEASE_SRCH2

    27 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: PROFILE_TBL

    28 ASSET_CLASS Character(10) VARCHAR2(10) NOT NULL Asset Class

    Prompt Table: ASSET_CLASS_TBL

    29 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #

    Prompt Table: CAP_OPEN_VW

    30 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence

    Prompt Table: CAP_DET_OPEN_VW

    31 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    32 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
    33 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: MFG_MODEL

    34 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version
    35 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    36 PRODUCTION_DT Date(10) DATE Production Date
    37 PLANT Character(30) VARCHAR2(30) NOT NULL Manufacturing Plant
    38 MANUFACTUR_CONTACT Character(30) VARCHAR2(30) NOT NULL Manufacturing Contact
    39 BUSINESS_UNIT_JV Character(5) VARCHAR2(5) NOT NULL Joint Venture BUS Unit
    40 INDEX_NAME Character(20) VARCHAR2(20) NOT NULL Index Name

    Prompt Table: AM_INDEX_TBL

    41 INDEX_DETAIL_NAME Character(35) VARCHAR2(35) NOT NULL SubIndex Name

    Prompt Table: AM_INDEX_DETAIL

    42 LAST_INDEX_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Last Index Value
    43 COMPOSITE_SW Character(1) VARCHAR2(1) NOT NULL Composite Asset

    Y/N Table Edit

    Default Value: N

    44 COMPOSITE_ID Character(12) VARCHAR2(12) NOT NULL Composite Asset ID

    Prompt Table: ASSET_COMPO1_VW

    45 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

    Prompt Table: FERC_CD_TBL

    46 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
    G=Group Asset
    M=Group Member
    N=None

    Default Value: N

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

    Default Value: CURR_CD_AM_VW.CURRENCY_CD

    48 RD_PLANT_ASSET Character(1) VARCHAR2(1) NOT NULL R and D Plant Asset

    Y/N Table Edit

    49 RD_START_DT Date(10) DATE R and D Start Date
    50 RD_USE_NBV Character(1) VARCHAR2(1) NOT NULL Use NBV for R and D

    Y/N Table Edit

    51 IP_ADDRESS Character(39) VARCHAR2(39) NOT NULL Internet Protocol Address
    52 IP_ALIAS Character(35) VARCHAR2(35) NOT NULL Internet Address Alias/UNC
    53 COLLATERAL_ASSET Character(2) VARCHAR2(2) NOT NULL Collateral Asset
    01=Mortgage
    02=Fixed Mortgage
    03=Factory Foundation Mortgage
    04=Others
    54 CLUSTERED_ASSET Character(1) VARCHAR2(1) NOT NULL Clustered Asset

    Y/N Table Edit

    55 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
    56 LAST_REVIEW_DT Date(10) DATE Used for Australian VAT - last date of mandatory review
    57 AM_AST_UD_CHAR1 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field1
    58 AM_AST_UD_CHAR2 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field2
    59 AM_AST_UD_DATE1 Date(10) DATE User Defined Date Field1
    60 AM_AST_UD_NUM1 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field1
    61 AM_AST_UD_NUM2 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field2
    62 LAST_CALC_RPL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Last calculated replacement cost
    63 HAZARDOUS_SW Character(1) VARCHAR2(1) NOT NULL Hazardous Asset

    Y/N Table Edit

    Default Value: N

    64 SS_STATUS Character(1) VARCHAR2(1) NOT NULL Strategic Sourcing Status
    A=Sent to Auction
    N=Not allowed to be Auctioned
    S=Sold in Auction
    Y=Allowed to be Auctioned
    65 VIN Character(18) VARCHAR2(18) NOT NULL VIN
    66 ASSET_RESOURCE_SW Character(1) VARCHAR2(1) NOT NULL Field to indicate that an Asset is used as a tool or resource

    Y/N Table Edit

    67 ALLOW_OVERBOOK_SW Character(1) VARCHAR2(1) NOT NULL Allow Overbooking

    Y/N Table Edit

    Default Value: N

    68 CHARGE_BACK_SW Character(1) VARCHAR2(1) NOT NULL Charge Back Switch
    D=Default
    N=No
    Y=Yes

    Default Value: D

    69 SCHEDULABLE_SW Character(1) VARCHAR2(1) NOT NULL Schedulable Switch

    Y/N Table Edit

    Default Value: N

    70 EPL_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Parts List Template

    Prompt Table: EPL_LOOKUP_VW

    71 REPAIRABLE_FLG Character(1) VARCHAR2(1) NOT NULL Repairable Flag

    Y/N Table Edit

    Default Value: N

    72 REPAIR_STATUS Character(1) VARCHAR2(1) NOT NULL Repair Status
    0=None
    1=Needs Repair
    2=In Repair

    Default Value: 0

    73 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

    Prompt Table: SP_BU_WM_NONVW

    74 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

    Prompt Table: AM_WM_SHOP

    75 UNOWNED_FLG Character(1) VARCHAR2(1) NOT NULL Non-Owned Asset

    Y/N Table Edit

    76 WO_LOCATION_FLG Character(1) VARCHAR2(1) NOT NULL Work Order Location
    1=Shop Location
    2=Asset Location
    3=Other Location
    77 OFFLINE_FLG Character(1) VARCHAR2(1) NOT NULL Asset Offline

    Y/N Table Edit

    Default Value: N

    78 ASSET_CRITICALITY Character(2) VARCHAR2(2) NOT NULL Asset Criticality

    Prompt Table: AM_CRIT_LVL

    79 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name

    Prompt Table: AM_CREW_VW

    80 AVAIL_FOR_USE Character(1) VARCHAR2(1) NOT NULL Available For Use

    Y/N Table Edit

    81 IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field1
    82 IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field2
    83 IT_UD_DATE1 Date(10) DATE IT User Defined Date Field
    84 IN_SERVICE_DT Date(10) DATE In Service Date
    85 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: REGION_CD_RP

    86 SKU Character(50) VARCHAR2(50) NOT NULL Stock Keeping Unit

    Prompt Table: AM_SKU_ITEM

    87 CRM_IPROD_ID Character(20) VARCHAR2(20) NOT NULL For CRM integration of IT Assets
    88 CRM_IPROD_SETID Character(5) VARCHAR2(5) NOT NULL For CRM integration of IT Assets
    89 CRM_IPROD_STATUS Character(3) VARCHAR2(3) NOT NULL For CRM integration of IT Assets
    INS=Install
    UNI=Uninstall
    90 CRM_DEPT_SETID Character(5) VARCHAR2(5) NOT NULL For CRM integration of IT Assets
    91 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
    92 LINEAR_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Linear Asset

    Y/N Table Edit

    93 NBR_OF_CPU Number(3,0) SMALLINT NOT NULL Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU.
    94 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID

    Prompt Table: CAP_THR_DEFN

    95 IN_PHY_USE Character(1) VARCHAR2(1) NOT NULL Describes if entity is in physical use.

    Y/N Table Edit

    Default Value: N

    96 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

    Default Value: 0

    97 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    98 ARO_SW Character(1) VARCHAR2(1) NOT NULL Asset Retirement Obligations
    N=No
    Y=Yes

    Y/N Table Edit

    99 ARO_ID Character(12) VARCHAR2(12) NOT NULL ARO Identification