ADD SAMPLE DATA TO CUSTOMERSFINANCIAL TABLE

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010001, 525000000001, ‘RBC’, ‘R999’, ‘S’, 999565565000000000000111);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010002, 525000000001, ‘RBC’, ‘R999’, ‘R’, 999565565000000000000112);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010003, 525000000002, ‘RBC’, ‘R999’, ‘C’, 999565565000000000000222);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010004, 525000000003, ‘TD’, ‘T2222’, ‘S’, 444565565000000000000333);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010005, 525000000004, ‘TD’, ‘T2222’, ‘S’, 444565565000000000000444);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010006, 525000000004, ‘RBC’, ‘R999’, ‘C’, 999565565000000000000445);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010007, 525000000006, ‘RBC’, ‘R999’, ‘S’, 999565565000000000000555);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010008, 525000000007, ‘RBC’, ‘R999’, ‘S’, 999565565000000000000666);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010009, 525000000008, ‘TD’, ‘T2222’, ‘S’, 444565565000000000000777);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010010, 525000000009, ‘RBC’, ‘R999’, ‘R’, 999565565000000000000888);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010011, 525000000009, ‘RBC’, ‘R999’, ‘C’, 999565565000000000000889);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010012, 525000000005, ‘RBC’, ‘R999’, ‘S’, 999565565000000000000000);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010013, 788000000001, ‘TD’, ‘T2222’, ‘S’, 444565565000000000000111);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010014, 788000000001, ‘TD’, ‘T2222’, ‘R’, 444565565000000000000112);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010015, 788000000002, ‘RBC’, ‘R999’, ‘S’, 999565565000000000000122);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010016, 788000000003, ‘RBC’, ‘R999’, ‘S’, 999565565000000000000229);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010016, 788000000003, ‘RBC’, ‘R999’, ‘C’, 999565565000000000000230);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010016, 788000000003, ‘RBC’, ‘R999’, ‘R’, 999565565000000000000231);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010016, 788000000004, ‘TD’, ‘T2222’, ‘S’, 444565565000000000000558);

 

INSERT INTO CUSTOMERSFINANCIAL (FINANCIALID, CUSTOMERID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (10010010010016, 788000000005, ‘TD’, ‘T2222’, ‘S’, 999565565000000000000887);