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