|
This data object is used to display all unit master detail information.
This information can be found in the Unit program within the Fusion business system.
URL
/frw/Unit
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AcquiringSalesperson | This field displays the salesperson associated with the acquisition of a unit. |
| AcquisitionDate | This field displays the date on which the unit was acquired. |
| AcquisitionMethod | This field displays the method by which a unit is aquired into inventory. |
| IsActiveUnit | This displays whether or not the given unit number is the active occurence for the unit. |
| ActualCashValue | This field displays the actual value of a trade-in unit at which it will be booked into inventory. |
| ActualShipDate | This field displays the date on which a unit was shipped. |
| AddDate | This field displays the date on which the unit was added. |
| AddUser | This field displays the user name that added the record. |
| AskingPrice | This field displays the amount, expressed in dollars that is being asked of for a unit. |
| AvailabilityStatus | This field displays the unit’s availability status (Available- In Stock, Not Available, Pending Trade, etc.). |
| Barcode | This field displays the bar code attached to a part. |
| BaseCost | This field displays the estimate of an additional unit’s cost before an invoice is received. |
| BillingMeterReading | This field displays the current Billing Meter for the given Unit. |
| BillingMeterReadingDate | This displays the date on which the current Billing Meter for the given unit was captured. |
| BookBranch | This field displays the book branch tied to a given Unit. |
| BuildDate | This field displays the date on which a unit was set to be built. |
| CharacteristicType | This field displays the unit’s characteristic type (truck, trailer, reefer, etc.). |
| Consignor | This field displays, if a unit was aquired through the method of consignement, the consignor of the unit. |
| ControlBranch | This field displays the controlling branch of a given unit. |
| ControlDepartment | This field displays the controlling department of a given unit within the controlling branch. |
| CurrencyCode | This field displays the currency code attached to a particular customer account. |
| CurrentCost | This field displays the cost returned from the Legacy system for schedule detail. |
| CurrentECMReading | This field displays the ECM reading of the unit. |
| CurrentECMReadingDate | This field displays the date the ECM reading was last updated. |
| CurrentMeterReading | This field displays the current meading reading of the unit. |
| CurrentMeterReadingDate | This field displays the date the meter reading was last updated. |
| CurrentTitleNumber | This field displays the Current Title Number for the unit. |
| DaysInInventory | This field displays the number of days the unit has been in inventory. |
| DaysInInventoryReceiveDate | This field displays the Days the Unit has been in Inventory based off of the Receive Date of the unit. |
| DaysInInventoryReceiveInvoiceDate | This field displays the Days the Unit has been in Inventory based off of the Invoice Date of the unit. |
| DueForServiceBranch | This field displays the branch in which the unit is due for preventive maintenance. |
| EquipmentClass | This field displays the equipment class of the given unit. |
| EquipmentType | This field displays the equipment type of the given unit. |
| EstimatedArrivalDate | This field displays the Estimated Arrival Date of the unit. |
| Export | This field is a flag to denote whether or not the Unit record can be exported (uploaded) to a website, etc. |
| FactoryOrderNumber | This field displays the number tied to a placed Factory Order. |
| FETCharged | This field displays whether or not FET is charged on the unit. |
| FETExemptDeliveryExpenses | This field displays any FET Exempt Delivery Expenses if it has been entered. |
| FETExemptEquipment | This field displays the FET Exempt Equipment amount if it has been entered. |
| FleetType | This field displays the fleet type of the given unit. |
| FlooringBalance | This field displays the flooring amount minus all principal payments. |
| GVWR | This field displays the Gross Vehicle Weight Rating (GVWR) of the Unit. |
| InServiceDate | This field displays the date on which an asset went into service. |
| InServiceDealerCode | This field displays the Warranty In Service Dealer Code. |
| InServiceMeterReading | This field displays the Warranty In Service Meter Reading. |
| Inactive | This field displays whether or not a given unit is set to inactive. |
| InventoryType | This field displays the unit’s inventory type (new truck, used truck, etc.). |
| LastUpdateDate | This field displays the date the given unit was last updated. |
| LastUpdateUser | This field displays the user name of the person who last updated the unit record. |
| ListPrice | This field displays either a user’s list price or a manufacturer’s list price. |
| LocationBranch | This field displays the location branch of a given asset. |
| LotLocation | This field displays the location of a unit. |
| LowPrice | This field displays the lowest asking price, expressed in dollars, listed for a unit. |
| Make | This field displays the make of a given unit. |
| Manufacturer | This field displays the manufacturer of a given unit. |
| MeterType | This field displays the unit’s meter type (gallons, hours, kilometers, etc.). |
| Model | This field displays the model of a given unit. |
| NewUnit | This field displays whether or not a unit is new. |
| OpenLpos | This field displays the sum of the expected amount of all LPOs whose purchasing status is “Open”. |
| OrderDate | This field displays the Order Date that the unit was ordered on. |
| PeriodType | This field displays the Warranty Period of the unit. |
| POBranch | This field displays the Branch that issued the Sales Purchase Order for the Unit. |
| PODealCustomer | This field displays the Customer Number tied to the Deal when the Deal number is referenced to a Sales Purchase Order. |
| PODealCustomerName | This field displays the Customer Name tied to the Deal when the Deal number is referenced to a Sales Purchase Order. |
| PODepartment | This field displays the Sales Department responsible for issuing the Sales Purchase Order. |
| PONumber | This field displays the customer’s PO number. |
| PreviousOwner | This field displays the previous owner of a unit. |
| ProductClass | This field displays the product class associated with a given lease/rental charge. |
| PurchaseCost | This field displays the amount for which a unit was purchased. Updates from the manufacture’s received invoice. |
| PurchaseOrderStatus | This field displays the status of a customer’s PO. |
| ReceiveInvoiceDate | This field displays the date on which a unit was received. |
| ReceiveInvoiceNumber | This field displays the received manufactuer’s invoice number. |
| ReceivedDate | This field displays the date on which a purchase order was received. |
| ReplenishStock | This flag is used to denote whether the unit was purchased to Replenish Stock or not. |
| RequestShipDate | This field displays the date on which shipment of a unit has been requested. |
| SellingStatus | This field displays the unit’s selling status (Available, Deal Contract, Sold, etc.). |
| SoldCustomerName | This field displays the Customer Name of the Customer that the Unit was sold to. |
| SoldCost | This field displays the Cost of the unit at the time the Unit was sold. |
| SoldCustomerKey | This field displays the Customer Number of the Customer that the Unit was sold to. |
| SoldCustomerAddress1 | This field displays Address Line 1 of the Customer that the Unit was sold to. |
| SoldCustomerAddress2 | This field displays Address Line 2 of the Customer that the Unit was sold to. |
| SoldCustomerCity | This field displays the City of the Customer that the Unit was sold to. |
| SoldCustomerCountry | This field displays the Country of the Customer that the Unit was sold to. |
| SoldCustomerCounty | This field displays the County of the Customer that the Unit was sold to. |
| SoldCustomerPostalCode | This field displays the Postal Code of the Customer that the Unit was sold to. |
| SoldCustomerRegion | This field displays the Region (State or Province) of the Customer that the Unit was sold to. |
| SoldDate | This field displays the date on which a core was sold. |
| SoldInvoiceNumber | This field displays the Invoice Number that the Unit was sold on. |
| SoldPrice | This field displays the Price of the unit at thte time the Unit was sold. |
| SoldSalesperson | This field displays the Salesperson responsible for the Sale of the unit. |
| SpecialPrice | This field displays the asking price, expressed in dollars, listed for a unit for a limited time. |
| SpecialPriceExpiration | This field displays the date a special price offered on a unit expires. |
| StockNumber | This field displays the stock number attached to a unit. |
| TemporaryLocationName | This field displays the Name of the Temporary location if one is associated with the unit. |
| TemporaryLocationType | This field displays the Temporary Location Type (Branch, Vendor or Customer) if one is associated with the unit. |
| TireTaxCredit | This field displays the tire tax credit FET exempt amount assigned to the give unit. This amount comes from the value assigned to the unit in the unit file. If the amount for the unit is overwritten on a deal, it will not be reflected here. |
| TitleRegion | This field displays the Region (State or Province) the Title was issued from for the Unit. |
| TotalUnitCost | This field displays the sum of Base Cost, Current Cost, and Open LPOs. |
| TradeInAllowance | This field displays the amount, in dollars for which is offered on a trade-in unit. |
| UnitCostConversion | This field displays the value used to control when the cost of the unit is converted from the foreign currency to the local currency (i.e., during receive invoice, when the unit is added to the quote, during invoicing, or when accounting is posted). |
| UnitCostConverted | This field denotes whether Cost of the Unit has been converted using Currency Exchange. |
| UnitIndicator | This field displays the unit indicator of the given unit. |
| UnitNumber | This field displays the ID number of a unit attached to a given note. |
| UsageType | This field displays the Usage Type of the Unit if they have been established and assigned to the unit. |
| VIN | This field displays the Vehicle Identification Number. |
| VoidOrderDate | This field displays the Void Order Date of the Sales Purchase Order if it has been Voided. |
| WarrantyContract | This field displays the Warranty Contract information for the unit. |
| WarrantyMeter | This field displays the Meter Reading for the Unit’s Warranty. |
| WarrantyPeriod | This field displays the Warranty Period for the Unit’s Warranty. |
| Year | This field displays the model year of the unit. |