-- DML BEGIN
-- __efmigrationshistory
-- accounttype
-- dailyfundinhouse
-- daydim
-- leasefundfact
-- leasefundfactarchive
-- opportunity
-- retailfundfact
-- retailfundfactarchive
-- vehiclecollatdim

-- INSERT ORDER: __efmigrationshistory, accounttype, vehiclecollatdim, daydim, opportunity, dailyfundinhouse, leasefundfact, leasefundfactarchive, retailfundfact, retailfundfactarchive

-- TABLE __efmigrationshistory START (>= 10 rows)
INSERT INTO __efmigrationshistory (migrationid, productversion) VALUES
('20240101000000_InitialCreate', '8.0.1'),
('20240215103000_AddFundingFacts', '8.0.1'),
('20240310081545_AddVehicleDimensions', '8.0.2'),
('20240405142010_OptimizedIndexes', '8.0.2'),
('20240512090000_LeaseArchiving', '8.0.3'),
('20240620164530_OpportunityStatusUpdates', '8.0.3'),
('20240715111111_DayDimExtensions', '8.0.4'),
('20240801120000_RetailFactExtensions', '8.0.4'),
('20240905153022_DpaEligibility', '8.0.5'),
('20241010101010_FinalV1', '8.0.5');
-- TABLE __efmigrationshistory END

-- TABLE accounttype START (>= 10 rows)
INSERT INTO accounttype (accounttypekey, accounttypecode, accounttypep1, accounttypep1_2, accounttypep2, accounttypep3_4, shortname, shortername, description, recordinserttimestamp) VALUES
(1, 'RETAIL', '01', 'A1', 'R1', 'Z1', 'Retail Finance', 'RET', 'Standard retail auto loan', '2026-02-03 14:00:00'),
(2, 'LEASE', '02', 'B2', 'L1', 'Z2', 'Consumer Lease', 'LSE', 'Standard consumer vehicle lease', '2026-02-03 14:00:00'),
(3, 'COMM', '03', 'C3', 'C1', 'Z3', 'Commercial Loan', 'COM', 'Commercial vehicle financing', '2026-02-03 14:00:00'),
(4, 'BALLOON', '04', 'D4', 'B1', 'Z4', 'Balloon Finance', 'BAL', 'Retail loan with balloon payment', '2026-02-03 14:00:00'),
(5, 'DEMO', '05', 'E5', 'D1', 'Z5', 'Dealer Demo', 'DEM', 'Dealer demonstration vehicle loan', '2026-02-03 14:00:00'),
(6, 'USED', '06', 'F6', 'U1', 'Z6', 'Used Retail', 'USD', 'Used vehicle retail contract', '2026-02-03 14:00:00'),
(7, 'FLEET', '07', 'G7', 'F1', 'Z7', 'Fleet Account', 'FLT', 'Fleet management financing', '2026-02-03 14:00:00'),
(8, 'DIRECT', '08', 'H8', 'I1', 'Z8', 'Direct Loan', 'DIR', 'Direct to consumer auto loan', '2026-02-03 14:00:00'),
(9, 'SUBVENT', '09', 'I9', 'S1', 'Z9', 'Subvented Rate', 'SUB', 'Manufacturer subvented financing', '2026-02-03 14:00:00'),
(10, 'PROMO', '10', 'J0', 'P1', 'Z0', 'Promotional', 'PRM', 'Special promotional finance offer', '2026-02-03 14:00:00');
-- TABLE accounttype END

-- TABLE vehiclecollatdim START (>= 10 rows)
INSERT INTO vehiclecollatdim (vehiclecollatkey, collatmodelname, recordinserttimestamp) VALUES
(101, 'Chevrolet Silverado 1500', '2026-02-03 14:00:00'),
(102, 'Chevrolet Equinox', '2026-02-03 14:00:00'),
(103, 'GMC Sierra 2500HD', '2026-02-03 14:00:00'),
(104, 'Cadillac Escalade', '2026-02-03 14:00:00'),
(105, 'Chevrolet Blazer', '2026-02-03 14:00:00'),
(106, 'Buick Enclave', '2026-02-03 14:00:00'),
(107, 'Chevrolet Tahoe', '2026-02-03 14:00:00'),
(108, 'GMC Yukon XL', '2026-02-03 14:00:00'),
(109, 'Chevrolet Colorado', '2026-02-03 14:00:00'),
(110, 'Cadillac CT5', '2026-02-03 14:00:00');
-- TABLE vehiclecollatdim END

-- TABLE daydim START (>= 10 rows)
INSERT INTO daydim (daykey, thirteenmonthindicator, calendaryear, canadaapplicationdayindicator, canadabusinessdayindicator, canadafundingdayindicator, canadaholidayindicator, creditcenterholidayindicator, daydimdate, endofmonthindicator, endofquarterindicator, fivemonthpluscurrentindicator, gappeddayindicator, gmsales13monthindicator, gmsalessixmonthindicator, gmsalesmonthyeardescription, gmsalesyearquartercode, monthabbreviation, monthyeardescription, monthyearshortdescription, monthlyreserveindicator, threemonthpluscurrentindicator, usaapplndayindicator, usabusinessdayindicator, usafundingdayindicator, usaholidayindicator, weekdayindicator, weekdayname, yearmonthcode, yearmonthdescription, yearquarterdescription, recordinserttimestamp) VALUES
(20260201, 'N', 2026, 'N', 'N', 'N', 'N', 'N', '2026-02-01', 'N', 'N', 'Y', 'N', 'N', 'Y', 'Feb 2026', 20261, 'Feb', 'February 2026', 'Feb 2026', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'Sunday', '202602', 'February 2026', '2026 Q1', '2026-02-03 14:00:00'),
(20260202, 'N', 2026, 'Y', 'Y', 'Y', 'N', 'N', '2026-02-02', 'N', 'N', 'Y', 'N', 'N', 'Y', 'Feb 2026', 20261, 'Feb', 'February 2026', 'Feb 2026', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Monday', '202602', 'February 2026', '2026 Q1', '2026-02-03 14:00:00'),
(20260203, 'N', 2026, 'Y', 'Y', 'Y', 'N', 'N', '2026-02-03', 'N', 'N', 'Y', 'N', 'N', 'Y', 'Feb 2026', 20261, 'Feb', 'February 2026', 'Feb 2026', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Tuesday', '202602', 'February 2026', '2026 Q1', '2026-02-03 14:00:00'),
(20260204, 'N', 2026, 'Y', 'Y', 'Y', 'N', 'N', '2026-02-04', 'N', 'N', 'Y', 'N', 'N', 'Y', 'Feb 2026', 20261, 'Feb', 'February 2026', 'Feb 2026', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Wednesday', '202602', 'February 2026', '2026 Q1', '2026-02-03 14:00:00'),
(20260205, 'N', 2026, 'Y', 'Y', 'Y', 'N', 'N', '2026-02-05', 'N', 'N', 'Y', 'N', 'N', 'Y', 'Feb 2026', 20261, 'Feb', 'February 2026', 'Feb 2026', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Thursday', '202602', 'February 2026', '2026 Q1', '2026-02-03 14:00:00'),
(20260206, 'N', 2026, 'Y', 'Y', 'Y', 'N', 'N', '2026-02-06', 'N', 'N', 'Y', 'N', 'N', 'Y', 'Feb 2026', 20261, 'Feb', 'February 2026', 'Feb 2026', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Friday', '202602', 'February 2026', '2026 Q1', '2026-02-03 14:00:00'),
(20260207, 'N', 2026, 'N', 'N', 'N', 'N', 'N', '2026-02-07', 'N', 'N', 'Y', 'N', 'N', 'Y', 'Feb 2026', 20261, 'Feb', 'February 2026', 'Feb 2026', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'Saturday', '202602', 'February 2026', '2026 Q1', '2026-02-03 14:00:00'),
(20260208, 'N', 2026, 'N', 'N', 'N', 'N', 'N', '2026-02-08', 'N', 'N', 'Y', 'N', 'N', 'Y', 'Feb 2026', 20261, 'Feb', 'February 2026', 'Feb 2026', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'Sunday', '202602', 'February 2026', '2026 Q1', '2026-02-03 14:00:00'),
(20260209, 'N', 2026, 'Y', 'Y', 'Y', 'N', 'N', '2026-02-09', 'N', 'N', 'Y', 'N', 'N', 'Y', 'Feb 2026', 20261, 'Feb', 'February 2026', 'Feb 2026', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Monday', '202602', 'February 2026', '2026 Q1', '2026-02-03 14:00:00'),
(20260210, 'N', 2026, 'Y', 'Y', 'Y', 'N', 'N', '2026-02-10', 'N', 'N', 'Y', 'N', 'N', 'Y', 'Feb 2026', 20261, 'Feb', 'February 2026', 'Feb 2026', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Tuesday', '202602', 'February 2026', '2026 Q1', '2026-02-03 14:00:00');
-- TABLE daydim END

-- TABLE opportunity START (>= 10 rows)
INSERT INTO opportunity (opportunityid, applicationnumber, loanadminstatus, loanadmindate, createdate, lastmodifydate, recordinserttimestamp) VALUES
('OPP000000000000001', 'APP1000001', 'Approved', '2026-02-02 10:00:00', '2026-02-01 09:00:00', '2026-02-02 10:00:00', '2026-02-03 14:00:00'),
('OPP000000000000002', 'APP1000002', 'Approved', '2026-02-02 11:00:00', '2026-02-01 09:15:00', '2026-02-02 11:00:00', '2026-02-03 14:00:00'),
('OPP000000000000003', 'APP1000003', 'Funded', '2026-02-02 12:00:00', '2026-02-01 09:30:00', '2026-02-03 09:00:00', '2026-02-03 14:00:00'),
('OPP000000000000004', 'APP1000004', 'Pending', NULL, '2026-02-02 09:00:00', '2026-02-02 15:00:00', '2026-02-03 14:00:00'),
('OPP000000000000005', 'APP1000005', 'Approved', '2026-02-03 08:30:00', '2026-02-02 10:00:00', '2026-02-03 08:30:00', '2026-02-03 14:00:00'),
('OPP000000000000006', 'APP1000006', 'Approved', '2026-02-03 10:00:00', '2026-02-02 11:00:00', '2026-02-03 10:00:00', '2026-02-03 14:00:00'),
('OPP000000000000007', 'APP1000007', 'Declined', NULL, '2026-02-02 12:00:00', '2026-02-02 14:00:00', '2026-02-03 14:00:00'),
('OPP000000000000008', 'APP1000008', 'Approved', '2026-02-03 11:00:00', '2026-02-02 13:00:00', '2026-02-03 11:00:00', '2026-02-03 14:00:00'),
('OPP000000000000009', 'APP1000009', 'Funded', '2026-02-03 12:00:00', '2026-02-02 14:00:00', '2026-02-03 13:30:00', '2026-02-03 14:00:00'),
('OPP000000000000010', 'APP1000010', 'Pending', NULL, '2026-02-03 09:00:00', '2026-02-03 09:00:00', '2026-02-03 14:00:00');
-- TABLE opportunity END

-- TABLE dailyfundinhouse START (>= 10 rows)
INSERT INTO dailyfundinhouse (applicationnumber, statuscode, caseid, recordtype, contractdate, casecreatedate, reportdate, recordinserttimestamp, accounttypeprodkey, collatconditioncode, customername, dealerid, econtractindicator, fincamount, gmnongm, lastupdatedate, loantype, newused, vin, vehiclecollatkey, yearmonthcode) VALUES
(1000001, 'FUNDED', 500001, 'RETAIL', '2026-02-01 10:00:00', '2026-02-01 09:00:00', '2026-02-03 00:00:00', '2026-02-03 14:00:00', 1, 'N', 'Alice Smith', 'DLR001', 1, 35000.00, 'GM', '2026-02-03 12:00:00', 'R', 'NEW', 'VIN00000000000001', 101, 202602),
(1000002, 'FUNDED', 500002, 'LEASE', '2026-02-01 11:00:00', '2026-02-01 10:00:00', '2026-02-03 00:00:00', '2026-02-03 14:00:00', 2, 'N', 'Bob Johnson', 'DLR002', 1, 42000.00, 'GM', '2026-02-03 12:00:00', 'L', 'NEW', 'VIN00000000000002', 102, 202602),
(1000003, 'PENDING', 500003, 'RETAIL', '2026-02-02 09:00:00', '2026-02-02 08:30:00', '2026-02-03 00:00:00', '2026-02-03 14:00:00', 1, 'U', 'Charlie Brown', 'DLR001', 0, 28000.00, 'NONGM', '2026-02-03 12:00:00', 'R', 'USED', 'VIN00000000000003', 103, 202602),
(1000004, 'FUNDED', 500004, 'RETAIL', '2026-02-01 14:00:00', '2026-02-01 13:00:00', '2026-02-03 00:00:00', '2026-02-03 14:00:00', 1, 'N', 'Diana Prince', 'DLR003', 1, 55000.00, 'GM', '2026-02-03 12:00:00', 'R', 'NEW', 'VIN00000000000004', 104, 202602),
(1000005, 'FUNDED', 500005, 'LEASE', '2026-02-02 10:00:00', '2026-02-02 09:30:00', '2026-02-03 00:00:00', '2026-02-03 14:00:00', 2, 'N', 'Edward Norton', 'DLR004', 1, 38000.00, 'GM', '2026-02-03 12:00:00', 'L', 'NEW', 'VIN00000000000005', 105, 202602),
(1000006, 'PENDING', 500006, 'RETAIL', '2026-02-02 15:00:00', '2026-02-02 14:00:00', '2026-02-03 00:00:00', '2026-02-03 14:00:00', 1, 'U', 'Fiona Apple', 'DLR002', 0, 22000.00, 'NONGM', '2026-02-03 12:00:00', 'R', 'USED', 'VIN00000000000006', 106, 202602),
(1000007, 'FUNDED', 500007, 'RETAIL', '2026-02-01 16:00:00', '2026-02-01 15:00:00', '2026-02-03 00:00:00', '2026-02-03 14:00:00', 4, 'N', 'George Miller', 'DLR005', 1, 47000.00, 'GM', '2026-02-03 12:00:00', 'R', 'NEW', 'VIN00000000000007', 107, 202602),
(1000008, 'FUNDED', 500008, 'LEASE', '2026-02-02 11:30:00', '2026-02-02 10:30:00', '2026-02-03 00:00:00', '2026-02-03 14:00:00', 2, 'N', 'Hannah Abbott', 'DLR001', 1, 51000.00, 'GM', '2026-02-03 12:00:00', 'L', 'NEW', 'VIN00000000000008', 108, 202602),
(1000009, 'PENDING', 500009, 'RETAIL', '2026-02-03 09:00:00', '2026-02-03 08:00:00', '2026-02-03 00:00:00', '2026-02-03 14:00:00', 6, 'U', 'Ian Wright', 'DLR003', 0, 19000.00, 'NONGM', '2026-02-03 12:00:00', 'R', 'USED', 'VIN00000000000009', 109, 202602),
(1000010, 'FUNDED', 500010, 'RETAIL', '2026-02-02 14:00:00', '2026-02-02 13:00:00', '2026-02-03 00:00:00', '2026-02-03 14:00:00', 1, 'N', 'Julia Roberts', 'DLR004', 1, 62000.00, 'GM', '2026-02-03 12:00:00', 'R', 'NEW', 'VIN00000000000010', 110, 202602);
-- TABLE dailyfundinhouse END

-- TABLE leasefundfact START (>= 10 rows)
INSERT INTO leasefundfact (accountnumber, accountkey, applicationinitialdate, applicationsourcecode, archivedate, backoutstatuscode, bankalliancecode, bankruptindicator, calcdealerpaymentmethodcode, commercialleaseindicator, contractmileqty, costcenternumber, credittiercode, customerlastname, dealeralliancecode, dealerid, dealerpaymenttypecode, employeerecordindicator, excessmilepurchaseqty, funddate, fundtiertext, fundedcredittiercode, gapinsurancetypecode, gmcreditincentive, gmsalesincentive, imagesourcecode, leaseclassdescription, mfrallowancecode, newusedcode, originalmonthtermqty, portaluserid, portfoliorecordindicator, pricingtiercode, reissuecode, reissuedate, regioncode, securepayabledepositamount, singlepaymentindicator, statecode, trimdescription, vehiclebodystylecode, vehiclelicensenumber, vehiclelicensestatecode, vehicleyear, vin, recordinserttimestamp, lastupdatedate) VALUES
(2000000000000001, 8000001, '2026-01-25 10:00:00', 'WEB', '2026-02-03', 'N', 'ALL', 'N', 'ACH', 'N', '12000', '90210', 'T1', 'Smith', 'AL1', 'DLR001', 'F', 'N', '0', '2026-02-02', 'Tier 1', 'T1', 'GP', 'Y', 'Y', 'S1', 'Consumer', 'MF1', 'N', '36', 'user01', 'Y', 'P1', 'N', 'N', 'NE', '0', 'N', 'NY', 'LTZ Crew Cab', 'PU', 'ABC-1234', 'NY', '2026', 'VIN00000000000001', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(2000000000000002, 8000002, '2026-01-26 11:00:00', 'APP', '2026-02-03', 'N', 'ALL', 'N', 'ACH', 'N', '10000', '90210', 'T2', 'Johnson', 'AL1', 'DLR002', 'F', 'N', '0', '2026-02-02', 'Tier 2', 'T2', 'GP', 'Y', 'N', 'S1', 'Consumer', 'MF1', 'N', '36', 'user02', 'Y', 'P2', 'N', 'N', 'SE', '0', 'N', 'FL', 'Premier AWD', 'SU', 'DEF-5678', 'FL', '2026', 'VIN00000000000002', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(2000000000000003, 8000003, '2026-01-27 12:00:00', 'WEB', '2026-02-03', 'N', 'ALL', 'N', 'ACH', 'N', '15000', '90211', 'T1', 'Brown', 'AL1', 'DLR003', 'F', 'N', '0', '2026-02-02', 'Tier 1', 'T1', 'GP', 'N', 'Y', 'S1', 'Consumer', 'MF1', 'N', '36', 'user03', 'Y', 'P1', 'N', 'N', 'MW', '0', 'N', 'IL', 'AT4 Crew Cab', 'PU', 'GHI-9012', 'IL', '2026', 'VIN00000000000003', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(2000000000000004, 8000004, '2026-01-28 09:00:00', 'WEB', '2026-02-03', 'N', 'ALL', 'N', 'CHK', 'N', '12000', '90211', 'T3', 'Prince', 'AL1', 'DLR004', 'F', 'N', '0', '2026-02-02', 'Tier 3', 'T3', 'GP', 'Y', 'Y', 'S1', 'Consumer', 'MF1', 'N', '48', 'user04', 'Y', 'P3', 'N', 'N', 'WE', '0', 'N', 'CA', 'Luxury 4WD', 'SU', 'JKL-3456', 'CA', '2026', 'VIN00000000000004', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(2000000000000005, 8000005, '2026-01-29 14:00:00', 'APP', '2026-02-03', 'N', 'ALL', 'N', 'ACH', 'N', '12000', '90212', 'T1', 'Norton', 'AL1', 'DLR005', 'F', 'N', '0', '2026-02-03', 'Tier 1', 'T1', 'GP', 'N', 'N', 'S1', 'Consumer', 'MF1', 'N', '36', 'user05', 'Y', 'P1', 'N', 'N', 'SW', '0', 'N', 'TX', 'RS AWD', 'SU', 'MNO-7890', 'TX', '2026', 'VIN00000000000005', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(2000000000000006, 8000006, '2026-01-30 10:00:00', 'WEB', '2026-02-03', 'N', 'ALL', 'N', 'ACH', 'N', '10000', '90212', 'T2', 'Apple', 'AL1', 'DLR001', 'F', 'N', '0', '2026-02-03', 'Tier 2', 'T2', 'GP', 'Y', 'Y', 'S1', 'Consumer', 'MF1', 'N', '36', 'user06', 'Y', 'P2', 'N', 'N', 'NE', '0', 'N', 'MA', 'Essence AWD', 'SU', 'PQR-1234', 'MA', '2026', 'VIN00000000000006', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(2000000000000007, 8000007, '2026-01-31 11:30:00', 'APP', '2026-02-03', 'N', 'ALL', 'N', 'ACH', 'N', '12000', '90213', 'T1', 'Miller', 'AL1', 'DLR002', 'F', 'N', '0', '2026-02-03', 'Tier 1', 'T1', 'GP', 'Y', 'N', 'S1', 'Consumer', 'MF1', 'N', '24', 'user07', 'Y', 'P1', 'N', 'N', 'SE', '0', 'N', 'GA', 'High Country', 'SU', 'STU-5678', 'GA', '2026', 'VIN00000000000007', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(2000000000000008, 8000008, '2026-02-01 09:00:00', 'WEB', '2026-02-03', 'N', 'ALL', 'N', 'ACH', 'N', '15000', '90213', 'T1', 'Abbott', 'AL1', 'DLR003', 'F', 'N', '0', '2026-02-03', 'Tier 1', 'T1', 'GP', 'N', 'Y', 'S1', 'Consumer', 'MF1', 'N', '36', 'user08', 'Y', 'P1', 'N', 'N', 'MW', '0', 'N', 'OH', 'Denali 4WD', 'SU', 'VWX-9012', 'OH', '2026', 'VIN00000000000008', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(2000000000000009, 8000009, '2026-02-01 15:00:00', 'APP', '2026-02-03', 'N', 'ALL', 'N', 'ACH', 'N', '12000', '90214', 'T3', 'Wright', 'AL1', 'DLR004', 'F', 'N', '0', '2026-02-03', 'Tier 3', 'T3', 'GP', 'Y', 'Y', 'S1', 'Consumer', 'MF1', 'N', '48', 'user09', 'Y', 'P3', 'N', 'N', 'WE', '0', 'N', 'WA', 'ZR2 Crew Cab', 'PU', 'YZA-3456', 'WA', '2026', 'VIN00000000000009', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(2000000000000010, 8000010, '2026-02-02 08:00:00', 'WEB', '2026-02-03', 'N', 'ALL', 'N', 'ACH', 'N', '10000', '90214', 'T1', 'Roberts', 'AL1', 'DLR005', 'F', 'N', '0', '2026-02-03', 'Tier 1', 'T1', 'GP', 'Y', 'N', 'S1', 'Consumer', 'MF1', 'N', '36', 'user10', 'Y', 'P1', 'N', 'N', 'SW', '0', 'N', 'AZ', 'V-Series', 'SD', 'BCD-7890', 'AZ', '2026', 'VIN00000000000010', '2026-02-03 14:00:00', '2026-02-03 14:00:00');
-- TABLE leasefundfact END

-- TABLE leasefundfactarchive START (>= 10 rows)
INSERT INTO leasefundfactarchive (accountnumber, accountkey, applicationinitialdate, applicationsourcecode, archivedate, backoutstatuscode, bankruptindicator, calcdealerpaymentmethodcode, commercialleaseindicator, contractmileqty, costcenternumber, credittiercode, customerlastname, dealeralliancecode, dealerid, dealerpaymenttypecode, employeerecordindicator, excessmilepurchaseqty, funddate, fundtiertext, fundedcredittiercode, gapinsurancetypecode, gmcreditincentive, gmsalesincentive, imagesourcecode, leaseclassdescription, mfrallowancecode, newusedcode, originalmonthtermqty, portaluserid, portfoliorecordindicator, pricingtiercode, reissuecode, reissuedate, regioncode, securepayabledepositamount, singlepaymentindicator, statecode, trimdescription, vehiclebodystylecode, vehiclelicensenumber, vehiclelicensestatecode, vehicleyear, vin, recordinserttimestamp, lastupdatedate) VALUES
(3000000000000001, 7000001, '2025-12-25 10:00:00', 'WEB', '2026-01-03', 'N', 'N', 'ACH', 'N', '12000', '80210', 'T1', 'Smith', 'AL1', 'DLR001', 'F', 'N', '0', '2025-12-30', 'Tier 1', 'T1', 'GP', 'Y', 'Y', 'S1', 'Consumer', 'MF1', 'N', '36', 'user01', 'Y', 'P1', 'N', 'N', 'NE', '0', 'N', 'NY', 'LTZ Crew Cab', 'PU', 'ABC-0001', 'NY', '2025', 'VIN99900000000001', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(3000000000000002, 7000002, '2025-12-26 11:00:00', 'APP', '2026-01-03', 'N', 'N', 'ACH', 'N', '10000', '80210', 'T2', 'Johnson', 'AL1', 'DLR002', 'F', 'N', '0', '2025-12-30', 'Tier 2', 'T2', 'GP', 'Y', 'N', 'S1', 'Consumer', 'MF1', 'N', '36', 'user02', 'Y', 'P2', 'N', 'N', 'SE', '0', 'N', 'FL', 'Premier AWD', 'SU', 'DEF-0002', 'FL', '2025', 'VIN99900000000002', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(3000000000000003, 7000003, '2025-12-27 12:00:00', 'WEB', '2026-01-03', 'N', 'N', 'ACH', 'N', '15000', '80211', 'T1', 'Brown', 'AL1', 'DLR003', 'F', 'N', '0', '2025-12-31', 'Tier 1', 'T1', 'GP', 'N', 'Y', 'S1', 'Consumer', 'MF1', 'N', '36', 'user03', 'Y', 'P1', 'N', 'N', 'MW', '0', 'N', 'IL', 'AT4 Crew Cab', 'PU', 'GHI-0003', 'IL', '2025', 'VIN99900000000003', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(3000000000000004, 7000004, '2025-12-28 09:00:00', 'WEB', '2026-01-03', 'N', 'N', 'CHK', 'N', '12000', '80211', 'T3', 'Prince', 'AL1', 'DLR004', 'F', 'N', '0', '2025-12-31', 'Tier 3', 'T3', 'GP', 'Y', 'Y', 'S1', 'Consumer', 'MF1', 'N', '48', 'user04', 'Y', 'P3', 'N', 'N', 'WE', '0', 'N', 'CA', 'Luxury 4WD', 'SU', 'JKL-0004', 'CA', '2025', 'VIN99900000000004', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(3000000000000005, 7000005, '2025-12-29 14:00:00', 'APP', '2026-01-03', 'N', 'N', 'ACH', 'N', '12000', '80212', 'T1', 'Norton', 'AL1', 'DLR005', 'F', 'N', '0', '2025-12-31', 'Tier 1', 'T1', 'GP', 'N', 'N', 'S1', 'Consumer', 'MF1', 'N', '36', 'user05', 'Y', 'P1', 'N', 'N', 'SW', '0', 'N', 'TX', 'RS AWD', 'SU', 'MNO-0005', 'TX', '2025', 'VIN99900000000005', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(3000000000000006, 7000006, '2025-12-30 10:00:00', 'WEB', '2026-01-03', 'N', 'N', 'ACH', 'N', '10000', '80212', 'T2', 'Apple', 'AL1', 'DLR001', 'F', 'N', '0', '2025-12-31', 'Tier 2', 'T2', 'GP', 'Y', 'Y', 'S1', 'Consumer', 'MF1', 'N', '36', 'user06', 'Y', 'P2', 'N', 'N', 'NE', '0', 'N', 'MA', 'Essence AWD', 'SU', 'PQR-0006', 'MA', '2025', 'VIN99900000000006', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(3000000000000007, 7000007, '2025-12-31 11:30:00', 'APP', '2026-01-03', 'N', 'N', 'ACH', 'N', '12000', '80213', 'T1', 'Miller', 'AL1', 'DLR002', 'F', 'N', '0', '2026-01-01', 'Tier 1', 'T1', 'GP', 'Y', 'N', 'S1', 'Consumer', 'MF1', 'N', '24', 'user07', 'Y', 'P1', 'N', 'N', 'SE', '0', 'N', 'GA', 'High Country', 'SU', 'STU-0007', 'GA', '2025', 'VIN99900000000007', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(3000000000000008, 7000008, '2026-01-01 09:00:00', 'WEB', '2026-01-03', 'N', 'N', 'ACH', 'N', '15000', '80213', 'T1', 'Abbott', 'AL1', 'DLR003', 'F', 'N', '0', '2026-01-01', 'Tier 1', 'T1', 'GP', 'N', 'Y', 'S1', 'Consumer', 'MF1', 'N', '36', 'user08', 'Y', 'P1', 'N', 'N', 'MW', '0', 'N', 'OH', 'Denali 4WD', 'SU', 'VWX-0008', 'OH', '2025', 'VIN99900000000008', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(3000000000000009, 7000009, '2026-01-01 15:00:00', 'APP', '2026-01-03', 'N', 'N', 'ACH', 'N', '12000', '80214', 'T3', 'Wright', 'AL1', 'DLR004', 'F', 'N', '0', '2026-01-01', 'Tier 3', 'T3', 'GP', 'Y', 'Y', 'S1', 'Consumer', 'MF1', 'N', '48', 'user09', 'Y', 'P3', 'N', 'N', 'WE', '0', 'N', 'WA', 'ZR2 Crew Cab', 'PU', 'YZA-0009', 'WA', '2025', 'VIN99900000000009', '2026-02-03 14:00:00', '2026-02-03 14:00:00'),
(3000000000000010, 7000010, '2026-01-02 08:00:00', 'WEB', '2026-01-03', 'N', 'N', 'ACH', 'N', '10000', '80214', 'T1', 'Roberts', 'AL1', 'DLR005', 'F', 'N', '0', '2026-01-01', 'Tier 1', 'T1', 'GP', 'Y', 'N', 'S1', 'Consumer', 'MF1', 'N', '36', 'user10', 'Y', 'P1', 'N', 'N', 'SW', '0', 'N', 'AZ', 'V-Series', 'SD', 'BCD-0010', 'AZ', '2025', 'VIN99900000000010', '2026-02-03 14:00:00', '2026-02-03 14:00:00');
-- TABLE leasefundfactarchive END

-- TABLE retailfundfact START (>= 10 rows)
INSERT INTO retailfundfact (accountnumber, applicationdealertypecode, applicationinitialdate, applicationsourcecode, archivedate, calcdealerpaymentmethodcode, carbravoindicator, cpoindicator, credittiercode, customerlastname, dealeralliancecode, dealerid, employeerecordindicator, evexcludecode, funddate, funddatekey, fundedcredittiercode, gmcreditincentive, gmsalesincentive, imagesourcecode, lastupdatedate, loantypedescription, martaccountnumber, portaluserid, portfoliorecordindicator, priceexceptionindicator, pricingtiercode, ratesheettypecode, statecode, subventindicator, tiercode, transactiontypecode, trimdescription, vehicleage, vehicleyear, vin, recordinserttimestamp) VALUES
(40000000000001, 'FRAN', '2026-01-25 10:00:00', 'WEB', '2026-02-03', 'ACH', 'N', 'N', 'T1', 'Smith', 'AL1', 'DLR001', 'N', 'NONE', '2026-02-02', 20260202, 'T1', 'Y', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MART001', 'user01', 'Y', 'N', 'P1', 'ST1', 'NY', 'N', 'T1', 'A', 'LTZ Crew Cab', '0', '2026', 'VIN10000000000001', '2026-02-03 14:00:00'),
(40000000000002, 'FRAN', '2026-01-26 11:00:00', 'APP', '2026-02-03', 'ACH', 'N', 'N', 'T2', 'Johnson', 'AL1', 'DLR002', 'N', 'NONE', '2026-02-02', 20260202, 'T2', 'Y', 'N', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MART002', 'user02', 'Y', 'N', 'P2', 'ST1', 'FL', 'N', 'T2', 'A', 'Premier AWD', '0', '2026', 'VIN10000000000002', '2026-02-03 14:00:00'),
(40000000000003, 'FRAN', '2026-01-27 12:00:00', 'WEB', '2026-02-03', 'ACH', 'N', 'N', 'T1', 'Brown', 'AL1', 'DLR003', 'N', 'NONE', '2026-02-02', 20260202, 'T1', 'N', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MART003', 'user03', 'Y', 'N', 'P1', 'ST1', 'IL', 'N', 'T1', 'A', 'AT4 Crew Cab', '0', '2026', 'VIN10000000000003', '2026-02-03 14:00:00'),
(40000000000004, 'FRAN', '2026-01-28 09:00:00', 'WEB', '2026-02-03', 'CHK', 'N', 'N', 'T3', 'Prince', 'AL1', 'DLR004', 'N', 'NONE', '2026-02-02', 20260202, 'T3', 'Y', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MART004', 'user04', 'Y', 'N', 'P3', 'ST1', 'CA', 'N', 'T3', 'A', 'Luxury 4WD', '0', '2026', 'VIN10000000000004', '2026-02-03 14:00:00'),
(40000000000005, 'FRAN', '2026-01-29 14:00:00', 'APP', '2026-02-03', 'ACH', 'N', 'N', 'T1', 'Norton', 'AL1', 'DLR005', 'N', 'NONE', '2026-02-03', 20260203, 'T1', 'N', 'N', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MART005', 'user05', 'Y', 'N', 'P1', 'ST1', 'TX', 'N', 'T1', 'A', 'RS AWD', '0', '2026', 'VIN10000000000005', '2026-02-03 14:00:00'),
(40000000000006, 'FRAN', '2026-01-30 10:00:00', 'WEB', '2026-02-03', 'ACH', 'N', 'N', 'T2', 'Apple', 'AL1', 'DLR001', 'N', 'NONE', '2026-02-03', 20260203, 'T2', 'Y', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MART006', 'user06', 'Y', 'N', 'P2', 'ST1', 'MA', 'N', 'T2', 'A', 'Essence AWD', '0', '2026', 'VIN10000000000006', '2026-02-03 14:00:00'),
(40000000000007, 'FRAN', '2026-01-31 11:30:00', 'APP', '2026-02-03', 'ACH', 'N', 'N', 'T1', 'Miller', 'AL1', 'DLR002', 'N', 'NONE', '2026-02-03', 20260203, 'T1', 'Y', 'N', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MART007', 'user07', 'Y', 'N', 'P1', 'ST1', 'GA', 'N', 'T1', 'A', 'High Country', '0', '2026', 'VIN10000000000007', '2026-02-03 14:00:00'),
(40000000000008, 'FRAN', '2026-02-01 09:00:00', 'WEB', '2026-02-03', 'ACH', 'N', 'N', 'T1', 'Abbott', 'AL1', 'DLR003', 'N', 'NONE', '2026-02-03', 20260203, 'T1', 'N', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MART008', 'user08', 'Y', 'N', 'P1', 'ST1', 'OH', 'N', 'T1', 'A', 'Denali 4WD', '0', '2026', 'VIN10000000000008', '2026-02-03 14:00:00'),
(40000000000009, 'FRAN', '2026-02-01 15:00:00', 'APP', '2026-02-03', 'ACH', 'N', 'N', 'T3', 'Wright', 'AL1', 'DLR004', 'N', 'NONE', '2026-02-03', 20260203, 'T3', 'Y', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MART009', 'user09', 'Y', 'N', 'P3', 'ST1', 'WA', 'N', 'T3', 'A', 'ZR2 Crew Cab', '0', '2026', 'VIN10000000000009', '2026-02-03 14:00:00'),
(40000000000010, 'FRAN', '2026-02-02 08:00:00', 'WEB', '2026-02-03', 'ACH', 'N', 'N', 'T1', 'Roberts', 'AL1', 'DLR005', 'N', 'NONE', '2026-02-03', 20260203, 'T1', 'Y', 'N', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MART010', 'user10', 'Y', 'N', 'P1', 'ST1', 'AZ', 'N', 'T1', 'A', 'V-Series', '0', '2026', 'VIN10000000000010', '2026-02-03 14:00:00');
-- TABLE retailfundfact END

-- TABLE retailfundfactarchive START (>= 10 rows)
INSERT INTO retailfundfactarchive (accountnumber, applicationdealertypecode, applicationinitialdate, applicationsourcecode, archivedate, calcdealerpaymentmethodcode, carbravoindicator, cpoindicator, credittiercode, customerlastname, dealeralliancecode, dealerid, employeerecordindicator, evexcludecode, funddate, funddatekey, fundedcredittiercode, gmcreditincentive, gmsalesincentive, imagesourcecode, lastupdatedate, loantypedescription, martaccountnumber, portaluserid, portfoliorecordindicator, priceexceptionindicator, pricingtiercode, ratesheettypecode, statecode, subventindicator, tiercode, transactiontypecode, trimdescription, vehicleage, vehicleyear, vin, recordinserttimestamp) VALUES
(50000000000001, 'FRAN', '2025-12-25 10:00:00', 'WEB', '2026-01-03', 'ACH', 'N', 'N', 'T1', 'Smith', 'AL1', 'DLR001', 'N', 'NONE', '2025-12-30', 20251230, 'T1', 'Y', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MARTX01', 'user01', 'Y', 'N', 'P1', 'ST1', 'NY', 'N', 'T1', 'A', 'LTZ Crew Cab', '1', '2025', 'VIN20000000000001', '2026-02-03 14:00:00'),
(50000000000002, 'FRAN', '2025-12-26 11:00:00', 'APP', '2026-01-03', 'ACH', 'N', 'N', 'T2', 'Johnson', 'AL1', 'DLR002', 'N', 'NONE', '2025-12-30', 20251230, 'T2', 'Y', 'N', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MARTX02', 'user02', 'Y', 'N', 'P2', 'ST1', 'FL', 'N', 'T2', 'A', 'Premier AWD', '1', '2025', 'VIN20000000000002', '2026-02-03 14:00:00'),
(50000000000003, 'FRAN', '2025-12-27 12:00:00', 'WEB', '2026-01-03', 'ACH', 'N', 'N', 'T1', 'Brown', 'AL1', 'DLR003', 'N', 'NONE', '2025-12-31', 20251231, 'T1', 'N', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MARTX03', 'user03', 'Y', 'N', 'P1', 'ST1', 'IL', 'N', 'T1', 'A', 'AT4 Crew Cab', '1', '2025', 'VIN20000000000003', '2026-02-03 14:00:00'),
(50000000000004, 'FRAN', '2025-12-28 09:00:00', 'WEB', '2026-01-03', 'CHK', 'N', 'N', 'T3', 'Prince', 'AL1', 'DLR004', 'N', 'NONE', '2025-12-31', 20251231, 'T3', 'Y', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MARTX04', 'user04', 'Y', 'N', 'P3', 'ST1', 'CA', 'N', 'T3', 'A', 'Luxury 4WD', '1', '2025', 'VIN20000000000004', '2026-02-03 14:00:00'),
(50000000000005, 'FRAN', '2025-12-29 14:00:00', 'APP', '2026-01-03', 'ACH', 'N', 'N', 'T1', 'Norton', 'AL1', 'DLR005', 'N', 'NONE', '2025-12-31', 20251231, 'T1', 'N', 'N', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MARTX05', 'user05', 'Y', 'N', 'P1', 'ST1', 'TX', 'N', 'T1', 'A', 'RS AWD', '1', '2025', 'VIN20000000000005', '2026-02-03 14:00:00'),
(50000000000006, 'FRAN', '2025-12-30 10:00:00', 'WEB', '2026-01-03', 'ACH', 'N', 'N', 'T2', 'Apple', 'AL1', 'DLR001', 'N', 'NONE', '2025-12-31', 20251231, 'T2', 'Y', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MARTX06', 'user06', 'Y', 'N', 'P2', 'ST1', 'MA', 'N', 'T2', 'A', 'Essence AWD', '1', '2025', 'VIN20000000000006', '2026-02-03 14:00:00'),
(50000000000007, 'FRAN', '2025-12-31 11:30:00', 'APP', '2026-01-03', 'ACH', 'N', 'N', 'T1', 'Miller', 'AL1', 'DLR002', 'N', 'NONE', '2026-01-01', 20260101, 'T1', 'Y', 'N', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MARTX07', 'user07', 'Y', 'N', 'P1', 'ST1', 'GA', 'N', 'T1', 'A', 'High Country', '1', '2025', 'VIN20000000000007', '2026-02-03 14:00:00'),
(50000000000008, 'FRAN', '2026-01-01 09:00:00', 'WEB', '2026-01-03', 'ACH', 'N', 'N', 'T1', 'Abbott', 'AL1', 'DLR003', 'N', 'NONE', '2026-01-01', 20260101, 'T1', 'N', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MARTX08', 'user08', 'Y', 'N', 'P1', 'ST1', 'OH', 'N', 'T1', 'A', 'Denali 4WD', '1', '2025', 'VIN20000000000008', '2026-02-03 14:00:00'),
(50000000000009, 'FRAN', '2026-01-01 15:00:00', 'APP', '2026-01-03', 'ACH', 'N', 'N', 'T3', 'Wright', 'AL1', 'DLR004', 'N', 'NONE', '2026-01-01', 20260101, 'T3', 'Y', 'Y', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MARTX09', 'user09', 'Y', 'N', 'P3', 'ST1', 'WA', 'N', 'T3', 'A', 'ZR2 Crew Cab', '1', '2025', 'VIN20000000000009', '2026-02-03 14:00:00'),
(50000000000010, 'FRAN', '2026-01-02 08:00:00', 'WEB', '2026-01-03', 'ACH', 'N', 'N', 'T1', 'Roberts', 'AL1', 'DLR005', 'N', 'NONE', '2026-01-01', 20260101, 'T1', 'Y', 'N', 'S1', '2026-02-03 14:00:00', 'Standard Retail', 'MARTX10', 'user10', 'Y', 'N', 'P1', 'ST1', 'AZ', 'N', 'T1', 'A', 'V-Series', '1', '2025', 'VIN20000000000010', '2026-02-03 14:00:00');
-- TABLE retailfundfactarchive END

-- DML END