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 128 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.