107 mvc_applicationsummaryvw, Table 107 – HP Storage Essentials NAS Manager Software User Manual

Page 555

Advertising
background image

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

Advertising