Table 101 MVC_ASSETSUMMARY (continued)

Column Name

Type

Description

 

 

 

RESELLER

VARCHAR2(255)

Asset Reseller

 

 

 

COMMENTS

VARCHAR2(4000)

Comments

 

 

 

 

NUMBER

Asset Fixed cost tax per department per

ASSETFIXCOSTTAXPERDEPTPE

 

Year

RYEAR

 

 

 

 

 

 

NUMBER

Storage Fixed cost tax per department per

STORAGFIXCOSTTAXPERDEPT

 

Year

PERYEAR

 

 

 

 

 

Table 102 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

 

 

 

PRODUCTNAME

VARCHAR2(254)

Product name

 

 

 

VERSION

VARCHAR2(254)

Software version

 

 

 

IDENTIFICATIONCODE

VARCHAR2(254)

Software identification code

 

 

 

SOFTWAREELEMENTID

VARCHAR2(254)

Software element ID

 

 

 

HOSTID

NUMBER(38)

ID of host where the application is running

 

 

from

 

 

 

478 Running Reports