[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 1000 < SKIP 1940 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63098_3 | 100 | 19722 | 463 | 4 | 2024-05-24 | 0.61 | 2024-05-12 | 24.49 | 3 | SO63098 | 2024-05-19 | 1.96 | 9.16 | |
SO69963_2 | 100 | 25431 | 540 | 4 | 2024-08-28 | 0.82 | 2024-08-16 | 32.60 | 2 | SO69963 | 2024-08-23 | 2.61 | 12.19 | |
SO47740_1 | 100 | 15337 | 325 | 4 | 2023-01-24 | 19.57 | 2023-01-12 | 782.99 | 1 | SO47740 | 2023-01-19 | 62.64 | 486.71 | |
SO63111_1 | 100 | 24668 | 564 | 4 | 2024-05-24 | 59.60 | 2024-05-12 | 2384.07 | 1 | SO63111 | 2024-05-19 | 190.73 | 1481.94 | |
SO69963_3 | 100 | 25431 | 214 | 4 | 2024-08-28 | 0.87 | 2024-08-16 | 34.99 | 3 | SO69963 | 2024-08-23 | 2.80 | 13.09 | |
SO47741_1 | 100 | 15343 | 337 | 4 | 2023-01-24 | 19.57 | 2023-01-12 | 782.99 | 1 | SO47741 | 2023-01-19 | 62.64 | 486.71 | |
SO63111_2 | 100 | 24668 | 541 | 4 | 2024-05-24 | 0.72 | 2024-05-12 | 28.99 | 2 | SO63111 | 2024-05-19 | 2.32 | 10.84 | |
SO69964_1 | 100 | 21499 | 478 | 4 | 2024-08-28 | 0.25 | 2024-08-16 | 9.99 | 1 | SO69964 | 2024-08-23 | 0.80 | 3.74 | |
SO47754_1 | 100 | 14104 | 389 | 4 | 2023-01-26 | 25.01 | 2023-01-14 | 1000.44 | 1 | SO47754 | 2023-01-21 | 80.04 | 605.65 | |
SO63111_3 | 100 | 24668 | 530 | 4 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 3 | SO63111 | 2024-05-19 | 0.40 | 1.87 | |
SO69964_2 | 100 | 21499 | 477 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 2 | SO69964 | 2024-08-23 | 0.40 | 1.87 | |
SO47760_1 | 100 | 13482 | 371 | 4 | 2023-01-26 | 54.54 | 2023-01-14 | 2181.56 | 1 | SO47760 | 2023-01-21 | 174.53 | 1320.68 | |
SO63111_4 | 100 | 24668 | 487 | 4 | 2024-05-24 | 1.37 | 2024-05-12 | 54.99 | 4 | SO63111 | 2024-05-19 | 4.40 | 20.57 | |
SO69964_3 | 100 | 21499 | 217 | 4 | 2024-08-28 | 0.87 | 2024-08-16 | 34.99 | 3 | SO69964 | 2024-08-23 | 2.80 | 13.09 | |
SO47766_1 | 100 | 26329 | 358 | 4 | 2023-01-28 | 51.23 | 2023-01-16 | 2049.10 | 1 | SO47766 | 2023-01-23 | 163.93 | 1105.81 | |
SO63112_1 | 100 | 20436 | 382 | 4 | 2024-05-24 | 28.01 | 2024-05-12 | 1120.49 | 1 | SO63112 | 2024-05-19 | 89.64 | 713.08 | |
SO69964_4 | 100 | 21499 | 228 | 4 | 2024-08-28 | 1.25 | 2024-08-16 | 49.99 | 4 | SO69964 | 2024-08-23 | 4.00 | 38.49 | |
SO47773_1 | 100 | 15345 | 325 | 4 | 2023-01-29 | 19.57 | 2023-01-17 | 782.99 | 1 | SO47773 | 2023-01-24 | 62.64 | 486.71 | |
SO63112_2 | 100 | 20436 | 477 | 4 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 2 | SO63112 | 2024-05-19 | 0.40 | 1.87 | |
SO69968_1 | 100 | 18779 | 477 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 1 | SO69968 | 2024-08-23 | 0.40 | 1.87 | |
SO47774_1 | 100 | 15346 | 333 | 4 | 2023-01-29 | 19.57 | 2023-01-17 | 782.99 | 1 | SO47774 | 2023-01-24 | 62.64 | 486.71 | |
SO63112_3 | 100 | 20436 | 479 | 4 | 2024-05-24 | 0.22 | 2024-05-12 | 8.99 | 3 | SO63112 | 2024-05-19 | 0.72 | 3.36 | |
SO69969_1 | 100 | 14390 | 528 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 1 | SO69969 | 2024-08-23 | 0.40 | 1.87 | |
SO47780_1 | 100 | 14105 | 381 | 4 | 2023-01-30 | 25.01 | 2023-01-18 | 1000.44 | 1 | SO47780 | 2023-01-25 | 80.04 | 605.65 | |
SO63306_1 | 100 | 26712 | 541 | 4 | 2024-05-25 | 0.72 | 2024-05-13 | 28.99 | 1 | SO63306 | 2024-05-20 | 2.32 | 10.84 | |
SO69969_2 | 100 | 14390 | 217 | 4 | 2024-08-28 | 0.87 | 2024-08-16 | 34.99 | 2 | SO69969 | 2024-08-23 | 2.80 | 13.09 | |
SO47789_1 | 100 | 13453 | 375 | 4 | 2023-02-01 | 54.54 | 2023-01-20 | 2181.56 | 1 | SO47789 | 2023-01-27 | 174.53 | 1320.68 | |
SO63306_2 | 100 | 26712 | 530 | 4 | 2024-05-25 | 0.12 | 2024-05-13 | 4.99 | 2 | SO63306 | 2024-05-20 | 0.40 | 1.87 | |
SO69978_1 | 100 | 11931 | 528 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 1 | SO69978 | 2024-08-23 | 0.40 | 1.87 | |
SO47814_1 | 100 | 26338 | 360 | 4 | 2023-02-04 | 51.23 | 2023-01-23 | 2049.10 | 1 | SO47814 | 2023-01-30 | 163.93 | 1105.81 | |
SO63306_3 | 100 | 26712 | 225 | 4 | 2024-05-25 | 0.22 | 2024-05-13 | 8.99 | 3 | SO63306 | 2024-05-20 | 0.72 | 6.92 | |
SO69978_2 | 100 | 11931 | 537 | 4 | 2024-08-28 | 0.88 | 2024-08-16 | 35.00 | 2 | SO69978 | 2024-08-23 | 2.80 | 13.09 | |
SO47841_1 | 100 | 26490 | 362 | 2 | 4 | 2023-02-07 | 51.23 | 2023-01-26 | 2049.10 | 1 | SO47841 | 2023-02-02 | 163.93 | 1105.81 |
SO63313_1 | 100 | 16677 | 477 | 4 | 2024-05-25 | 0.12 | 2024-05-13 | 4.99 | 1 | SO63313 | 2024-05-20 | 0.40 | 1.87 | |
SO69978_3 | 100 | 11931 | 214 | 4 | 2024-08-28 | 0.87 | 2024-08-16 | 34.99 | 3 | SO69978 | 2024-08-23 | 2.80 | 13.09 | |
SO47842_1 | 100 | 15338 | 323 | 4 | 2023-02-07 | 19.57 | 2023-01-26 | 782.99 | 1 | SO47842 | 2023-02-02 | 62.64 | 486.71 | |
SO63313_2 | 100 | 16677 | 225 | 4 | 2024-05-25 | 0.22 | 2024-05-13 | 8.99 | 2 | SO63313 | 2024-05-20 | 0.72 | 6.92 | |
SO69978_4 | 100 | 11931 | 234 | 4 | 2024-08-28 | 1.25 | 2024-08-16 | 49.99 | 4 | SO69978 | 2024-08-23 | 4.00 | 38.49 | |
SO47843_1 | 100 | 15339 | 333 | 4 | 2023-02-07 | 19.57 | 2023-01-26 | 782.99 | 1 | SO47843 | 2023-02-02 | 62.64 | 486.71 | |
SO63316_1 | 100 | 14748 | 528 | 4 | 2024-05-25 | 0.12 | 2024-05-13 | 4.99 | 1 | SO63316 | 2024-05-20 | 0.40 | 1.87 | |
SO69978_5 | 100 | 11931 | 463 | 4 | 2024-08-28 | 0.61 | 2024-08-16 | 24.49 | 5 | SO69978 | 2024-08-23 | 1.96 | 9.16 | |
SO47848_1 | 100 | 26328 | 358 | 4 | 2023-02-08 | 51.23 | 2023-01-27 | 2049.10 | 1 | SO47848 | 2023-02-03 | 163.93 | 1105.81 | |
SO63316_2 | 100 | 14748 | 483 | 4 | 2024-05-25 | 3.00 | 2024-05-13 | 120.00 | 2 | SO63316 | 2024-05-20 | 9.60 | 44.88 | |
SO69983_1 | 100 | 15342 | 587 | 4 | 2024-08-28 | 19.24 | 2024-08-16 | 769.49 | 1 | SO69983 | 2024-08-23 | 61.56 | 419.78 | |
SO47849_1 | 100 | 15342 | 323 | 4 | 2023-02-08 | 19.57 | 2023-01-27 | 782.99 | 1 | SO47849 | 2023-02-03 | 62.64 | 486.71 | |
SO63317_1 | 100 | 16017 | 528 | 4 | 2024-05-25 | 0.12 | 2024-05-13 | 4.99 | 1 | SO63317 | 2024-05-20 | 0.40 | 1.87 | |
SO69983_2 | 100 | 15342 | 475 | 4 | 2024-08-28 | 1.75 | 2024-08-16 | 69.99 | 2 | SO69983 | 2024-08-23 | 5.60 | 26.18 | |
SO47852_1 | 100 | 26342 | 354 | 4 | 2023-02-09 | 51.79 | 2023-01-28 | 2071.42 | 1 | SO47852 | 2023-02-04 | 165.71 | 1117.86 | |
SO63317_2 | 100 | 16017 | 487 | 4 | 2024-05-25 | 1.37 | 2024-05-13 | 54.99 | 2 | SO63317 | 2024-05-20 | 4.40 | 20.57 | |
SO69983_3 | 100 | 15342 | 463 | 4 | 2024-08-28 | 0.61 | 2024-08-16 | 24.49 | 3 | SO69983 | 2024-08-23 | 1.96 | 9.16 | |
SO47854_1 | 100 | 15341 | 321 | 4 | 2023-02-09 | 19.57 | 2023-01-28 | 782.99 | 1 | SO47854 | 2023-02-04 | 62.64 | 486.71 | |
SO63319_1 | 100 | 14241 | 485 | 4 | 2024-05-25 | 0.55 | 2024-05-13 | 21.98 | 1 | SO63319 | 2024-05-20 | 1.76 | 8.22 | |
SO69984_1 | 100 | 17171 | 355 | 4 | 2024-08-28 | 58.00 | 2024-08-16 | 2319.99 | 1 | SO69984 | 2024-08-23 | 185.60 | 1265.62 | |
SO47882_1 | 100 | 13464 | 375 | 4 | 2023-02-12 | 54.54 | 2023-01-31 | 2181.56 | 1 | SO47882 | 2023-02-07 | 174.53 | 1320.68 | |
SO63319_2 | 100 | 14241 | 487 | 4 | 2024-05-25 | 1.37 | 2024-05-13 | 54.99 | 2 | SO63319 | 2024-05-20 | 4.40 | 20.57 | |
SO69984_2 | 100 | 17171 | 483 | 4 | 2024-08-28 | 3.00 | 2024-08-16 | 120.00 | 2 | SO69984 | 2024-08-23 | 9.60 | 44.88 | |
SO47883_1 | 100 | 26481 | 352 | 4 | 2023-02-12 | 51.79 | 2023-01-31 | 2071.42 | 1 | SO47883 | 2023-02-07 | 165.71 | 1117.86 | |
SO63319_3 | 100 | 14241 | 484 | 4 | 2024-05-25 | 0.20 | 2024-05-13 | 7.95 | 3 | SO63319 | 2024-05-20 | 0.64 | 2.97 | |
SO69993_1 | 100 | 11175 | 585 | 4 | 2024-08-28 | 18.56 | 2024-08-16 | 742.35 | 1 | SO69993 | 2024-08-23 | 59.39 | 461.44 | |
SO47894_1 | 100 | 26344 | 358 | 4 | 2023-02-13 | 51.23 | 2023-02-01 | 2049.10 | 1 | SO47894 | 2023-02-08 | 163.93 | 1105.81 | |
SO63335_1 | 100 | 18947 | 590 | 4 | 2024-05-25 | 19.24 | 2024-05-13 | 769.49 | 1 | SO63335 | 2024-05-20 | 61.56 | 419.78 | |
SO69993_2 | 100 | 11175 | 530 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 2 | SO69993 | 2024-08-23 | 0.40 | 1.87 |
Generated 2024-11-10 13:00:13.213 UTC