Reports: Special Reports - Contract Status File

Contents - Index

Reports: Special Reports - Contract Status File

Purpose
Used to create a file of the status of current active leases and loans.

How To
To run this, set the locations and set the date range to the date through which you want balances calculated. Then, click the Contract Status File menu entry.

To access the results, query into the ALMSys database as follows:

1. The database name is ALMSYS

2. The access logon and password will vary depending on your installation. Contact Support for this information.

3. Set up your query: Select * from ContractStatusFile

The data fields are: (SQL definition is in parenthesis at the end of the description.)

CSF_AcctNo Customer account number. (Varchar(15))
CSF_AcctDealNo Customer deal number under this account number. (Int)
CSF_ControlNo Control number for this deal (i.e. lease number, loan number). (Varchar(15))
CSF_CustomerName Formatted customer name. (Varchar(40))
CSF_ContractType LEASE or LOAN. (Varchar(10))
CSF_ContractDate Lease or loan inception date. (Datetime)
CSF_MaturityDate Lease or loan maturity date. (Datetime)
CSF_VIN Vehice identification number or serial number of the collateral. (Varchar(17))
CSF_VehicleYear Year. (Int)
CSF_VehicleMake Make. (Varchar(10))
CSF_VehicleModel Model. (Varchar(15))
CSF_VehicleStockNo Stock Number. (Varchar(20))
CSF_PmtAmt Payment amount. (Money)
CSF_PmtFrequency Payment frequency (i.e. Monthly, Weekly, etc.). (Varchar(20))
CSF_Balance Lease or loan balance. (Money)
CSF_OriginalFinanceAmt Original lease or loan capitalized cost. (Money)
CSF_BalloonAmt Lease end value or loan balloon amount. (Money)
CSF_BalloonDueDate Date on which the balloon is due. (Datetime)
CSF_InterestRate Interest rate. (Real)
CSF_OriginalTerm Term. (Int)
CSF_DaysPastDue Number of days past due. Zero means current. (Int)
CSF_NextPmtDueDate The next scheduled payment due date. If zero, then the deal is at term. (Datetime)
CSF_DataAsOfDate The date that this data is as of. (Datetime)