Contents

Collateral Lease

Collateral Lease conditions allow you to query accounts based on collateral lease criteria.

Condition	Table	Column	Description
AccountID	Collateral_Lease	AccountID	Code that identifies the Latitude account associated to the piece of collateral.
CollateralID	Collateral_Lease	CollateralID	Code that identifies the vehicle.
ContractMiles	Collateral_Lease	ContractMiles	Mileage allowed under the leasing contract.
ContractObligation	Collateral_Lease	ContractObligation	Total amount due under the lease agreement. This amount excludes the security deposit, sales tax, and any other fees and taxes paid to a third party.
Created	Collateral_Lease	Created	Date the lease was first created
CreatedBy	Collateral_Lease	CreatedBy	User who created the lease
DisposalAssessedAmount	Collateral_Lease	DisposalAssessedAmount	Amount charged to dispose of the vehicle.
DispositionDate	Collateral_Lease	DispositionDate	Date the leasing agency determined the status of the returned vehicle.
EffectiveDate	Collateral_Lease	EffectiveDate	Date the lease became effective.
EndofTermMiles	Collateral_Lease	EndofTermMiles	Mileage at the end of the lease term.
EndofTermTaxAssessed	Collateral_Lease	EndofTermTaxAssessed	Tax assessed at the end of the lease.
ExcessMileage	Collateral_Lease	ExcessMileage	Amount charged for each mile over the mileage limit.
ExcessMiles	Collateral_Lease	ExcessMiles	Number of miles over the contract and purchased miles.
ID	Collateral_Lease	ID	Code that Latitude assigned to identify the lease record in Latitude.
InceptionMiles	Collateral_Lease	InceptionMiles	Mileage at the beginning of the lease term.
InspectionReceivedDate	Collateral_Lease	InspectionReceivedDate	Date the leasing agency inspected the vehicle.
MajorWearCharge	Collateral_Lease	MajorWearCharge	Amount charged for major wear on the vehicle.
MaturityDate	Collateral_Lease	MaturityDate	Date the lease matured.
MileageCredit	Collateral_Lease	MileageCredit	Amount credited for unused mileage.
MinorWearCharge	Collateral_Lease	MinorWearCharge	Amount charged for minor wear on the vehicle.
OriginalMiles	Collateral_Lease	OriginalMiles	Original mileage on the leased vehicle.
OtherTaxAssessed	Collateral_Lease	OtherTaxAssessed	Amount charged for other taxes (for example, property tax).
PurchaseMiles	Collateral_Lease	PurchaseMiles	Number of extra miles purchased.
Residual	Collateral_Lease	Residual	Lease-end value of the vehicle.
ResidualGainLoss	Collateral_Lease	ResidualGainLoss	Difference between the residual value and the end-of-lease purchase price.
ReturnDate	Collateral_Lease	ReturnDate	Date the leasing agency received the vehicle.
SecurityDeposit	Collateral_Lease	SecurityDeposit	Amount the lessee paid as a security deposit.
TermMonths	Collateral_Lease	TermMonths	Length of the lease, in months.
UnpaidMonthsPayment	Collateral_Lease	UnpaidMonthsPayment	Amount in unpaid payments that the lessee owes.
UnpaidTax	Collateral_Lease	UnpaidTax	Amount in unpaid taxes that the lessee owes.
UnusedMiles	Collateral_Lease	UnusedMiles	Number of unused contract and purchased miles.
Updated	Collateral_Lease	Updated	Date the lease was last updated
UpdatedBy	Collateral_Lease	UpdatedBy	User who last updated the lease
WearandTear	Collateral_Lease	WearandTear	Total amount charged for wear and tear on the vehicle.