ADD SAMPLE DATA TO TRANSACTIONS TABLE

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 5250000000012016053101, 525000000001, 5259876, ‘2016-05-31’, 11.25, 10000.00, ‘USD’, ‘O’, ‘C’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 5250000000012016063001, 525000000001, 5257654, ‘2016-06-30’, 10.25, 5000.00, ‘USD’, ‘C’, ‘Q’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 5250000000022016053101, 525000000002, 5259876, ‘2016-05-31’, 11.25, 1000.00, ‘USD’, ‘C’, ‘D’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 5250000000042016053101, 525000000004, 5258765, ‘2016-05-31’, 11.25, 7000.00, ‘USD’, ‘D’, ‘Q’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 5250000000062016063001, 525000000006, 5259876, ‘2016-06-30’, 5.37, 7000.00, ‘CND’, ‘T’, ‘Q’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 5250000000072016063001, 525000000007, 5258765, ‘2016-06-30’, 5.37, 4500.00, ‘CND’, ‘R’, ‘C’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 5250000000082016063001, 525000000008, 5257654, ‘2016-06-30’, 5.37, 9999.00, ‘CND’, ‘D’, ‘O’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 5250000000092016063001, 525000000009, 5256543, ‘2016-06-30’, 10.25, 9999.00, ‘USD’, ‘O’, ‘O’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 7880000000012016053101, 788000000001, 7885432, ‘2016-05-31’, 11.25, 4870.00, ‘USD’, ‘D’, ‘Q’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 7880000000012016063001, 788000000001, 7885432, ‘2016-06-30’, 10.25, 3000.00, ‘USD’, ‘D’, ‘Q’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 7880000000012016063002, 788000000001, 7885432, ‘2016-06-30’, 5.37, 3000.00, ‘USD’, ‘O’, ‘C’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 7880000000022016053101, 788000000002, 7885432, ‘2016-05-31’, 6.11, 5500.00, ‘CND’, ‘D’, ‘Q’);

INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, “DATE”, EXCHANGERATE, MONEYAMOUNT, CURRENCYTYPE, PAYMENTMETHOD, DELIVERYMETHOD)

VALUES ( 7880000000022016053102, 788000000002, 7885432, ‘2016-05-31’, 11.25, 5500.00, ‘USD’, ‘D’, ‘Q’);