1753 lines
237 KiB
Gherkin
1753 lines
237 KiB
Gherkin
Feature: Import Read Service - New and Updated Loans from DNA
|
|
Gets loans from the CoreApiWrapper, calculates reserve, saves loans, saves import information. Updates loans that already exist
|
|
Note that the export service is a mock, so the step for "loans now look like" will reflect the loans before the export
|
|
|
|
Background:
|
|
Given a loan type table consisting of
|
|
| LoanTypeId | LoanComment | ChargebackMethod | NoChargebackDays | NoChargebackPayments | ReserveDiscount | FlatFeePercent | NoReserveThreshold |
|
|
| NC | 75% Reserve | N | 90 | 3 | 25.00 | 1.00 | 0.25 |
|
|
| BB | Standard | S | 0 | 0 | 0 | 1.00 | 0.25 |
|
|
| NR | No reserve to be paid | N | 0 | 0 | 0 | 0.00 | 0.25 |
|
|
|
|
Scenario: Add From DNA - Add all fields, vehicles added, missing VIN action required, VIN length longer than 17 characters works
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerCode | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1918 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | BB | 10/31/2019 | 11/6/2019 | 12/15/2019 | 2/15/2026 | 20171.51 | 3.29 | 4.90 | False | True | False | True | False | 3488 | 9888447543454544 | 232323455 | M233333389Y853128921 | Honda | Civic | 2020 | 1900 | Black | 2294 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | LoanTypeId | Dealer Code | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 9888447543454544 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 9888447543454544 |
|
|
And the loans now look like
|
|
#before export
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | true |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3488 | BB | 10/31/2019 | 11/6/2019 | 12/15/2019 | 2/15/2026 | 20171.51 | 3.29 | 4.90 | New | 1132.5564086943452341656244555 | False | True | False | True | False | 232323455 | | | false |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1 | | 1 | | | 0 | 0 | |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 2 | M233333389Y853128921 | 2 | Honda | Civic | 2020 | 1900 | Black |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - import but skip export
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerCode | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | BB | 10/31/2019 | 11/6/2019 | 12/15/2019 | 2/15/2026 | 20171.51 | 3.29 | 4.90 | False | True | False | True | False | 3488 | 9888447543454544 | 232323455 | M233333389Y853128921 | Honda | Civic | 2020 | 1900 | Black | 2294 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | LoanTypeId | Dealer Code | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 9888447543454544 |
|
|
When I process this DNA new/updated loan import at "3/5/2021 5:00:00 AM" and skip the export
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename | Import Type |
|
|
| 3/5/2021 5:00:00 AM | 2 | 2 | true | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 9888447543454544 |
|
|
And the loans now look like
|
|
#before export
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | true |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3488 | BB | 10/31/2019 | 11/6/2019 | 12/15/2019 | 2/15/2026 | 20171.51 | 3.29 | 4.90 | New | 1132.5564086943452341656244555 | False | True | False | True | False | 232323455 | false |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1 | | 1 | | | 0 | 0 | |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 2 | M233333389Y853128921 | 2 | Honda | Civic | 2020 | 1900 | Black |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is not called
|
|
And MarkReservesAsExportedAsync is called
|
|
|
|
Scenario: Add From DNA - Dealer Name is updated
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | Dealer Name | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | True | False | True | 3434 | 324324324324324 | SUBURBAN MOTORS HD | 2123444 | | | | | | | 1918 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | H21 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | False | True | False | True | False | 3488 | 9888447543454544 | HEISER CHEVROLET CADILLAC OF WEST BEND | 232323455 | M233333389Y853128921 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HD | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 9888447543454544 |
|
|
And the loans now look like
|
|
#before export
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | True | False | True | 2123444 | | | true |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3488 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 819.2332826134477373747357048 | False | True | False | True | False | 232323455 | | | false |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1 | | 1 | | | 0 | 0 | |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 2 | M233333389Y853128921 | 2 | Honda | Civic | 2020 | 1900 | Black |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - Dealer code with different casing won't matter
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | Dealer Name | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | s7 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | SUBURBAN MOTORS HD | 2123444 | | | | | | | 1918 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | H21 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | False | True | True | True | False | 3488 | 9888447543454544 | HEISER CHEVROLET CADILLAC OF WEST BEND | 232323455 | M233333389Y853128921 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | LoanTypeId | Dealer Code | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HD | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 9888447543454544 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | true |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3488 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 819.2332826134477373747357048 | False | True | True | True | False | 232323455 | | | false |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1 | | 1 | | | 0 | 0 | |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 2 | M233333389Y853128921 | 2 | Honda | Civic | 2020 | 1900 | Black |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - We only take the dealer information from the first loan with that dealer
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | Dealer Name | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | SUBURBAN MOTORS HD | 2123444 | | | | | | | 1919 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | S7 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | False | True | True | True | False | 3434 | 9888447543454544 | HEISER CHEVROLET CADILLAC OF WEST BEND | 232323455 | M233333389Y853128921 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
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 | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1234 | 124324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HD | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1234 | 124324324324324 |
|
|
And the loans now look like
|
|
#before export
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | true |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3434 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 819.2332826134477373747357048 | False | True | True | True | False | 232323455 | | | false |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1 | | 1 | | | 0 | 0 | |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 2 | M233333389Y853128921 | 2 | Honda | Civic | 2020 | 1900 | Black |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - We only take the dealer information from the first loan with that dealer with multiple scenarios
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | Dealer Name | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | SUBURBAN MOTORS HD | 2123444 | | | | | | | 1919 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | S7 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | False | True | True | True | False | 3434 | 9888447543454544 | HEISER CHEVROLET CADILLAC OF WEST BEND | 232323455 | M233333389Y853128921 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
| 3250 | 145 | BRABANT | STEVEN | C | A1 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 1434 | 4324324324324 | ACURA OF BROOKFIELD | 3123444 | | | | | | | 1919 |
|
|
| 12021 | 146 | DRYDEN | ALEX | W | A1 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 2000 | 4.39 | 6.39 | False | True | True | True | False | 1434 | 4324324324324 | ACURA OF BROOKFIELD | 432323455 | P233333389Y853128921 | Honda | Pilot | 2020 | 1900 | Black | 1447 |
|
|
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 | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | Term |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1234 | 124324324324324 |
|
|
| A1 | ACURA OF BROOKFIELD | 1434 | 4324324324324 |
|
|
When I process this DNA new/updated loan import 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 | 4 | 4 | true | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HD | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1234 | 124324324324324 |
|
|
| A1 | ACURA OF BROOKFIELD | 1434 | 4324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | true |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3434 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 819.2332826134477373747357048 | False | True | True | True | False | 232323455 | | | false |
|
|
| 1 | 3 | 3250 | 145 | BRABANT | STEVEN | C | 1434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 3123444 | | | true |
|
|
| 1 | 4 | 12021 | 146 | DRYDEN | ALEX | W | 1434 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 2000 | 4.39 | 6.39 | New | 65.538662609075818989978856425 | False | True | True | True | False | 432323455 | | | false |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1 | | 1 | | | 0 | 0 | |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 2 | M233333389Y853128921 | 2 | Honda | Civic | 2020 | 1900 | Black |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - Action Required on Dealer acount number missing
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | Dealer Name | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | SUBURBAN MOTORS HD | 2123444 | R233333389Y853128921 | | | | | | 1919 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | S7 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | False | True | True | True | False | 3434 | 9888447543454544 | SUBURBAN MOTORS HD | 232323455 | V233333389Y853128921 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
| 3250 | 145 | BRABANT | STEVEN | C | A1 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 1434 | 4324324324324 | ACURA OF BROOKFIELD | 3123444 | M233333389Y853128921 | | | | | | 1919 |
|
|
| 12021 | 146 | DRYDEN | ALEX | W | H21 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 2000 | 4.39 | 6.39 | False | True | True | True | False | 1234 | | HEISER CHEVROLET CADILLAC OF WEST BEND | 432323455 | P233333389Y853128921 | Honda | Pilot | 2020 | 1900 | Black | 1447 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | LoanTypeId | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1234 | |
|
|
| A1 | ACURA OF BROOKFIELD | 1434 | 4324324324324 |
|
|
When I process this DNA new/updated loan import 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 | 4 | 4 | true | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HD | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1234 | |
|
|
| A1 | ACURA OF BROOKFIELD | 1434 | 4324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | false |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3434 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 819.2332826134477373747357048 | False | True | True | True | False | 232323455 | | | false |
|
|
| 1 | 3 | 3250 | 145 | BRABANT | STEVEN | C | 1434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 3123444 | | | false |
|
|
| 1 | 4 | 12021 | 146 | DRYDEN | ALEX | W | 1234 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 2000 | 4.39 | 6.39 | New | 65.538662609075818989978856425 | False | True | True | True | False | 432323455 | | | true |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1 | R233333389Y853128921 | 1 | | | 0 | 0 | |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 2 | V233333389Y853128921 | 2 | Honda | Civic | 2020 | 1900 | Black |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - Action Required on Dealer org number missing
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | Dealer Name | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | SUBURBAN MOTORS HD | 2123444 | R233333389Y853128921 | | | | | | 1919 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | S7 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | False | True | True | True | False | 3434 | 9888447543454544 | SUBURBAN MOTORS HD | 232323455 | V233333389Y853128921 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
| 3250 | 145 | BRABANT | STEVEN | C | A1 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | | 4324324324324 | ACURA OF BROOKFIELD | 3123444 | M233333389Y853128921 | | | | | | 1919 |
|
|
| 12021 | 146 | DRYDEN | ALEX | W | H21 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 2000 | 4.39 | 6.39 | False | True | True | True | False | 1234 | 124324324324324 | HEISER CHEVROLET CADILLAC OF WEST BEND | 432323455 | P233333389Y853128921 | Honda | Pilot | 2020 | 1900 | Black | 1447 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | LoanTypeId | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1234 | 124324324324324 |
|
|
| A1 | ACURA OF BROOKFIELD | | 4324324324324 |
|
|
When I process this DNA new/updated loan import 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 | 4 | 4 | true | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HD | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1234 | 124324324324324 |
|
|
| A1 | ACURA OF BROOKFIELD | | 4324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | false |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3434 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 819.2332826134477373747357048 | False | True | True | True | False | 232323455 | | | false |
|
|
| 1 | 3 | 3250 | 145 | BRABANT | STEVEN | C | | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 3123444 | | | true |
|
|
| 1 | 4 | 12021 | 146 | DRYDEN | ALEX | W | 1234 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 2000 | 4.39 | 6.39 | New | 65.538662609075818989978856425 | False | True | True | True | False | 432323455 | | | false |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1 | R233333389Y853128921 | 1 | | | 0 | 0 | |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VehicleId | VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 2 | V233333389Y853128921 | 2 | Honda | Civic | 2020 | 1900 | Black |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - can handle 4 characters in dealer code
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | LoanType | Dealer Code | DealerName | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | NC | S777 | SUBURBAN MOTORS HARLEY DAVIDSON | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
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 | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S777 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 2525 | 924324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S777 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 2525 | 924324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | true |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - can insert new dealer if doesn't already exist
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | Dealer Name | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S777 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | Dealer Name | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1434 | 424324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S777 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1434 | 424324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | true |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - if dealer code is null, add the loan, Action Required for dealer code is True
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | | HEISER CHEVROLET CADILLAC OF WEST BEND | NC | 01/23/2021 | 01/30/2021 | 02/15/2021 | 01/15/2025 | 25000 | 4.39 | 6.39 | False | True | False | True | False | 4545 | 924324324324324 | 232323455 | M233333389Y85312 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Dealer Name | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1111 | |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 1111 | |
|
|
| | HEISER CHEVROLET CADILLAC OF WEST BEND | 4545 | 924324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | True |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 4545 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 819.2332826134477373747357048 | False | True | False | True | False | 232323455 | | | True |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - if dealer code is more than 4 chars, add the loan and the dealer with an empty dealer code, Action Required for dealer code is True
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | S7777 | BARTZ AUTO | NC | 01/23/2021 | 01/30/2021 | 02/15/2021 | 01/15/2025 | 25000 | 4.39 | 6.39 | False | True | False | True | False | 5656 | 43453453455565 | 232323455 | M233333389Y85312 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Dealer Name | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| | BARTZ AUTO | 5656 | 43453453455565 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| | BARTZ AUTO | 5656 | 43453453455565 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | True |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 5656 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 819.2332826134477373747357048 | False | True | False | True | False | 232323455 | | | True |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - if member number is null, add the loan
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
| | 143 | HAYDEN | ALEXANDER | W | H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | NC | 01/23/2021 | 01/30/2021 | 02/15/2021 | 01/15/2025 | 25000 | 4.39 | 6.39 | False | True | False | True | False | 3488 | 9888447543454544 | 232323455 | M233333389Y85312 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 9888447543454544 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 9888447543454544 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | True |
|
|
| 1 | 2 | | 143 | HAYDEN | ALEXANDER | W | 3488 | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 819.2332826134477373747357048 | False | True | False | True | False | 232323455 | | | False |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - only amount on loan is updated and saved, Reserve is recalculated, ReserveExportedDate becomes NULL, vehicle is updated
|
|
#Gap, Warranty, Mbp insurance on an updated loan will come in false on conversion loans
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 20889.51 | 2.03 | 3.39 | False | False | False | False | True | 3434 | 324324324324324 | 2123444 | 1DODGE1234DAKOTA5 | DODGE | DAKOTA | 2009 | 97997 | | 1553 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Term |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | 793.9133223793564 | | New | True | False | True | False | True | 2123444 | 3/4/2021 | | 51 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 20889.51 | 2.03 | 3.39 | Updated | 478.99635611847757906025386875 | -314.91 | True | False | True | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1DODGE1234DAKOTA5 | 1 | DODGE | DAKOTA | 2009 | 97997 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - only first payment date on loan is updated and saved, Reserve is recalculated, ReserveExportedDate becomes NULL, vehicle is updated, updated loan after conversion
|
|
#Gap, Warranty, Mbp insurance on an updated loan will come in false on conversion loans
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/10/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | True | False | True | 3434 | 324324324324324 | 2123444 | 1DODGE1234DAKOTA5 | DODGE | DAKOTA | 2009 | 97997 | | 1553 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Term |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | 793.9133223793564 | | New | True | False | True | False | True | 2123444 | 3/4/2021 | | 51 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/10/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 639.50631986723679138365336850 | -154.40 | True | False | True | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1DODGE1234DAKOTA5 | 1 | DODGE | DAKOTA | 2009 | 97997 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - only term in days on loan is updated and saved, Reserve is recalculated, ReserveExportedDate becomes NULL, vehicle is updated, updated after conversion
|
|
#Gap, Warranty, Mbp insurance on an updated loan will come in false on conversion loans
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | False | False | True | False | True | 3434 | 324324324324324 | 2123444 | 1DODGE1234DAKOTA5 | DODGE | DAKOTA | 2009 | 97997 | | 1653 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Term |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | 793.9133223793564 | | New | False | False | True | False | True | 2123444 | 3/4/2021 | | 51 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Term | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 54 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 677.86846015764668312435076825 | -116.04 | False | False | True | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1DODGE1234DAKOTA5 | 1 | DODGE | DAKOTA | 2009 | 97997 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - buy rate and contract rate on loan is updated, Reserve is calculated at Zero, Adjustment is saved as negative, ReserveExportedDate becomes NULL, vehicle is updated
|
|
#Gap, Warranty, Mbp insurance on an updated loan will come in false on conversion loans
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.00 | 1.75 | False | False | False | False | True | 3434 | 324324324324324 | 2123444 | 1DODGE1234DAKOTA5 | DODGE | DAKOTA | 2009 | 97997 | | 1553 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Term |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | 793.9133223793564 | | New | True | False | True | False | True | 2123444 | 3/4/2021 | | 51 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.00 | 1.75 | Updated | 0 | -793.91 | True | False | True | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1DODGE1234DAKOTA5 | 1 | DODGE | DAKOTA | 2009 | 97997 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - Amount on loan is updated, reserve amount changed positive Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/06/2026 | 7494.61 | 3.75 | 4.39 | False | False | False | True | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 6494.61 | 3.75 | 4.39 | New | 88.93436782692176 | | True | True | False | False | True | 2123444 | 03/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color | VehicleId |
|
|
| | 1 | | | 0 | 0 | | 1 |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/06/2026 | 7494.61 | 3.75 | 4.39 | Updated | 102.62793338773629744790336800 | 13.70 | True | True | False | True | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - Amount on loan is updated, skip export, Gap, Warranty, Mbp insurance on an updated loan will come in false on conversion loans
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/06/2026 | 7494.61 | 3.75 | 4.39 | False | False | False | True | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 6494.61 | 3.75 | 4.39 | New | 88.93436782692176 | | True | True | False | False | True | 2123444 | 03/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color | VehicleId |
|
|
| | 1 | | | 0 | 0 | | 1 |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import at "3/5/2021 5:00:00 AM" and skip the export
|
|
Then the import looks like
|
|
| StartDate | RecordCount | RecordsSaved | Success | Filename | Import Type |
|
|
| 3/5/2021 5:00:00 AM | 1 | 1 | true | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/06/2026 | 7494.61 | 3.75 | 4.39 | Updated | 102.62793338773629744790336800 | 13.70 | True | True | False | True | True | 2123444 |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is not called
|
|
And MarkReservesAsExportedAsync is called
|
|
|
|
Scenario: Update From DNA - buy rate and contract rate on loan are the same, reserve amount did not change, Adjustment is zero and not saved, ReserveExportedDate does not change
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/06/2026 | 56494.61 | 4.8 | 6.8 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 56494.61 | 4.8 | 6.8 | New | 2483.9795673591888888559725690 | | True | False | False | True | True | 2123444 | 03/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/06/2026 | 56494.61 | 4.8 | 6.8 | Updated | 2483.9795673591888888559725690 | | True | False | False | False | True | 2123444 | 03/4/2021 | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate on loan is updated, a positive Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 4.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | 793.9136070432343 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 4.39 | Updated | 1388.9291450596866411776963565 | 595.02 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - Loan Type on loan is updated, a positive Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | BB | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 56494.61 | 2.03 | 4.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 56494.61 | 2.03 | 4.39 | 2813.495481554908 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | BB | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 56494.61 | 2.03 | 4.39 | Updated | 3751.327308739877395505521437 | 937.83 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - Loan Date on loan is updated, the difference in reserve is nothing after rounding, no adjustment is saved, ReserveExportedDate does not change.
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 02/28/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 56494.61 | 2.03 | 4.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 56494.61 | 2.03 | 4.39 | 2813.495481554908 | | New | True | False | False | False | True | 2123444 | 03/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/28/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 56494.61 | 2.03 | 4.39 | Updated | 2813.4954815549080466291410778 | | True | False | False | False | True | 2123444 | 03/4/2021 | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - Loan Date on loan is updated, difference in reserve after rounding, adjustment is saved, ReserveExportedDate is called.
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 02/28/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 56494.61 | 2.03 | 4.40 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 56494.61 | 2.03 | 4.39 | 2813.495481554908 | | New | True | False | False | False | True | 2123444 | 03/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/28/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 56494.61 | 2.03 | 4.40 | Updated | 2825.6457912806237971046561640 | 12.15 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - First Payment Date and Final payment is updated on loan, one loan has ten thousandth decimal place difference in buy rate, and same with contract rate, round up
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 02/10/2021 | 02/03/2021 | 03/13/2021 | 05/05/2025 | 6494.61 | 3.7546 | 4.3746 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1553 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 6494.61 | 3.754 | 4.374 | 88.93436782692176 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/10/2021 | 02/03/2021 | 03/13/2021 | 05/05/2025 | 6494.61 | 3.755 | 4.375 | Updated | 69.213652690701353974372119183 | -19.72 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - First Payment Date and Final payment is updated on loan, one loan has ten thousandth decimal place difference in buy rate, and same with contract rate, round down, no change in rates
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 02/10/2021 | 02/03/2021 | 03/13/2021 | 05/05/2025 | 6494.61 | 3.7543 | 4.3743 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1553 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 6494.61 | 3.754 | 4.374 | 88.93436782692176 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/10/2021 | 02/03/2021 | 03/13/2021 | 05/05/2025 | 6494.61 | 3.754 | 4.374 | Updated | 69.212747142003089864206789735 | -19.72 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - First Payment Date and Final payment is updated on loan, a negative Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 02/10/2021 | 02/03/2021 | 03/13/2021 | 05/05/2025 | 6494.61 | 3.75 | 4.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1553 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 6494.61 | 3.75 | 4.39 | 88.93436782692176 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 02/10/2021 | 02/03/2021 | 03/13/2021 | 05/05/2025 | 6494.61 | 3.75 | 4.39 | Updated | 71.451064016423407827940133096 | -17.48 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate and buy rate Buy Down on loan is updated, a negative Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 5.03 | 2.03 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 4.03 | 2.39 | -1286.924928920238171593013688 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 5.03 | 2.03 | Updated | -2366.304727958569622108164422 | -1079.38 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate and buy rate from Buy Down to Markup on loan is updated, a positive Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 6.03 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 5.03 | 2.03 | -2366.304727958569622108164422 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 6.03 | Updated | 2385.3099543374864451605083395 | 4751.61 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate on loan is updated, a negative Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 4.03 | 2.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | 793.9136070432343 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 4.03 | 2.39 | Updated | -1286.924928920238171593013688 | -2080.83 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - larger buy down to smaller buy down, a negative Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 4.03 | 2.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 5.03 | 3.39 | -1307.753251900924 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 4.03 | 2.39 | Updated | -1286.924928920238171593013688 | 20.83 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - buy down smaller buy down to larger buy down, a negative Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 5.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 4.03 | 2.39 | -1286.924928920238171593013688 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 5.03 | 3.39 | Updated | -1307.753251900923882113670130 | -20.83 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - buy down reserve to standard reserve, a positive Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 4.03 | 3.39 | -506.2845343943843 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | 1300.19 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - standard reserve to buy down reserve, a negative Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 4.03 | 2.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | 793.9136070432343 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 4.03 | 2.39 | Updated | -1286.924928920238171593013688 | -2080.83 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - standard reserve increase, a positive Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 3.03 | 5.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 4.03 | 5.39 | 819.8207658670196 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 3.03 | 5.39 | Updated | 1411.4070557133671182781753948 | 591.59 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - flat fee reserve decrease, a negative Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 800.51 | 5.00 | 5.05 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 889.51 | 5.00 | 5.02 | 6.671325 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 800.51 | 5.00 | 5.05 | Updated | 6.003825 | -0.67 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - no reserve to standard reserve, a positive Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 889.51 | 5.00 | 5.02 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | BB | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 889.51 | 5.00 | 4.99 | 0 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 889.51 | 5.00 | 5.02 | Updated | 6.671325 | 6.67 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - standard reserve to no reserve, a negative Adjustment is saved, ReserveExportedDate becomes NULL
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | BB | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 889.51 | 5.00 | 4.99 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 889.51 | 5.00 | 5.05 | 6.003825 | | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 889.51 | 5.00 | 4.99 | Updated | 0 | -6.00 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - nothing on loan actually changed, vehicle has 17 characters, no update to dealer - no audit history added, loan status and ReserveExportedDate are unchanged
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | M88333783983AS111 | | | | | |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Reserve Amount |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | | 793.9136070432343049958707190 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M88333783983AS111 | 1 | | | 0 | 0 | |
|
|
When I process this DNA new/updated loan import 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 | 0 | 0 | true | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M88333783983AS111 | 1 | | | 0 | 0 | |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
|
|
Scenario: Update From DNA - nothing on loan actually changed except middle initial, the action required used to be true
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color |
|
|
| 3250 | 144 | MUELLER | STEVEN | R | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | M88333783983AS111 | | | | | |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Reserve Amount | Action Required |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | | 793.9136070432343049958707190 | true |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M88333783983AS111 | 1 | | | 0 | 0 | |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Action Required |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | R | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | 3/4/2021 | | false |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M88333783983AS111 | 1 | | | 0 | 0 | |
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add and Update From DNA - one new loan, one with nothing on loan actually changed, vin has 17 characters, no update to dealer - no audit history added, loan status and ReserveExportedDate are unchanged
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerCode | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | M88333783983AS111 | | | | | | 1919 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | False | True | False | True | False | 3434 | 324324324324324 | 232323455 | M233333389Y85312 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Reserve Amount | Term |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | | 793.9136070432343049958707190 | 63 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M88333783983AS111 | 1 | | | 0 | 0 | |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3434 | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 819.2332826134477373747357048 | False | True | False | True | False | 232323455 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M88333783983AS111 | 1 | | | 0 | 0 | |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add and Update From DNA - one new boat loan, and an updated vehicle loan
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerCode | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays | AccountType |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | M88333783983AS111 | | | | | | 1919 | DL08 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | False | True | False | True | False | 3434 | 324324324324324 | 232323455 | M233333389Y85312 | Honda | Civic | 2020 | 1900 | Black | 1447 | DL10 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Reserve Amount | Term |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | | 793.9136070432343049958707190 | 63 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M88333783983AS111 | 1 | | | 0 | 0 | |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3434 | 1/23/2021 | 1/30/2021 | 2/15/2021 | 1/15/2025 | 25000 | 4.39 | 6.39 | New | 1500.00 | False | True | False | True | False | 232323455 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M88333783983AS111 | 1 | | | 0 | 0 | |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - only non-reserve fields on loan changed, no vehicle update, no update to dealer - audit history is added, ReserveExportedDate is unchanged
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | LoanType | DealerCode | DealerName | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color |
|
|
| 3250 | 144 | SMITH | STEVEN | C | NC | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Reserve Amount |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | | 793.9136070432343049958707190 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | SMITH | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - only non-reserve fields on loan changed, adjustment from a previous change is still there
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color |
|
|
| 3250 | 144 | SMITH | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Reserve Amount | Adjustment |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | | 793.9136070432343049958707190 | 133.55 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Adjustment |
|
|
| 1 | 1 | 3250 | 144 | SMITH | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | 3/4/2021 | | 133.55 |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate on loan is updated, no vehicle update, update to dealer is not ignored
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 2.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate on Boat loan is updated, no vehicle update, update to dealer is not ignored
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays | AccountType |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S47 | SKIPPER BUDS SEQUOIT HARBOR | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 6662 | 19617804574 | 2123444 | | | | | | | 1919 | DL11 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Adjustment | ReserveAmount | AccountType |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 6662 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 2.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | | | 278.8951 | DL11 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S47 | SKIPPER BUDS SEQUOIT HARBOR | 6662 | |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S47 | SKIPPER BUDS SEQUOIT HARBOR | 6662 | 19617804574 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 6662 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 1115.5804 | 836.68 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - only amount on Boat loan is updated and saved, Reserve is recalculated, ReserveExportedDate becomes NULL, vehicle is updated
|
|
#Gap, Warranty, Mbp insurance on an updated loan will come in false on conversion loans
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays | AccountType |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 20889.51 | 2.03 | 3.39 | False | False | False | False | True | 3434 | 324324324324324 | 2123444 | 1DODGE1234DAKOTA5 | DODGE | DAKOTA | 2009 | 97997 | | 1553 | DL11 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Reserve Amount | Adjustment | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Term | AccountType |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | 793.9133223793564 | | New | True | False | True | False | True | 2123444 | 3/4/2021 | | 51 | DL11 |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Adjustment | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 20889.51 | 2.03 | 3.39 | Updated | 835.5804 | 41.67 | True | False | True | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| 1DODGE1234DAKOTA5 | 1 | DODGE | DAKOTA | 2009 | 97997 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate on loan is updated, no vehicle update, dealer with null org number is added as a blank
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | | | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | <null> | | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 2.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| | | | |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate on loan is updated, no vehicle update, update to dealer is not ignored, Action Required on Dealer Org
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 2.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | | |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Action Required |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | true |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate on loan is updated, no vehicle update, update to dealer is not ignored, Action Required on Dealer Account Number
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | | 2123444 | | | | | | | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 2.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | Action Required |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | | true |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate on loan is updated, vehicle update, no dealer update, VIN less than 17 characters
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | M233333389Y85312 | Honda | Civic | 2020 | 1900 | Black | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 2.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M233333389Y85312 | 1 | Honda | Civic | 2020 | 1900 | Black |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate on loan is updated, vehicle update, dealer does not exist, write dealer record, VIN less than 17 characters
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | Dealer Name | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S777 | SHEBOYGAN HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | M233333389Y85312 | Honda | Civic | 2020 | 1900 | Black | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Dealer Name | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 1434 | SHEBOYGAN HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 2.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 1434 | 924324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 1434 | 924324324324324 |
|
|
| S777 | SHEBOYGAN HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M233333389Y85312 | 1 | Honda | Civic | 2020 | 1900 | Black |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - contract rate on loan is updated, vehicle update, update dealer record, VIN less than 17 characters
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S777 | SHEBOYGAN HARLEY DAVIDSON LLC | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | M233333389Y85312 | Honda | Civic | 2020 | 1900 | Black | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Dealer Name | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | SHEBOYGAN HARLEY DAVIDSON | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 2.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 1434 | 924324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 1434 | 924324324324324 |
|
|
| S777 | SHEBOYGAN HARLEY DAVIDSON LLC | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 3.39 | Updated | 793.9136070432343049958707190 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M233333389Y85312 | 1 | Honda | Civic | 2020 | 1900 | Black |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Add From DNA - Add all fields except Buy Rate and PostedDate are missing, vehicles added, missing VIN action required for one vehicle, VIN length over 17 chars OK.
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerCode | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | | 03/05/2021 | 05/05/2026 | 27889.51 | 0 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | | | | | | | 1919 |
|
|
| 12021 | 143 | HAYDEN | ALEXANDER | W | H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | NC | 1/23/2021 | | 2/15/2021 | 1/15/2025 | 25000 | 0 | 6.39 | False | True | False | True | False | 3488 | 9888447543454544 | 232323455 | M233333389Y853128921 | Honda | Civic | 2020 | 1900 | Black | 1447 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | LoanTypeId | DealerOrganizationNumber | Loan Date | Buy Rate | Contract Rate | LoanStatus | ExportedReserveDate | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 9888447543454544 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 3488 | 9888447543454544 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 12:00:00 AM | 2/10/2021 12:00:00 AM | 03/05/2021 12:00:00 AM | 05/05/2026 12:00:00 AM | 27889.51 | 0 | 3.39 | New | 1946.0007321277132119237549908 | True | False | False | False | True | 2123444 | | | true |
|
|
| 1 | 2 | 12021 | 143 | HAYDEN | ALEXANDER | W | 3488 | NC | 1/23/2021 12:00:00 AM | 1/23/2021 12:00:00 AM | 2/15/2021 12:00:00 AM | 1/15/2025 12:00:00 AM | 25000 | 0 | 6.39 | New | 2547.8270112271161397638921532 | False | True | False | True | False | 232323455 | | | false |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And the vehicle for LoanId 2 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M233333389Y853128921 | 2 | Honda | Civic | 2020 | 1900 | Black |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: Update From DNA - where PostedDate is null and Buy Rate is 0 loan is for now updated with that, vehicle update, no dealer update
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | DealerName | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color | OriginalTermInDays |
|
|
| 3250 | 144 | MUELLER | STEVEN | C | S7 | SUBURBAN MOTORS HARLEY DAVIDSON | NC | 2/10/2021 | | 03/05/2021 | 05/05/2026 | 27889.51 | 0 | 3.39 | True | False | False | False | True | 3434 | 324324324324324 | 2123444 | M233333389Y85312 | Honda | Civic | 2020 | 1900 | Black | 1919 |
|
|
And a loan table consisting of
|
|
| LoanId | ImportId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | LoanStatus | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | NC | 2/10/2021 | 02/03/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 2.03 | 2.39 | New | True | False | False | False | True | 2123444 | 3/4/2021 | |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
When I process this DNA new/updated loan import 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 | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the dealers now look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | 324324324324324 |
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate |
|
|
| 1 | 1 | 3250 | 144 | MUELLER | STEVEN | C | 3434 | 2/10/2021 | 2/10/2021 | 03/05/2021 | 05/05/2026 | 27889.51 | 0 | 3.39 | Updated | 1946.0007321277132119237549908 | True | False | False | False | True | 2123444 | | |
|
|
And the vehicle for LoanId 1 looks like this
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| M233333389Y85312 | 1 | Honda | Civic | 2020 | 1900 | Black |
|
|
And there is a record added to the Audit History table
|
|
And ExportReservesAsync is called
|
|
|
|
Scenario: No loans from DNA - no exception
|
|
Given an import from DNA that contains
|
|
| Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | Dealer Code | LoanType | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Gap | Warranty | Mbp | CreditLife | CreditDisability | DealerOrganizationNumber | DealerAccountNumber | ApplicationId | VIN | Make | Model | Year | Mileage | Color |
|
|
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 | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId |
|
|
And the current vehicle for loanId 1 is
|
|
| VIN Number | LoanId | Make | Model | Year | Mileage | Color |
|
|
| | 1 | | | 0 | 0 | |
|
|
And dealers that look like
|
|
| Dealer Code | Name | DealerOrganizationNumber | DealerAccountNumber |
|
|
| S7 | SUBURBAN MOTORS HARLEY DAVIDSON | 3434 | |
|
|
| H21 | HEISER CHEVROLET CADILLAC OF WEST BEND | 4545 | |
|
|
When I process this DNA new/updated loan import 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 | 0 | 0 | true | | Active |
|
|
And the import has an end date that is greater or equal to the start date
|
|
And the loans now look like
|
|
| ImportId | LoanId | Member Number | Loan Number | Member Last Name | Member First Name | Member Initial | DealerOrganizationNumber | LoanTypeId | Loan Date | PostedDate | FirstPmtDate | FinalPmtDate | LoanAmount | Buy Rate | Contract Rate | Loan Status | Reserve Amount | Gap | Warranty | Mbp | CreditLife | CreditDisability | ApplicationId | ExportedReserveDate | ExportedChargebackDate | ActionRequired |
|
|
And no audit history record is added
|
|
And ExportReservesAsync is called |