Table 101 MVC_ASSETSUMMARY (continued)
Column Name | Type | Description |
|
|
|
STORAGETIERCOSTPERGB | NUMBER(36,2) | Asset storage Tier cost |
|
|
|
DEPARTMENTNO | VARCHAR2(255) | Asset department no |
|
|
|
DEPARTMENTNAME | VARCHAR2(255) | Asset department Name |
|
|
|
PERCENTAGEOWNED | NUMBER(5, 2) | Percentage owned by Department |
|
|
|
ADMINISTRATOR | VARCHAR2(255) | Asset maintained by |
|
|
|
STAFFNAME | VARCHAR2(255) | Staff Name |
|
|
|
STAFFPHONENUMBER | VARCHAR2(255) | Staff PH# |
|
|
|
STAFFDEPARTMENT | VARCHAR2(255) | Staff Department |
|
|
|
STAFFEMAIL | VARCHAR2(255) | Staff |
|
|
|
RACKNUMBER | VARCHAR2(100) |
|
|
|
|
FLOOR | VARCHAR2(100) |
|
|
|
|
DATACENTER | VARCHAR2(100) |
|
|
|
|
CITY | VARCHAR2(100) |
|
|
|
|
REGION | VARCHAR2(100) |
|
|
|
|
COUNTRY | VARCHAR2(50) |
|
|
|
|
CONTINENT | VARCHAR2(20) |
|
|
|
|
ADDRESS | VARCHAR2(1024) |
|
|
|
|
ZIPCODE | VARCHAR2(16) |
|
|
|
|
LICENSE | VARCHAR2(4000) |
|
|
|
|
PURCHASEORDERNUMBER | VARCHAR2(255) | Asset Purchase Order no |
|
|
|
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 |
|
|
|
Storage Essentials 5.00.01 User Guide 477