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', '2013-01-01 08:39:34.000000',
18000.00, 'VIR');
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0C98CCCC-219D-C9B1-E050-D7936EBE02BF', '0C99BEF9-375F-3E4A-E050-D7936EBE2782', '2013-05-02 08:47:26.000000',
9500.00, 'VIR');
INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
('0C98CCCC-219F-C9B1-E050-D7936EBE02BF', '0C99BEF9-3762-3E4A-E050-D7936EBE2782', '2013-03-01 08:50:15.000000',
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',
'2013-05-26 00:00:00.000000', - 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',
'2013-05-26 00:00:00.000000', - 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',
'2013-05-26 00:00:00.000000', 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',
'2013-07-02 00:00:00.000000', - 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',
'2013-07-02 00:00:00.000000', - 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',
'2013-07-02 00:00:00.000000', 12900.00,
'SALE 0C98CCCC-21A5-C9B1-E050-D7936EBE02BF');
|