RooftopHarborline Automotive Group, all 8 rooftopsas at 31 Aug 2026 · synthetic
60 source files arrived in three DMS dialects plus lender and OEM formats. 109,390 rows came in; 109,225 loaded and 165 were quarantined with a reason. Rows in equal rows loaded plus rows quarantined, for every file.
What was excluded, and why.
Raw DMS spellings mapped onto the group master.
| Rooftop | DMS | As exported | Canonical | Rows |
|---|---|---|---|---|
| Honda | Reynolds & Reynolds ERA | CIVIC | Civic | 319 |
| Honda | Reynolds & Reynolds ERA | ACCORD | Accord | 286 |
| Buick GMC | Reynolds & Reynolds ERA | SIERRA 1500 | Sierra 1500 | 250 |
| Honda | Reynolds & Reynolds ERA | PILOT | Pilot | 231 |
| Buick GMC | Reynolds & Reynolds ERA | TERRAIN | Terrain | 219 |
| Honda | Reynolds & Reynolds ERA | ODYSSEY | Odyssey | 192 |
| Buick GMC | Reynolds & Reynolds ERA | ACADIA | Acadia | 189 |
| Buick GMC | Reynolds & Reynolds ERA | YUKON | Yukon | 189 |
| Buick GMC | Reynolds & Reynolds ERA | ENCLAVE | Enclave | 169 |
| Buick GMC | Reynolds & Reynolds ERA | ENCORE GX | Encore GX | 150 |
| Buick GMC | Reynolds & Reynolds ERA | ENVISION | Envision | 147 |
| Honda | Reynolds & Reynolds ERA | PROLOGUE | Prologue | 125 |
| Chevrolet | Dealertrack DMS | SILVERADO 1500 | Silverado 1500 | 93 |
| Chevrolet | Dealertrack DMS | SILVERADO 1500 4WD |
Every file, rooftop by rooftop.
| Feed | File | Rows in | Loaded | Quarantined | Exceptions | Control total | Loaded total | Last event | Status | Note |
|---|---|---|---|---|---|---|---|---|---|---|
| Retail deals | cdk_deals.csv | 2,316 | 2,218 | 98 | 0 | $8.55M | $8.20M | 2026-08-30 | attention | contract dates, money and N/U codes normalised from the DMS dialect |
| Vehicle inventory | cdk_inventory.csv | 510 | 510 | 0 | 0 | – | – | 2026-08-30 | ok | 42 model spellings mapped to the master |
| Sales leads | cdk_leads.csv | 690 | 690 | 0 | 218 | – | – | 2026-08-30 | ok | 218 leads without a vehicle of interest, kept |
| Parts inventory | cdk_parts.csv | 1,336 | 1,336 | 0 | 0 | – | – | 2026-08-30 | ok | clean |
| Repair orders | cdk_ros.csv | 11,827 | 11,827 | 0 | 37 | – | – | 2026-08-29 | ok | 37 repair orders still open |
| Silverado 1500 |
| 80 |
A spelling the master does not know is quarantined, never guessed. Store codes and dealer codes map the same way: Ford is 01 in CDK Drive; Toyota is 02 in CDK Drive; Buick GMC is BR1 in Reynolds & Reynolds ERA, and so on.
| Technicians | cdk_technicians.csv | 17 | 17 | 0 | 0 | – | – | 2026-08-30 | ok | roster with certifications |
| Feed | File | Rows in | Loaded | Quarantined | Exceptions | Control total | Loaded total | Last event | Status | Note |
|---|---|---|---|---|---|---|---|---|---|---|
| Retail deals | cdk_deals.csv | 2,490 | 2,490 | 0 | 0 | $11.57M | $11.57M | 2026-08-30 | ok | contract dates, money and N/U codes normalised from the DMS dialect |
| Vehicle inventory | cdk_inventory.csv | 243 | 243 | 0 | 0 | – | – | 2026-08-30 | ok | 10 model spellings mapped to the master |
| Sales leads | cdk_leads.csv | 794 | 794 | 0 | 267 | – | – | 2026-08-30 | ok | 267 leads without a vehicle of interest, kept |
| Parts inventory | cdk_parts.csv | 1,408 | 1,408 | 0 | 0 | – | – | 2026-08-30 | ok | clean |
| Repair orders | cdk_ros.csv | 13,521 | 13,521 | 0 | 45 | – | – | 2026-08-29 | ok | 45 repair orders still open |
| Technicians | cdk_technicians.csv | 19 | 19 | 0 | 0 | – | – | 2026-08-30 | ok | roster with certifications |
| Feed | File | Rows in | Loaded | Quarantined | Exceptions | Control total | Loaded total | Last event | Status | Note |
|---|---|---|---|---|---|---|---|---|---|---|
| Retail deals | reynolds_deals.csv | 1,582 | 1,569 | 13 | 0 | $6.03M | $5.99M | 2026-08-30 | attention | contract dates, money and N/U codes normalised from the DMS dialect |
| Vehicle inventory | reynolds_inventory.csv | 369 | 369 | 0 | 0 | – | – | 2026-08-30 | ok | 348 model spellings mapped to the master |
| Sales leads | reynolds_leads.csv | 556 | 556 | 0 | 175 | – | – | 2026-08-30 | ok | 175 leads without a vehicle of interest, kept |
| Parts inventory | reynolds_parts.csv | 1,160 | 1,150 | 10 | 7 | – | – | 2026-08-30 | attention | 7 negative on-hand quantities clamped to zero, raw retained |
| Repair orders | reynolds_ros.csv | 8,417 | 8,417 | 0 | 28 | – | – | 2026-08-29 | ok | 28 repair orders still open |
| Technicians | reynolds_technicians.csv | 12 | 12 | 0 | 0 | – | – | 2026-08-30 | ok | roster with certifications |
| Feed | File | Rows in | Loaded | Quarantined | Exceptions | Control total | Loaded total | Last event | Status | Note |
|---|---|---|---|---|---|---|---|---|---|---|
| Retail deals | reynolds_deals.csv | 1,936 | 1,920 | 16 | 0 | $8.07M | $8.00M | 2026-08-30 | attention | contract dates, money and N/U codes normalised from the DMS dialect |
| Vehicle inventory | reynolds_inventory.csv | 211 | 211 | 0 | 0 | – | – | 2026-08-30 | ok | 167 model spellings mapped to the master |
| Sales leads | reynolds_leads.csv | 650 | 637 | 13 | 226 | – | – | 2026-08-30 | attention | 226 leads without a vehicle of interest, kept |
| Parts inventory | reynolds_parts.csv | 1,260 | 1,260 | 0 | 0 | – | – | 2026-08-30 | ok | clean |
| Repair orders | reynolds_ros.csv | 10,126 | 10,126 | 0 | 35 | – | – | 2026-08-29 | ok | 35 repair orders still open |
| Technicians | reynolds_technicians.csv | 14 | 14 | 0 | 0 | – | – | 2026-08-30 | ok | roster with certifications |
| Feed | File | Rows in | Loaded | Quarantined | Exceptions | Control total | Loaded total | Last event | Status | Note |
|---|---|---|---|---|---|---|---|---|---|---|
| Retail deals | dealertrack_deals.csv | 1,717 | 1,712 | 5 | 0 | $7.29M | $7.26M | 2026-08-30 | attention | contract dates, money and N/U codes normalised from the DMS dialect |
| Vehicle inventory | dealertrack_inventory.csv | 534 | 534 | 0 | 0 | – | – | 2026-08-30 | ok | 117 model spellings mapped to the master |
| Sales leads | dealertrack_leads.csv | 603 | 603 | 0 | 195 | – | – | 2026-08-30 | ok | 195 leads without a vehicle of interest, kept |
| Parts inventory | dealertrack_parts.csv | 1,206 | 1,206 | 0 | 0 | – | – | 2026-08-30 | ok | clean |
| Repair orders | dealertrack_ros.csv | 9,193 | 9,193 | 0 | 26 | – | – | 2026-08-29 | ok | 26 repair orders still open |
| Technicians | dealertrack_technicians.csv | 13 | 13 | 0 | 0 | – | – | 2026-08-30 | ok | roster with certifications |
| Feed | File | Rows in | Loaded | Quarantined | Exceptions | Control total | Loaded total | Last event | Status | Note |
|---|---|---|---|---|---|---|---|---|---|---|
| Retail deals | dealertrack_deals.csv | 1,287 | 1,287 | 0 | 0 | $5.00M | $5.00M | 2026-08-30 | ok | contract dates, money and N/U codes normalised from the DMS dialect |
| Vehicle inventory | dealertrack_inventory.csv | 111 | 111 | 0 | 0 | – | – | 2026-08-30 | ok | 7 model spellings mapped to the master |
| Sales leads | dealertrack_leads.csv | 458 | 458 | 0 | 159 | – | – | 2026-08-30 | ok | 159 leads without a vehicle of interest, kept |
| Parts inventory | dealertrack_parts.csv | 1,029 | 1,029 | 0 | 0 | – | – | 2026-08-30 | ok | clean |
| Repair orders | dealertrack_ros.csv | 5,890 | 5,890 | 0 | 14 | – | – | 2026-08-29 | ok | 14 repair orders still open |
| Technicians | dealertrack_technicians.csv | 8 | 8 | 0 | 0 | – | – | 2026-08-30 | ok | roster with certifications |
| Feed | File | Rows in | Loaded | Quarantined | Exceptions | Control total | Loaded total | Last event | Status | Note |
|---|---|---|---|---|---|---|---|---|---|---|
| Retail deals | cdk_deals.csv | 1,479 | 1,479 | 0 | 0 | $5.35M | $5.35M | 2026-08-30 | ok | contract dates, money and N/U codes normalised from the DMS dialect |
| Vehicle inventory | cdk_inventory.csv | 145 | 145 | 0 | 0 | – | – | 2026-08-30 | ok | 4 model spellings mapped to the master |
| Sales leads | cdk_leads.csv | 501 | 501 | 0 | 181 | – | – | 2026-08-30 | ok | 181 leads without a vehicle of interest, kept |
| Parts inventory | cdk_parts.csv | 1,091 | 1,091 | 0 | 0 | – | – | 2026-08-30 | ok | clean |
| Repair orders | cdk_ros.csv | 6,742 | 6,742 | 0 | 10 | – | – | 2026-08-29 | ok | 10 repair orders still open |
| Technicians | cdk_technicians.csv | 10 | 10 | 0 | 0 | – | – | 2026-08-30 | ok | roster with certifications |
| Feed | File | Rows in | Loaded | Quarantined | Exceptions | Control total | Loaded total | Last event | Status | Note |
|---|---|---|---|---|---|---|---|---|---|---|
| Retail deals | cdk_deals.csv | 1,691 | 1,691 | 0 | 0 | $7.57M | $7.57M | 2026-08-30 | ok | contract dates, money and N/U codes normalised from the DMS dialect |
| Vehicle inventory | cdk_inventory.csv | 341 | 341 | 0 | 0 | – | – | 2026-08-30 | ok | 17 model spellings mapped to the master |
| Sales leads | cdk_leads.csv | 549 | 549 | 0 | 177 | – | – | 2026-08-30 | ok | 177 leads without a vehicle of interest, kept |
| Parts inventory | cdk_parts.csv | 1,188 | 1,178 | 10 | 7 | – | – | 2026-08-30 | attention | 7 negative on-hand quantities clamped to zero, raw retained |
| Repair orders | cdk_ros.csv | 7,637 | 7,637 | 0 | 22 | – | – | 2026-08-29 | ok | 22 repair orders still open |
| Technicians | cdk_technicians.csv | 11 | 11 | 0 | 0 | – | – | 2026-08-30 | ok | roster with certifications |
| Feed | Provider | Rows in | Loaded | Quarantined | Statement balance | Note |
|---|---|---|---|---|---|---|
| Floorplan statement | Ally Financial | 443 | 443 | 0 | $8.65M | reconciled against DMS inventory and deals in the analysis step |
| Floorplan statement | First Lakeshore Bank | 458 | 458 | 0 | $8.82M | reconciled against DMS inventory and deals in the analysis step |
| Floorplan statement | Ford Credit | 516 | 516 | 0 | $18.63M | reconciled against DMS inventory and deals in the analysis step |
| Floorplan statement | GM Financial | 744 | 744 | 0 | $27.73M | reconciled against DMS inventory and deals in the analysis step |
| Floorplan statement | Honda Financial Services | 161 | 161 | 0 | $5.13M | reconciled against DMS inventory and deals in the analysis step |
| Floorplan statement | Hyundai Motor Finance | 66 | 66 | 0 | $2.05M | reconciled against DMS inventory and deals in the analysis step |
| Floorplan statement | Toyota Financial Services | 412 | 412 | 0 | $13.62M | reconciled against DMS inventory and deals in the analysis step |
| Lease portfolio | Ford Credit | 428 | 428 | 0 | – | maturities feed the equity-mining view |
| Lease portfolio | GM Financial | 399 | 399 | 0 | – | maturities feed the equity-mining view |
| Lease portfolio | Honda Financial Services | 228 | 228 | 0 | – | maturities feed the equity-mining view |
| Lease portfolio | Hyundai Motor Finance | 152 | 152 | 0 | – | maturities feed the equity-mining view |
| Lease portfolio | Toyota Financial Services | 485 | 485 | 0 | – | maturities feed the equity-mining view |