Rep_EquipmentWithOrderDetView

Reference No: 26965

(V 02.00.20-00)

Rep_EquipmentWithOrderDetView

Details

A Custom Report can be generated using the Rep_EquipmentWithOrderDetView which displays the details of the Equipment on the Order. The Rep_EquipmentWithOrderDetView has all the columns of the existing view named Rep_EquipmentDetailsView, along with some additional columns. The details of the columns in the view are as given in Table 1.0.

Table 1.0. Column Reference Table

Column Name	Description
INVIID	Product IID.
ASSETID	Asset ID.
DESCRIPTION	Equipment Description.
STATUS	Equipment Status.
BINNUMBER	Equipment Bin Number.
AVAILABLELOCATION	Equipment Available Location.
ACQUIREDSTATUS	Acquired Status.
CURRENTLOCATIONID	Current Location ID where the Asset is present.
CURRENTLOCATIONNAME	Current Location Name where the Asset is present.
CONTRACTNUMBER	Order Number.
BILLINGCUSTOMERID	Billing Customer ID of the Order.
BILLINGCUSTOMERNAME	Billing Customer Name of the Order.
OWNERLOCATIONID	Owner Location ID of the Asset.
OWNERLOCATIONNAME	Owner Location Name of the Asset.
OWNERLOCATION	Owner Location of the Asset.
ONWORKORDER	Asset Status on Work Order.
WORKORDERID	Work Order ID.
WOSEGMENTID	Work Order Segment ID.
WOCUSTOMERNAME	Work Order Customer Name.
RENTALSTATUS	Rental Status.
SALESMAN	Name of the Sales Person of the Order / Work Order.
ASSETMODEL	Asset Model.
ASSETMFR	Asset Manufacturer.
ASSETMFRSERIALNO	Asset Manufacturer Serial Number.
ORDERCATEGORY	Order Category.
STATUSDATE	Status Date.
MAINCUSTOMERID	Main Customer ID of the Order.
MAIINCOMPANYNAME	Main Customer Name of the Order.
RATE	Order line level price.
BILLINGTERMID	Billing Term ID tagged to the Order.
BILLINGTERMDESCRIPTION	Billing Term Description tagged to the Order.
UNIT	Order line level Unit. The various live level Units are: Weekly Day AMPM Hour Each Monthly
TOTALINVOICEAMT	Sum of posted invoices amount for the particular asset.
NOOFOPENWOS	Number of open Work Orders.
DAYPRICE	Order line level Day Price.
WEEKPRICE	Order line level Week Price.
MONTHPRICE	Order line level Month Price.
DURATION	Order line level Duration.
SELLPRICE	Equipment Sell Price
SHELF	Shelf.
MODEL	Model.
SERVICESTATUS	Service Status.
LASTRENTEDDATE	Last rented date of the Equipment.
RECEIVEDDATE	Asset Received Date.
RETIREDFLAG	Asset retired or not. 0 - Asset is Active. 1 - Asset is Retired.
DAMAGEDFLAG	Asset Damaged or not. 0 - Asset is not Damaged. 1 - Asset is Damaged.
NBV	Net Book Value.
CATEGORY	Category.
SUBCATEGORY	Sub-Category.
CONTRACTDESCRIPTION	Order Description.
PONUMBER	PO Number tagged to the Order.
PICKUPDATE	Order Pickup Date.
OFFRENTDATE	Order Off-Rent Date.
PICKUPID	Pickup Order ID.
ORDERLINESTATUS	Order line Status.
COMMENTS	Order Comments.