[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 656 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45778_1 | 100 | 26002 | 351 | 1 | 2022-07-23 | 84.37 | 2022-07-11 | 3374.99 | 1 | SO45778 | 2022-07-18 | 270.00 | 1898.09 | |
SO56074_1 | 100 | 27388 | 541 | 1 | 2024-02-05 | 0.72 | 2024-01-24 | 28.99 | 1 | SO56074 | 2024-01-31 | 2.32 | 10.84 | |
SO45821_1 | 100 | 26041 | 346 | 1 | 2022-07-25 | 85.00 | 2022-07-13 | 3399.99 | 1 | SO45821 | 2022-07-20 | 272.00 | 1912.15 | |
SO56074_2 | 100 | 27388 | 530 | 1 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 2 | SO56074 | 2024-01-31 | 0.40 | 1.87 | |
SO45824_1 | 100 | 11696 | 312 | 1 | 2022-07-26 | 89.46 | 2022-07-14 | 3578.27 | 1 | SO45824 | 2022-07-21 | 286.26 | 2171.29 | |
SO56074_3 | 100 | 27388 | 237 | 1 | 2024-02-05 | 1.25 | 2024-01-24 | 49.99 | 3 | SO56074 | 2024-01-31 | 4.00 | 38.49 | |
SO45828_1 | 100 | 14753 | 330 | 1 | 2022-07-26 | 17.48 | 2022-07-14 | 699.10 | 1 | SO45828 | 2022-07-21 | 55.93 | 413.15 | |
SO56080_1 | 100 | 23002 | 528 | 1 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 1 | SO56080 | 2024-01-31 | 0.40 | 1.87 | |
SO45833_1 | 100 | 11815 | 313 | 1 | 2022-07-27 | 89.46 | 2022-07-15 | 3578.27 | 1 | SO45833 | 2022-07-22 | 286.26 | 2171.29 | |
SO56080_2 | 100 | 23002 | 536 | 1 | 2024-02-05 | 0.75 | 2024-01-24 | 29.99 | 2 | SO56080 | 2024-01-31 | 2.40 | 11.22 | |
SO45835_1 | 100 | 11688 | 313 | 1 | 2022-07-27 | 89.46 | 2022-07-15 | 3578.27 | 1 | SO45835 | 2022-07-22 | 286.26 | 2171.29 | |
SO56080_3 | 100 | 23002 | 485 | 1 | 2024-02-05 | 0.55 | 2024-01-24 | 21.98 | 3 | SO56080 | 2024-01-31 | 1.76 | 8.22 | |
SO45837_1 | 100 | 26050 | 348 | 1 | 2022-07-27 | 84.37 | 2022-07-15 | 3374.99 | 1 | SO45837 | 2022-07-22 | 270.00 | 1898.09 | |
SO56080_4 | 100 | 23002 | 480 | 1 | 2024-02-05 | 0.06 | 2024-01-24 | 2.29 | 4 | SO56080 | 2024-01-31 | 0.18 | 0.86 | |
SO45844_1 | 100 | 11812 | 312 | 1 | 2022-07-28 | 89.46 | 2022-07-16 | 3578.27 | 1 | SO45844 | 2022-07-23 | 286.26 | 2171.29 | |
SO56080_5 | 100 | 23002 | 484 | 1 | 2024-02-05 | 0.20 | 2024-01-24 | 7.95 | 5 | SO56080 | 2024-01-31 | 0.64 | 2.97 | |
SO45855_1 | 100 | 14754 | 338 | 1 | 2022-07-30 | 17.48 | 2022-07-18 | 699.10 | 1 | SO45855 | 2022-07-25 | 55.93 | 413.15 | |
SO56083_1 | 100 | 19886 | 225 | 1 | 2024-02-05 | 0.22 | 2024-01-24 | 8.99 | 1 | SO56083 | 2024-01-31 | 0.72 | 6.92 | |
SO45867_1 | 100 | 11772 | 312 | 1 | 2022-08-02 | 89.46 | 2022-07-21 | 3578.27 | 1 | SO45867 | 2022-07-28 | 286.26 | 2171.29 | |
SO56083_2 | 100 | 19886 | 474 | 1 | 2024-02-05 | 1.75 | 2024-01-24 | 69.99 | 2 | SO56083 | 2024-01-31 | 5.60 | 26.18 | |
SO45873_1 | 100 | 11925 | 314 | 1 | 2022-08-03 | 89.46 | 2022-07-22 | 3578.27 | 1 | SO45873 | 2022-07-29 | 286.26 | 2171.29 | |
SO56085_1 | 100 | 20127 | 474 | 1 | 2024-02-05 | 1.75 | 2024-01-24 | 69.99 | 1 | SO56085 | 2024-01-31 | 5.60 | 26.18 | |
SO45882_1 | 100 | 11745 | 312 | 1 | 2022-08-04 | 89.46 | 2022-07-23 | 3578.27 | 1 | SO45882 | 2022-07-30 | 286.26 | 2171.29 | |
SO56086_1 | 100 | 19833 | 475 | 1 | 2024-02-05 | 1.75 | 2024-01-24 | 69.99 | 1 | SO56086 | 2024-01-31 | 5.60 | 26.18 | |
SO45883_1 | 100 | 11799 | 313 | 1 | 2022-08-04 | 89.46 | 2022-07-23 | 3578.27 | 1 | SO45883 | 2022-07-30 | 286.26 | 2171.29 | |
SO56101_1 | 100 | 16970 | 582 | 1 | 2024-02-05 | 42.52 | 2024-01-24 | 1700.99 | 1 | SO56101 | 2024-01-31 | 136.08 | 1082.51 | |
SO45884_1 | 100 | 11678 | 313 | 1 | 2022-08-04 | 89.46 | 2022-07-23 | 3578.27 | 1 | SO45884 | 2022-07-30 | 286.26 | 2171.29 | |
SO56101_2 | 100 | 16970 | 489 | 1 | 2024-02-05 | 1.35 | 2024-01-24 | 53.99 | 2 | SO56101 | 2024-01-31 | 4.32 | 41.57 | |
SO45897_1 | 100 | 11933 | 313 | 1 | 2022-08-07 | 89.46 | 2022-07-26 | 3578.27 | 1 | SO45897 | 2022-08-02 | 286.26 | 2171.29 | |
SO56102_1 | 100 | 16972 | 581 | 1 | 2024-02-05 | 42.52 | 2024-01-24 | 1700.99 | 1 | SO56102 | 2024-01-31 | 136.08 | 1082.51 | |
SO45919_1 | 100 | 11780 | 312 | 1 | 2022-08-09 | 89.46 | 2022-07-28 | 3578.27 | 1 | SO45919 | 2022-08-04 | 286.26 | 2171.29 | |
SO56102_2 | 100 | 16972 | 489 | 1 | 2024-02-05 | 1.35 | 2024-01-24 | 53.99 | 2 | SO56102 | 2024-01-31 | 4.32 | 41.57 | |
SO45921_1 | 100 | 11798 | 312 | 1 | 2022-08-09 | 89.46 | 2022-07-28 | 3578.27 | 1 | SO45921 | 2022-08-04 | 286.26 | 2171.29 | |
SO56105_1 | 100 | 14098 | 590 | 1 | 2024-02-05 | 19.24 | 2024-01-24 | 769.49 | 1 | SO56105 | 2024-01-31 | 61.56 | 419.78 | |
SO45928_1 | 100 | 11813 | 313 | 1 | 2022-08-10 | 89.46 | 2022-07-29 | 3578.27 | 1 | SO45928 | 2022-08-05 | 286.26 | 2171.29 | |
SO56105_2 | 100 | 14098 | 485 | 1 | 2024-02-05 | 0.55 | 2024-01-24 | 21.98 | 2 | SO56105 | 2024-01-31 | 1.76 | 8.22 | |
SO45933_1 | 100 | 11779 | 313 | 1 | 2022-08-11 | 89.46 | 2022-07-30 | 3578.27 | 1 | SO45933 | 2022-08-06 | 286.26 | 2171.29 | |
SO56105_3 | 100 | 14098 | 488 | 1 | 2024-02-05 | 1.35 | 2024-01-24 | 53.99 | 3 | SO56105 | 2024-01-31 | 4.32 | 41.57 | |
SO45954_1 | 100 | 11810 | 314 | 1 | 2022-08-14 | 89.46 | 2022-08-02 | 3578.27 | 1 | SO45954 | 2022-08-09 | 286.26 | 2171.29 | |
SO56119_1 | 100 | 22092 | 604 | 1 | 2024-02-05 | 13.50 | 2024-01-24 | 539.99 | 1 | SO56119 | 2024-01-31 | 43.20 | 343.65 | |
SO45955_1 | 100 | 26055 | 344 | 1 | 2022-08-14 | 85.00 | 2022-08-02 | 3399.99 | 1 | SO45955 | 2022-08-09 | 272.00 | 1912.15 | |
SO56119_2 | 100 | 22092 | 538 | 1 | 2024-02-05 | 0.54 | 2024-01-24 | 21.49 | 2 | SO56119 | 2024-01-31 | 1.72 | 8.04 | |
SO45974_1 | 100 | 26018 | 347 | 1 | 2022-08-17 | 85.00 | 2022-08-05 | 3399.99 | 1 | SO45974 | 2022-08-12 | 272.00 | 1912.15 | |
SO56119_3 | 100 | 22092 | 480 | 1 | 2024-02-05 | 0.06 | 2024-01-24 | 2.29 | 3 | SO56119 | 2024-01-31 | 0.18 | 0.86 | |
SO45984_1 | 100 | 11690 | 313 | 1 | 2022-08-19 | 89.46 | 2022-08-07 | 3578.27 | 1 | SO45984 | 2022-08-14 | 286.26 | 2171.29 | |
SO56137_1 | 100 | 11013 | 529 | 1 | 2024-02-06 | 0.10 | 2024-01-25 | 3.99 | 1 | SO56137 | 2024-02-01 | 0.32 | 1.49 | |
SO45988_1 | 100 | 11675 | 314 | 1 | 2022-08-19 | 89.46 | 2022-08-07 | 3578.27 | 1 | SO45988 | 2022-08-14 | 286.26 | 2171.29 | |
SO56137_2 | 100 | 11013 | 217 | 1 | 2024-02-06 | 0.87 | 2024-01-25 | 34.99 | 2 | SO56137 | 2024-02-01 | 2.80 | 13.09 | |
SO46000_1 | 100 | 11778 | 310 | 1 | 2022-08-21 | 89.46 | 2022-08-09 | 3578.27 | 1 | SO46000 | 2022-08-16 | 286.26 | 2171.29 | |
SO56140_1 | 100 | 27023 | 538 | 1 | 2024-02-06 | 0.54 | 2024-01-25 | 21.49 | 1 | SO56140 | 2024-02-01 | 1.72 | 8.04 | |
SO46018_1 | 100 | 11663 | 312 | 1 | 2022-08-22 | 89.46 | 2022-08-10 | 3578.27 | 1 | SO46018 | 2022-08-17 | 286.26 | 2171.29 | |
SO56140_2 | 100 | 27023 | 529 | 1 | 2024-02-06 | 0.10 | 2024-01-25 | 3.99 | 2 | SO56140 | 2024-02-01 | 0.32 | 1.49 | |
SO46109_1 | 100 | 12167 | 312 | 1 | 2022-08-23 | 89.46 | 2022-08-11 | 3578.27 | 1 | SO46109 | 2022-08-18 | 286.26 | 2171.29 | |
SO56140_3 | 100 | 27023 | 217 | 1 | 2024-02-06 | 0.87 | 2024-01-25 | 34.99 | 3 | SO56140 | 2024-02-01 | 2.80 | 13.09 | |
SO46111_1 | 100 | 11937 | 311 | 1 | 2022-08-23 | 89.46 | 2022-08-11 | 3578.27 | 1 | SO46111 | 2022-08-18 | 286.26 | 2171.29 | |
SO56141_1 | 100 | 25259 | 528 | 1 | 2024-02-06 | 0.12 | 2024-01-25 | 4.99 | 1 | SO56141 | 2024-02-01 | 0.40 | 1.87 | |
SO46145_1 | 100 | 14881 | 340 | 1 | 2022-08-27 | 17.48 | 2022-08-15 | 699.10 | 1 | SO46145 | 2022-08-22 | 55.93 | 413.15 | |
SO56141_2 | 100 | 25259 | 535 | 1 | 2024-02-06 | 0.62 | 2024-01-25 | 24.99 | 2 | SO56141 | 2024-02-01 | 2.00 | 9.35 | |
SO46149_1 | 100 | 12120 | 311 | 1 | 2022-08-28 | 89.46 | 2022-08-16 | 3578.27 | 1 | SO46149 | 2022-08-23 | 286.26 | 2171.29 | |
SO56141_3 | 100 | 25259 | 480 | 2 | 1 | 2024-02-06 | 0.06 | 2024-01-25 | 2.29 | 3 | SO56141 | 2024-02-01 | 0.18 | 0.86 |
Generated 2024-11-10 09:53:21.772 UTC