This data object is used to return all information from a unit on a lease or rental contract from within the Fusion business system.

This is found within the Lease Rental Contract Unit program within the Fusion business system.

URL

/frw/LRContractUnit

Field Details…

SQL Field Name Column Description
AddDate This field display the date and time the record was added.
AddUser This field displays the user name that added the record.
AllowedForFixed This field displays what percentage of the new CPI a customer is subject to for fixed charges.
AllowedForVariable This field displays what percentage of the new CPI a customer is subject to for variable charges.
Area This field displays the location where commodities are being hauled.
BillFuelTicketOnLRInvoice This field displays whether or not the unit will have fuel invoices charged to it.
CharacteristicType This field displays the unit’s characteristic type (truck, trailer, reefer, etc.).
ChildUnits This field displays whether or not the given unit has any child units attached to it.
ChildUnitsOnContract This field displays whether or not the given unit has any child units  added on the contract.
Commodity This field displays the commodity that will be hauled in then given vehicle.
ContractNumber This field displays the number attached to a contract.
LeaseContractStatus This field displays the status of the  given contract.
CustomerPO This field displays the customer purchase order associated with the given unit.
FirstName This field displays the driver’s first name.
LastName This field displays the driver’s last name.
DriverMiddleInitial This field displays the driver’s middle initial.
EndingMeter This field displays the meter reading for the given unit when the contract ended.
EquipmentClass This field displays the classification of inventory, such as different size trailers.
EquipmentType This field displays the equipment type of the given unit.
EstimatedBilledMeter This field displays the value used to calculate the variable billing for each billing cycle.
FleetType This field displays the fleet type for the given unit.
IsHazardous This field displays whether or not a commodity being hauled is hazardous.
LastBillThruFixed This field displays the date the unit is billed thru for fixed charges.
LastBillThruVariable This field displays the date the unit is billed thru for variable charges.
LastCPI This field displays the Consumer Price Index number when CPI was last calculated.
LastUpdateDate This field display the date and time the record was last updated.
UpdateUser This field displays the user name of the individual who made the update.
ExpirationDate This field displays the date on which a customer’s liability insurance policy expires.
PolicyNumber This field displays the customer’s liability insurance policy number.
InsuranceProvider This field displays the name of a customer’s liability insurance provider.
LicenseExpiration This field displays the date on which a driver’s license expires.
LicenseNumber This field displays the driver’s license number of the driver on a unit.
RentalRate This field displays the rental rate for a reservation or agreement.
Make This field displays the make of the given unit.
MaxAnnualMeter This field displays the maximum annual meter reading on the given unit.
MaxAnnualofIncreaseFixed This field displays the maximum annual adjustment allowable increase for Fixed Charges, based on the increase in the Consumer Price Index.
MaxAnnualofIncreaseVariable This field displays the maximum annual adjustment allowable increase for Variable Charges, based on the increase in the Consumer Price Index.
MeterAllowance This field displays the maximum number of miles that can be put on the given unit on a given contract.
MeterReading This field displays the current meter reading for the given unit.
MinAnnualMeter This field displays the minimum annual reading on the given unit.
Model This field displays the model of the given unit.
ProductionYear This field displays the production year of the given unit.
MonthsBeforeCPICalculated This field displays the time, in months, before any Consumer Price Index increases can take hold.
IsNoReturnDate This field displays that a unit on a contract does not have a return date.
OriginalUnit This field displays the unit number that the given unit is being substituted for.
OutDate This field displays the date on which a contract began.
ParentUnitNumber This field displays the number(s) attached to any parents units.
PhysicalDamangeInsuranceExpirationDate  
PhysicalDamageInsurancePolicyNumber This field displays the customer’s physical damage insurance policy number.
PhysicalDamageInsuranceProvider  
PreviouslyBilledMeter This field displays the meter reading at the time billing last occurred for the given unit.
ReturnBranch This field displays the branch where a unit will be returned.
ReturnDate This field displays the time when a unit on a contract is due back.
UserName This field displays the user name assigned as the salesperson on the given contract.
StaringCPI This field displays the Consumer Price Index at the time a unit became active on a contract.
StartingMeter This field displays the starting meter for the given unit on a contract.
SubUnit This field displays whether the given unit is acting as a substitute for another unit.
IsSubjectToCPI This field displays whether or not a unit is subject to Consumer Price Index increases.
SubsAllowed This field displays whether the given unit is able to be substituted with another unit.
Term This field displays the customer’s payment terms for invoices.
TotalBilledMeter This field displays the Total Billed Meter for the given unit (running total of meter intervals).
UnitIndicator This field displays the unit’s unit indicator.
UnitNumber This field displays the ID number of a unit attached to a given note.
LeaseContractUnitStatus This field displays the status of the given unit on the contract.
Vin This field displays the Vehicle Identification Number.