-
Notifications
You must be signed in to change notification settings - Fork 0
/
fact_sales.sql
6550 lines (6550 loc) · 671 KB
/
fact_sales.sql
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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO43698-1','2016-07-01',346,28389,7,'SO43698',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43704-1','2016-07-02',351,11005,9,'SO43704',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43705-1','2016-07-02',344,11011,9,'SO43705',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43713-1','2016-07-05',310,27601,4,'SO43713',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43714-1','2016-07-05',311,13591,10,'SO43714',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43719-1','2016-07-06',312,27612,4,'SO43719',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43720-1','2016-07-06',311,13264,8,'SO43720',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43721-1','2016-07-06',310,13590,10,'SO43721',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43725-1','2016-07-08',311,13258,8,'SO43725',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43728-1','2016-07-09',313,27666,4,'SO43728',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO43729-1','2016-07-09',346,11238,10,'SO43729',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43730-1','2016-07-09',346,25861,4,'SO43730',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43732-1','2016-07-09',350,11025,9,'SO43732',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43733-1','2016-07-09',312,27577,1,'SO43733',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43734-1','2016-07-10',312,27604,1,'SO43734',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43736-1','2016-07-10',346,11002,9,'SO43736',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43737-1','2016-07-11',311,13261,8,'SO43737',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43743-1','2016-07-12',347,11007,9,'SO43743',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43752-1','2016-07-14',311,13265,8,'SO43752',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43757-1','2016-07-15',350,11017,9,'SO43757',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO43759-1','2016-07-16',310,13257,8,'SO43759',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43762-1','2016-07-17',314,27578,4,'SO43762',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43765-1','2016-07-17',346,11010,9,'SO43765',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43767-1','2016-07-18',350,11001,9,'SO43767',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43768-1','2016-07-19',312,27649,1,'SO43768',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43770-1','2016-07-19',312,27614,1,'SO43770',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43775-1','2016-07-19',347,11027,9,'SO43775',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43776-1','2016-07-20',314,13260,8,'SO43776',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43778-1','2016-07-20',345,11018,9,'SO43778',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43787-1','2016-07-22',344,29385,8,'SO43787',1,1,47599860,47599860,26770162,1189997,20829698);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO43788-1','2016-07-22',351,11239,10,'SO43788',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43790-1','2016-07-22',344,25857,1,'SO43790',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43793-1','2016-07-22',344,11000,9,'SO43793',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43794-1','2016-07-22',347,11029,9,'SO43794',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43804-1','2016-07-25',310,13585,10,'SO43804',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43808-1','2016-07-26',313,13259,8,'SO43808',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43810-1','2016-07-26',345,11004,9,'SO43810',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43811-1','2016-07-26',346,11026,9,'SO43811',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43813-1','2016-07-27',350,28390,7,'SO43813',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43819-1','2016-07-27',346,11006,9,'SO43819',1,1,47599860,47599860,26770162,1189997,20829698);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO43826-1','2016-07-28',348,11008,9,'SO43826',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43828-1','2016-07-29',310,27605,1,'SO43828',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43829-1','2016-07-29',310,27611,4,'SO43829',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43831-1','2016-07-29',349,11028,9,'SO43831',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43832-1','2016-07-29',310,13584,10,'SO43832',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43835-1','2016-07-30',348,19802,6,'SO43835',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43836-1','2016-07-30',324,26620,6,'SO43836',1,1,9787375,9787375,5784048,244685,4003327),
('SO43837-1','2016-07-30',350,11009,9,'SO43837',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43839-1','2016-07-31',311,27673,1,'SO43839',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43841-1','2016-07-31',314,13406,8,'SO43841',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO43919-1','2016-08-01',314,12124,7,'SO43919',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43923-1','2016-08-02',312,28018,4,'SO43923',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43924-1','2016-08-02',310,12132,7,'SO43924',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43926-1','2016-08-03',351,11055,9,'SO43926',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43933-1','2016-08-04',347,11031,9,'SO43933',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43934-1','2016-08-04',346,11034,9,'SO43934',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43941-1','2016-08-06',314,13600,10,'SO43941',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43944-1','2016-08-06',344,11054,9,'SO43944',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43948-1','2016-08-06',345,11047,9,'SO43948',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43949-1','2016-08-07',310,27726,4,'SO43949',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO43950-1','2016-08-07',311,28014,4,'SO43950',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43954-1','2016-08-08',311,13602,10,'SO43954',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43956-1','2016-08-08',344,11030,9,'SO43956',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43959-1','2016-08-09',348,11035,9,'SO43959',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43960-1','2016-08-09',349,11046,9,'SO43960',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43965-1','2016-08-10',351,11038,9,'SO43965',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43966-1','2016-08-10',347,11039,9,'SO43966',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43967-1','2016-08-11',313,28040,1,'SO43967',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43973-1','2016-08-12',312,28039,4,'SO43973',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43975-1','2016-08-12',312,13540,8,'SO43975',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO43980-1','2016-08-13',351,11048,9,'SO43980',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43983-1','2016-08-14',314,28017,1,'SO43983',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43987-1','2016-08-15',310,28042,4,'SO43987',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43988-1','2016-08-15',344,11244,10,'SO43988',1,1,47599860,47599860,26770162,1189997,20829698),
('SO43994-1','2016-08-18',314,27681,4,'SO43994',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43997-1','2016-08-18',310,28022,4,'SO43997',1,1,50095780,50095780,30398119,1252395,19697661),
('SO43998-1','2016-08-18',348,11033,9,'SO43998',1,1,47249860,47249860,26573322,1181247,20676538),
('SO43999-1','2016-08-18',311,28047,1,'SO43999',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44001-1','2016-08-19',313,28044,4,'SO44001',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44005-1','2016-08-19',334,26629,6,'SO44005',1,1,9787375,9787375,5784048,244685,4003327);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44008-1','2016-08-20',312,27678,1,'SO44008',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44009-1','2016-08-20',314,27759,1,'SO44009',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44012-1','2016-08-20',349,11052,9,'SO44012',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44014-1','2016-08-21',313,27917,4,'SO44014',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44016-1','2016-08-21',350,11247,10,'SO44016',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44021-1','2016-08-21',348,11032,9,'SO44021',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44029-1','2016-08-23',350,11050,9,'SO44029',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44030-1','2016-08-24',311,12131,7,'SO44030',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44032-1','2016-08-24',344,11243,10,'SO44032',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44040-1','2016-08-25',351,11057,9,'SO44040',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44056-1','2016-08-29',314,13559,8,'SO44056',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44058-1','2016-08-29',350,11056,9,'SO44058',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44062-1','2016-08-30',310,28041,1,'SO44062',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44063-1','2016-08-30',344,11240,10,'SO44063',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44068-1','2016-08-31',313,13541,8,'SO44068',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44073-1','2016-08-31',351,11044,9,'SO44073',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44143-1','2016-09-02',313,28145,4,'SO44143',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44148-1','2016-09-03',310,28172,4,'SO44148',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44152-1','2016-09-04',346,11334,10,'SO44152',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44153-1','2016-09-04',312,28168,4,'SO44153',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44154-1','2016-09-04',311,28181,1,'SO44154',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44159-1','2016-09-05',311,28182,4,'SO44159',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44160-1','2016-09-05',312,28186,1,'SO44160',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44162-1','2016-09-06',311,28185,4,'SO44162',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44164-1','2016-09-06',310,28088,4,'SO44164',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44169-1','2016-09-07',311,28179,1,'SO44169',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44170-1','2016-09-07',314,28183,4,'SO44170',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44171-1','2016-09-07',313,28112,4,'SO44171',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44177-1','2016-09-09',350,11337,10,'SO44177',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44178-1','2016-09-09',312,28097,4,'SO44178',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44180-1','2016-09-09',347,11058,9,'SO44180',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44190-1','2016-09-13',348,11061,9,'SO44190',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44193-1','2016-09-14',312,28164,4,'SO44193',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44197-1','2016-09-15',312,28096,4,'SO44197',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44198-1','2016-09-15',310,28150,4,'SO44198',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44203-1','2016-09-16',312,28149,4,'SO44203',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44206-1','2016-09-17',347,11250,10,'SO44206',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44207-1','2016-09-17',313,28162,4,'SO44207',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44212-1','2016-09-18',312,28170,4,'SO44212',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44215-1','2016-09-19',312,28180,1,'SO44215',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44216-1','2016-09-19',314,13560,8,'SO44216',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44217-1','2016-09-19',310,28148,1,'SO44217',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44220-1','2016-09-19',345,11060,9,'SO44220',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44224-1','2016-09-20',314,28166,4,'SO44224',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44227-1','2016-09-21',349,28401,7,'SO44227',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44228-1','2016-09-21',344,11333,10,'SO44228',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44233-1','2016-09-22',310,13841,10,'SO44233',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44234-1','2016-09-22',312,28184,4,'SO44234',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44240-1','2016-09-23',311,13580,8,'SO44240',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44242-1','2016-09-23',313,28163,1,'SO44242',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44250-1','2016-09-25',312,28167,4,'SO44250',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44254-1','2016-09-26',314,28142,1,'SO44254',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44258-1','2016-09-27',310,13579,8,'SO44258',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44259-1','2016-09-27',312,28171,1,'SO44259',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44273-1','2016-09-30',311,28147,4,'SO44273',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44321-1','2016-10-01',311,28222,1,'SO44321',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44323-1','2016-10-01',344,11072,9,'SO44323',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44325-1','2016-10-02',351,11095,9,'SO44325',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44327-1','2016-10-03',314,28598,4,'SO44327',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44330-1','2016-10-03',312,28199,4,'SO44330',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44333-1','2016-10-05',345,11343,10,'SO44333',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44337-1','2016-10-05',351,11097,9,'SO44337',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44344-1','2016-10-07',310,14427,10,'SO44344',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44345-1','2016-10-07',313,28200,4,'SO44345',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44351-1','2016-10-08',314,28271,4,'SO44351',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44355-1','2016-10-08',347,11093,9,'SO44355',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44356-1','2016-10-08',345,11099,9,'SO44356',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44359-1','2016-10-09',311,14525,10,'SO44359',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44361-1','2016-10-09',310,13686,8,'SO44361',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44364-1','2016-10-09',348,11092,9,'SO44364',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44368-1','2016-10-10',314,14150,10,'SO44368',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44374-1','2016-10-11',310,14157,10,'SO44374',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44375-1','2016-10-11',310,14183,10,'SO44375',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44379-1','2016-10-11',351,11080,9,'SO44379',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44381-1','2016-10-12',313,14191,10,'SO44381',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44382-1','2016-10-12',347,11341,10,'SO44382',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44386-1','2016-10-12',312,28587,4,'SO44386',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44387-1','2016-10-12',351,11096,9,'SO44387',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44395-1','2016-10-13',314,28339,1,'SO44395',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44400-1','2016-10-14',312,28588,4,'SO44400',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44404-1','2016-10-16',314,28221,4,'SO44404',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44406-1','2016-10-16',313,28299,4,'SO44406',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44407-1','2016-10-16',351,11077,9,'SO44407',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44408-1','2016-10-16',351,11103,9,'SO44408',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44410-1','2016-10-17',310,28223,4,'SO44410',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44411-1','2016-10-17',312,28584,4,'SO44411',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44412-1','2016-10-17',349,11100,9,'SO44412',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44413-1','2016-10-18',310,13606,8,'SO44413',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44414-1','2016-10-18',311,28340,4,'SO44414',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44415-1','2016-10-18',312,28355,4,'SO44415',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44416-1','2016-10-18',345,11069,9,'SO44416',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44421-1','2016-10-19',313,13607,8,'SO44421',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44423-1','2016-10-19',313,28586,4,'SO44423',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44426-1','2016-10-20',314,13770,8,'SO44426',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44427-1','2016-10-20',314,14146,10,'SO44427',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44428-1','2016-10-20',313,28362,4,'SO44428',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44429-1','2016-10-20',314,28583,1,'SO44429',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44433-1','2016-10-21',312,28270,1,'SO44433',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44435-1','2016-10-22',312,28573,1,'SO44435',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44436-1','2016-10-22',322,26630,6,'SO44436',1,1,9787375,9787375,5784048,244685,4003327);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44437-1','2016-10-22',344,11076,9,'SO44437',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44439-1','2016-10-23',310,14195,10,'SO44439',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44444-1','2016-10-25',311,13697,8,'SO44444',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44449-1','2016-10-27',312,28293,4,'SO44449',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44450-1','2016-10-27',310,28294,4,'SO44450',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44451-1','2016-10-27',313,28295,1,'SO44451',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44467-1','2016-10-29',346,11070,9,'SO44467',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44468-1','2016-10-29',351,11075,9,'SO44468',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44472-1','2016-10-30',312,13685,8,'SO44472',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44475-1','2016-10-30',345,11101,9,'SO44475',1,1,47599860,47599860,26770162,1189997,20829698);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44571-1','2016-11-01',347,29448,8,'SO44571',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44574-1','2016-11-01',349,11107,9,'SO44574',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44575-1','2016-11-01',344,11110,9,'SO44575',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44576-1','2016-11-01',313,28660,1,'SO44576',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44578-1','2016-11-02',314,28653,4,'SO44578',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44580-1','2016-11-03',314,13782,8,'SO44580',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44581-1','2016-11-03',348,11108,9,'SO44581',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44582-1','2016-11-03',346,11134,9,'SO44582',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44585-1','2016-11-04',312,28790,1,'SO44585',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44586-1','2016-11-04',314,28794,1,'SO44586',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44587-1','2016-11-04',311,28627,4,'SO44587',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44589-1','2016-11-04',346,11104,9,'SO44589',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44592-1','2016-11-05',314,28761,4,'SO44592',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44593-1','2016-11-05',313,28645,4,'SO44593',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44595-1','2016-11-05',345,11124,9,'SO44595',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44599-1','2016-11-06',310,28792,1,'SO44599',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44601-1','2016-11-06',345,11117,9,'SO44601',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44602-1','2016-11-07',314,14702,10,'SO44602',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44606-1','2016-11-07',313,28772,1,'SO44606',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44607-1','2016-11-07',310,28774,4,'SO44607',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44612-1','2016-11-08',311,28675,4,'SO44612',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44613-1','2016-11-08',313,28628,1,'SO44613',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44614-1','2016-11-08',312,28650,4,'SO44614',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44615-1','2016-11-08',314,28654,1,'SO44615',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44616-1','2016-11-08',314,28655,1,'SO44616',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44622-1','2016-11-09',311,13771,8,'SO44622',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44623-1','2016-11-10',312,12301,7,'SO44623',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44625-1','2016-11-10',314,28658,4,'SO44625',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44627-1','2016-11-10',349,11109,9,'SO44627',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44628-1','2016-11-10',348,11356,9,'SO44628',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44630-1','2016-11-11',312,28765,4,'SO44630',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44631-1','2016-11-11',310,28629,4,'SO44631',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44637-1','2016-11-12',311,28644,1,'SO44637',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44638-1','2016-11-12',310,28651,4,'SO44638',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44645-1','2016-11-13',344,11344,10,'SO44645',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44646-1','2016-11-13',344,29449,8,'SO44646',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44650-1','2016-11-13',351,11147,9,'SO44650',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44652-1','2016-11-14',350,28407,7,'SO44652',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44654-1','2016-11-14',313,28619,4,'SO44654',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44655-1','2016-11-14',346,11105,9,'SO44655',1,1,47599860,47599860,26770162,1189997,20829698);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44657-1','2016-11-14',350,11120,9,'SO44657',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44660-1','2016-11-15',310,28775,4,'SO44660',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44662-1','2016-11-15',349,11151,9,'SO44662',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44666-1','2016-11-16',313,28763,4,'SO44666',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44667-1','2016-11-16',310,28795,4,'SO44667',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44668-1','2016-11-16',313,28621,4,'SO44668',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44674-1','2016-11-17',314,28635,4,'SO44674',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44679-1','2016-11-18',346,11106,9,'SO44679',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44680-1','2016-11-19',312,12296,7,'SO44680',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44682-1','2016-11-19',310,28797,4,'SO44682',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44683-1','2016-11-19',312,28799,4,'SO44683',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44684-1','2016-11-19',310,28643,4,'SO44684',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44686-1','2016-11-20',313,14712,10,'SO44686',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44690-1','2016-11-20',344,11111,9,'SO44690',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44691-1','2016-11-21',346,28414,7,'SO44691',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44692-1','2016-11-21',311,28670,1,'SO44692',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44693-1','2016-11-21',311,28676,4,'SO44693',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44703-1','2016-11-24',311,12300,7,'SO44703',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44706-1','2016-11-24',311,28618,1,'SO44706',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44707-1','2016-11-24',311,28649,4,'SO44707',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44712-1','2016-11-25',348,11112,9,'SO44712',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44714-1','2016-11-26',313,28657,1,'SO44714',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44720-1','2016-11-27',311,28625,1,'SO44720',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44721-1','2016-11-27',342,26643,6,'SO44721',1,1,9787375,9787375,5784048,244685,4003327),
('SO44723-1','2016-11-28',345,29410,8,'SO44723',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44728-1','2016-11-28',344,11126,9,'SO44728',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44729-1','2016-11-29',310,12307,7,'SO44729',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44730-1','2016-11-29',311,14697,10,'SO44730',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44731-1','2016-11-29',312,28661,1,'SO44731',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44804-1','2016-12-01',310,28829,4,'SO44804',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44807-1','2016-12-01',350,11365,9,'SO44807',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44810-1','2016-12-02',311,29126,4,'SO44810',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44812-1','2016-12-02',314,28988,4,'SO44812',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44815-1','2016-12-02',351,11444,9,'SO44815',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44816-1','2016-12-03',312,12321,7,'SO44816',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44818-1','2016-12-03',313,28827,4,'SO44818',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44819-1','2016-12-03',313,28853,1,'SO44819',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44826-1','2016-12-04',314,12308,7,'SO44826',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44828-1','2016-12-04',312,28997,4,'SO44828',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44831-1','2016-12-05',350,29467,8,'SO44831',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44832-1','2016-12-05',311,28804,4,'SO44832',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44839-1','2016-12-06',314,28825,1,'SO44839',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44840-1','2016-12-06',314,28857,4,'SO44840',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44843-1','2016-12-07',312,29058,4,'SO44843',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44844-1','2016-12-07',314,29139,4,'SO44844',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44847-1','2016-12-07',346,11445,9,'SO44847',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44864-1','2016-12-08',348,11364,9,'SO44864',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44865-1','2016-12-08',351,11372,9,'SO44865',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44866-1','2016-12-08',350,11443,9,'SO44866',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44868-1','2016-12-09',313,28852,1,'SO44868',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44871-1','2016-12-09',345,11363,9,'SO44871',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44876-1','2016-12-11',312,29056,4,'SO44876',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44877-1','2016-12-11',311,29136,4,'SO44877',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44878-1','2016-12-11',311,28807,1,'SO44878',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44879-1','2016-12-11',310,28833,1,'SO44879',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44885-1','2016-12-12',310,14833,10,'SO44885',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44886-1','2016-12-12',314,29108,4,'SO44886',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44887-1','2016-12-12',310,28821,1,'SO44887',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44888-1','2016-12-12',310,28838,1,'SO44888',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44889-1','2016-12-13',348,11351,10,'SO44889',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44890-1','2016-12-13',346,11381,10,'SO44890',1,1,47599860,47599860,26770162,1189997,20829698),
('SO44893-1','2016-12-13',314,28856,1,'SO44893',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44899-1','2016-12-13',351,11353,10,'SO44899',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44900-1','2016-12-14',314,14778,10,'SO44900',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44904-1','2016-12-14',350,11359,9,'SO44904',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44905-1','2016-12-15',312,13822,8,'SO44905',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44912-1','2016-12-15',310,28966,4,'SO44912',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44918-1','2016-12-16',350,29466,8,'SO44918',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44919-1','2016-12-16',310,29017,1,'SO44919',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44924-1','2016-12-17',310,28830,1,'SO44924',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44927-1','2016-12-17',348,11448,9,'SO44927',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44928-1','2016-12-18',314,14843,10,'SO44928',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44929-1','2016-12-18',312,12398,7,'SO44929',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44930-1','2016-12-18',312,29110,4,'SO44930',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44931-1','2016-12-18',312,28849,1,'SO44931',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44934-1','2016-12-19',312,14771,10,'SO44934',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44938-1','2016-12-19',314,28851,1,'SO44938',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44939-1','2016-12-19',314,28993,1,'SO44939',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44946-1','2016-12-19',349,11357,9,'SO44946',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44947-1','2016-12-19',346,11446,9,'SO44947',1,1,47599860,47599860,26770162,1189997,20829698);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44949-1','2016-12-20',349,29474,8,'SO44949',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44950-1','2016-12-20',313,28835,4,'SO44950',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44951-1','2016-12-20',311,28843,4,'SO44951',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44954-1','2016-12-20',310,28990,4,'SO44954',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44956-1','2016-12-20',351,11449,9,'SO44956',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44961-1','2016-12-21',313,29060,4,'SO44961',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44962-1','2016-12-21',310,28831,4,'SO44962',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44970-1','2016-12-22',312,28820,1,'SO44970',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44971-1','2016-12-22',313,28989,1,'SO44971',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44972-1','2016-12-22',311,29016,1,'SO44972',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO44975-1','2016-12-23',311,28823,1,'SO44975',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44976-1','2016-12-23',311,28824,1,'SO44976',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44977-1','2016-12-23',313,29010,4,'SO44977',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44982-1','2016-12-24',312,29132,4,'SO44982',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44984-1','2016-12-24',314,29008,4,'SO44984',1,1,50095780,50095780,30398119,1252395,19697661),
('SO44993-1','2016-12-25',350,11368,9,'SO44993',1,1,47249860,47249860,26573322,1181247,20676538),
('SO44994-1','2016-12-26',311,28805,4,'SO44994',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45003-1','2016-12-27',314,29059,4,'SO45003',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45004-1','2016-12-27',314,29106,4,'SO45004',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45015-1','2016-12-28',346,11360,9,'SO45015',1,1,47599860,47599860,26770162,1189997,20829698);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45016-1','2016-12-29',310,14770,10,'SO45016',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45017-1','2016-12-29',312,28826,1,'SO45017',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45021-1','2016-12-29',348,11358,9,'SO45021',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45022-1','2016-12-29',350,11447,9,'SO45022',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45024-1','2016-12-30',344,29475,8,'SO45024',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45025-1','2016-12-30',311,29070,4,'SO45025',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45030-1','2016-12-30',348,11450,9,'SO45030',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45034-1','2016-12-31',310,28822,1,'SO45034',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45035-1','2016-12-31',310,28839,1,'SO45035',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45081-1','2017-01-01',338,26782,6,'SO45081',1,1,9787375,9787375,5784048,244685,4003327);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45082-1','2017-01-01',350,11455,9,'SO45082',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45083-1','2017-01-02',312,14947,10,'SO45083',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45084-1','2017-01-02',310,29143,4,'SO45084',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45087-1','2017-01-03',350,11388,10,'SO45087',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45088-1','2017-01-03',345,11398,10,'SO45088',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45090-1','2017-01-03',310,29170,4,'SO45090',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45095-1','2017-01-04',344,11394,10,'SO45095',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45097-1','2017-01-04',313,29151,4,'SO45097',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45103-1','2017-01-06',310,29140,1,'SO45103',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45104-1','2017-01-06',310,29142,4,'SO45104',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45108-1','2017-01-06',310,22975,6,'SO45108',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45109-1','2017-01-07',311,14937,10,'SO45109',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45113-1','2017-01-08',313,29141,4,'SO45113',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45114-1','2017-01-08',310,29146,1,'SO45114',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45120-1','2017-01-08',344,11751,9,'SO45120',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45121-1','2017-01-09',310,29169,1,'SO45121',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45123-1','2017-01-09',311,22971,6,'SO45123',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45127-1','2017-01-10',313,29158,1,'SO45127',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45129-1','2017-01-10',350,11759,9,'SO45129',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45133-1','2017-01-11',314,29163,1,'SO45133',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45138-1','2017-01-11',349,11452,9,'SO45138',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45146-1','2017-01-13',310,14950,10,'SO45146',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45149-1','2017-01-14',314,14941,10,'SO45149',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45156-1','2017-01-14',344,11465,9,'SO45156',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45157-1','2017-01-14',344,11750,9,'SO45157',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45159-1','2017-01-15',349,11400,10,'SO45159',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45164-1','2017-01-15',349,11453,9,'SO45164',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45170-1','2017-01-16',351,11462,9,'SO45170',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45171-1','2017-01-16',345,11754,9,'SO45171',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45173-1','2017-01-17',314,29157,4,'SO45173',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45174-1','2017-01-17',313,29198,4,'SO45174',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45176-1','2017-01-17',313,29254,1,'SO45176',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45178-1','2017-01-17',347,11456,9,'SO45178',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45179-1','2017-01-17',351,11457,9,'SO45179',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45181-1','2017-01-18',310,14929,10,'SO45181',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45185-1','2017-01-18',310,14949,10,'SO45185',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45189-1','2017-01-19',310,29145,1,'SO45189',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45192-1','2017-01-20',314,14846,10,'SO45192',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45198-1','2017-01-21',313,14847,10,'SO45198',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45199-1','2017-01-21',346,29476,8,'SO45199',1,1,47599860,47599860,26770162,1189997,20829698);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45200-1','2017-01-21',311,29148,4,'SO45200',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45204-1','2017-01-21',345,11460,9,'SO45204',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45207-1','2017-01-22',312,29156,4,'SO45207',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45213-1','2017-01-22',349,11464,9,'SO45213',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45215-1','2017-01-23',312,29208,1,'SO45215',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45217-1','2017-01-24',314,29144,1,'SO45217',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45220-1','2017-01-24',312,29207,1,'SO45220',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45229-1','2017-01-26',349,11387,10,'SO45229',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45233-1','2017-01-26',344,11472,9,'SO45233',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45235-1','2017-01-27',314,29147,1,'SO45235',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45238-1','2017-01-27',346,11459,9,'SO45238',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45240-1','2017-01-28',310,29155,1,'SO45240',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45244-1','2017-01-28',350,11756,9,'SO45244',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45248-1','2017-01-29',344,11451,9,'SO45248',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45249-1','2017-01-30',310,14928,10,'SO45249',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45260-1','2017-01-31',310,29150,1,'SO45260',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45264-1','2017-01-31',349,11454,9,'SO45264',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45265-1','2017-01-31',350,11461,9,'SO45265',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45346-1','2017-02-01',312,28648,6,'SO45346',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45353-1','2017-02-02',310,28630,6,'SO45353',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45355-1','2017-02-02',312,28778,6,'SO45355',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45357-1','2017-02-03',351,28443,7,'SO45357',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45359-1','2017-02-03',313,11227,4,'SO45359',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45360-1','2017-02-03',313,28036,6,'SO45360',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45364-1','2017-02-04',311,14161,8,'SO45364',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45372-1','2017-02-05',348,28449,7,'SO45372',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45376-1','2017-02-05',344,11761,9,'SO45376',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45378-1','2017-02-06',310,28178,6,'SO45378',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45379-1','2017-02-06',313,28363,6,'SO45379',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45382-1','2017-02-06',313,11129,1,'SO45382',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45384-1','2017-02-06',338,26789,6,'SO45384',1,1,9787375,9787375,5784048,244685,4003327),
('SO45387-1','2017-02-07',310,11224,1,'SO45387',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45389-1','2017-02-07',310,11090,4,'SO45389',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45392-1','2017-02-07',344,11762,9,'SO45392',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45393-1','2017-02-08',312,14171,8,'SO45393',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45394-1','2017-02-08',348,11468,10,'SO45394',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45395-1','2017-02-08',313,29352,4,'SO45395',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45400-1','2017-02-10',313,14162,8,'SO45400',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45402-1','2017-02-10',344,11413,10,'SO45402',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45404-1','2017-02-10',310,11217,1,'SO45404',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45407-1','2017-02-10',314,29285,4,'SO45407',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45408-1','2017-02-10',314,29326,4,'SO45408',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45411-1','2017-02-11',313,28197,6,'SO45411',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45413-1','2017-02-11',312,11191,4,'SO45413',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45415-1','2017-02-11',312,28092,6,'SO45415',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45416-1','2017-02-11',310,28161,6,'SO45416',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45417-1','2017-02-11',310,28620,6,'SO45417',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45422-1','2017-02-12',310,28198,6,'SO45422',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45424-1','2017-02-12',311,28165,6,'SO45424',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45426-1','2017-02-13',312,14164,8,'SO45426',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45427-1','2017-02-13',349,29481,8,'SO45427',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45428-1','2017-02-13',346,11414,10,'SO45428',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45429-1','2017-02-13',310,28129,6,'SO45429',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45430-1','2017-02-13',312,28176,6,'SO45430',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45431-1','2017-02-13',311,28013,6,'SO45431',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45434-1','2017-02-14',311,11252,4,'SO45434',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45436-1','2017-02-14',312,28130,6,'SO45436',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45437-1','2017-02-14',312,28169,6,'SO45437',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45438-1','2017-02-14',310,29334,1,'SO45438',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45441-1','2017-02-15',312,11216,1,'SO45441',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45442-1','2017-02-15',314,29335,1,'SO45442',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45443-1','2017-02-15',313,29350,4,'SO45443',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45450-1','2017-02-17',312,28624,6,'SO45450',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45455-1','2017-02-19',310,14163,8,'SO45455',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45457-1','2017-02-19',313,27752,6,'SO45457',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45461-1','2017-02-20',311,28646,6,'SO45461',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45462-1','2017-02-20',310,28647,6,'SO45462',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45463-1','2017-02-20',312,11171,4,'SO45463',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45467-1','2017-02-22',345,11422,10,'SO45467',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45470-1','2017-02-22',312,28177,6,'SO45470',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45471-1','2017-02-22',313,29280,1,'SO45471',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45477-1','2017-02-23',313,14160,8,'SO45477',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45478-1','2017-02-23',313,29354,1,'SO45478',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45485-1','2017-02-24',312,11257,4,'SO45485',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45491-1','2017-02-25',311,27672,6,'SO45491',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45496-1','2017-02-26',314,29340,6,'SO45496',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45497-1','2017-02-26',311,28354,6,'SO45497',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45498-1','2017-02-26',312,28574,6,'SO45498',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45499-1','2017-02-26',314,28626,6,'SO45499',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45500-1','2017-02-26',312,11189,1,'SO45500',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45502-1','2017-02-26',314,28173,6,'SO45502',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45508-1','2017-02-27',310,12510,7,'SO45508',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45512-1','2017-02-28',312,11175,4,'SO45512',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45514-1','2017-02-28',314,28051,6,'SO45514',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45580-1','2017-03-01',310,14428,8,'SO45580',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45581-1','2017-03-01',313,11263,1,'SO45581',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45582-1','2017-03-01',312,28656,6,'SO45582',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45583-1','2017-03-01',311,11274,1,'SO45583',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45585-1','2017-03-01',351,11905,9,'SO45585',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45587-1','2017-03-02',310,11531,4,'SO45587',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45588-1','2017-03-02',313,11275,4,'SO45588',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45592-1','2017-03-02',345,11897,9,'SO45592',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45594-1','2017-03-03',312,11282,1,'SO45594',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45595-1','2017-03-03',314,11515,4,'SO45595',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45601-1','2017-03-03',348,11893,9,'SO45601',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45602-1','2017-03-04',312,12607,7,'SO45602',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45603-1','2017-03-04',312,11296,1,'SO45603',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45604-1','2017-03-04',314,11317,1,'SO45604',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45608-1','2017-03-04',349,11896,9,'SO45608',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45609-1','2017-03-04',311,14774,8,'SO45609',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45610-1','2017-03-05',310,11303,1,'SO45610',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45611-1','2017-03-05',310,11535,1,'SO45611',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45613-1','2017-03-06',314,11522,1,'SO45613',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45621-1','2017-03-06',346,11768,9,'SO45621',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45622-1','2017-03-07',344,28470,7,'SO45622',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45624-1','2017-03-07',313,11291,4,'SO45624',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45625-1','2017-03-07',314,11307,4,'SO45625',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45626-1','2017-03-07',310,11259,1,'SO45626',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45629-1','2017-03-07',347,11892,9,'SO45629',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45630-1','2017-03-07',351,11899,9,'SO45630',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45631-1','2017-03-08',350,11237,8,'SO45631',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45636-1','2017-03-09',311,11302,1,'SO45636',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45637-1','2017-03-09',314,11525,1,'SO45637',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45644-1','2017-03-11',350,28458,7,'SO45644',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45645-1','2017-03-11',351,11482,10,'SO45645',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45646-1','2017-03-11',312,11289,4,'SO45646',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45649-1','2017-03-12',310,11319,4,'SO45649',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45650-1','2017-03-12',312,28652,6,'SO45650',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45653-1','2017-03-12',347,11764,9,'SO45653',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45654-1','2017-03-13',348,28478,7,'SO45654',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45655-1','2017-03-13',312,11323,4,'SO45655',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45657-1','2017-03-13',311,11266,1,'SO45657',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45658-1','2017-03-13',312,11270,4,'SO45658',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45662-1','2017-03-13',350,11906,9,'SO45662',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45663-1','2017-03-13',347,11901,9,'SO45663',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45664-1','2017-03-14',312,14713,8,'SO45664',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45668-1','2017-03-15',312,11298,4,'SO45668',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45669-1','2017-03-15',314,11528,4,'SO45669',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45670-1','2017-03-15',310,11541,1,'SO45670',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45676-1','2017-03-15',349,11765,9,'SO45676',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45677-1','2017-03-15',348,11895,9,'SO45677',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45678-1','2017-03-16',313,11281,4,'SO45678',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45679-1','2017-03-16',314,11540,4,'SO45679',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45684-1','2017-03-17',345,11485,10,'SO45684',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45691-1','2017-03-17',344,11898,9,'SO45691',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45695-1','2017-03-18',311,11292,4,'SO45695',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45696-1','2017-03-18',314,11326,4,'SO45696',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45697-1','2017-03-18',314,11516,4,'SO45697',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45700-1','2017-03-19',310,11278,1,'SO45700',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45701-1','2017-03-19',311,11538,4,'SO45701',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45706-1','2017-03-20',313,11267,4,'SO45706',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45707-1','2017-03-20',345,11904,9,'SO45707',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45712-1','2017-03-20',346,11767,9,'SO45712',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45714-1','2017-03-21',312,11534,4,'SO45714',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45717-1','2017-03-22',310,11325,1,'SO45717',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45718-1','2017-03-22',311,11272,4,'SO45718',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45721-1','2017-03-22',345,11766,9,'SO45721',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45722-1','2017-03-22',351,11908,9,'SO45722',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45723-1','2017-03-23',311,11290,4,'SO45723',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45724-1','2017-03-23',312,12620,7,'SO45724',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45727-1','2017-03-23',350,11909,9,'SO45727',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45730-1','2017-03-24',350,28471,7,'SO45730',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45731-1','2017-03-24',310,11286,4,'SO45731',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45732-1','2017-03-24',311,11537,4,'SO45732',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45738-1','2017-03-24',346,11900,9,'SO45738',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45739-1','2017-03-24',348,11903,9,'SO45739',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45744-1','2017-03-25',351,11894,9,'SO45744',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45747-1','2017-03-26',314,11539,4,'SO45747',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45754-1','2017-03-27',311,11529,1,'SO45754',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45755-1','2017-03-27',314,11536,4,'SO45755',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45759-1','2017-03-28',313,11295,4,'SO45759',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45760-1','2017-03-28',311,11329,4,'SO45760',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45762-1','2017-03-28',312,12621,7,'SO45762',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45765-1','2017-03-29',350,11245,8,'SO45765',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45766-1','2017-03-29',312,11297,4,'SO45766',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45767-1','2017-03-29',310,11299,4,'SO45767',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45768-1','2017-03-29',310,11324,4,'SO45768',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45769-1','2017-03-29',314,11327,4,'SO45769',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45771-1','2017-03-30',314,11271,4,'SO45771',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45774-1','2017-03-30',312,11261,4,'SO45774',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45777-1','2017-03-31',346,11907,9,'SO45777',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45832-1','2017-04-03',351,11916,9,'SO45832',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45839-1','2017-04-04',349,11915,9,'SO45839',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45840-1','2017-04-05',349,11246,8,'SO45840',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45845-1','2017-04-06',311,23566,6,'SO45845',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45857-1','2017-04-07',351,11919,9,'SO45857',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45858-1','2017-04-07',350,11952,9,'SO45858',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45859-1','2017-04-08',314,12754,7,'SO45859',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45872-1','2017-04-11',347,11249,8,'SO45872',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45877-1','2017-04-11',351,11910,9,'SO45877',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45878-1','2017-04-12',310,12750,7,'SO45878',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45889-1','2017-04-12',350,11920,9,'SO45889',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45890-1','2017-04-13',349,11338,8,'SO45890',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45891-1','2017-04-13',346,11380,8,'SO45891',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45908-1','2017-04-15',347,11918,9,'SO45908',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45909-1','2017-04-15',349,11947,9,'SO45909',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45916-1','2017-04-16',346,11964,9,'SO45916',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45917-1','2017-04-17',346,11332,8,'SO45917',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45925-1','2017-04-17',347,11942,9,'SO45925',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45946-1','2017-04-20',350,11914,9,'SO45946',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45947-1','2017-04-20',351,11943,9,'SO45947',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45951-1','2017-04-21',348,11944,9,'SO45951',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45952-1','2017-04-21',347,11969,9,'SO45952',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45966-1','2017-04-23',345,11946,9,'SO45966',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45970-1','2017-04-24',348,11963,9,'SO45970',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45971-1','2017-04-25',345,11335,8,'SO45971',1,1,47599860,47599860,26770162,1189997,20829698),
('SO45978-1','2017-04-25',350,11967,9,'SO45978',1,1,47249860,47249860,26573322,1181247,20676538),
('SO45979-1','2017-04-26',311,15630,10,'SO45979',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45980-1','2017-04-26',312,15631,10,'SO45980',1,1,50095780,50095780,30398119,1252395,19697661),
('SO45981-1','2017-04-26',310,12805,7,'SO45981',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO45991-1','2017-04-27',351,11976,9,'SO45991',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46001-1','2017-04-29',310,23806,6,'SO46001',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46008-1','2017-04-29',348,11912,9,'SO46008',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46009-1','2017-04-29',344,11917,9,'SO46009',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46010-1','2017-04-30',348,11488,10,'SO46010',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46011-1','2017-04-30',351,11489,10,'SO46011',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46022-1','2017-04-30',346,11968,9,'SO46022',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46138-1','2017-05-04',311,13405,7,'SO46138',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46139-1','2017-05-04',347,11977,9,'SO46139',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46146-1','2017-05-06',345,11421,8,'SO46146',1,1,47599860,47599860,26770162,1189997,20829698);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46154-1','2017-05-06',349,11989,9,'SO46154',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46159-1','2017-05-07',351,11996,9,'SO46159',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46160-1','2017-05-08',351,11412,8,'SO46160',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46166-1','2017-05-08',313,15657,10,'SO46166',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46167-1','2017-05-08',347,11997,9,'SO46167',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46175-1','2017-05-09',349,12003,9,'SO46175',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46176-1','2017-05-10',349,11491,10,'SO46176',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46181-1','2017-05-11',348,12004,9,'SO46181',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46183-1','2017-05-12',351,28492,7,'SO46183',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46185-1','2017-05-12',314,15632,10,'SO46185',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46190-1','2017-05-12',312,15653,10,'SO46190',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46203-1','2017-05-13',346,11999,9,'SO46203',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46204-1','2017-05-13',348,11988,9,'SO46204',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46226-1','2017-05-16',313,13263,7,'SO46226',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46227-1','2017-05-16',351,11990,9,'SO46227',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46229-1','2017-05-17',344,11395,8,'SO46229',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46230-1','2017-05-17',344,11493,10,'SO46230',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46236-1','2017-05-17',350,12001,9,'SO46236',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46249-1','2017-05-19',347,12000,9,'SO46249',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46250-1','2017-05-19',313,14940,8,'SO46250',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46251-1','2017-05-19',350,11998,9,'SO46251',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46256-1','2017-05-20',314,15652,10,'SO46256',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46264-1','2017-05-22',350,28491,7,'SO46264',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46269-1','2017-05-22',312,15638,10,'SO46269',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46285-1','2017-05-24',346,12005,9,'SO46285',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46294-1','2017-05-25',345,11986,9,'SO46294',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46304-1','2017-05-27',350,12002,9,'SO46304',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46309-1','2017-05-28',350,11994,9,'SO46309',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46395-1','2017-06-02',346,11496,10,'SO46395',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46407-1','2017-06-03',342,27026,6,'SO46407',1,1,9787375,9787375,5784048,244685,4003327);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46408-1','2017-06-03',351,12011,9,'SO46408',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46410-1','2017-06-04',348,11548,10,'SO46410',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46412-1','2017-06-04',311,24493,6,'SO46412',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46413-1','2017-06-04',346,20075,6,'SO46413',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46429-1','2017-06-07',345,11428,8,'SO46429',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46436-1','2017-06-07',347,12337,9,'SO46436',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46441-1','2017-06-08',312,15661,10,'SO46441',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46443-1','2017-06-08',314,15662,10,'SO46443',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46449-1','2017-06-09',345,12007,9,'SO46449',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46463-1','2017-06-12',348,11423,8,'SO46463',1,1,47249860,47249860,26573322,1181247,20676538);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46477-1','2017-06-13',346,12009,9,'SO46477',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46497-1','2017-06-18',310,13558,7,'SO46497',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46508-1','2017-06-19',349,28504,7,'SO46508',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46519-1','2017-06-19',310,15660,10,'SO46519',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46520-1','2017-06-19',312,24491,6,'SO46520',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46536-1','2017-06-21',311,13556,7,'SO46536',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46537-1','2017-06-22',344,11427,8,'SO46537',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46542-1','2017-06-23',347,11431,8,'SO46542',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46543-1','2017-06-23',345,11549,10,'SO46543',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46545-1','2017-06-23',310,24646,6,'SO46545',1,1,50095780,50095780,30398119,1252395,19697661);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46555-1','2017-06-23',351,12010,9,'SO46555',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46564-1','2017-06-25',347,11494,10,'SO46564',1,1,47599860,47599860,26770162,1189997,20829698),
('SO46573-1','2017-06-26',314,13555,7,'SO46573',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46575-1','2017-06-26',351,12338,9,'SO46575',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46590-1','2017-06-29',312,24501,6,'SO46590',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46596-1','2017-06-29',349,12037,9,'SO46596',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46597-1','2017-06-29',348,12039,9,'SO46597',1,1,47249860,47249860,26573322,1181247,20676538),
('SO46598-1','2017-06-30',311,15080,8,'SO46598',1,1,50095780,50095780,30398119,1252395,19697661),
('SO46681-1','2017-07-01',362,12349,9,'SO46681',1,1,28687375,28687375,15481340,717185,13206035),
('SO46682-1','2017-07-01',358,12355,9,'SO46682',1,1,28687375,28687375,15481340,717185,13206035);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46701-1','2017-07-04',375,15114,8,'SO46701',1,1,30541875,30541875,18489573,763547,12052302),
('SO46702-1','2017-07-04',369,15116,8,'SO46702',1,1,34206900,34206900,21263010,855173,12943890),
('SO46710-1','2017-07-05',356,11484,8,'SO46710',1,1,28999874,28999874,15649983,724997,13349891),
('SO46711-1','2017-07-05',369,13592,7,'SO46711',1,1,34206900,34206900,21263010,855173,12943890),
('SO46715-1','2017-07-05',375,24976,6,'SO46715',1,1,30541875,30541875,18489573,763547,12052302),
('SO46716-1','2017-07-05',375,25046,6,'SO46716',1,1,30541875,30541875,18489573,763547,12052302),
('SO46719-1','2017-07-06',362,11604,10,'SO46719',1,1,28687375,28687375,15481340,717185,13206035),
('SO46721-1','2017-07-06',370,16046,10,'SO46721',1,1,34206900,34206900,21263010,855173,12943890),
('SO46724-1','2017-07-06',368,28663,6,'SO46724',1,1,34206900,34206900,21263010,855173,12943890),
('SO46728-1','2017-07-06',358,12354,9,'SO46728',1,1,28687375,28687375,15481340,717185,13206035);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46730-1','2017-07-07',379,15100,8,'SO46730',1,1,30541875,30541875,18489573,763547,12052302),
('SO46731-1','2017-07-07',371,15101,8,'SO46731',1,1,30541875,30541875,18489573,763547,12052302),
('SO46733-1','2017-07-07',375,24781,6,'SO46733',1,1,30541875,30541875,18489573,763547,12052302),
('SO46736-1','2017-07-07',360,12341,9,'SO46736',1,1,28687375,28687375,15481340,717185,13206035),
('SO46737-1','2017-07-07',354,12346,9,'SO46737',1,1,28999874,28999874,15649983,724997,13349891),
('SO46741-1','2017-07-08',370,28766,6,'SO46741',1,1,34206900,34206900,21263010,855173,12943890),
('SO46747-1','2017-07-09',360,26127,1,'SO46747',1,1,28687375,28687375,15481340,717185,13206035),
('SO46749-1','2017-07-09',354,12350,9,'SO46749',1,1,28999874,28999874,15649983,724997,13349891),
('SO46757-1','2017-07-11',354,26174,1,'SO46757',1,1,28999874,28999874,15649983,724997,13349891),
('SO46759-1','2017-07-11',373,16033,10,'SO46759',1,1,30541875,30541875,18489573,763547,12052302);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46770-1','2017-07-12',370,15357,8,'SO46770',1,1,34206900,34206900,21263010,855173,12943890),
('SO46775-1','2017-07-12',352,26249,1,'SO46775',1,1,28999874,28999874,15649983,724997,13349891),
('SO46776-1','2017-07-12',360,12356,9,'SO46776',1,1,28687375,28687375,15481340,717185,13206035),
('SO46777-1','2017-07-13',356,11568,10,'SO46777',1,1,28999874,28999874,15649983,724997,13349891),
('SO46778-1','2017-07-13',352,11610,10,'SO46778',1,1,28999874,28999874,15649983,724997,13349891),
('SO46788-1','2017-07-13',358,12342,9,'SO46788',1,1,28687375,28687375,15481340,717185,13206035),
('SO46794-1','2017-07-14',373,24977,6,'SO46794',1,1,30541875,30541875,18489573,763547,12052302),
('SO46801-1','2017-07-15',368,25094,6,'SO46801',1,1,34206900,34206900,21263010,855173,12943890),
('SO46803-1','2017-07-16',379,13595,7,'SO46803',1,1,30541875,30541875,18489573,763547,12052302),
('SO46807-1','2017-07-16',354,12339,9,'SO46807',1,1,28999874,28999874,15649983,724997,13349891);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46808-1','2017-07-16',360,12347,9,'SO46808',1,1,28687375,28687375,15481340,717185,13206035),
('SO46815-1','2017-07-17',375,25093,6,'SO46815',1,1,30541875,30541875,18489573,763547,12052302),
('SO46820-1','2017-07-18',352,28510,7,'SO46820',1,1,28999874,28999874,15649983,724997,13349891),
('SO46821-1','2017-07-18',377,24824,6,'SO46821',1,1,30541875,30541875,18489573,763547,12052302),
('SO46829-1','2017-07-19',369,24786,6,'SO46829',1,1,34206900,34206900,21263010,855173,12943890),
('SO46833-1','2017-07-19',354,12360,9,'SO46833',1,1,28999874,28999874,15649983,724997,13349891),
('SO46835-1','2017-07-20',371,13768,7,'SO46835',1,1,30541875,30541875,18489573,763547,12052302),
('SO46836-1','2017-07-20',377,13769,7,'SO46836',1,1,30541875,30541875,18489573,763547,12052302),
('SO46839-1','2017-07-20',375,24817,6,'SO46839',1,1,30541875,30541875,18489573,763547,12052302),
('SO46844-1','2017-07-20',358,12343,9,'SO46844',1,1,28687375,28687375,15481340,717185,13206035);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46845-1','2017-07-21',358,11603,10,'SO46845',1,1,28687375,28687375,15481340,717185,13206035),
('SO46846-1','2017-07-21',373,13575,7,'SO46846',1,1,30541875,30541875,18489573,763547,12052302),
('SO46855-1','2017-07-22',379,15117,8,'SO46855',1,1,30541875,30541875,18489573,763547,12052302),
('SO46862-1','2017-07-23',362,11550,10,'SO46862',1,1,28687375,28687375,15481340,717185,13206035),
('SO46863-1','2017-07-23',362,11575,10,'SO46863',1,1,28687375,28687375,15481340,717185,13206035),
('SO46864-1','2017-07-23',373,16045,10,'SO46864',1,1,30541875,30541875,18489573,763547,12052302),
('SO46869-1','2017-07-24',379,13577,7,'SO46869',1,1,30541875,30541875,18489573,763547,12052302),
('SO46870-1','2017-07-24',368,13605,7,'SO46870',1,1,34206900,34206900,21263010,855173,12943890),
('SO46875-1','2017-07-25',362,11470,8,'SO46875',1,1,28687375,28687375,15481340,717185,13206035),
('SO46876-1','2017-07-25',375,15084,8,'SO46876',1,1,30541875,30541875,18489573,763547,12052302);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46878-1','2017-07-25',369,25061,6,'SO46878',1,1,34206900,34206900,21263010,855173,12943890),
('SO46886-1','2017-07-26',377,28669,6,'SO46886',1,1,30541875,30541875,18489573,763547,12052302),
('SO46887-1','2017-07-26',362,12340,9,'SO46887',1,1,28687375,28687375,15481340,717185,13206035),
('SO46893-1','2017-07-27',369,28659,6,'SO46893',1,1,34206900,34206900,21263010,855173,12943890),
('SO46895-1','2017-07-27',354,26183,4,'SO46895',1,1,28999874,28999874,15649983,724997,13349891),
('SO46903-1','2017-07-28',354,12353,9,'SO46903',1,1,28999874,28999874,15649983,724997,13349891),
('SO46905-1','2017-07-29',375,16053,10,'SO46905',1,1,30541875,30541875,18489573,763547,12052302),
('SO46911-1','2017-07-30',377,24832,6,'SO46911',1,1,30541875,30541875,18489573,763547,12052302),
('SO46919-1','2017-07-30',362,11481,8,'SO46919',1,1,28687375,28687375,15481340,717185,13206035),
('SO46920-1','2017-07-31',362,11609,10,'SO46920',1,1,28687375,28687375,15481340,717185,13206035);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO46927-1','2017-07-31',362,12348,9,'SO46927',1,1,28687375,28687375,15481340,717185,13206035),
('SO46928-1','2017-07-31',356,12358,9,'SO46928',1,1,28999874,28999874,15649983,724997,13349891),
('SO47075-1','2017-08-01',360,12685,9,'SO47075',1,1,28687375,28687375,15481340,717185,13206035),
('SO47091-1','2017-08-04',354,28532,7,'SO47091',1,1,28999874,28999874,15649983,724997,13349891),
('SO47092-1','2017-08-04',369,28802,6,'SO47092',1,1,34206900,34206900,21263010,855173,12943890),
('SO47095-1','2017-08-04',370,25095,6,'SO47095',1,1,34206900,34206900,21263010,855173,12943890),
('SO47098-1','2017-08-04',360,12667,9,'SO47098',1,1,28687375,28687375,15481340,717185,13206035),
('SO47100-1','2017-08-05',360,11612,10,'SO47100',1,1,28687375,28687375,15481340,717185,13206035),
('SO47106-1','2017-08-05',369,25361,6,'SO47106',1,1,34206900,34206900,21263010,855173,12943890),
('SO47109-1','2017-08-06',375,28819,6,'SO47109',1,1,30541875,30541875,18489573,763547,12052302);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47110-1','2017-08-06',370,28850,6,'SO47110',1,1,34206900,34206900,21263010,855173,12943890),
('SO47111-1','2017-08-06',369,25100,6,'SO47111',1,1,34206900,34206900,21263010,855173,12943890),
('SO47118-1','2017-08-06',362,28541,7,'SO47118',1,1,28687375,28687375,15481340,717185,13206035),
('SO47121-1','2017-08-07',375,28832,6,'SO47121',1,1,30541875,30541875,18489573,763547,12052302),
('SO47129-1','2017-08-07',352,12677,9,'SO47129',1,1,28999874,28999874,15649983,724997,13349891),
('SO47135-1','2017-08-08',343,27027,6,'SO47135',1,1,10961860,10961860,6813892,274047,4147968),
('SO47143-1','2017-08-09',362,12684,9,'SO47143',1,1,28687375,28687375,15481340,717185,13206035),
('SO47149-1','2017-08-10',360,12669,9,'SO47149',1,1,28687375,28687375,15481340,717185,13206035),
('SO47150-1','2017-08-11',370,15625,8,'SO47150',1,1,34206900,34206900,21263010,855173,12943890),
('SO47151-1','2017-08-11',370,25363,6,'SO47151',1,1,34206900,34206900,21263010,855173,12943890);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47152-1','2017-08-11',360,28547,7,'SO47152',1,1,28687375,28687375,15481340,717185,13206035),
('SO47156-1','2017-08-12',373,28837,6,'SO47156',1,1,30541875,30541875,18489573,763547,12052302),
('SO47157-1','2017-08-12',369,25864,6,'SO47157',1,1,34206900,34206900,21263010,855173,12943890),
('SO47163-1','2017-08-12',362,12671,9,'SO47163',1,1,28687375,28687375,15481340,717185,13206035),
('SO47164-1','2017-08-13',360,12123,10,'SO47164',1,1,28687375,28687375,15481340,717185,13206035),
('SO47172-1','2017-08-13',352,12668,9,'SO47172',1,1,28999874,28999874,15649983,724997,13349891),
('SO47173-1','2017-08-13',356,12675,9,'SO47173',1,1,28999874,28999874,15649983,724997,13349891),
('SO47176-1','2017-08-14',358,11492,8,'SO47176',1,1,28687375,28687375,15481340,717185,13206035),
('SO47179-1','2017-08-14',377,28848,6,'SO47179',1,1,30541875,30541875,18489573,763547,12052302),
('SO47185-1','2017-08-14',356,12133,10,'SO47185',1,1,28999874,28999874,15649983,724997,13349891);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47189-1','2017-08-15',373,28818,6,'SO47189',1,1,30541875,30541875,18489573,763547,12052302),
('SO47190-1','2017-08-15',369,25892,6,'SO47190',1,1,34206900,34206900,21263010,855173,12943890),
('SO47203-1','2017-08-17',370,25883,6,'SO47203',1,1,34206900,34206900,21263010,855173,12943890),
('SO47204-1','2017-08-17',377,25371,6,'SO47204',1,1,30541875,30541875,18489573,763547,12052302),
('SO47207-1','2017-08-17',337,27043,6,'SO47207',1,1,10961860,10961860,6813892,274047,4147968),
('SO47215-1','2017-08-18',368,28836,6,'SO47215',1,1,34206900,34206900,21263010,855173,12943890),
('SO47221-1','2017-08-19',370,13823,7,'SO47221',1,1,34206900,34206900,21263010,855173,12943890),
('SO47222-1','2017-08-19',381,26316,6,'SO47222',1,1,14006125,14006125,8479089,350153,5527036),
('SO47223-1','2017-08-19',370,25875,6,'SO47223',1,1,34206900,34206900,21263010,855173,12943890),
('SO47231-1','2017-08-19',362,11564,8,'SO47231',1,1,28687375,28687375,15481340,717185,13206035);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47232-1','2017-08-20',373,15627,8,'SO47232',1,1,30541875,30541875,18489573,763547,12052302),
('SO47237-1','2017-08-20',368,28834,6,'SO47237',1,1,34206900,34206900,21263010,855173,12943890),
('SO47242-1','2017-08-20',362,28540,7,'SO47242',1,1,28687375,28687375,15481340,717185,13206035),
('SO47252-1','2017-08-21',352,12676,9,'SO47252',1,1,28999874,28999874,15649983,724997,13349891),
('SO47253-1','2017-08-21',356,12683,9,'SO47253',1,1,28999874,28999874,15649983,724997,13349891),
('SO47255-1','2017-08-22',358,11561,8,'SO47255',1,1,28687375,28687375,15481340,717185,13206035),
('SO47267-1','2017-08-23',352,12674,9,'SO47267',1,1,28999874,28999874,15649983,724997,13349891),
('SO47269-1','2017-08-24',362,28512,7,'SO47269',1,1,28687375,28687375,15481340,717185,13206035),
('SO47270-1','2017-08-24',360,28519,7,'SO47270',1,1,28687375,28687375,15481340,717185,13206035),
('SO47272-1','2017-08-24',371,29013,6,'SO47272',1,1,30541875,30541875,18489573,763547,12052302);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47279-1','2017-08-24',362,12680,9,'SO47279',1,1,28687375,28687375,15481340,717185,13206035),
('SO47285-1','2017-08-25',373,29135,6,'SO47285',1,1,30541875,30541875,18489573,763547,12052302),
('SO47302-1','2017-08-26',360,12670,9,'SO47302',1,1,28687375,28687375,15481340,717185,13206035),
('SO47305-1','2017-08-27',369,25393,6,'SO47305',1,1,34206900,34206900,21263010,855173,12943890),
('SO47306-1','2017-08-27',369,28798,6,'SO47306',1,1,34206900,34206900,21263010,855173,12943890),
('SO47314-1','2017-08-27',362,12673,9,'SO47314',1,1,28687375,28687375,15481340,717185,13206035),
('SO47323-1','2017-08-29',362,28529,7,'SO47323',1,1,28687375,28687375,15481340,717185,13206035),
('SO47328-1','2017-08-29',360,12681,9,'SO47328',1,1,28687375,28687375,15481340,717185,13206035),
('SO47339-1','2017-08-31',371,15626,8,'SO47339',1,1,30541875,30541875,18489573,763547,12052302),
('SO47344-1','2017-08-31',354,12686,9,'SO47344',1,1,28999874,28999874,15649983,724997,13349891);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47462-1','2017-09-02',375,15926,8,'SO47462',1,1,30541875,30541875,18489573,763547,12052302),
('SO47463-1','2017-09-02',373,14203,7,'SO47463',1,1,30541875,30541875,18489573,763547,12052302),
('SO47470-1','2017-09-03',358,28685,7,'SO47470',1,1,28687375,28687375,15481340,717185,13206035),
('SO47476-1','2017-09-03',352,12693,9,'SO47476',1,1,28999874,28999874,15649983,724997,13349891),
('SO47477-1','2017-09-04',352,28560,7,'SO47477',1,1,28999874,28999874,15649983,724997,13349891),
('SO47483-1','2017-09-05',379,14424,7,'SO47483',1,1,30541875,30541875,18489573,763547,12052302),
('SO47491-1','2017-09-07',369,15932,8,'SO47491',1,1,34206900,34206900,21263010,855173,12943890),
('SO47494-1','2017-09-08',373,15927,8,'SO47494',1,1,30541875,30541875,18489573,763547,12052302),
('SO47495-1','2017-09-08',368,16196,8,'SO47495',1,1,34206900,34206900,21263010,855173,12943890),
('SO47498-1','2017-09-08',325,27071,6,'SO47498',1,1,10961860,10961860,6813892,274047,4147968);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47501-1','2017-09-08',360,12214,10,'SO47501',1,1,28687375,28687375,15481340,717185,13206035),
('SO47510-1','2017-09-09',352,12688,9,'SO47510',1,1,28999874,28999874,15649983,724997,13349891),
('SO47511-1','2017-09-10',375,14200,7,'SO47511',1,1,30541875,30541875,18489573,763547,12052302),
('SO47513-1','2017-09-10',368,15675,8,'SO47513',1,1,34206900,34206900,21263010,855173,12943890),
('SO47514-1','2017-09-10',377,15684,8,'SO47514',1,1,30541875,30541875,18489573,763547,12052302),
('SO47526-1','2017-09-11',354,12215,10,'SO47526',1,1,28999874,28999874,15649983,724997,13349891),
('SO47527-1','2017-09-11',360,28559,7,'SO47527',1,1,28687375,28687375,15481340,717185,13206035),
('SO47544-1','2017-09-13',358,12694,9,'SO47544',1,1,28687375,28687375,15481340,717185,13206035),
('SO47546-1','2017-09-14',360,28683,7,'SO47546',1,1,28687375,28687375,15481340,717185,13206035),
('SO47553-1','2017-09-14',354,12698,9,'SO47553',1,1,28999874,28999874,15649983,724997,13349891);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47554-1','2017-09-14',362,12222,10,'SO47554',1,1,28687375,28687375,15481340,717185,13206035),
('SO47559-1','2017-09-15',362,12699,9,'SO47559',1,1,28687375,28687375,15481340,717185,13206035),
('SO47560-1','2017-09-16',325,27053,6,'SO47560',1,1,10961860,10961860,6813892,274047,4147968),
('SO47564-1','2017-09-16',356,12210,10,'SO47564',1,1,28999874,28999874,15649983,724997,13349891),
('SO47565-1','2017-09-17',377,15697,8,'SO47565',1,1,30541875,30541875,18489573,763547,12052302),
('SO47571-1','2017-09-18',377,14185,7,'SO47571',1,1,30541875,30541875,18489573,763547,12052302),
('SO47572-1','2017-09-18',368,29149,6,'SO47572',1,1,34206900,34206900,21263010,855173,12943890),
('SO47578-1','2017-09-18',352,12687,9,'SO47578',1,1,28999874,28999874,15649983,724997,13349891),
('SO47581-1','2017-09-19',375,29152,6,'SO47581',1,1,30541875,30541875,18489573,763547,12052302),
('SO47595-1','2017-09-21',369,14186,7,'SO47595',1,1,34206900,34206900,21263010,855173,12943890);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47601-1','2017-09-22',379,14192,7,'SO47601',1,1,30541875,30541875,18489573,763547,12052302),
('SO47606-1','2017-09-23',375,15928,8,'SO47606',1,1,30541875,30541875,18489573,763547,12052302),
('SO47619-1','2017-09-24',356,12689,9,'SO47619',1,1,28999874,28999874,15649983,724997,13349891),
('SO47620-1','2017-09-24',352,12239,10,'SO47620',1,1,28999874,28999874,15649983,724997,13349891),
('SO47629-1','2017-09-26',370,15685,8,'SO47629',1,1,34206900,34206900,21263010,855173,12943890),
('SO47632-1','2017-09-26',343,27060,6,'SO47632',1,1,10961860,10961860,6813892,274047,4147968),
('SO47634-1','2017-09-26',356,11570,8,'SO47634',1,1,28999874,28999874,15649983,724997,13349891),
('SO47635-1','2017-09-26',354,12216,10,'SO47635',1,1,28999874,28999874,15649983,724997,13349891),
('SO47641-1','2017-09-28',321,27062,6,'SO47641',1,1,10961860,10961860,6813892,274047,4147968),
('SO47644-1','2017-09-29',375,15693,8,'SO47644',1,1,30541875,30541875,18489573,763547,12052302);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47648-1','2017-09-29',356,12263,10,'SO47648',1,1,28999874,28999874,15649983,724997,13349891),
('SO47651-1','2017-09-30',377,25911,6,'SO47651',1,1,30541875,30541875,18489573,763547,12052302),
('SO47735-1','2017-10-01',343,27084,6,'SO47735',1,1,10961860,10961860,6813892,274047,4147968),
('SO47736-1','2017-10-01',358,12705,9,'SO47736',1,1,28687375,28687375,15481340,717185,13206035),
('SO47743-1','2017-10-02',362,12988,9,'SO47743',1,1,28687375,28687375,15481340,717185,13206035),
('SO47744-1','2017-10-02',360,12989,9,'SO47744',1,1,28687375,28687375,15481340,717185,13206035),
('SO47745-1','2017-10-02',360,12998,9,'SO47745',1,1,28687375,28687375,15481340,717185,13206035),
('SO47764-1','2017-10-06',356,28711,7,'SO47764',1,1,28999874,28999874,15649983,724997,13349891),
('SO47769-1','2017-10-06',360,12703,9,'SO47769',1,1,28687375,28687375,15481340,717185,13206035),
('SO47776-1','2017-10-07',352,13007,9,'SO47776',1,1,28999874,28999874,15649983,724997,13349891);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47784-1','2017-10-08',356,13078,9,'SO47784',1,1,28999874,28999874,15649983,724997,13349891),
('SO47785-1','2017-10-09',356,28708,7,'SO47785',1,1,28999874,28999874,15649983,724997,13349891),
('SO47786-1','2017-10-09',370,14719,7,'SO47786',1,1,34206900,34206900,21263010,855173,12943890),
('SO47793-1','2017-10-11',368,14716,7,'SO47793',1,1,34206900,34206900,21263010,855173,12943890),
('SO47798-1','2017-10-11',354,13000,9,'SO47798',1,1,28999874,28999874,15649983,724997,13349891),
('SO47821-1','2017-10-13',352,13038,9,'SO47821',1,1,28999874,28999874,15649983,724997,13349891),
('SO47822-1','2017-10-13',354,13051,9,'SO47822',1,1,28999874,28999874,15649983,724997,13349891),
('SO47829-1','2017-10-14',352,12706,9,'SO47829',1,1,28999874,28999874,15649983,724997,13349891),
('SO47836-1','2017-10-16',356,28707,7,'SO47836',1,1,28999874,28999874,15649983,724997,13349891),
('SO47855-1','2017-10-18',354,12987,9,'SO47855',1,1,28999874,28999874,15649983,724997,13349891);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47856-1','2017-10-18',362,12995,9,'SO47856',1,1,28687375,28687375,15481340,717185,13206035),
('SO47865-1','2017-10-19',352,12701,9,'SO47865',1,1,28999874,28999874,15649983,724997,13349891),
('SO47866-1','2017-10-19',352,12990,9,'SO47866',1,1,28999874,28999874,15649983,724997,13349891),
('SO47867-1','2017-10-19',360,12991,9,'SO47867',1,1,28687375,28687375,15481340,717185,13206035),
('SO47878-1','2017-10-20',358,12702,9,'SO47878',1,1,28687375,28687375,15481340,717185,13206035),
('SO47880-1','2017-10-21',360,28689,7,'SO47880',1,1,28687375,28687375,15481340,717185,13206035),
('SO47883-1','2017-10-21',352,26481,4,'SO47883',1,1,28999874,28999874,15649983,724997,13349891),
('SO47886-1','2017-10-21',358,13011,9,'SO47886',1,1,28687375,28687375,15481340,717185,13206035),
('SO47887-1','2017-10-21',356,13012,9,'SO47887',1,1,28999874,28999874,15649983,724997,13349891),
('SO47899-1','2017-10-23',358,12996,9,'SO47899',1,1,28687375,28687375,15481340,717185,13206035);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47901-1','2017-10-23',354,13075,9,'SO47901',1,1,28999874,28999874,15649983,724997,13349891),
('SO47902-1','2017-10-23',360,13076,9,'SO47902',1,1,28687375,28687375,15481340,717185,13206035),
('SO47903-1','2017-10-24',368,14714,7,'SO47903',1,1,34206900,34206900,21263010,855173,12943890),
('SO47905-1','2017-10-24',373,29336,6,'SO47905',1,1,30541875,30541875,18489573,763547,12052302),
('SO47906-1','2017-10-24',339,27082,6,'SO47906',1,1,10961860,10961860,6813892,274047,4147968),
('SO47909-1','2017-10-24',356,12999,9,'SO47909',1,1,28999874,28999874,15649983,724997,13349891),
('SO47910-1','2017-10-24',352,13049,9,'SO47910',1,1,28999874,28999874,15649983,724997,13349891),
('SO47911-1','2017-10-24',358,13077,9,'SO47911',1,1,28687375,28687375,15481340,717185,13206035),
('SO47912-1','2017-10-25',360,28724,7,'SO47912',1,1,28687375,28687375,15481340,717185,13206035),
('SO47913-1','2017-10-25',368,29159,6,'SO47913',1,1,34206900,34206900,21263010,855173,12943890);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO47917-1','2017-10-25',358,13001,9,'SO47917',1,1,28687375,28687375,15481340,717185,13206035),
('SO47918-1','2017-10-25',362,13006,9,'SO47918',1,1,28687375,28687375,15481340,717185,13206035),
('SO47926-1','2017-10-26',360,13079,9,'SO47926',1,1,28687375,28687375,15481340,717185,13206035),
('SO47928-1','2017-10-27',377,29154,6,'SO47928',1,1,30541875,30541875,18489573,763547,12052302),
('SO47929-1','2017-10-27',368,29281,6,'SO47929',1,1,34206900,34206900,21263010,855173,12943890),
('SO47940-1','2017-10-29',354,12994,9,'SO47940',1,1,28999874,28999874,15649983,724997,13349891),
('SO47941-1','2017-10-29',356,13010,9,'SO47941',1,1,28999874,28999874,15649983,724997,13349891),
('SO47944-1','2017-10-30',362,28690,7,'SO47944',1,1,28687375,28687375,15481340,717185,13206035),
('SO47951-1','2017-10-30',356,12700,9,'SO47951',1,1,28999874,28999874,15649983,724997,13349891),
('SO48099-1','2017-11-02',360,12128,8,'SO48099',1,1,28687375,28687375,15481340,717185,13206035);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO48113-1','2017-11-05',335,20716,8,'SO48113',1,1,10961860,10961860,6813892,274047,4147968),
('SO48123-1','2017-11-06',360,13080,9,'SO48123',1,1,28687375,28687375,15481340,717185,13206035),
('SO48136-1','2017-11-08',354,13082,9,'SO48136',1,1,28999874,28999874,15649983,724997,13349891),
('SO48137-1','2017-11-09',352,12130,8,'SO48137',1,1,28999874,28999874,15649983,724997,13349891),
('SO48141-1','2017-11-10',354,12299,10,'SO48141',1,1,28999874,28999874,15649983,724997,13349891),
('SO48178-1','2017-11-16',352,12125,8,'SO48178',1,1,28999874,28999874,15649983,724997,13349891),
('SO48210-1','2017-11-20',354,13089,9,'SO48210',1,1,28999874,28999874,15649983,724997,13349891),
('SO48213-1','2017-11-21',358,12292,10,'SO48213',1,1,28687375,28687375,15481340,717185,13206035),
('SO48215-1','2017-11-21',387,26482,6,'SO48215',1,1,14006125,14006125,8479089,350153,5527036),
('SO48245-1','2017-11-26',354,12129,8,'SO48245',1,1,28999874,28999874,15649983,724997,13349891);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO48255-1','2017-11-27',385,26496,6,'SO48255',1,1,14006125,14006125,8479089,350153,5527036),
('SO48259-1','2017-11-27',327,27085,6,'SO48259',1,1,10961860,10961860,6813892,274047,4147968),
('SO48260-1','2017-11-27',323,27099,6,'SO48260',1,1,10961860,10961860,6813892,274047,4147968),
('SO48261-1','2017-11-27',329,27101,6,'SO48261',1,1,10961860,10961860,6813892,274047,4147968),
('SO48267-1','2017-11-28',327,27102,6,'SO48267',1,1,10961860,10961860,6813892,274047,4147968),
('SO48270-1','2017-11-28',360,13081,9,'SO48270',1,1,28687375,28687375,15481340,717185,13206035),
('SO48271-1','2017-11-29',356,28727,7,'SO48271',1,1,28999874,28999874,15649983,724997,13349891),
('SO48439-1','2017-12-05',389,17651,7,'SO48439',1,1,14006125,14006125,8479089,350153,5527036),
('SO48441-1','2017-12-05',389,26503,6,'SO48441',1,1,14006125,14006125,8479089,350153,5527036),
('SO48446-1','2017-12-05',339,27265,6,'SO48446',1,1,10961860,10961860,6813892,274047,4147968);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO48453-1','2017-12-06',385,17647,7,'SO48453',1,1,14006125,14006125,8479089,350153,5527036),
('SO48476-1','2017-12-08',385,26512,6,'SO48476',1,1,14006125,14006125,8479089,350153,5527036),
('SO48530-1','2017-12-12',352,13104,9,'SO48530',1,1,28999874,28999874,15649983,724997,13349891),
('SO48570-1','2017-12-16',389,26504,6,'SO48570',1,1,14006125,14006125,8479089,350153,5527036),
('SO48591-1','2017-12-18',358,28739,7,'SO48591',1,1,28687375,28687375,15481340,717185,13206035),
('SO48601-1','2017-12-19',362,28728,7,'SO48601',1,1,28687375,28687375,15481340,717185,13206035),
('SO48618-1','2017-12-20',333,27259,6,'SO48618',1,1,10961860,10961860,6813892,274047,4147968),
('SO48659-1','2017-12-24',362,28749,7,'SO48659',1,1,28687375,28687375,15481340,717185,13206035),
('SO48666-1','2017-12-24',360,13090,9,'SO48666',1,1,28687375,28687375,15481340,717185,13206035),
('SO48668-1','2017-12-25',389,18626,8,'SO48668',1,1,14006125,14006125,8479089,350153,5527036);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO48680-1','2017-12-26',341,27242,6,'SO48680',1,1,10961860,10961860,6813892,274047,4147968),
('SO48682-1','2017-12-26',354,13091,9,'SO48682',1,1,28999874,28999874,15649983,724997,13349891),
('SO48683-1','2017-12-27',385,17648,7,'SO48683',1,1,14006125,14006125,8479089,350153,5527036),
('SO48686-1','2017-12-27',371,25999,6,'SO48686',1,1,30541875,30541875,18489573,763547,12052302),
('SO48693-1','2017-12-28',370,25995,6,'SO48693',1,1,34206900,34206900,21263010,855173,12943890),
('SO48701-1','2017-12-28',360,13103,9,'SO48701',1,1,28687375,28687375,15481340,717185,13206035),
('SO48710-1','2017-12-29',354,12305,10,'SO48710',1,1,28999874,28999874,15649983,724997,13349891),
('SO48712-1','2017-12-29',339,27252,6,'SO48712',1,1,10961860,10961860,6813892,274047,4147968),
('SO48713-1','2017-12-29',335,27253,6,'SO48713',1,1,10961860,10961860,6813892,274047,4147968),
('SO48717-1','2017-12-30',352,28736,7,'SO48717',1,1,28999874,28999874,15649983,724997,13349891);
INSERT INTO public.fact_sales (order_detail_id,order_date,product_id,customer_id,territory_id,sales_order_number,sales_order_line_number,quantity,unitprice_rupiah,totalprice_rupiah,totalcost_rupiah,shippingprice_rupiah,omset) VALUES
('SO49675-1','2018-03-14',360,11241,7,'SO49675',1,1,28687375,28687375,15481340,717185,13206035),
('SO49752-1','2018-03-23',360,11242,7,'SO49752',1,1,28687375,28687375,15481340,717185,13206035),
('SO49814-1','2018-03-31',356,11336,7,'SO49814',1,1,28999874,28999874,15649983,724997,13349891),
('SO49929-1','2018-04-04',360,11346,7,'SO49929',1,1,28687375,28687375,15481340,717185,13206035),
('SO49939-1','2018-04-05',360,11379,7,'SO49939',1,1,28687375,28687375,15481340,717185,13206035),
('SO49985-1','2018-04-10',360,11339,7,'SO49985',1,1,28687375,28687375,15481340,717185,13206035),
('SO50092-1','2018-04-20',354,11378,7,'SO50092',1,1,28999874,28999874,15649983,724997,13349891),
('SO50133-1','2018-04-25',362,11345,7,'SO50133',1,1,28687375,28687375,15481340,717185,13206035),
('SO50184-1','2018-04-30',360,11340,7,'SO50184',1,1,28687375,28687375,15481340,717185,13206035),