[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > < SKIP 414 > < TAKE 64 >
64 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56223_1 | 98 | 23760 | 382 | 2 | 10 | 2024-02-07 | 28.01 | 2024-01-26 | 1120.49 | 1 | SO56223 | 2024-02-02 | 89.64 | 713.08 |
SO56223_2 | 98 | 23760 | 491 | 10 | 2024-02-07 | 1.35 | 2024-01-26 | 53.99 | 2 | SO56223 | 2024-02-02 | 4.32 | 41.57 | |
SO56223_3 | 98 | 23760 | 225 | 10 | 2024-02-07 | 0.22 | 2024-01-26 | 8.99 | 3 | SO56223 | 2024-02-02 | 0.72 | 6.92 | |
SO56225_1 | 98 | 12658 | 357 | 2 | 10 | 2024-02-08 | 58.00 | 2024-01-27 | 2319.99 | 1 | SO56225 | 2024-02-03 | 185.60 | 1265.62 |
SO56225_2 | 98 | 12658 | 225 | 10 | 2024-02-08 | 0.22 | 2024-01-27 | 8.99 | 2 | SO56225 | 2024-02-03 | 0.72 | 6.92 | |
SO56225_3 | 98 | 12658 | 217 | 10 | 2024-02-08 | 0.87 | 2024-01-27 | 34.99 | 3 | SO56225 | 2024-02-03 | 2.80 | 13.09 | |
SO56227_1 | 98 | 11616 | 355 | 10 | 2024-02-08 | 58.00 | 2024-01-27 | 2319.99 | 1 | SO56227 | 2024-02-03 | 185.60 | 1265.62 | |
SO56227_2 | 98 | 11616 | 478 | 10 | 2024-02-08 | 0.25 | 2024-01-27 | 9.99 | 2 | SO56227 | 2024-02-03 | 0.80 | 3.74 | |
SO56227_3 | 98 | 11616 | 477 | 10 | 2024-02-08 | 0.12 | 2024-01-27 | 4.99 | 3 | SO56227 | 2024-02-03 | 0.40 | 1.87 | |
SO56227_4 | 98 | 11616 | 489 | 10 | 2024-02-08 | 1.35 | 2024-01-27 | 53.99 | 4 | SO56227 | 2024-02-03 | 4.32 | 41.57 | |
SO56227_5 | 98 | 11616 | 225 | 10 | 2024-02-08 | 0.22 | 2024-01-27 | 8.99 | 5 | SO56227 | 2024-02-03 | 0.72 | 6.92 | |
SO56249_1 | 98 | 19946 | 528 | 10 | 2024-02-08 | 0.12 | 2024-01-27 | 4.99 | 1 | SO56249 | 2024-02-03 | 0.40 | 1.87 | |
SO56249_2 | 98 | 19946 | 535 | 10 | 2024-02-08 | 0.62 | 2024-01-27 | 24.99 | 2 | SO56249 | 2024-02-03 | 2.00 | 9.35 | |
SO56249_3 | 98 | 19946 | 485 | 10 | 2024-02-08 | 0.55 | 2024-01-27 | 21.98 | 3 | SO56249 | 2024-02-03 | 1.76 | 8.22 | |
SO56249_4 | 98 | 19946 | 214 | 10 | 2024-02-08 | 0.87 | 2024-01-27 | 34.99 | 4 | SO56249 | 2024-02-03 | 2.80 | 13.09 | |
SO56251_1 | 98 | 24546 | 536 | 10 | 2024-02-08 | 0.75 | 2024-01-27 | 29.99 | 1 | SO56251 | 2024-02-03 | 2.40 | 11.22 | |
SO56251_2 | 98 | 24546 | 528 | 10 | 2024-02-08 | 0.12 | 2024-01-27 | 4.99 | 2 | SO56251 | 2024-02-03 | 0.40 | 1.87 | |
SO56251_3 | 98 | 24546 | 480 | 10 | 2024-02-08 | 0.06 | 2024-01-27 | 2.29 | 3 | SO56251 | 2024-02-03 | 0.18 | 0.86 | |
SO56276_1 | 98 | 20852 | 582 | 10 | 2024-02-09 | 42.52 | 2024-01-28 | 1700.99 | 1 | SO56276 | 2024-02-04 | 136.08 | 1082.51 | |
SO56276_2 | 98 | 20852 | 491 | 10 | 2024-02-09 | 1.35 | 2024-01-28 | 53.99 | 2 | SO56276 | 2024-02-04 | 4.32 | 41.57 | |
SO56276_3 | 98 | 20852 | 225 | 10 | 2024-02-09 | 0.22 | 2024-01-28 | 8.99 | 3 | SO56276 | 2024-02-04 | 0.72 | 6.92 | |
SO56278_1 | 98 | 17720 | 593 | 10 | 2024-02-09 | 14.12 | 2024-01-28 | 564.99 | 1 | SO56278 | 2024-02-04 | 45.20 | 308.22 | |
SO56278_2 | 98 | 17720 | 225 | 10 | 2024-02-09 | 0.22 | 2024-01-28 | 8.99 | 2 | SO56278 | 2024-02-04 | 0.72 | 6.92 | |
SO56278_3 | 98 | 17720 | 217 | 10 | 2024-02-09 | 0.87 | 2024-01-28 | 34.99 | 3 | SO56278 | 2024-02-04 | 2.80 | 13.09 | |
SO56311_1 | 98 | 11580 | 222 | 10 | 2024-02-09 | 0.87 | 2024-01-28 | 34.99 | 1 | SO56311 | 2024-02-04 | 2.80 | 13.09 | |
SO56317_1 | 98 | 14843 | 570 | 10 | 2024-02-09 | 18.56 | 2024-01-28 | 742.35 | 1 | SO56317 | 2024-02-04 | 59.39 | 461.44 | |
SO56317_2 | 98 | 14843 | 222 | 10 | 2024-02-09 | 0.87 | 2024-01-28 | 34.99 | 2 | SO56317 | 2024-02-04 | 2.80 | 13.09 | |
SO56336_1 | 98 | 11612 | 359 | 10 | 2024-02-10 | 57.37 | 2024-01-29 | 2294.99 | 1 | SO56336 | 2024-02-05 | 183.60 | 1251.98 | |
SO56336_2 | 98 | 11612 | 485 | 10 | 2024-02-10 | 0.55 | 2024-01-29 | 21.98 | 2 | SO56336 | 2024-02-05 | 1.76 | 8.22 | |
SO56336_3 | 98 | 11612 | 478 | 10 | 2024-02-10 | 0.25 | 2024-01-29 | 9.99 | 3 | SO56336 | 2024-02-05 | 0.80 | 3.74 | |
SO56343_1 | 98 | 20851 | 583 | 10 | 2024-02-10 | 42.52 | 2024-01-29 | 1700.99 | 1 | SO56343 | 2024-02-05 | 136.08 | 1082.51 | |
SO56343_2 | 98 | 20851 | 222 | 10 | 2024-02-10 | 0.87 | 2024-01-29 | 34.99 | 2 | SO56343 | 2024-02-05 | 2.80 | 13.09 | |
SO56344_1 | 98 | 20856 | 580 | 10 | 2024-02-10 | 42.52 | 2024-01-29 | 1700.99 | 1 | SO56344 | 2024-02-05 | 136.08 | 1082.51 | |
SO56359_1 | 98 | 20570 | 535 | 10 | 2024-02-10 | 0.62 | 2024-01-29 | 24.99 | 1 | SO56359 | 2024-02-05 | 2.00 | 9.35 | |
SO44432_1 | 98 | 14165 | 314 | 10 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO44432 | 2022-02-07 | 286.26 | 2171.29 | |
SO44439_1 | 98 | 14195 | 310 | 10 | 2022-02-14 | 89.46 | 2022-02-02 | 3578.27 | 1 | SO44439 | 2022-02-09 | 286.26 | 2171.29 | |
SO44452_1 | 98 | 20164 | 332 | 10 | 2022-02-18 | 17.48 | 2022-02-06 | 699.10 | 1 | SO44452 | 2022-02-13 | 55.93 | 413.15 | |
SO44460_1 | 98 | 20150 | 334 | 10 | 2022-02-19 | 17.48 | 2022-02-07 | 699.10 | 1 | SO44460 | 2022-02-14 | 55.93 | 413.15 | |
SO44462_1 | 98 | 14155 | 311 | 10 | 2022-02-20 | 89.46 | 2022-02-08 | 3578.27 | 1 | SO44462 | 2022-02-15 | 286.26 | 2171.29 | |
SO44602_1 | 98 | 14702 | 314 | 10 | 2022-03-01 | 89.46 | 2022-02-17 | 3578.27 | 1 | SO44602 | 2022-02-24 | 286.26 | 2171.29 | |
SO44603_1 | 98 | 20167 | 342 | 10 | 2022-03-01 | 17.48 | 2022-02-17 | 699.10 | 1 | SO44603 | 2022-02-24 | 55.93 | 413.15 | |
SO44636_1 | 98 | 14705 | 314 | 10 | 2022-03-06 | 89.46 | 2022-02-22 | 3578.27 | 1 | SO44636 | 2022-03-01 | 286.26 | 2171.29 | |
SO44645_1 | 98 | 11344 | 344 | 10 | 2022-03-07 | 85.00 | 2022-02-23 | 3399.99 | 1 | SO44645 | 2022-03-02 | 272.00 | 1912.15 | |
SO44651_1 | 98 | 14720 | 313 | 10 | 2022-03-08 | 89.46 | 2022-02-24 | 3578.27 | 1 | SO44651 | 2022-03-03 | 286.26 | 2171.29 | |
SO44653_1 | 98 | 20170 | 326 | 10 | 2022-03-08 | 17.48 | 2022-02-24 | 699.10 | 1 | SO44653 | 2022-03-03 | 55.93 | 413.15 | |
SO44686_1 | 98 | 14712 | 313 | 10 | 2022-03-14 | 89.46 | 2022-03-02 | 3578.27 | 1 | SO44686 | 2022-03-09 | 286.26 | 2171.29 | |
SO44687_1 | 98 | 20172 | 342 | 10 | 2022-03-14 | 17.48 | 2022-03-02 | 699.10 | 1 | SO44687 | 2022-03-09 | 55.93 | 413.15 | |
SO44719_1 | 98 | 14700 | 313 | 10 | 2022-03-21 | 89.46 | 2022-03-09 | 3578.27 | 1 | SO44719 | 2022-03-16 | 286.26 | 2171.29 | |
SO44730_1 | 98 | 14697 | 311 | 10 | 2022-03-23 | 89.46 | 2022-03-11 | 3578.27 | 1 | SO44730 | 2022-03-18 | 286.26 | 2171.29 | |
SO44809_1 | 98 | 20552 | 342 | 10 | 2022-03-26 | 17.48 | 2022-03-14 | 699.10 | 1 | SO44809 | 2022-03-21 | 55.93 | 413.15 | |
SO44817_1 | 98 | 14777 | 312 | 10 | 2022-03-27 | 89.46 | 2022-03-15 | 3578.27 | 1 | SO44817 | 2022-03-22 | 286.26 | 2171.29 | |
SO44867_1 | 98 | 14793 | 313 | 10 | 2022-04-02 | 89.46 | 2022-03-21 | 3578.27 | 1 | SO44867 | 2022-03-28 | 286.26 | 2171.29 | |
SO44885_1 | 98 | 14833 | 310 | 10 | 2022-04-05 | 89.46 | 2022-03-24 | 3578.27 | 1 | SO44885 | 2022-03-31 | 286.26 | 2171.29 | |
SO44889_1 | 98 | 11351 | 348 | 10 | 2022-04-06 | 84.37 | 2022-03-25 | 3374.99 | 1 | SO44889 | 2022-04-01 | 270.00 | 1898.09 | |
SO44890_1 | 98 | 11381 | 346 | 10 | 2022-04-06 | 85.00 | 2022-03-25 | 3399.99 | 1 | SO44890 | 2022-04-01 | 272.00 | 1912.15 | |
SO44899_1 | 98 | 11353 | 351 | 10 | 2022-04-06 | 84.37 | 2022-03-25 | 3374.99 | 1 | SO44899 | 2022-04-01 | 270.00 | 1898.09 | |
SO44900_1 | 98 | 14778 | 314 | 10 | 2022-04-07 | 89.46 | 2022-03-26 | 3578.27 | 1 | SO44900 | 2022-04-02 | 286.26 | 2171.29 | |
SO44906_1 | 98 | 14832 | 311 | 10 | 2022-04-08 | 89.46 | 2022-03-27 | 3578.27 | 1 | SO44906 | 2022-04-03 | 286.26 | 2171.29 | |
SO44928_1 | 98 | 14843 | 314 | 10 | 2022-04-11 | 89.46 | 2022-03-30 | 3578.27 | 1 | SO44928 | 2022-04-06 | 286.26 | 2171.29 | |
SO44934_1 | 98 | 14771 | 312 | 10 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO44934 | 2022-04-07 | 286.26 | 2171.29 | |
SO44958_1 | 98 | 20173 | 332 | 10 | 2022-04-14 | 17.48 | 2022-04-02 | 699.10 | 1 | SO44958 | 2022-04-09 | 55.93 | 413.15 | |
SO44967_1 | 98 | 14794 | 310 | 10 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO44967 | 2022-04-10 | 286.26 | 2171.29 | |
SO44974_1 | 98 | 14776 | 312 | 10 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO44974 | 2022-04-11 | 286.26 | 2171.29 | |
SO45008_1 | 98 | 14831 | 313 | 10 | 2022-04-21 | 89.46 | 2022-04-09 | 3578.27 | 1 | SO45008 | 2022-04-16 | 286.26 | 2171.29 |
Generated 2024-11-10 17:36:50.420 UTC