Collateral Lease Table

Field Name

Description

Length

Data Type

Parent Table and Field

Import Types

ID

Code that Latitude assigned to identify the lease record in Latitude.

4

Integer

None

NB, M

AccountID

Code that identifies the Latitude account associated to the piece of collateral.

4

Integer

Master/Number

NB, M

CollateralID

Code that identifies the vehicle.

4

Integer

None

NB, M

TermMonths

Length of the lease, in months.

10

VarChar

None

NB, M

MaturityDate

Date the lease matured.

8

DateTime

None

NB, M

EffectiveDate

Date the lease became effective.

8

DateTime

None

NB, M

OriginalMiles

Original mileage on the leased vehicle.

4

Integer

None

NB, M

ContractMiles

Mileage allowed under the leasing contract.

4

Integer

None

NB, M

PurchaseMiles

Number of extra miles purchased.

4

Integer

None

NB, M

EndOfTermMiles

Mileage at the end of the lease term.

4

Integer

None

NB, M

Residual

Lease-end value of the vehicle.

8

Money

None

NB, M

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.

8

Money

None

NB, M

SecurityDeposit

Amount the lessee paid as a security deposit.

8

Money

None

NB, M

UnpaidMonthsPayment

Amount in unpaid payments that the lessee owes.

8

Money

None

NB, M

UnpaidTax

Amount in unpaid taxes that the lessee owes.

8

Money

None

NB, M

ExcessMileage

Amount charged for each mile over the mileage limit.

8

Money

None

NB, M

WearAndTear

Total amount charged for wear and tear on the vehicle.

8

Money

None

NB, M

ReturnDate

Date the leasing agency received the vehicle.

8

DateTime

None

NB, M

ExcessMiles

Number of miles over the contract and purchased miles.

4

Integer

None

NB, M

UnusedMiles

Number of unused contract and purchased miles.

4

Integer

None

NB, M

InceptionMiles

Mileage at the beginning of the lease term.

4

Integer

None

NB, M

MileageCredit

Amount credited for unused mileage.

8

Money

None

NB, M

MinorWearCharge

Amount charged for minor wear on the vehicle.

8

Money

None

NB, M

MajorWearCharge

Amount charged for major wear on the vehicle.

8

Money

None

NB, M

DisposalAssessedAmount

Amount charged to dispose of the vehicle.

8

Money

None

NB, M

ResidualGainLoss

Difference between the residual value and the end-of-lease purchase price.

8

Money

None

NB, M

EndOfTermTaxAssessed

Tax assessed at the end of the lease.

8

Money

None

NB, M

OtherTaxAssessed

Amount charged for other taxes (for example, property tax).

8

Money

None

NB, M

DispositionDate

Date the leasing agency determined the status of the returned vehicle.

8

DateTime

None

NB, M

InspectionReceivedDate

Date the leasing agency inspected the vehicle.

8

DateTime

None

NB, M

Created

Date the lease was first created

DateTime

None

NB, M

CreatedBy

User who created the lease

   100

VarChar

None

NB, M

Updated

Date the lease was last updated

DateTime

None

NB, M

UpdatedBy

User who last updated the lease

100

VarChar

None

NB, M