PROFILE

Purpose - the Profile Table provides current car movement transactions involving those in which the car moves to you as a "new car" for your service, or back to the leasing company at the end of a lease/sublease. Start and End date information is also captured for the movement of cars traveling from one lease or service to another. The Profile captures the Lease Number information associated with the car at a particular point in time and can provide current information regarding its movement from one sublease to another. Information about Payoff Value, Manufacturer and a brief comment line are also included in this table.

The Profile Table is also the basis for monthly invoice reporting in systems with the Invoicing module. Entries in Profile are compared with Lease numbers in the Lease table to produce accurate monthly arrears and monthly prepaid invoicing. If you do not have the Invoicing module, entries will be moved from Profile to Cumulative Profile when an "End Date" is entered for a car. You will be asked to confirm the end date before this occurs.

PROFILE FIELDS:

Car Number

     10 Characters. This field is required. The first four characters will be an abbreviation, such as PTLX for the car initial, or JMW with a trailing space. The last six characters will be a six digit car number with leading zeroes. This will conform to standard AAR car numbering conventions and ensure consistent data entry.

Lease Number

     12 Characters. This is a User-defined code for the car's lease. See the description of the LEASE table for more information. When your cursor is on this field, you can pop up a list of applicable leases by clicking the mouse on the down arrow to the right of the field.

Sublease Number

     12 Characters. This is a User-defined code for the car's sublease. See the description of the SUBLEASE for more information. When your cursor is on this field, you can pop up a list of applicable subleases by clicking the mouse on the down arrow to the right of the field.

Start Date

     Date field. This is the date that the car started service for the current sublease. This will be entered in standard MM/DD/YYYY format.

End Date

     Date field. This is the date that the car ended service for the current sublease. This will be entered in standard MM/DD/YYYY format.

Icode

     1 Character. This is an "Allocation Code" for the current car. The following codes are supported by the system:

     D - Destroyed car

     Q - Terminated Car

     R - Regular allocation

      User-entered Icodes will identify the current status of the car.

Destroyed DT

     Date field. This is the date that the car was destroyed, if applicable. Once a car has been destroyed, it will be moved to Cumulative Profile. This will be entered in standard MM/DD/YYYY format.

Payoff Value

     Numeric field. This is the payoff value for the car, if applicable.

Manufacturer

     15 Characters. This is the car's manufacturer, and may be entered if desired.

Comments

     40 Characters. This is a brief comment about the current transaction. To enter more extensive information, see MEMOS.

Mileage Rate

     Numeric field. Enter the Mileage Rate for the car if desired.

Cubic Capacity

     Numeric field. Enter the Cubic Capacity for the car if desired.