Rep_AssetDetailView
Reference No: 27056
(V 02.00.20-00)
Rep_AssetDetailView
Details
A Custom Report can be generated using the Rep_AssetDetailView which displays the details of the Assets. The details of the columns in the view are as given in Table 1.0.
Table 1.0. Column Reference Table
Column Name | Description |
ASSETID | Asset ID. |
ASSETDESCRIPTION | Asset Description. |
PRODUCTID | Product ID of the Asset. |
MODEL | Model. |
MODELYEAR | Model Year. |
ORDERLINESTATUS | Order line Status of the Asset. The various statuses are: Out Off-Rent Reserved In |
CUSTOMERNAME | Displays the Name of the Customer if Asset is Out or Sold. |
DATEONRENT | Date on Rent if Asset is Out. |
METERREADING | Meter Reading value. |
ASSETSHELF | Asset Shelf. |
ASSETBINNUMBER | Asset Bin Number. |
CURRENTBRANCH | Current Branch. |
TOTALCOST | Total Cost. |
NETBOOKVALUE | Net Book Value of the Asset. |
PAYABLECUSTOMERNAME | Payable Customer Name. |
LTDRENTALINCOME | Rental Income generated from the Asset from the time the Asset is acquired till date. |
LTDSERVICEEXPENSE | Service Expenses incurred for the Asset from the time the Asset is acquired till date. |
YTDRENTALINCOME | Rental Income generated from the Asset from the start of the current calendar year till date. |
YTDSERVICEEXPENSE | Service Expenses generated for the Asset from the start of the current calendar year till date. |
ATTACHMENTASSEID | Asset ID of the Attachment tagged to the Asset. |
SOLDPRICE | Invoice Amount of the Asset when Asset is Sold. |
DEPRECIATEDAMOUNT | Total Depreciated Amount of the Asset as in the Asset NBV History window. |
FIRSTINVOICEDATE | Sale Order Invoice Date when the Asset is sold. |
COSTOFSALE | Cost of the Asset at the time of selling the Asset as in the Asset NBV History window. |