The data source of the Sales Person Grid List is the "IDMS_SALESPERSONINQSTATS_TEAM_VIEW" and the logic behind the 3 columns is the following:
- Total Open Inquiries: The system checks if the Closed field in IDMS_SALESACTIVITIESVIEW is 'N' and the "AttendUser" is the OHEM.UserId of the Sales Person.
- New Vehicles: Same check as above but now the system checks also the field U_IDMS_VIN to be empty, if a vehicle doesn't have a VIN no. it is considered "new "and thus it is displayed as New.
- Used Vehicles: Same check as "Total Open Inquiries" but the system checks for entries with U_IDMS_VIN not to be empty and the DIM_Make of the VOI to be equal with the value of "VehicleUsedMakeCode" setup key.