[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 799 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65115_3 | 100 | 13835 | 477 | 7 | 2024-05-03 | 0.12 | 2024-04-21 | 4.99 | 3 | SO65115 | 2024-04-28 | 0.40 | 1.87 | |
SO65117_1 | 100 | 20593 | 529 | 7 | 2024-05-03 | 0.10 | 2024-04-21 | 3.99 | 1 | SO65117 | 2024-04-28 | 0.32 | 1.49 | |
SO65117_2 | 100 | 20593 | 539 | 7 | 2024-05-03 | 0.62 | 2024-04-21 | 24.99 | 2 | SO65117 | 2024-04-28 | 2.00 | 9.35 | |
SO65117_3 | 100 | 20593 | 480 | 7 | 2024-05-03 | 0.06 | 2024-04-21 | 2.29 | 3 | SO65117 | 2024-04-28 | 0.18 | 0.86 | |
SO65122_1 | 100 | 26871 | 541 | 7 | 2024-05-03 | 0.72 | 2024-04-21 | 28.99 | 1 | SO65122 | 2024-04-28 | 2.32 | 10.84 | |
SO65122_2 | 100 | 26871 | 530 | 7 | 2024-05-03 | 0.12 | 2024-04-21 | 4.99 | 2 | SO65122 | 2024-04-28 | 0.40 | 1.87 | |
SO65122_3 | 100 | 26871 | 487 | 7 | 2024-05-03 | 1.37 | 2024-04-21 | 54.99 | 3 | SO65122 | 2024-04-28 | 4.40 | 20.57 | |
SO65137_1 | 100 | 25600 | 560 | 7 | 2024-05-03 | 30.37 | 2024-04-21 | 1214.85 | 1 | SO65137 | 2024-04-28 | 97.19 | 755.15 | |
SO65137_2 | 100 | 25600 | 488 | 7 | 2024-05-03 | 1.35 | 2024-04-21 | 53.99 | 2 | SO65137 | 2024-04-28 | 4.32 | 41.57 | |
SO65325_1 | 100 | 24709 | 582 | 7 | 2024-05-04 | 42.52 | 2024-04-22 | 1700.99 | 1 | SO65325 | 2024-04-29 | 136.08 | 1082.51 | |
SO65325_2 | 100 | 24709 | 214 | 7 | 2024-05-04 | 0.87 | 2024-04-22 | 34.99 | 2 | SO65325 | 2024-04-29 | 2.80 | 13.09 | |
SO65338_1 | 100 | 22647 | 374 | 7 | 2024-05-04 | 61.08 | 2024-04-22 | 2443.35 | 1 | SO65338 | 2024-04-29 | 195.47 | 1554.95 | |
SO65338_2 | 100 | 22647 | 483 | 7 | 2024-05-04 | 3.00 | 2024-04-22 | 120.00 | 2 | SO65338 | 2024-04-29 | 9.60 | 44.88 | |
SO65361_1 | 100 | 16439 | 539 | 7 | 2024-05-04 | 0.62 | 2024-04-22 | 24.99 | 1 | SO65361 | 2024-04-29 | 2.00 | 9.35 | |
SO65365_1 | 100 | 19489 | 529 | 7 | 2024-05-04 | 0.10 | 2024-04-22 | 3.99 | 1 | SO65365 | 2024-04-29 | 0.32 | 1.49 | |
SO65365_2 | 100 | 19489 | 222 | 7 | 2024-05-04 | 0.87 | 2024-04-22 | 34.99 | 2 | SO65365 | 2024-04-29 | 2.80 | 13.09 | |
SO65367_1 | 100 | 11566 | 530 | 7 | 2024-05-04 | 0.12 | 2024-04-22 | 4.99 | 1 | SO65367 | 2024-04-29 | 0.40 | 1.87 | |
SO65367_2 | 100 | 11566 | 214 | 7 | 2024-05-04 | 0.87 | 2024-04-22 | 34.99 | 2 | SO65367 | 2024-04-29 | 2.80 | 13.09 | |
SO65368_1 | 100 | 25688 | 541 | 7 | 2024-05-04 | 0.72 | 2024-04-22 | 28.99 | 1 | SO65368 | 2024-04-29 | 2.32 | 10.84 | |
SO65368_2 | 100 | 25688 | 530 | 7 | 2024-05-04 | 0.12 | 2024-04-22 | 4.99 | 2 | SO65368 | 2024-04-29 | 0.40 | 1.87 | |
SO65368_3 | 100 | 25688 | 214 | 7 | 2024-05-04 | 0.87 | 2024-04-22 | 34.99 | 3 | SO65368 | 2024-04-29 | 2.80 | 13.09 | |
SO65427_1 | 100 | 20810 | 529 | 7 | 2024-05-05 | 0.10 | 2024-04-23 | 3.99 | 1 | SO65427 | 2024-04-30 | 0.32 | 1.49 | |
SO65427_2 | 100 | 20810 | 480 | 7 | 2024-05-05 | 0.06 | 2024-04-23 | 2.29 | 2 | SO65427 | 2024-04-30 | 0.18 | 0.86 | |
SO65429_1 | 100 | 20964 | 529 | 7 | 2024-05-05 | 0.10 | 2024-04-23 | 3.99 | 1 | SO65429 | 2024-04-30 | 0.32 | 1.49 | |
SO65429_2 | 100 | 20964 | 214 | 7 | 2024-05-05 | 0.87 | 2024-04-23 | 34.99 | 2 | SO65429 | 2024-04-30 | 2.80 | 13.09 | |
SO65434_1 | 100 | 27159 | 569 | 7 | 2024-05-05 | 18.56 | 2024-04-23 | 742.35 | 1 | SO65434 | 2024-04-30 | 59.39 | 461.44 | |
SO65434_2 | 100 | 27159 | 477 | 7 | 2024-05-05 | 0.12 | 2024-04-23 | 4.99 | 2 | SO65434 | 2024-04-30 | 0.40 | 1.87 | |
SO65434_3 | 100 | 27159 | 479 | 7 | 2024-05-05 | 0.22 | 2024-04-23 | 8.99 | 3 | SO65434 | 2024-04-30 | 0.72 | 3.36 | |
SO65434_4 | 100 | 27159 | 214 | 7 | 2024-05-05 | 0.87 | 2024-04-23 | 34.99 | 4 | SO65434 | 2024-04-30 | 2.80 | 13.09 | |
SO65435_1 | 100 | 25619 | 579 | 7 | 2024-05-05 | 30.37 | 2024-04-23 | 1214.85 | 1 | SO65435 | 2024-04-30 | 97.19 | 755.15 | |
SO65435_2 | 100 | 25619 | 237 | 2 | 7 | 2024-05-05 | 1.25 | 2024-04-23 | 49.99 | 2 | SO65435 | 2024-04-30 | 4.00 | 38.49 |
SO65435_3 | 100 | 25619 | 225 | 7 | 2024-05-05 | 0.22 | 2024-04-23 | 8.99 | 3 | SO65435 | 2024-04-30 | 0.72 | 6.92 | |
SO65449_1 | 100 | 20858 | 390 | 7 | 2024-05-05 | 28.01 | 2024-04-23 | 1120.49 | 1 | SO65449 | 2024-04-30 | 89.64 | 713.08 | |
SO45158_1 | 100 | 28419 | 344 | 7 | 2022-03-20 | 85.00 | 2022-03-08 | 3399.99 | 1 | SO45158 | 2022-03-15 | 272.00 | 1912.15 | |
SO55903_2 | 100 | 27851 | 214 | 7 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 2 | SO55903 | 2023-12-08 | 2.80 | 13.09 | |
SO45172_1 | 100 | 18008 | 334 | 7 | 2022-03-22 | 17.48 | 2022-03-10 | 699.10 | 1 | SO45172 | 2022-03-17 | 55.93 | 413.15 | |
SO55904_1 | 100 | 22378 | 538 | 7 | 2023-12-13 | 0.54 | 2023-12-01 | 21.49 | 1 | SO55904 | 2023-12-08 | 1.72 | 8.04 | |
SO45205_1 | 100 | 28420 | 344 | 7 | 2022-03-27 | 85.00 | 2022-03-15 | 3399.99 | 1 | SO45205 | 2022-03-22 | 272.00 | 1912.15 | |
SO55904_2 | 100 | 22378 | 225 | 7 | 2023-12-13 | 0.22 | 2023-12-01 | 8.99 | 2 | SO55904 | 2023-12-08 | 0.72 | 6.92 | |
SO45206_1 | 100 | 12474 | 313 | 7 | 2022-03-27 | 89.46 | 2022-03-15 | 3578.27 | 1 | SO45206 | 2022-03-22 | 286.26 | 2171.29 | |
SO55924_1 | 100 | 11587 | 363 | 7 | 2023-12-14 | 57.37 | 2023-12-02 | 2294.99 | 1 | SO55924 | 2023-12-09 | 183.60 | 1251.98 | |
SO45214_1 | 100 | 12464 | 310 | 7 | 2022-03-28 | 89.46 | 2022-03-16 | 3578.27 | 1 | SO45214 | 2022-03-23 | 286.26 | 2171.29 | |
SO55924_2 | 100 | 11587 | 537 | 7 | 2023-12-14 | 0.88 | 2023-12-02 | 35.00 | 2 | SO55924 | 2023-12-09 | 2.80 | 13.09 | |
SO45234_1 | 100 | 18009 | 328 | 7 | 2022-04-01 | 17.48 | 2022-03-20 | 699.10 | 1 | SO45234 | 2022-03-27 | 55.93 | 413.15 | |
SO55924_3 | 100 | 11587 | 480 | 7 | 2023-12-14 | 0.06 | 2023-12-02 | 2.29 | 3 | SO55924 | 2023-12-09 | 0.18 | 0.86 | |
SO45351_1 | 100 | 12520 | 313 | 7 | 2022-04-07 | 89.46 | 2022-03-26 | 3578.27 | 1 | SO45351 | 2022-04-02 | 286.26 | 2171.29 | |
SO55924_4 | 100 | 11587 | 486 | 7 | 2023-12-14 | 3.98 | 2023-12-02 | 159.00 | 4 | SO55924 | 2023-12-09 | 12.72 | 59.47 | |
SO45357_1 | 100 | 28443 | 351 | 7 | 2022-04-08 | 84.37 | 2022-03-27 | 3374.99 | 1 | SO45357 | 2022-04-03 | 270.00 | 1898.09 | |
SO55951_1 | 100 | 11581 | 491 | 7 | 2023-12-14 | 1.35 | 2023-12-02 | 53.99 | 1 | SO55951 | 2023-12-09 | 4.32 | 41.57 | |
SO45366_1 | 100 | 18011 | 330 | 7 | 2022-04-09 | 17.48 | 2022-03-28 | 699.10 | 1 | SO45366 | 2022-04-04 | 55.93 | 413.15 | |
SO55980_1 | 100 | 12332 | 376 | 7 | 2023-12-15 | 61.08 | 2023-12-03 | 2443.35 | 1 | SO55980 | 2023-12-10 | 195.47 | 1554.95 | |
SO45372_1 | 100 | 28449 | 348 | 7 | 2022-04-10 | 84.37 | 2022-03-29 | 3374.99 | 1 | SO45372 | 2022-04-05 | 270.00 | 1898.09 | |
SO55980_2 | 100 | 12332 | 529 | 7 | 2023-12-15 | 0.10 | 2023-12-03 | 3.99 | 2 | SO55980 | 2023-12-10 | 0.32 | 1.49 | |
SO45380_1 | 100 | 18010 | 324 | 7 | 2022-04-11 | 17.48 | 2022-03-30 | 699.10 | 1 | SO45380 | 2022-04-06 | 55.93 | 413.15 | |
SO55980_3 | 100 | 12332 | 540 | 7 | 2023-12-15 | 0.82 | 2023-12-03 | 32.60 | 3 | SO55980 | 2023-12-10 | 2.61 | 12.19 | |
SO45414_1 | 100 | 18038 | 330 | 7 | 2022-04-16 | 17.48 | 2022-04-04 | 699.10 | 1 | SO45414 | 2022-04-11 | 55.93 | 413.15 |
Generated 2024-09-21 09:57:56.247 UTC