1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0C98CCCC-219C-C9B1-E050-D7936EBE02BF', '0C99BEF9-375F-3E4A-E050-D7936EBE2782',
TO_TIMESTAMP_TZ('2013-01-01 08:39:34.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 18000.00, 'VIR');
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0C98CCCC-219D-C9B1-E050-D7936EBE02BF', '0C99BEF9-375F-3E4A-E050-D7936EBE2782',
TO_TIMESTAMP_TZ('2013-05-02 08:47:26.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 9500.00, 'VIR');
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0C98CCCC-219F-C9B1-E050-D7936EBE02BF', '0C99BEF9-3762-3E4A-E050-D7936EBE2782',
TO_TIMESTAMP_TZ('2013-03-01 08:50:15.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 30000.00, 'VIR');
-- transactions for sales
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0DA506A8-8E2F-EF92-E050-D7936EBE4603', '0C99BEF9-375F-3E4A-E050-D7936EBE2782',
TO_TIMESTAMP_TZ('2013-05-26 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), - 26000.00,
'PURCHASE 0C98CCCC-219B-C9B1-E050-D7936EBE02BF');
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0DA506A8-8E30-EF92-E050-D7936EBE4603', '0C99BEF9-375F-3E4A-E050-D7936EBE2782',
TO_TIMESTAMP_TZ('2013-05-26 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), - 6504.00,
'CHARGES 0C98CCCC-219B-C9B1-E050-D7936EBE02BF');
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0DA506A8-8E31-EF92-E050-D7936EBE4603', '0C99BEF9-3760-3E4A-E050-D7936EBE2782',
TO_TIMESTAMP_TZ('2013-05-26 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 26000.00,
'SALE 0C98CCCC-219B-C9B1-E050-D7936EBE02BF');
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0DA506A8-8E32-EF92-E050-D7936EBE4603', '0C99BEF9-3762-3E4A-E050-D7936EBE2782',
TO_TIMESTAMP_TZ('2013-07-02 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), - 12900.00,
'PURCHASE 0C98CCCC-21A5-C9B1-E050-D7936EBE02BF');
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0DA506A8-8E33-EF92-E050-D7936EBE4603', '0C99BEF9-3762-3E4A-E050-D7936EBE2782',
TO_TIMESTAMP_TZ('2013-07-02 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), - 3229.00,
'CHARGES 0C98CCCC-21A5-C9B1-E050-D7936EBE02BF');
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0DA506A8-8E34-EF92-E050-D7936EBE4603', '0C99BEF9-375F-3E4A-E050-D7936EBE2782',
TO_TIMESTAMP_TZ('2013-07-02 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 12900.00,
'SALE 0C98CCCC-21A5-C9B1-E050-D7936EBE02BF');
|