Contents - Index

New Deal File Interface

Purpose
The ALMSysŪ Deal File Interface File is the current format that ALMSys uses for deal file imports when adding new deals. It is in the format of the classic Windows INI file.

File Naming
ALMSys does not care what files are named, or where they are located (as long as the program can get to them). The file extension must be ".adf" ("ALMSys Deal File").

Layout
INI-type files are arranged with section headers (i.e. "[Deal]") followed by detail lines (i.e. "Date=12/31/2001"). The order that these sections and detail lines appear does not matter. There does not need to be a blank line between sections (although you may want one for readability purposes). Section headers and detail line titles are not case sensitive. However, the data after the equal sign is.

An example would look like this:
[Deal]
Date=08/15/2004
Control=421A

[Lessee]
FName=John
MName=Quincy
LName=Public

Each section header will be listed (alphabetically), followed by the available detail lines (alphabetically). Each detail line will convey the format of the data that is expected:
  • For character (alphanumeric) input, the maximum number of positions will be listed.
  • Dates are input as "mm/dd/yyyy."
  • Numeric format includes digits and a possible decimal point. Do not include commas.
  • Integer format includes digits only. Do not include commas or a decimal point.

    All available detail lines will be defined. Some of the detail lines are used internally and will be ignored by ALMSys if you specify them. These will be marked as "Internal Only:".

    Sections
    [Add-Ons]
    "Add-ons" incorporate monthly charges beyond the base payment calculation. These are typically used by a leasing company that is leveraging its financing.

    ExpenseReserve Monthly expense reserve amount: numeric format.
    MonthlyReserve Monthly reserve amount: numeric format.
    Other Monthly other amount: numeric format.
    TaxableAddOn Internal Only: Monthly amount that is taxable: numeric format

    [Cap Costs]
    "Cap Costs" are used for leases only and represent the capitalized costs that are added to the total lease finance amount.

    CapReduction Capitalized cost reduction (a positive amount will reduce the total capitalized costs and increase the total non-capitalized costs): numeric format.
    GSTRegistrant Canada only, input 1 if the lessee is a GST Registrant and 0 if not: integer format. If not input, 0 is assumed.
    LienOnTrade Remaining amount of the lien on the trade-in that is capitalized in this lease.
    MiscAmount1 There are 10 miscellaneous amounts with corresponding titles. The rest are named "MiscAmount2 ... MiscAmount10." These amounts represent taxable amounts that are added to the base price and effect the monthly payment. Numeric format.
    MiscTitle1 There are 10 miscellaneous titles. The rest are named "MiscTitle2 ... MiscTitle10." These titles correspond to the MiscAmount data and are 30 characters in length.
    PSTAffectedByLien Canada only, input 1 if PST is to be reduced when a lien on trade situation exists. Otherwise, input 0.
    Security Security deposit: numeric format.
    TradeCapReduction Capitalized cost reduction as the result of a trade-in (positive amount will reduce the total capitalized costs): numeric format.
    TradeCapReductionIncludeOnDOD This will force the trade cap. reduction to be included in the Due on Delivery calculation. Input 1 to turn this on, otherwise 0.

    [Co-Lessee]
    This is the second borrower on the lease, or the second buyer on a purchase. Address information is only provided when the co-lessee lives at a different address than the lessee.

    Address1 Address line 1: 30 characters.
    Address2 Address line 2: 30 characters.
    CellPhone Cell phone number: 15 characters
    City City: 15 characters.
    Country Country: 30 characters.
    DOB Date of birth: date format.
    EMail E-mail address: 60 characters
    Extension Work phone extension: 5 characters.
    Fax Fax phone number: 15 characters.
    FName First name: 10 characters.
    License Driver's license number: 20 characters.
    LName Last name: 20 characters.
    MName Middle name: 10 characters.
    Phone Phone number: 15 characters.
    SSN Social security number: integer format.
    State State/province code: 2 characters.
    WorkPhone Work phone number: 15 characters.
    Zip Postal code: 10 characters.

    [Costs]
    All of the "Costs" fields listed (except "BasePrice") are for leases only. "BasePrice" is also used to represent the cost of a purchased vehicle.

    BasePrice Base price of the vehicle: numeric format.
    BasePriceBreakDown This is used internally. It specifies that the base price is broken down by the costs and miscellaneous costs in the Cost section.
    MoneyFactor Used to calculate the monthly base payment using the money factor formula. If this is specified, do not specify the Rate and NoRate fields. An interest rate will be back-calculated as a result of the money factor calculation. Numeric format. (A money factor of .00298 would be entered as 2.98.) If you want the calculation to use the money factor, please also specify the UseMoneyFactor field and set it to 1.
    NonTaxable Internal Only: Amount that is part of total capitalized cost that is not to be taxed. Numeric format.
    NoRate 1 if the Interest rate provided is zero. If the interest rate is provided, this field may be set to 0 or not specified at all.
    NoResidual 1 if the Residual provided is zero. If a residual is provided (either via Residual or ResidualPerc), this field may be set to 0 or not specified at all.
    Payment Monthly payment amount before taxes: numeric format.
    Residual End value of the vehicle: numeric format.
    ResidualPerc Percentage of the total capitalized cost that is used to calculate the end value. If this is specified, do not specify the Residual field. Numeric format. (50% is input at 50.)
    Rate Interest rate (7.25% input as 7.25): numeric format.
    Tax Internal Only: Monthly tax amount: numeric format.
    TaxableBasePmt Internal Only: This field is used to store the calculated base payment that tax is based upon.
    TotalPayment Internal Only: Monthly payment amount: numeric format.
    UseMoneyFactor Used in conjunction with the MoneyFactor field. Set this to 1 to tell the calculation to use the MoneyFactor specified. A 0 (zero) value disables this field.

    [Deal]
    General deal-related information.

    Control Control number (from leasing company): 15 characters.
    Date Date of the deal: date format. (Default = Today)
    ListPrice MSRP: numeric format.
    ReferralCode How the deal was referred: 1 character.
    A - Referred by Loan Officer
    B - Referred by Member
    C - Lunch & Learn
    D - Car Buying Seminar
    E - Newspaper
    F - Poster
    G - Car Sale
    H - Statement Stuffer
    I - Newsletter
    J - Brochure
    K - Loan Rate
    L - Drive-Up Sign or Flyer
    M - Past Customer
    N - Credit Union Staff
    O - Personal
    P - Other
    Q - Termination
    S - Outside Agency
    Type Type of deal: "L" = Lease, "P" = Purchase: 1 character. (Default = "L")
    [Depreciation]
    Depreciation-related information.

    BookTerm The number of months in the book depreciation. Integer format.
    EndAmount Depreciation ending amount. Numeric format.
    EndDate Depreciation end date. Date format.
    FiscalYearStartMonth Internal Only: The first month in each fiscal year. If not specified, "1" is assumed. This is overridden by the ALMSys depreciation defaults.
    StartAmount Depreciation starting amount. Numeric format.
    StartDate Depreciation start date. Date format.

    [Insurance]
    Insurance-related information.

    Address1 Agency address line 1: 30 characters.
    Address2 Agency address line 2: 30 characters.
    Agent Agent name: 30 characters.
    BodilyInjuryPerOccurrence Bodily injury per occurrence coverage: integer format.
    BodilyInjuryPerPerson  Bodily injury per person coverage: integer format.
    City Agency city: 15 characters.
    CollisionDeductible Collision deductible amount: integer format.
    CompanyName Insurance company name: 30 characters.
    CompDeductible Comprehensive deductible amount: integer format.
    Contact Agency contact name: 30 characters.
    Coverage 0 = Continuous coverage, 1 = policy expires. 1 character. Default is the ALMSys location's default setting.
    Extension Agency phone extension: 5 characters.
    Fax Fax phone number: 15 characters.
    LienholderListed 0 = No, 1 = Yes. Specifies whether or not the lienholder is listed on the policy. 1 character. Default is 0.
    LessorListed 0 = No, 1 = Yes. Specifies whether or not the lessor is listed on the policy. 1 character. Default is 0.
    Phone Agency phone number: 15 characters.
    Policy Policy number: 20 characters.
    PolicyExpDate Policy expiration date: date format.
    PolicyHolder Policyholder name (if different than lessee): 30 characters.
    PropertyDamage Property damage coverage: integer format.
    State Agency state/province code: 2 characters.
    Zip Agency postal code: 10 characters.

    [Lease]
    Lease-specific data.

    1stScheduledPaymentDate Date of the first scheduled payment. For due-on-delivery leases, this is the lease delivery date. For deferred first payment leases, this is the first payment date: date format.
    2ndScheduledPaymentDate Date of the second scheduled payment. Date format.
    CalcTypeCode Calculation formula to use: 1 character: (Default = "1")
    "1" Standard. This type calculates an amortization schedule that has the first payment as all principal. This is for payments made at the beginning of each month.
    "2" Standard, with interest. This is very similar to the first type, in that the payment amount and the interest earned over the term of the lease are identical. However, the first payment in the amortization schedule includes interest.
    3" Spreadsheet. The calculation used in this type is similar to the PAYMT function used in popular spreadsheet programs. Typically, the payment is a little higher than types 1 and 2. The first payment in the amortization schedule includes interest. This is most commonly used for payments made at the end of each month.
    CapFirstPayment Capitalize first payment code: "N" = No, "Y" = Yes: 1 character. (Default = "N")
    DayDue Day of month due: integer format between 1 and 31. 31 means "last day of each month."
    EvenPrincipal Even principal code: "N" = No, "Y" = Yes: 1 character. (Default = "N")
    LoanOfficer Loan officer initials: 3 characters.
    Term Term of lease in months: integer format.

    [Lessee]
    Lease lessee or purchaser information.

    Address1 Address line 1: 30 characters.
    Address2 Address line 2: 30 characters.
    BusinessName Name of business (for business leases only): 30 characters.
    CellPhone Cell phone number: 15 characters
    City City: 15 characters.
    Country Country: 30 characters.
    County County: 15 characters.
    DOB Date of birth: date format.
    EMail E-mail address: 60 characters
    Extension Work phone extension: 5 characters.
    Fax Fax phone number: 15 characters.
    FName First name: 10 characters.
    License Driver's license number: 20 characters.
    LName Last name: 20 characters.
    MName Middle name: 10 characters.
    Phone Phone number: 15 characters.
    SSN Social security number: integer format.
    State State/province code: 2 characters.
    WorkPhone Work phone number: 15 characters.
    Zip Postal code: 10 characters.

    [Non-Applicant Spouse]
    For states or provinces that require non-applicant spouse tracking.

    Address1 Address line 1: 30 characters.
    Address2 Address line 2: 30 characters.
    City City: 15 characters.
    Extension Work phone extension: 5 characters.
    FName First name: 10 characters.
    LName Last name: 20 characters.
    MName Middle name: 10 characters.
    Phone Phone number: 15 characters.
    SSN Social security number: integer format.
    State State/province code: 2 characters.
    WorkPhone Work phone number: 15 characters.
    Zip Postal code: 10 characters.

    [Non-Cap Costs]
    "Non-Cap Costs" are used for leases only and represent the due-on-delivery costs.

    MiscAmount1 There are 10 miscellaneous amounts with corresponding titles. The rest are named "MiscAmount2 ... MiscAmount10." These amounts represent amounts that effect the due on delivery calculation. Numeric format.
    MiscTitle1 There are 10 miscellaneous titles. The rest are named "MiscTitle2 ... MiscTitle10." These titles correspond to the MiscAmount data and are 30 characters in length.
    Security Security deposit: numeric format.

    [Taxes]
    "Taxes" are used for leases only and represent the monthly tax breakdown.

    Accum1 Specifies whether or not the taxes are accumulative or calculated separately. Accumulative is the default. Set to 1 for accumulatively or 0 for separately. There are 8 of these fields and the remaining fields are named "Accum2 ... Accum8."
    Desc1 Tax breakdown description: 30 characters. There are 8 of these fields and the remaining fields are named "Desc2 ... Desc 8."
    GSTPST1 Internal Only: Specifies if the tax is Canadian GST or PST: 1 character. G = GST, P = PST, N = Neither (default).
    Rate Internal Only: Total tax rate (6.75% input as 6.75): numeric format.
    Rate1 Tax breakdown rate #1: numeric format. There are 8 of these fields and the remaining fields are named "Rate2 ... Rate 8."

    [Trade]
    Trade-in information.

    Body Vehicle body style: 10 characters.
    Color Vehicle color: 10 characters.
    Make Vehicle make: 10 characters.
    Model Vehicle model: 15 characters.
    Lienholder Lienholder name (if there is a lien). 30 characters.
    Odometer Ending odometer: integer format.
    Payoff Payoff amount (only if there is a lien). Numeric format.
    Present Was a trade present?: "N" = No, "Y" = Yes: 1 character. (Default = "N")
    VIN Vehicle identification number. 17 characters.
    Year 4 digit year of the vehicle: integer format.

    [Vehicle]
    Vehicle information.

    AnnualMilesAllowed The total number of miles or kilometers that is allowed in each year of the lease. Integer format.
    Body Vehicle body style: 10 characters.
    Color Vehicle color: 10 characters.
    Condition Condition of the vehicle: "N" = New, "U" = Used: 1 character. (Default = "N")
    Dealer Selling dealer's name: 40 characters.
    DriverLocation Used in business leases, the location of the driver. 30 characters.
    DriverName Used in business leases, the name of the driver. 30 characters.
    DriverUnitNo Used in business leases, the internal unit number of the vehicle. 10 characters.
    EndOdom Ending odometer: integer format.
    ExcessMileageCost Cost (per mile or kilometer) of mileage over the allowed contract limit
    LicenseExpMonth License expiration month: integer format, between 1 and 12.
    Make Vehicle make: 10 characters.
    Model Vehicle model: 15 characters.
    Plate License plate number: 8 characters.
    ServiceContract Service contract indicator: "N" = No, "Y" = Yes: 1 character. (Default = "N")
    StartOdom Starting odometer: integer format.
    StockNumber Vehicle stock number: 20 characters.
    TitleState State/province code in which the vehicle is titled: 2 characters.
    Usage Usage type code: "C" = Commercial, "P" = Personal: 1 character. (Default = "P")
    VIN Vehicle identification number. For other collateral, a unique (to ALMSysŪ) serial number: 17 characters.
    Year 4 digit year of the vehicle: integer format.

    Assistance
    If you have questions with any of the information in this document, please contact ALMSys Support at 800-827-3164 for assistance.