The Asset Object

This item maps to the Asset object in the IT Asset Management compliance database. It supports the addition of custom properties through the Business Importer.

Properties

The Asset object exposes the following properties in the data model for the Business Importer and the Business Adapter Studio.

Table 1. Data model properties for `Asset` object (alphabetical listing)
Property	Details
`Acquisition Mode`	Type: `nvarchar`. Maximum: 100. Values of `Acquisition Mode` must match those stored in the `AcquisitionMode` table of the compliance database.
`Asset Name`	Type: `nvarchar`. Maximum: 256. Mandatory: adapters must provide values for this column. Maps to `Asset.ShortDescription` in the compliance database.
`Asset Status`	Type: `nvarchar`. Maximum: 100. Values of `Asset Status` must match those stored in the `AssetStatus` table of the compliance database.
`Asset Tag`	Type: `nvarchar`. Maximum: 256. Maps to `Asset.AssetTag` in the compliance database.
`Asset Type`	Type: `nvarchar`. Maximum: 64. Values of `Asset Type` must match those stored in the `AssetType` table of the compliance database.
`Assigned To User ID`	Type: `int`. Stores the `AssignToUserID` as a foreign key to the `user` table in the compliance database.
`Category ID`	Type: `varchar`. Maximum: 128. Stores the `categoryID` as a foreign key to the `category` table in the compliance database.
`Charges Amount`	Type: `float`. Maps to `Asset.ChargeBackPrice` in the compliance database.
`Charges Amount Currency Rate ID`	Type: `int`. Stores the `ChargeBackPriceRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Charges Frequency`	Type: `nvarchar`. Maximum: 100. Values of `Charges Frequency` must match those stored in the `PeriodType` table of the compliance database.
`Comments`	Type: `ntext`. Maps to `Asset.Comments` in the compliance database.
`Corporate Unit ID`	Type: `varchar`. Maximum: 128. Stores the `businessunitID` as a foreign key to the `CorporateUnit` table in the compliance database.
`Cost Center ID`	Type: `varchar`. Maximum: 128. Stores the `costcenterID` as a foreign key to the `costcenter` table in the compliance database.
`Delivery Date`	Type: `datetime`. Maps to `Asset.DeliveryDate` in the compliance database.
`Depreciation Current Value`	Type: `float`. Maps to `Asset.DepreciationCurrentValue` in the compliance database.
`Depreciation Current Value Currency Rate ID`	Type: `int`. Stores the `DepreciationCurrentValueRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Depreciation Method`	Type: `nvarchar`. Maximum: 100. Values of `Depreciation Method` must match those stored in the `DepreciationMethod` table of the compliance database.
`Depreciation Period (Years)`	Type: `int`. Maps to `Asset.DepreciationPeriod` in the compliance database.
`Depreciation Rate (0-1)`	Type: `decimal`. Maps to `Asset.DepreciationRate` in the compliance database.
`Depreciation Residual Value`	Type: `float`. Maps to `Asset.DepreciationResidualValue` in the compliance database.
`Depreciation Residual Value Currency Rate ID`	Type: `int`. Stores the `DepreciationResidualValueRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Disposal Date`	Type: `datetime`. Maps to `Asset.DisposalDate` in the compliance database.
`End of Life Recipient`	Type: `nvarchar`. Maximum: 128. Maps to `Asset.EndOfLifeRecipient` in the compliance database.
`Installed On`	Type: `datetime`. Maps to `Asset.InstallationDate` in the compliance database.
`Inventoried By Electronic`	Type: `nvarchar`. Maximum: 64. Maps to `Asset.InventoryAgent` in the compliance database.
`Inventoried By Physical`	Type: `nvarchar`. Maximum: 64. Maps to `Asset.InventoryAgentManual` in the compliance database.
`Inventory Date Electronic`	Type: `smalldatetime`. Maps to `Asset.InventoryDate` in the compliance database.
`Inventory Date Physical`	Type: `datetime`. Maps to `Asset.InventoryDateManual` in the compliance database.
`Lease Agreement`	Type: `nvarchar`. Maximum: 200. Maps to `Asset.LeaseName` in the compliance database.
`Lease Buyout Cost`	Type: `money`. Maps to `Asset.LeaseBuyoutCost` in the compliance database.
`Lease Buyout Cost Currency Rate ID`	Type: `int`. Stores the `LeaseBuyoutCostRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Lease End Date`	Type: `datetime`. Maps to `Asset.LeaseEndDate` in the compliance database.
`Lease Number`	Type: `nvarchar`. Maximum: 120. Maps to `Asset.LeaseNo` in the compliance database.
`Lease Periodic Payment`	Type: `money`. Maps to `Asset.LeasePeriodicPayment` in the compliance database.
`Lease Periodic Payment Currency Rate ID`	Type: `int`. Stores the `LeasePeriodicPaymentRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Lease Price`	Type: `money`. Maps to `Asset.LeasePrice` in the compliance database.
`Lease Price Currency Rate ID`	Type: `int`. Stores the `LeasePriceRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Lease Start Date`	Type: `datetime`. Maps to `Asset.LeaseStartDate` in the compliance database.
`Lease Termination Date`	Type: `datetime`. Maps to `Asset.LeaseTerminationDate` in the compliance database.
`Lease Termination Reason`	Type: `nvarchar`. Maximum: 100. Values of `Lease Termination Reason` must match those stored in the `LeaseEndReason` table of the compliance database.
`Lease period type`	Type: `nvarchar`. Maximum: 100. Values of `Lease period type` must match those stored in the `PeriodType` table of the compliance database.
`Location ID`	Type: `varchar`. Maximum: 128. Stores the `locationID` as a foreign key to the `location` table in the compliance database.
`Manufacturer`	Type: `nvarchar`. Maximum: 100. Maps to `Asset.Manufacturer` in the compliance database.
`Manufacturer Part No`	Type: `nvarchar`. Maximum: 100. Maps to `Asset.ManufacturerPartNo` in the compliance database.
`Model No`	Type: `nvarchar`. Maximum: 200. Maps to `Asset.ModelNo` in the compliance database.
`Parent Asset ID`	Type: `int`. Stores the `ParentAssetID` as a foreign key to the `asset` table in the compliance database.
`Resale Price`	Type: `float`. Maps to `Asset.ResalePrice` in the compliance database.
`Resale Price Currency Rate ID`	Type: `int`. Stores the `ResalePriceRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Retirement Date`	Type: `datetime`. Maps to `Asset.RetirementDate` in the compliance database.
`Retirement Reason`	Type: `varchar`. Maximum: 100. Values of `Retirement Reason` must match those stored in the `EndOfLifeReason` table of the compliance database.
`Serial Number`	Type: `nvarchar`. Maximum: 150. Maps to `Asset.SerialNumber` in the compliance database.
`Warranty End Date`	Type: `datetime`. Maps to `Asset.WarrantyExpirationDate` in the compliance database.
`Warranty Type`	Type: `nvarchar`. Maximum: 100. Values of `Warranty Type` must match those stored in the `AssetWarrantyType` table of the compliance database.
`Written Off Value`	Type: `float`. Maps to `Asset.WrittenOffValue` in the compliance database.
`Written Off Value Currency Rate ID`	Type: `int`. Stores the `WrittenOffValueRateID` as a foreign key to the `currencyrate` table in the compliance database.

Data model version 13.2

IT Asset Management (Cloud)

Current