[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1486 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44995_1 | 100 | 28841 | 313 | 4 | 2022-02-27 | 89.46 | 2022-02-15 | 3578.27 | 1 | SO44995 | 2022-02-22 | 286.26 | 2171.29 | |
SO55766_2 | 100 | 16884 | 222 | 1 | 2023-12-10 | 0.87 | 2023-11-28 | 34.99 | 2 | SO55766 | 2023-12-05 | 2.80 | 13.09 | |
SO44996_1 | 100 | 25970 | 349 | 1 | 2022-02-27 | 84.37 | 2022-02-15 | 3374.99 | 1 | SO44996 | 2022-02-22 | 270.00 | 1898.09 | |
SO55767_1 | 100 | 15368 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55767 | 2023-12-05 | 0.40 | 1.87 | |
SO44997_1 | 100 | 28870 | 310 | 1 | 2022-02-27 | 89.46 | 2022-02-15 | 3578.27 | 1 | SO44997 | 2022-02-22 | 286.26 | 2171.29 | |
SO55767_2 | 100 | 15368 | 480 | 2 | 4 | 2023-12-10 | 0.06 | 2023-11-28 | 2.29 | 2 | SO55767 | 2023-12-05 | 0.18 | 0.86 |
SO44998_1 | 100 | 14646 | 340 | 4 | 2022-02-27 | 17.48 | 2022-02-15 | 699.10 | 1 | SO44998 | 2022-02-22 | 55.93 | 413.15 | |
SO55768_1 | 100 | 14445 | 485 | 4 | 2023-12-10 | 0.55 | 2023-11-28 | 21.98 | 1 | SO55768 | 2023-12-05 | 1.76 | 8.22 | |
SO44999_1 | 6 | 18485 | 311 | 9 | 2022-02-27 | 89.46 | 2022-02-15 | 3578.27 | 1 | SO44999 | 2022-02-22 | 286.26 | 2171.29 | |
SO55768_2 | 100 | 14445 | 478 | 4 | 2023-12-10 | 0.25 | 2023-11-28 | 9.99 | 2 | SO55768 | 2023-12-05 | 0.80 | 3.74 | |
SO45000_1 | 6 | 18297 | 312 | 9 | 2022-02-27 | 89.46 | 2022-02-15 | 3578.27 | 1 | SO45000 | 2022-02-22 | 286.26 | 2171.29 | |
SO55768_3 | 100 | 14445 | 477 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 3 | SO55768 | 2023-12-05 | 0.40 | 1.87 | |
SO45001_1 | 6 | 18302 | 312 | 9 | 2022-02-27 | 89.46 | 2022-02-15 | 3578.27 | 1 | SO45001 | 2022-02-22 | 286.26 | 2171.29 | |
SO55768_4 | 100 | 14445 | 473 | 4 | 2023-12-10 | 1.59 | 2023-11-28 | 63.50 | 4 | SO55768 | 2023-12-05 | 5.08 | 23.75 | |
SO45002_1 | 29 | 13844 | 312 | 8 | 2022-02-28 | 89.46 | 2022-02-16 | 3578.27 | 1 | SO45002 | 2022-02-23 | 286.26 | 2171.29 | |
SO55769_1 | 100 | 14243 | 485 | 1 | 2023-12-10 | 0.55 | 2023-11-28 | 21.98 | 1 | SO55769 | 2023-12-05 | 1.76 | 8.22 | |
SO45003_1 | 100 | 29059 | 314 | 4 | 2022-02-28 | 89.46 | 2022-02-16 | 3578.27 | 1 | SO45003 | 2022-02-23 | 286.26 | 2171.29 | |
SO55769_2 | 100 | 14243 | 231 | 1 | 2023-12-10 | 1.25 | 2023-11-28 | 49.99 | 2 | SO55769 | 2023-12-05 | 4.00 | 38.49 | |
SO45004_1 | 100 | 29106 | 314 | 4 | 2022-02-28 | 89.46 | 2022-02-16 | 3578.27 | 1 | SO45004 | 2022-02-23 | 286.26 | 2171.29 | |
SO55770_1 | 100 | 15273 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55770 | 2023-12-05 | 0.40 | 1.87 | |
SO45005_1 | 100 | 28844 | 312 | 4 | 2022-02-28 | 89.46 | 2022-02-16 | 3578.27 | 1 | SO45005 | 2022-02-23 | 286.26 | 2171.29 | |
SO55770_2 | 100 | 15273 | 222 | 4 | 2023-12-10 | 0.87 | 2023-11-28 | 34.99 | 2 | SO55770 | 2023-12-05 | 2.80 | 13.09 | |
SO45006_1 | 39 | 12373 | 312 | 7 | 2022-03-01 | 89.46 | 2022-02-17 | 3578.27 | 1 | SO45006 | 2022-02-24 | 286.26 | 2171.29 | |
SO55770_3 | 100 | 15273 | 471 | 4 | 2023-12-10 | 1.59 | 2023-11-28 | 63.50 | 3 | SO55770 | 2023-12-05 | 5.08 | 23.75 | |
SO45007_1 | 29 | 14137 | 310 | 8 | 2022-03-01 | 89.46 | 2022-02-17 | 3578.27 | 1 | SO45007 | 2022-02-24 | 286.26 | 2171.29 | |
SO55771_1 | 19 | 18407 | 485 | 6 | 2023-12-10 | 0.55 | 2023-11-28 | 21.98 | 1 | SO55771 | 2023-12-05 | 1.76 | 8.22 | |
SO45008_1 | 98 | 14831 | 313 | 10 | 2022-03-01 | 89.46 | 2022-02-17 | 3578.27 | 1 | SO45008 | 2022-02-24 | 286.26 | 2171.29 | |
SO55771_2 | 19 | 18407 | 481 | 6 | 2023-12-10 | 0.22 | 2023-11-28 | 8.99 | 2 | SO55771 | 2023-12-05 | 0.72 | 3.36 | |
SO45009_1 | 29 | 19387 | 338 | 8 | 2022-03-01 | 17.48 | 2022-02-17 | 699.10 | 1 | SO45009 | 2022-02-24 | 55.93 | 413.15 | |
SO55772_1 | 98 | 19926 | 528 | 10 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55772 | 2023-12-05 | 0.40 | 1.87 | |
SO45010_1 | 100 | 28869 | 313 | 1 | 2022-03-01 | 89.46 | 2022-02-17 | 3578.27 | 1 | SO45010 | 2022-02-24 | 286.26 | 2171.29 | |
SO55772_2 | 98 | 19926 | 222 | 10 | 2023-12-10 | 0.87 | 2023-11-28 | 34.99 | 2 | SO55772 | 2023-12-05 | 2.80 | 13.09 | |
SO45011_1 | 19 | 22268 | 313 | 6 | 2022-03-01 | 89.46 | 2022-02-17 | 3578.27 | 1 | SO45011 | 2022-02-24 | 286.26 | 2171.29 | |
SO55773_1 | 100 | 14422 | 540 | 8 | 2023-12-10 | 0.82 | 2023-11-28 | 32.60 | 1 | SO55773 | 2023-12-05 | 2.61 | 12.19 | |
SO45012_1 | 100 | 14650 | 342 | 1 | 2022-03-01 | 17.48 | 2022-02-17 | 699.10 | 1 | SO45012 | 2022-02-24 | 55.93 | 413.15 | |
SO55773_2 | 100 | 14422 | 529 | 8 | 2023-12-10 | 0.10 | 2023-11-28 | 3.99 | 2 | SO55773 | 2023-12-05 | 0.32 | 1.49 | |
SO45013_1 | 6 | 18483 | 310 | 9 | 2022-03-01 | 89.46 | 2022-02-17 | 3578.27 | 1 | SO45013 | 2022-02-24 | 286.26 | 2171.29 | |
SO55773_3 | 100 | 14422 | 480 | 8 | 2023-12-10 | 0.06 | 2023-11-28 | 2.29 | 3 | SO55773 | 2023-12-05 | 0.18 | 0.86 | |
SO45014_1 | 6 | 25705 | 322 | 9 | 2022-03-01 | 17.48 | 2022-02-17 | 699.10 | 1 | SO45014 | 2022-02-24 | 55.93 | 413.15 | |
SO55774_1 | 100 | 14943 | 485 | 8 | 2023-12-10 | 0.55 | 2023-11-28 | 21.98 | 1 | SO55774 | 2023-12-05 | 1.76 | 8.22 | |
SO45015_1 | 6 | 11360 | 346 | 9 | 2022-03-01 | 85.00 | 2022-02-17 | 3399.99 | 1 | SO45015 | 2022-02-24 | 272.00 | 1912.15 | |
SO55774_2 | 100 | 14943 | 478 | 8 | 2023-12-10 | 0.25 | 2023-11-28 | 9.99 | 2 | SO55774 | 2023-12-05 | 0.80 | 3.74 | |
SO45016_1 | 98 | 14770 | 310 | 10 | 2022-03-02 | 89.46 | 2022-02-18 | 3578.27 | 1 | SO45016 | 2022-02-25 | 286.26 | 2171.29 | |
SO55774_3 | 100 | 14943 | 477 | 8 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 3 | SO55774 | 2023-12-05 | 0.40 | 1.87 | |
SO45017_1 | 100 | 28826 | 312 | 1 | 2022-03-02 | 89.46 | 2022-02-18 | 3578.27 | 1 | SO45017 | 2022-02-25 | 286.26 | 2171.29 | |
SO55775_1 | 100 | 18014 | 473 | 7 | 2023-12-10 | 1.59 | 2023-11-28 | 63.50 | 1 | SO55775 | 2023-12-05 | 5.08 | 23.75 | |
SO45018_1 | 6 | 18494 | 313 | 9 | 2022-03-02 | 89.46 | 2022-02-18 | 3578.27 | 1 | SO45018 | 2022-02-25 | 286.26 | 2171.29 | |
SO55775_2 | 100 | 18014 | 536 | 7 | 2023-12-10 | 0.75 | 2023-11-28 | 29.99 | 2 | SO55775 | 2023-12-05 | 2.40 | 11.22 | |
SO45019_1 | 6 | 18691 | 313 | 9 | 2022-03-02 | 89.46 | 2022-02-18 | 3578.27 | 1 | SO45019 | 2022-02-25 | 286.26 | 2171.29 | |
SO55776_1 | 100 | 21843 | 225 | 8 | 2023-12-10 | 0.22 | 2023-11-28 | 8.99 | 1 | SO55776 | 2023-12-05 | 0.72 | 6.92 | |
SO45020_1 | 6 | 18332 | 311 | 9 | 2022-03-02 | 89.46 | 2022-02-18 | 3578.27 | 1 | SO45020 | 2022-02-25 | 286.26 | 2171.29 | |
SO55776_2 | 100 | 21843 | 477 | 8 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 2 | SO55776 | 2023-12-05 | 0.40 | 1.87 | |
SO45021_1 | 6 | 11358 | 348 | 9 | 2022-03-02 | 84.37 | 2022-02-18 | 3374.99 | 1 | SO45021 | 2022-02-25 | 270.00 | 1898.09 | |
SO55777_1 | 98 | 24035 | 477 | 10 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55777 | 2023-12-05 | 0.40 | 1.87 | |
SO45022_1 | 6 | 11447 | 350 | 9 | 2022-03-02 | 84.37 | 2022-02-18 | 3374.99 | 1 | SO45022 | 2022-02-25 | 270.00 | 1898.09 | |
SO55777_2 | 98 | 24035 | 482 | 10 | 2023-12-10 | 0.22 | 2023-11-28 | 8.99 | 2 | SO55777 | 2023-12-05 | 0.72 | 3.36 |
Generated 2024-09-20 09:20:19.279 UTC