Asset Table

The Asset table contains details of all the assets being managed within FlexNet Manager Suite.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for Asset table

Database Column

Details

AssetID

Type: integer. Key. Generated ID

A unique identifier for an asset.

ParentAssetID

Type: integer. Key. Nullable

The parent asset. Foreign key to another asset in this same Asset table.

ShortDescription

Type: text (max 256 characters)

A brief description of the asset.

SerialNumber

Type: text (max 150 characters). Key. Nullable

The serial number of the asset.

AssetTypeID

Type: integer. Key

The asset type. Foreign key to the AssetType table.

AssetTag

Type: text (max 256 characters). Nullable

A user-defined asset tag for a particular asset. This may be a barcode number.

AssetStatusID

Type: integer. Key

The status of the asset. Defaults to Purchased. Foreign key to the AssetStatus table.

PurchasePrice

Type: currency. Nullable

The purchase price of the asset.

PurchasePriceRateID

Type: integer. Nullable

The currency rate to apply to the purchase price of the asset. Foreign key to the CurrencyRate table.

AcquisitionModeID

Type: integer. Nullable

The method of acquisition used for the asset. Defaults to Purchased. Foreign key to the AcquisitionMode table.

PrimaryPurchaseOrderNo

Type: text (max 50 characters). Nullable

The purchase order number which was used to purchase the asset.

PrimaryPurchaseOrderDate

Type: datetime. Nullable

The date the primary purchase order was made.

VendorID

Type: integer. Key. Nullable

The vendor from whom the asset was purchased. Foreign key to the Vendor table.

Manufacturer

Type: text (max 200 characters). Nullable

The manufacturer of the asset.

ManufacturerPartNo

Type: text (max 100 characters). Nullable

The manufacturer’s part number for this asset.

ModelNo

Type: text (max 200 characters). Nullable

The model number of the asset.

DeliveryDate

Type: datetime. Nullable

The date the asset was received.

AssetWarrantyTypeID

Type: integer

The type of warranty for the asset. Defaults to None. Foreign key to the AssetWarrantyType table.

WarrantyExpirationDate

Type: datetime. Nullable

The date the warranty expires.

InstallationDate

Type: datetime. Nullable

The date the asset was installed.

RetirementDate

Type: datetime. Nullable

The date the asset was retired.

DisposalDate

Type: datetime. Nullable

The date the asset was disposed of.

DeletionDate

Type: datetime. Nullable

The date the asset was deleted.

InventoryDate

Type: datetime. Nullable

The date the asset last had inventory reported.

InventoryAgent

Type: text (max 64 characters). Nullable

The name of the person or tool that performed the last inventory.

InventoryDateManual

Type: datetime. Nullable

The date the asset last had inventory updated (entered) manually.

InventoryAgentManual

Type: text (max 64 characters). Nullable

The name of the person or tool that performed the last manual inventory.

RequestNo

Type: text (max 60 characters). Nullable

The request number for the asset.

PartNo

Type: text (max 100 characters). Nullable

The vendor’s part number for this asset.

IsLeased

Type: boolean

Flag to indicate if this asset is leased. This field is no longer in use in FlexNet Manager Suite.

LeaseNo

Type: text (max 60 characters). Nullable

The contract number of the lease agreement for this asset.

LeaseName

Type: text (max 100 characters). Nullable

A contract name of the lease agreement for this asset.

LeaseStartDate

Type: datetime. Nullable

The start date of the lease for this asset.

LeaseEndDate

Type: datetime. Nullable

The end date of the lease for this asset.

LeaseTerminationDate

Type: datetime. Nullable

The date that the lease for this asset is terminated.

LeaseEndReasonID

Type: integer

The reason for the end of lease for this asset.

LeasePrice

Type: currency. Nullable

The purchase price of the lease for this individual asset.

LeasePriceRateID

Type: integer. Nullable

The purchase price of the lease currency rate for this individual asset.

LeasePeriodicPayment

Type: currency. Nullable

The price of periodic payments associated with this contract.

LeasePeriodicPayment RateID

Type: integer. Nullable

The price of periodic payments currency rate associated with this contract.

LeasePeriodTypeID

Type: integer

The frequency with which the lease payments are applicable.

LeaseBuyoutCost

Type: currency. Nullable

The buyout cost of the lease for this asset.

LeaseBuyoutCostRateID

Type: integer. Nullable

The buyout cost of the lease currency rate associated for this asset.

LeaseComments

Type: text. Nullable

Comments recorded about the lease for this asset. This field is no longer in use in FlexNet Manager Suite.

AssignToUserID

Type: integer. Key. Nullable

The end-user the asset has been assigned to. Foreign key to the ComplianceUser table.

Comments

Type: text. Nullable

Comments entered about the asset.

ChargeBackPrice

Type: currency. Nullable

Amount to be charged back for the use of this asset. No calculations based on this charge and the frequency will be provided.

ChargeBackPriceRateID

Type: integer. Nullable

The currency rate to be applied to the charge back value of the asset. Foreign key to the CurrencyRate table.

ChargeBackPeriodTypeID

Type: integer

The frequency with which the charge back price is charged. Defaults to None. Foreign key to the PeriodType table.

EndOfLifeRecipient

Type: text (max 128 characters). Nullable

The person or organization who received the asset when it was disposed of.

EndOfLifeReasonID

Type: integer

The reason the asset was disposed of. Foreign key to the EndOfLifeReason table.

ResalePrice

Type: currency. Nullable

The amount the asset was sold for.

ResalePriceRateID

Type: integer. Nullable

The currency rate to be applied to the resale price of the asset. Foreign key to the CurrencyRate table.

CreationUser

Type: text (max 128 characters). Nullable

The operator who created the record.

CreationDate

Type: datetime

The date the record was created.

UpdatedUser

Type: text (max 128 characters). Nullable

The operator who last updated the record.

UpdatedDate

Type: datetime. Nullable

The date the record was last updated.

LocationID

Type: text (max 128 characters). Key. Nullable

Any enterprise location associated with this asset. Foreign key to the GroupEx table.

BusinessUnitID

Type: text (max 128 characters). Key. Nullable

Any corporate unit in the enterprise associated with this asset. Foreign key to the GroupEx table.

CostCenterID

Type: text (max 128 characters). Key. Nullable

Any cost center in the enterprise associated with this asset. Foreign key to the GroupEx table.

CategoryID

Type: text (max 128 characters). Key. Nullable

Any enterprise category associated with this asset. Foreign key to the GroupEx table.

DepreciationCurrentValue

Type: currency. Nullable

The current value of the asset, after depreciation has been applied.

DepreciationCurrent ValueRateID

Type: integer. Nullable

The currency rate to be applied to the depreciation current value of the asset. Foreign key to the CurrencyRate table.

DepreciationResidualValue

Type: currency. Nullable

The residual value of the asset (value when fully depreciated).

DepreciationResidual ValueRateID

Type: integer. Nullable

The currency rate to be applied to the residual value of the asset. Foreign key to the CurrencyRate table.

DepreciationMethodID

Type: integer. Nullable

The depreciation method (straight line or residual value). Foreign key to the DepreciationMethod table.

DepreciationPeriod

Type: integer

The depreciation period (in years), for customers to use for straight line depreciation.

DepreciationRate

Type: decimal. Nullable

The annual depreciation rate (as a percentage - like 50% per year), for customers to use for residual value depreciation. Stored as a value between 0 (for 0%) and 1 (for 100%).

WrittenOffValue

Type: currency. Nullable

The written-off value is the value of the asset at the time of retirement/disposal.

WrittenOffValueRateID

Type: integer. Nullable

The currency rate to be applied to the written-off value of the asset. Foreign key to the CurrencyRate table.