HP Storage Essentials V5.1 User Guide First Edition (T4283-96026, August 2006)

Storage Essentials 5.1 User Guide 523
DATEPURCHASED DATE Asset Date purchased
COST NUMBER(36,2) Asset cost
VALUE NUMBER(36,2)
SALVAGECOST NUMBER(36,2) Asset Deprecated Salvage Cost
DEPRECITIONPERIOD NUMBER(18) Asset Deprecation Period
DEPRECITIONMETHOD NUMBER(16) Asset Deprecation Method ('Straight line',
'Fixed declining', 'Double declining')
DEPRECITEDVALUE NUMBER(36,2) Asset Depreciated Value
RESELLER VARCHAR2(255) Asset Reseller
COMMENTS VARCHAR2(4000) Comments
ASSETFIXCOSTTAXPERDEPTPE
RYEAR
NUMBER Asset Fixed cost tax per department per
Year
STORAGFIXCOSTTAXPERDEP
TPERYEAR
NUMBER Storage Fixed cost tax per department per
Year
Table 106 MVC_ASSETSUMMARY (continued)
Column Name Type Description
Table 107 MVC_APPLICATIONSUMMARYVW
Column Name Type Description
APPLICATIONID NUMBER(38) Application ID
APPLICATIONNAME VARCHAR2(256) Application Name
DOMAINID NUMBER(38) Domain ID
APPLICATIONTYPE NUMBER(38) Application type
VENDOR VARCHAR2(254) Vendor
DESCRIPTION VARCHAR2(1024) Description of the application
STATUS NUMBER(38) Operational status
BUILDNUMBER VARCHAR2(254) Software build number
SERIALNUMBER VARCHAR2(254) Software serial number
TARGETOS VARCHAR2(254) Target operating system