Advanced Enterprise Technologies, Inc.
Table of Contents

Vehicles Sample

Vehicle import samples are available in the following file formats:

 

Download Sample

Microsoft Excel Worksheet

Account ID Account Number Account Name Vehicle ID VIN Year Make Model Vehicle Class GVW Body Type Vehicle Type Engine Rate Class Registered Owner Contact ID Registered Owner Company Name Registered Owner First Name Registered Owner Last Name Registered Owner Type Registered Owner Address Registered Owner Address 2 Registered Owner Address 3 Registered Owner City Registered Owner State Registered Owner Zip Registered Owner Phone Registered Owner E-mail Registered Owner Fax Ownership Type Finance Contact ID Finance Contact Company Name Finance Contact Address Finance Contact Address 2 Finance Contact Address 3 Finance Contact City Finance Contact State Finance Contact Zip Finance Contact Phone Finance Contact E-mail Finance Contact Fax Finance Effective Date Finance Expiration Date Finance Contract Description Finance Contract Number Garage City Garage State Garage Zip Title Number Original Cost New Original Capacity Plate Number Vehicle Color Client Auto ID Date Added Date Dropped Transportation Usage Vehicle Safety Classification Vehicle Safety Classification Other My Company Fleet
1   DIV-A Division A   1FTDF15NXPNB34148                       John Doe Auto Owner 123 State Street     Media PA 19063       Financed   Ford Motor Credit Company PO Box 650575     Dallas TX 75265       05/01/2015 06/01/2021 72 month finance contract FMCO0100523315     19063     3   Red F00013 05/01/2015         Yes
2   DIV-B Division B   1FTEW1E5ZKFA51158 2019 Ford Fiesta                 Walter Cruz Auto Owner 15 Race Street     Philadelphia PA 19101       Owned                               Media PA 19063     4   Green   07/01/2019         No
3                                                                                                                      
 
Download Sample

JSON File

{
  "vehicles": [
    {
      "accountId": "",
      "accountNumber": "DIV-A",
      "accountName": "Division A",
      "vehicleId": "",
      "vin": "1FTDF15NXPNB34148",
      "year": "",
      "make": "",
      "model": "",
      "vehicleClass": "",
      "gvw": "",
      "bodyType": "",
      "vehicleType": "",
      "engine": "",
      "rateClass": "",
      "registeredOwnerContactId": "",
      "registeredOwnerCompanyName": "",
      "registeredOwnerFirstName": "John",
      "registeredOwnerLastName": "Doe",
      "registeredOwnerType": "Auto Owner",
      "registeredOwnerAddress": "123 State Street",
      "registeredOwnerAddress2": "",
      "registeredOwnerAddress3": "",
      "registeredOwnerCity": "Media",
      "registeredOwnerState": "PA",
      "registeredOwnerZip": "19063",
      "registeredOwnerPhone": "",
      "registeredOwnerEmail": "",
      "registeredOwnerFax": "",
      "ownershipType": "Financed",
      "financeContactId": "",
      "financeContactCompanyName": "Ford Motor Credit Company",
      "financeContactAddress": "PO Box 650575",
      "financeContactAddress2": "",
      "financeContactAddress3": "",
      "financeContactCity": "Dallas",
      "financeContactState": "TX",
      "financeContactZip": "75265",
      "financeContactPhone": "",
      "financeContactEmail": "",
      "financeContactFax": "",
      "financeEffectiveDate": "05/01/2015",
      "financeExpirationDate": "06/01/2021",
      "financeContractDescription": "72 month finance contract",
      "financeContractNumber": "FMCO0100523315",
      "garageCity": "",
      "garageState": "",
      "garageZip": "19063",
      "titleNumber": "",
      "originalCostNew": "",
      "originalCapacity": "3",
      "plateNumber": "",
      "vehicleColor": "Red",
      "clientAutoId": "F00013",
      "dateAdded": "05/01/2015",
      "dateDropped": "",
      "transportationUsage": "",
      "vehicleSafetyClassification": "",
      "vehicleSafetyClassificationOther": "",
      "userDefinedFields": [
        {
          "fieldName": "My Company Fleet",
          "fieldValue": "Yes"
        }
      ]
    },
    {
      "accountId": "",
      "accountNumber": "DIV-B",
      "accountName": "Division B",
      "vehicleId": "",
      "vin": "1FTEW1E5ZKFA51158",
      "year": "2019",
      "make": "Ford",
      "model": "Fiesta",
      "vehicleClass": "",
      "gvw": "",
      "bodyType": "",
      "vehicleType": "",
      "engine": "",
      "rateClass": "",
      "registeredOwnerContactId": "",
      "registeredOwnerCompanyName": "",
      "registeredOwnerFirstName": "Walter",
      "registeredOwnerLastName": "Cruz",
      "registeredOwnerType": "Auto Owner",
      "registeredOwnerAddress": "15 Race Street",
      "registeredOwnerAddress2": "",
      "registeredOwnerAddress3": "",
      "registeredOwnerCity": "Philadelphia",
      "registeredOwnerState": "PA",
      "registeredOwnerZip": "19101",
      "registeredOwnerPhone": "",
      "registeredOwnerEmail": "",
      "registeredOwnerFax": "",
      "ownershipType": "Owned",
      "financeContactId": "",
      "financeContactCompanyName": "",
      "financeContactAddress": "",
      "financeContactAddress2": "",
      "financeContactAddress3": "",
      "financeContactCity": "",
      "financeContactState": "",
      "financeContactZip": "",
      "financeContactPhone": "",
      "financeContactEmail": "",
      "financeContactFax": "",
      "financeEffectiveDate": "",
      "financeExpirationDate": "",
      "financeContractDescription": "",
      "financeContractNumber": "",
      "garageCity": "Media",
      "garageState": "PA",
      "garageZip": "19063",
      "titleNumber": "",
      "originalCostNew": "",
      "originalCapacity": "4",
      "plateNumber": "",
      "vehicleColor": "Green",
      "clientAutoId": "",
      "dateAdded": "07/01/2019",
      "dateDropped": "",
      "transportationUsage": "",
      "vehicleSafetyClassification": "",
      "vehicleSafetyClassificationOther": "",
      "userDefinedFields": [
        {
          "fieldName": "My Company Fleet",
          "fieldValue": "No"
        }
      ]
    }
  ]
}
 
Download Sample

XML Document

<?xml version="1.0"?>
<import>
  <vehicle>
    <accountId></accountId>
    <accountNumber>DIV-A</accountNumber>
    <accountName>Division A</accountName>
    <vehicleId></vehicleId>
    <vin>1FTDF15NXPNB34148</vin>
    <year></year>
    <make></make>
    <model></model>
    <vehicleClass></vehicleClass>
    <gvw></gvw>
    <bodyType></bodyType>
    <vehicleType></vehicleType>
    <engine></engine>
    <rateClass></rateClass>
    <registeredOwnerContactId></registeredOwnerContactId>
    <registeredOwnerCompanyName></registeredOwnerCompanyName>
    <registeredOwnerFirstName>John</registeredOwnerFirstName>
    <registeredOwnerLastName>Doe</registeredOwnerLastName>
    <registeredOwnerType>Auto Owner</registeredOwnerType>
    <registeredOwnerAddress>123 State Street</registeredOwnerAddress>
    <registeredOwnerAddress2></registeredOwnerAddress2>
    <registeredOwnerAddress3></registeredOwnerAddress3>
    <registeredOwnerCity>Media</registeredOwnerCity>
    <registeredOwnerState>PA</registeredOwnerState>
    <registeredOwnerZip>19063</registeredOwnerZip>
    <registeredOwnerPhone></registeredOwnerPhone>
    <registeredOwnerEmail></registeredOwnerEmail>
    <registeredOwnerFax></registeredOwnerFax>
    <ownershipType>Financed</ownershipType>
    <financeContactId></financeContactId>
    <financeContactCompanyName>Ford Motor Credit Company</financeContactCompanyName>
    <financeContactAddress>PO Box 650575</financeContactAddress>
    <financeContactAddress2></financeContactAddress2>
    <financeContactAddress3></financeContactAddress3>
    <financeContactCity>Dallas</financeContactCity>
    <financeContactState>TX</financeContactState>
    <financeContactZip>75265</financeContactZip>
    <financeContactPhone></financeContactPhone>
    <financeContactEmail></financeContactEmail>
    <financeContactFax></financeContactFax>
    <financeEffectiveDate>05/01/2015</financeEffectiveDate>
    <financeExpirationDate>06/01/2021</financeExpirationDate>
    <financeContractDescription>72 month finance contract</financeContractDescription>
    <financeContractNumber>FMCO0100523315</financeContractNumber>
    <garageCity></garageCity>
    <garageState></garageState>
    <garageZip>19063</garageZip>
    <titleNumber></titleNumber>
    <originalCostNew></originalCostNew>
    <originalCapacity>3</originalCapacity>
    <plateNumber></plateNumber>
    <vehicleColor>Red</vehicleColor>
    <clientAutoId>F00013</clientAutoId>
    <dateAdded>05/01/2015</dateAdded>
    <dateDropped></dateDropped>
    <transportationUsage></transportationUsage>
    <vehicleSafetyClassification></vehicleSafetyClassification>
    <vehicleSafetyClassificationOther></vehicleSafetyClassificationOther>
    <userDefinedField>
      <fieldName>My Company Fleet</fieldName>
      <fieldValue>Yes</fieldValue>
    </userDefinedField>
  </vehicle>
  <vehicle>
    <accountId></accountId>
    <accountNumber>DIV-B</accountNumber>
    <accountName>Division B</accountName>
    <vehicleId></vehicleId>
    <vin>1FTEW1E5ZKFA51158</vin>
    <year>2019</year>
    <make>Ford</make>
    <model>Fiesta</model>
    <vehicleClass></vehicleClass>
    <gvw></gvw>
    <bodyType></bodyType>
    <vehicleType></vehicleType>
    <engine></engine>
    <rateClass></rateClass>
    <registeredOwnerContactId></registeredOwnerContactId>
    <registeredOwnerCompanyName></registeredOwnerCompanyName>
    <registeredOwnerFirstName>Walter</registeredOwnerFirstName>
    <registeredOwnerLastName>Cruz</registeredOwnerLastName>
    <registeredOwnerType>Auto Owner</registeredOwnerType>
    <registeredOwnerAddress>15 Race Street</registeredOwnerAddress>
    <registeredOwnerAddress2></registeredOwnerAddress2>
    <registeredOwnerAddress3></registeredOwnerAddress3>
    <registeredOwnerCity>Philadelphia</registeredOwnerCity>
    <registeredOwnerState>PA</registeredOwnerState>
    <registeredOwnerZip>19101</registeredOwnerZip>
    <registeredOwnerPhone></registeredOwnerPhone>
    <registeredOwnerEmail></registeredOwnerEmail>
    <registeredOwnerFax></registeredOwnerFax>
    <ownershipType>Owned</ownershipType>
    <financeContactId></financeContactId>
    <financeContactCompanyName></financeContactCompanyName>
    <financeContactAddress></financeContactAddress>
    <financeContactAddress2></financeContactAddress2>
    <financeContactAddress3></financeContactAddress3>
    <financeContactCity></financeContactCity>
    <financeContactState></financeContactState>
    <financeContactZip></financeContactZip>
    <financeContactPhone></financeContactPhone>
    <financeContactEmail></financeContactEmail>
    <financeContactFax></financeContactFax>
    <financeEffectiveDate></financeEffectiveDate>
    <financeExpirationDate></financeExpirationDate>
    <financeContractDescription></financeContractDescription>
    <financeContractNumber></financeContractNumber>
    <garageCity>Media</garageCity>
    <garageState>PA</garageState>
    <garageZip>19063</garageZip>
    <titleNumber></titleNumber>
    <originalCostNew></originalCostNew>
    <originalCapacity>4</originalCapacity>
    <plateNumber></plateNumber>
    <vehicleColor>Green</vehicleColor>
    <clientAutoId></clientAutoId>
    <dateAdded>07/01/2019</dateAdded>
    <dateDropped></dateDropped>
    <transportationUsage></transportationUsage>
    <vehicleSafetyClassification></vehicleSafetyClassification>
    <vehicleSafetyClassificationOther></vehicleSafetyClassificationOther>
    <userDefinedField>
      <fieldName>My Company Fleet</fieldName>
      <fieldValue>No</fieldValue>
    </userDefinedField>
  </vehicle>
</import>