Docs · File formats
Warranty Recovery CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as |
|---|---|---|
| RO Number | Yes | ro, ro number, ro #, repair order, repair order number, ronumber |
| Vin | vin, vehicle identification number, vehicle vin | |
| Claim Number | claim, claim number, claim #, claimno, claim_no | |
| Repair Date | repair date, ro date, r/o date, ro closed, r/o closed, in service date | |
| Submitted At | submitted, submit date, claim date, submitted date, r/o submitted, submitted_at | |
| Op Code | op code, labor op, operation, op, opcode, op_code | |
| Labor Hours | hours, labor hours, frl hours, time, labor_time | |
| Labor Cents | labor, labor amount, labor $, labor_amt, labor sale | |
| Parts Cents | parts, parts amount, parts $, parts_amt, parts sale | |
| Sublet Cents | sublet, sublet amount, sublet $, sublet_amt | |
| Total Cents | total, total amount, claim amount, total $, claim total | |
| Paid Cents | paid, paid amount, approved, approved amount, warranty paid | |
| Preauth On File | preauth, pre-auth, pre authorization, preauth on file, auth | |
| Has Dtc Printout | dtc, dtc printout, dtc attached, has dtc | |
| Has Diag Narrative | narrative, diag narrative, diagnosis narrative, comments, tech narrative | |
| Has Photos | photos, photo, photos attached, images | |
| Parts Returned | parts returned, part returned, preturn, parts return | |
| Denial Code | denial code, denial, reject code, reason code, denial_code | |
| Denial Text | denial text, denial reason, reason, reject reason, denial_text |