234 lines
23 KiB
Gherkin
234 lines
23 KiB
Gherkin
Feature: Import Read Service - New Loans
|
|
Gets loans from a stream of csv data, reads loans into memory, calculates reserve, saves loans, saves import information
|
|
|
|
Scenario: AddImport - happy path
|
|
Given an import file named "NewLoans 2021-03-01.txt" that contains
|
|
"""
|
|
3434,3250,144,MUELLER, STEVEN C,02/10/2021,02/12/2021,03/12/2021,2/12/2025,25989.97,2.03,3.39,579.76,NC,XX,N,1462
|
|
4545,12021,143,HAYDEN, ALEXANDER W,01/23/2021,02/02/2021,03/09/2021,2/9/2027,14975.57,4.39,6.39,251.61,NC,XX,N,2189
|
|
"""
|
|
When I read this new loan import file at "3/5/2021 5:00:00 AM"
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename | Import Type |
|
|
| 3/5/2021 5:00:00 AM | 2 | 2 | true | NewLoans 2021-03-01.txt | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the loans now look like
|
|
| ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | Loan Status | ExportedReserveDate | Term |
|
|
| 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 2.03 | 3.39 | New | | 48 |
|
|
| 1 | 12021 | 143 | HAYDEN | ALEXANDER | W | 4545 | 1/23/2021 | 4.39 | 6.39 | New | | 72 |
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: AddImport with Boat Loan Account Type
|
|
Given an import file named "NewLoans 2021-03-01.txt" that contains
|
|
"""
|
|
3434,71229741,143,WILLIAMS,SAM R,01/06/2021,02/03/2021,03/05/2021,05/05/2026,27889.51,2.49,4.49,472.71,NC,XX,N,1918,M233333389Y85312,Honda,Civic,2020,1900,Black,1245988,false,false,false,false,false,DL10
|
|
"""
|
|
When I read this new loan import file at "3/5/2021 5:00:00 AM"
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename | Import Type |
|
|
| 3/5/2021 5:00:00 AM | 1 | 1 | true | NewLoans 2021-03-01.txt | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the loans now look like
|
|
| ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | Loan Status | ExportedReserveDate | ReserveAmount | ReserveMessage | Term |
|
|
| 1 | 71229741 | 143 | WILLIAMS | SAM | R | 3434 | 1/06/2021 | 2.49 | 4.49 | New | | 1673.3706 | Standard Reserve | 63 |
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: AddImport - file is wrong format (missing column, etc.) - note that this doesn't return the import that was saved but it is in the table
|
|
Given an import file named "NewLoans 2021-03-01.txt" that contains
|
|
"""
|
|
C9,3250,144,MUELLER, STEVEN C,02/10/2021,03/12/2021,2/12/2025,25989.97,2.03,3.39,579.76,NC,XX,N
|
|
R23,12021,143,HAYDEN, ALEXANDER W,01/23/2021,03/09/2021,2/9/2027,14975.57,4.39,6.39,251.61,NC,XX,N
|
|
"""
|
|
When I read this new loan import file at "3/5/2021 5:00:00 AM"
|
|
And I get the record from the ImportTable
|
|
Then the import looks like
|
|
| StartDate | EndDate | RecordCount | RecordsSaved | Success | Filename | Import Type |
|
|
| 3/5/2021 5:00:00 AM | | 0 | 0 | false | NewLoans 2021-03-01.txt | Active |
|
|
And ExportReservesAsync is not called
|
|
|
|
Scenario: AddImport - file name has more than 50 characters
|
|
Given an import file named "NewLoans 2021-03-011234567890123456789012345678901234567890.txt" that contains
|
|
"""
|
|
1234,3250,144,MUELLER, STEVEN C,02/10/2021,02/12/2021,03/12/2021,2/12/2025,25989.97,2.03,3.39,579.76,NC,XX,N,1462
|
|
5678,12021,143,HAYDEN, ALEXANDER W,01/23/2021,02/02/2021,03/09/2021,2/9/2027,14975.57,4.39,6.39,251.61,NC,XX,N,2189
|
|
"""
|
|
When I read this new loan import file at "3/5/2021 5:00:00 AM"
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename |
|
|
| 3/5/2021 5:00:00 AM | 2 | 2 | true | NewLoans 2021-03-011234567890123456789012345678901 |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the loans now look like
|
|
| ImportId | Member Number | Loan Number | Member LastName | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | Loan Status | ExportedReserveDate | Term |
|
|
| 1 | 3250 | 144 | MUELLER | STEVEN | C | 1234 | 2/10/2021 | 2.03 | 3.39 | New | | 48 |
|
|
| 1 | 12021 | 143 | HAYDEN | ALEXANDER | W | 5678 | 1/23/2021 | 4.39 | 6.39 | New | | 72 |
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: AddImport for Update Loans - updates three new loans that are in the loan table, saves one brand new loan
|
|
Given an import file named "NewLoans 2021-03-01.txt" that contains
|
|
"""
|
|
3434,13,3,SMITH, JOE,02/25/2021,02/28/2021,04/11/2021,6/11/2026,12615.87,4.03,5.790,579.76,NC,XX,N,1930
|
|
4545,3250,144,MUELLER, STEVEN C,02/10/2021,02/12/2021,03/12/2021,2/12/2025,25989.97,2.03,3.39,579.76,NC,XX,N,1462
|
|
1212,12021,143,HAYDEN, ALEXANDER W,01/23/2021,02/02/2021,03/09/2021,2/9/2027,14975.57,4.39,6.39,251.61,NC,XX,N,2199
|
|
7878,13991,145,RUTHENBERG, RICHARD J,01/22/2021,02/02/2021,03/08/2021,5/8/2027,32891.50,2.43,3.19,484.92,NC,XX,N,2287
|
|
"""
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Term |
|
|
| 1 | 1 | 13 | 3 | SMITH | JOE | | 3434 | 2/25/2021 | 4.030 | 4.790 | New | 5/2/2021 | 63 |
|
|
| 2 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 4545 | 2/10/2021 | 2.03 | 3.39 | New | 5/2/2021 | 48 |
|
|
| 3 | 1 | 12021 | 143 | HAYDEN | ALEXANDER | W | 1212 | 1/23/2021 | 4.39 | 6.39 | New | 5/2/2021 | 72 |
|
|
When I read this new loan import file at "3/5/2021 5:00:00 AM"
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename |
|
|
| 3/5/2021 5:00:00 AM | 4 | 4 | true | NewLoans 2021-03-01.txt |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the loans now look like
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Term |
|
|
| 1 | 1 | 13 | 3 | SMITH | JOE | | 3434 | 2/25/2021 12:00:00 AM | 4.03 | 5.790 | Updated | | 63 |
|
|
| 2 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 4545 | 2/10/2021 12:00:00 AM | 2.03 | 3.39 | Updated | | 48 |
|
|
| 3 | 1 | 12021 | 143 | HAYDEN | ALEXANDER | W | 1212 | 1/23/2021 12:00:00 AM | 4.39 | 6.39 | Updated | | 72 |
|
|
| 4 | 1 | 13991 | 145 | RUTHENBERG | RICHARD | J | 7878 | 1/22/2021 12:00:00 AM | 2.43 | 3.19 | New | | 75 |
|
|
And AddHistoriesAsync is called with 3 history/ies having ActivityType "NewLoanUpdate" and AuditDescription "Loan found in table, record updated"
|
|
And AddHistoriesAsync is called with 1 history/ies having LoanNumber "3" and MemberNumber "13"
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: AddImport for Update Loans - updates three new loans that are in the loan table, one loan has ten thousandth decimal place difference in buy rate, and same with contract rate, round down
|
|
Given an import file named "NewLoans 2021-03-01.txt" that contains
|
|
"""
|
|
3434,13,3,SMITH, JOE,02/25/2021,02/28/2021,04/11/2021,6/11/2026,12615.87,4.03124,5.790,579.76,NC,XX,N,1930
|
|
4545,3250,144,MUELLER, STEVEN C,02/10/2021,02/12/2021,03/12/2021,2/12/2025,25989.97,2.03,3.39,579.76,NC,XX,N,1462
|
|
1212,12021,143,HAYDEN, ALEXANDER W,01/23/2021,02/02/2021,03/09/2021,2/9/2027,14975.57,4.39,6.39,251.61,NC,XX,N,2199
|
|
7878,13991,145,RUTHENBERG, RICHARD J,01/22/2021,02/02/2021,03/08/2021,5/8/2027,32891.50,2.43,3.19,484.92,NC,XX,N,2287
|
|
"""
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Term |
|
|
| 1 | 1 | 13 | 3 | SMITH | JOE | | 3434 | 2/25/2021 | 4.031 | 4.790 | New | 5/2/2021 | 63 |
|
|
| 2 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 4545 | 2/10/2021 | 2.03 | 3.39 | New | 5/2/2021 | 48 |
|
|
| 3 | 1 | 12021 | 143 | HAYDEN | ALEXANDER | W | 1212 | 1/23/2021 | 4.39 | 6.39 | New | 5/2/2021 | 72 |
|
|
When I read this new loan import file at "3/5/2021 5:00:00 AM"
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename |
|
|
| 3/5/2021 5:00:00 AM | 4 | 4 | true | NewLoans 2021-03-01.txt |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the loans now look like
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Term |
|
|
| 1 | 1 | 13 | 3 | SMITH | JOE | | 3434 | 2/25/2021 12:00:00 AM | 4.031 | 5.790 | Updated | | 63 |
|
|
| 2 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 4545 | 2/10/2021 12:00:00 AM | 2.03 | 3.39 | Updated | | 48 |
|
|
| 3 | 1 | 12021 | 143 | HAYDEN | ALEXANDER | W | 1212 | 1/23/2021 12:00:00 AM | 4.39 | 6.39 | Updated | | 72 |
|
|
| 4 | 1 | 13991 | 145 | RUTHENBERG | RICHARD | J | 7878 | 1/22/2021 12:00:00 AM | 2.43 | 3.19 | New | | 75 |
|
|
And AddHistoriesAsync is called with 3 history/ies having ActivityType "NewLoanUpdate" and AuditDescription "Loan found in table, record updated"
|
|
And AddHistoriesAsync is called with 1 history/ies having LoanNumber "3" and MemberNumber "13"
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: AddImport for Update Loans - updates three new loans that are in the loan table, one loan has ten thousandth decimal place difference in buy rate, and same with contract rate, round up
|
|
Given an import file named "NewLoans 2021-03-01.txt" that contains
|
|
"""
|
|
3434,13,3,SMITH, JOE,02/25/2021,02/28/2021,04/11/2021,6/11/2026,12615.87,4.03155,5.790,579.76,NC,XX,N,1930
|
|
4545,3250,144,MUELLER, STEVEN C,02/10/2021,02/12/2021,03/12/2021,2/12/2025,25989.97,2.03,3.39,579.76,NC,XX,N,1462
|
|
1212,12021,143,HAYDEN, ALEXANDER W,01/23/2021,02/02/2021,03/09/2021,2/9/2027,14975.57,4.39,6.2465,251.61,NC,XX,N,2199
|
|
7878,13991,145,RUTHENBERG, RICHARD J,01/22/2021,02/02/2021,03/08/2021,5/8/2027,32891.50,2.43,3.19,484.92,NC,XX,N,2287
|
|
"""
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Term |
|
|
| 1 | 1 | 13 | 3 | SMITH | JOE | | 3434 | 2/25/2021 | 4.031 | 5.790 | New | 5/2/2021 | 63 |
|
|
| 2 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 4545 | 2/10/2021 | 2.03 | 3.39 | New | 5/2/2021 | 48 |
|
|
| 3 | 1 | 12021 | 143 | HAYDEN | ALEXANDER | W | 1212 | 1/23/2021 | 4.39 | 6.246 | New | 5/2/2021 | 72 |
|
|
When I read this new loan import file at "3/5/2021 5:00:00 AM"
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename |
|
|
| 3/5/2021 5:00:00 AM | 4 | 4 | true | NewLoans 2021-03-01.txt |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the loans now look like
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Term |
|
|
| 1 | 1 | 13 | 3 | SMITH | JOE | | 3434 | 2/25/2021 12:00:00 AM | 4.032 | 5.790 | Updated | | 63 |
|
|
| 2 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 4545 | 2/10/2021 12:00:00 AM | 2.03 | 3.39 | Updated | | 48 |
|
|
| 3 | 1 | 12021 | 143 | HAYDEN | ALEXANDER | W | 1212 | 1/23/2021 12:00:00 AM | 4.39 | 6.247 | Updated | | 72 |
|
|
| 4 | 1 | 13991 | 145 | RUTHENBERG | RICHARD | J | 7878 | 1/22/2021 12:00:00 AM | 2.43 | 3.19 | New | | 75 |
|
|
And AddHistoriesAsync is called with 3 history/ies having ActivityType "NewLoanUpdate" and AuditDescription "Loan found in table, record updated"
|
|
And AddHistoriesAsync is called with 1 history/ies having LoanNumber "3" and MemberNumber "13"
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: AddImport for Update Loans - updates one loan that is in the loan table, 1 records to audit table for updates
|
|
Given an import file named "NewLoans 2021-03-01.txt" that contains
|
|
"""
|
|
3434,12,3,SMITH, JOE,02/25/2021,02/28/2021,04/11/2021,6/11/2026,12615.87,4.03,5.790,579.76,NC,XX,N,1930
|
|
"""
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Term |
|
|
| 1 | 1 | 12 | 3 | SMITH | JOE | | 3434 | 2/25/2021 | 4.030 | 4.790 | New | 5/2/2021 | 63 |
|
|
When I read this new loan import file at "3/5/2021 5:00:00 AM"
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename | Import Type |
|
|
| 3/5/2021 5:00:00 AM | 1 | 1 | true | NewLoans 2021-03-01.txt | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the loans now look like
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Term |
|
|
| 1 | 1 | 12 | 3 | SMITH | JOE | | 3434 | 2/25/2021 12:00:00 AM | 4.03 | 5.790 | Updated | | 63 |
|
|
And AddHistoriesAsync is called with 1 history/ies having ActivityType "NewLoanUpdate" and AuditDescription "Loan found in table, record updated"
|
|
And AddHistoriesAsync is called with 1 history/ies having LoanNumber "3" and MemberNumber "12"
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: AddImport - Vehicle Info - One record populated with VIN, one record optional, Not checking for invalid dealer code any more, Two Invalid Missing VIN action required True
|
|
Given an import file named "NewLoans 2021-05-19.txt" that contains
|
|
"""
|
|
3434,71229741,143,WILLIAMS,SAM R,01/06/2021,02/03/2021,03/05/2021,05/05/2026,27889.51,2.49,2.49,472.71,NC,XX,N,1918,M233333389Y85312,Honda,Civic,2020,1900,Black
|
|
4545,7488740,144,STERLING, JIM C,01/06/2021,02/03/2021,03/05/2021,05/05/2026,27889.51,2.49,2.49,472.71,NC,XX,N,1918
|
|
4545,8488740,144,STERLING, KIM C,01/06/2021,02/03/2021,03/05/2021,05/05/2026,27889.51,2.49,2.49,472.71,NC,XX,N,1918,,Honda,Civic,2020,1900,Black
|
|
"""
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3333 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 4545 |
|
|
When I read this new loan import file at "5/19/2021 1:00:00 PM"
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename | Import Type |
|
|
| 5/19/2021 1:00:00 PM | 3 | 3 | true | NewLoans 2021-05-19.txt | Active |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | Loan Status | Action Required | ExportedReserveDate | Term |
|
|
| 1 | 1 | 71229741 | 143 | WILLIAMS | SAM | R | 3434 | 1/06/2021 | 2.49 | 2.49 | New | False | | 63 |
|
|
| 1 | 2 | 7488740 | 144 | STERLING | JIM | C | 4545 | 1/06/2021 | 2.49 | 2.49 | New | True | | 63 |
|
|
| 1 | 3 | 8488740 | 144 | STERLING | KIM | C | 4545 | 1/06/2021 | 2.49 | 2.49 | New | True | | 63 |
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: AddImport - Vehicle Info - One record populated with VIN, one record optional
|
|
Given an import file named "NewLoans 2021-05-19.txt" that contains
|
|
"""
|
|
3434,71229741,143,WILLIAMS,SAM R,01/06/2021,02/03/2021,03/05/2021,05/05/2026,27889.51,2.49,2.49,472.71,NC,XX,N,1918
|
|
4545,7488740,144,STERLING, JIM C,01/06/2021,02/03/2021,03/05/2021,05/05/2026,27889.51,2.49,2.49,472.71,NC,XX,N,1918,M233333389Y85312,Honda,Civic,2020,1900,Black
|
|
"""
|
|
When I read this new loan import file at "5/19/2021 1:00:00 PM"
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename | Import Type |
|
|
| 5/19/2021 1:00:00 PM | 2 | 2 | true | NewLoans 2021-05-19.txt | Active |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | Loan Status | ExportedReserveDate | Term |
|
|
| 1 | 1 | 71229741 | 143 | WILLIAMS | SAM | R | 3434 | 1/06/2021 | 2.49 | 2.49 | New | | 63 |
|
|
| 1 | 2 | 7488740 | 144 | STERLING | JIM | C | 4545 | 1/06/2021 | 2.49 | 2.49 | New | | 63 |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M233333389Y85312 | 2 | Honda | Civic | 2020 | 1900 | Black |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | | 0 | |
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: AddImport - Vehicle Info - Both records populated with VIN, can handle VIN longer than 17 characters
|
|
Given an import file named "NewLoans 2021-05-19-2.txt" that contains
|
|
"""
|
|
3434,7488740,144,SWEENEY, JIM C,01/06/2021,02/03/2021,03/05/2021,05/05/2026,27889.51,2.49,2.49,472.71,NC,XX,N,1918,M733P33389Y85216,Chevrolet,Cruze,2013,10K,White
|
|
4545,71229741,143,BARNES,BILL R,01/06/2021,02/03/2021,03/05/2021,05/05/2026,27889.51,2.49,2.49,472.71,NC,XX,N,1918,M233333389Y853128921,Buick,LaCrosse,2017,56000,Burgundy
|
|
"""
|
|
When I read this new loan import file at "5/19/2021 1:00:00 PM"
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename | Import Type |
|
|
| 5/19/2021 1:00:00 PM | 2 | 2 | true | NewLoans 2021-05-19-2.txt | Active |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | Loan Status | ExportedReserveDate | Term |
|
|
| 1 | 1 | 7488740 | 144 | SWEENEY | JIM | C | 3434 | 1/06/2021 | 2.49 | 2.49 | New | | 63 |
|
|
| 1 | 2 | 71229741 | 143 | BARNES | BILL | R | 4545 | 1/06/2021 | 2.49 | 2.49 | New | | 63 |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1 | M733P33389Y85216 | 1 | Chevrolet | Cruze | 2013 | 0 | White |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 2 | M233333389Y853128921 | 2 | Buick | LaCrosse | 2017 | 56000 | Burgundy |
|
|
And ExportReservesAsync is called |