[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > < SKIP 1130 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69322_2 | 98 | 20921 | 484 | 10 | 2024-07-02 | 0.20 | 2024-06-20 | 7.95 | 2 | SO69322 | 2024-06-27 | 0.64 | 2.97 | |
SO69323_1 | 98 | 19186 | 598 | 10 | 2024-07-02 | 13.50 | 2024-06-20 | 539.99 | 1 | SO69323 | 2024-06-27 | 43.20 | 294.58 | |
SO69323_2 | 98 | 19186 | 485 | 10 | 2024-07-02 | 0.55 | 2024-06-20 | 21.98 | 2 | SO69323 | 2024-06-27 | 1.76 | 8.22 | |
SO69324_1 | 98 | 18021 | 597 | 10 | 2024-07-02 | 13.50 | 2024-06-20 | 539.99 | 1 | SO69324 | 2024-06-27 | 43.20 | 294.58 | |
SO69324_2 | 98 | 18021 | 485 | 10 | 2024-07-02 | 0.55 | 2024-06-20 | 21.98 | 2 | SO69324 | 2024-06-27 | 1.76 | 8.22 | |
SO69324_3 | 98 | 18021 | 234 | 10 | 2024-07-02 | 1.25 | 2024-06-20 | 49.99 | 3 | SO69324 | 2024-06-27 | 4.00 | 38.49 | |
SO69347_1 | 98 | 15610 | 528 | 10 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO69347 | 2024-06-27 | 0.40 | 1.87 | |
SO69347_2 | 98 | 15610 | 537 | 10 | 2024-07-02 | 0.88 | 2024-06-20 | 35.00 | 2 | SO69347 | 2024-06-27 | 2.80 | 13.09 | |
SO69347_3 | 98 | 15610 | 222 | 10 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 3 | SO69347 | 2024-06-27 | 2.80 | 13.09 | |
SO69348_1 | 98 | 21116 | 528 | 10 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO69348 | 2024-06-27 | 0.40 | 1.87 | |
SO69348_2 | 98 | 21116 | 536 | 10 | 2024-07-02 | 0.75 | 2024-06-20 | 29.99 | 2 | SO69348 | 2024-06-27 | 2.40 | 11.22 | |
SO69348_3 | 98 | 21116 | 225 | 10 | 2024-07-02 | 0.22 | 2024-06-20 | 8.99 | 3 | SO69348 | 2024-06-27 | 0.72 | 6.92 | |
SO69348_4 | 98 | 21116 | 222 | 10 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 4 | SO69348 | 2024-06-27 | 2.80 | 13.09 | |
SO69350_1 | 98 | 27848 | 529 | 10 | 2024-07-02 | 0.10 | 2024-06-20 | 3.99 | 1 | SO69350 | 2024-06-27 | 0.32 | 1.49 | |
SO69350_2 | 98 | 27848 | 538 | 10 | 2024-07-02 | 0.54 | 2024-06-20 | 21.49 | 2 | SO69350 | 2024-06-27 | 1.72 | 8.04 | |
SO69350_3 | 98 | 27848 | 480 | 10 | 2024-07-02 | 0.06 | 2024-06-20 | 2.29 | 3 | SO69350 | 2024-06-27 | 0.18 | 0.86 | |
SO69351_1 | 98 | 24581 | 477 | 10 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO69351 | 2024-06-27 | 0.40 | 1.87 | |
SO69351_2 | 98 | 24581 | 217 | 10 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 2 | SO69351 | 2024-06-27 | 2.80 | 13.09 | |
SO69362_1 | 98 | 11586 | 225 | 10 | 2024-07-02 | 0.22 | 2024-06-20 | 8.99 | 1 | SO69362 | 2024-06-27 | 0.72 | 6.92 | |
SO69363_1 | 98 | 12590 | 225 | 10 | 2024-07-02 | 0.22 | 2024-06-20 | 8.99 | 1 | SO69363 | 2024-06-27 | 0.72 | 6.92 | |
SO69385_1 | 98 | 24200 | 382 | 10 | 2024-07-02 | 28.01 | 2024-06-20 | 1120.49 | 1 | SO69385 | 2024-06-27 | 89.64 | 713.08 | |
SO69610_1 | 98 | 12545 | 538 | 10 | 2024-07-03 | 0.54 | 2024-06-21 | 21.49 | 1 | SO69610 | 2024-06-28 | 1.72 | 8.04 | |
SO63915_1 | 98 | 14554 | 541 | 10 | 2024-04-13 | 0.72 | 2024-04-01 | 28.99 | 1 | SO63915 | 2024-04-08 | 2.32 | 10.84 | |
SO63915_2 | 98 | 14554 | 530 | 10 | 2024-04-13 | 0.12 | 2024-04-01 | 4.99 | 2 | SO63915 | 2024-04-08 | 0.40 | 1.87 | |
SO63915_3 | 98 | 14554 | 228 | 10 | 2024-04-13 | 1.25 | 2024-04-01 | 49.99 | 3 | SO63915 | 2024-04-08 | 4.00 | 38.49 | |
SO63915_4 | 98 | 14554 | 467 | 2 | 10 | 2024-04-13 | 0.61 | 2024-04-01 | 24.49 | 4 | SO63915 | 2024-04-08 | 1.96 | 9.16 |
SO63917_1 | 98 | 12551 | 529 | 10 | 2024-04-13 | 0.10 | 2024-04-01 | 3.99 | 1 | SO63917 | 2024-04-08 | 0.32 | 1.49 | |
SO63917_2 | 98 | 12551 | 538 | 10 | 2024-04-13 | 0.54 | 2024-04-01 | 21.49 | 2 | SO63917 | 2024-04-08 | 1.72 | 8.04 | |
SO63956_1 | 98 | 22396 | 581 | 10 | 2024-04-14 | 42.52 | 2024-04-02 | 1700.99 | 1 | SO63956 | 2024-04-09 | 136.08 | 1082.51 | |
SO63956_2 | 98 | 22396 | 539 | 10 | 2024-04-14 | 0.62 | 2024-04-02 | 24.99 | 2 | SO63956 | 2024-04-09 | 2.00 | 9.35 | |
SO63957_1 | 98 | 16275 | 589 | 10 | 2024-04-14 | 19.24 | 2024-04-02 | 769.49 | 1 | SO63957 | 2024-04-09 | 61.56 | 419.78 | |
SO63957_2 | 98 | 16275 | 476 | 10 | 2024-04-14 | 1.75 | 2024-04-02 | 69.99 | 2 | SO63957 | 2024-04-09 | 5.60 | 26.18 | |
SO63959_1 | 98 | 15933 | 361 | 10 | 2024-04-14 | 57.37 | 2024-04-02 | 2294.99 | 1 | SO63959 | 2024-04-09 | 183.60 | 1251.98 | |
SO63959_2 | 98 | 15933 | 480 | 10 | 2024-04-14 | 0.06 | 2024-04-02 | 2.29 | 2 | SO63959 | 2024-04-09 | 0.18 | 0.86 | |
SO63960_1 | 98 | 16575 | 355 | 10 | 2024-04-14 | 58.00 | 2024-04-02 | 2319.99 | 1 | SO63960 | 2024-04-09 | 185.60 | 1265.62 | |
SO63960_2 | 98 | 16575 | 478 | 10 | 2024-04-14 | 0.25 | 2024-04-02 | 9.99 | 2 | SO63960 | 2024-04-09 | 0.80 | 3.74 | |
SO63960_3 | 98 | 16575 | 477 | 10 | 2024-04-14 | 0.12 | 2024-04-02 | 4.99 | 3 | SO63960 | 2024-04-09 | 0.40 | 1.87 | |
SO63960_4 | 98 | 16575 | 225 | 10 | 2024-04-14 | 0.22 | 2024-04-02 | 8.99 | 4 | SO63960 | 2024-04-09 | 0.72 | 6.92 | |
SO63981_1 | 98 | 12599 | 578 | 10 | 2024-04-14 | 30.37 | 2024-04-02 | 1214.85 | 1 | SO63981 | 2024-04-09 | 97.19 | 755.15 | |
SO63981_2 | 98 | 12599 | 477 | 10 | 2024-04-14 | 0.12 | 2024-04-02 | 4.99 | 2 | SO63981 | 2024-04-09 | 0.40 | 1.87 | |
SO63981_3 | 98 | 12599 | 479 | 10 | 2024-04-14 | 0.22 | 2024-04-02 | 8.99 | 3 | SO63981 | 2024-04-09 | 0.72 | 3.36 | |
SO64028_1 | 98 | 20951 | 536 | 10 | 2024-04-15 | 0.75 | 2024-04-03 | 29.99 | 1 | SO64028 | 2024-04-10 | 2.40 | 11.22 | |
SO64028_2 | 98 | 20951 | 528 | 10 | 2024-04-15 | 0.12 | 2024-04-03 | 4.99 | 2 | SO64028 | 2024-04-10 | 0.40 | 1.87 | |
SO64028_3 | 98 | 20951 | 480 | 10 | 2024-04-15 | 0.06 | 2024-04-03 | 2.29 | 3 | SO64028 | 2024-04-10 | 0.18 | 0.86 | |
SO64029_1 | 98 | 24555 | 528 | 10 | 2024-04-15 | 0.12 | 2024-04-03 | 4.99 | 1 | SO64029 | 2024-04-10 | 0.40 | 1.87 | |
SO64029_2 | 98 | 24555 | 536 | 10 | 2024-04-15 | 0.75 | 2024-04-03 | 29.99 | 2 | SO64029 | 2024-04-10 | 2.40 | 11.22 | |
SO64029_3 | 98 | 24555 | 478 | 10 | 2024-04-15 | 0.25 | 2024-04-03 | 9.99 | 3 | SO64029 | 2024-04-10 | 0.80 | 3.74 | |
SO64029_4 | 98 | 24555 | 477 | 10 | 2024-04-15 | 0.12 | 2024-04-03 | 4.99 | 4 | SO64029 | 2024-04-10 | 0.40 | 1.87 | |
SO64029_5 | 98 | 24555 | 225 | 10 | 2024-04-15 | 0.22 | 2024-04-03 | 8.99 | 5 | SO64029 | 2024-04-10 | 0.72 | 6.92 | |
SO64048_1 | 98 | 27171 | 606 | 10 | 2024-04-15 | 13.50 | 2024-04-03 | 539.99 | 1 | SO64048 | 2024-04-10 | 43.20 | 343.65 | |
SO64048_2 | 98 | 27171 | 477 | 10 | 2024-04-15 | 0.12 | 2024-04-03 | 4.99 | 2 | SO64048 | 2024-04-10 | 0.40 | 1.87 | |
SO64048_3 | 98 | 27171 | 479 | 10 | 2024-04-15 | 0.22 | 2024-04-03 | 8.99 | 3 | SO64048 | 2024-04-10 | 0.72 | 3.36 | |
SO64048_4 | 98 | 27171 | 214 | 10 | 2024-04-15 | 0.87 | 2024-04-03 | 34.99 | 4 | SO64048 | 2024-04-10 | 2.80 | 13.09 | |
SO64049_1 | 98 | 15699 | 562 | 10 | 2024-04-15 | 59.60 | 2024-04-03 | 2384.07 | 1 | SO64049 | 2024-04-10 | 190.73 | 1481.94 | |
SO64049_2 | 98 | 15699 | 479 | 10 | 2024-04-15 | 0.22 | 2024-04-03 | 8.99 | 2 | SO64049 | 2024-04-10 | 0.72 | 3.36 | |
SO64049_3 | 98 | 15699 | 477 | 10 | 2024-04-15 | 0.12 | 2024-04-03 | 4.99 | 3 | SO64049 | 2024-04-10 | 0.40 | 1.87 | |
SO64049_4 | 98 | 15699 | 214 | 10 | 2024-04-15 | 0.87 | 2024-04-03 | 34.99 | 4 | SO64049 | 2024-04-10 | 2.80 | 13.09 | |
SO64049_5 | 98 | 15699 | 234 | 10 | 2024-04-15 | 1.25 | 2024-04-03 | 49.99 | 5 | SO64049 | 2024-04-10 | 4.00 | 38.49 | |
SO64054_1 | 98 | 22321 | 580 | 10 | 2024-04-16 | 42.52 | 2024-04-04 | 1700.99 | 1 | SO64054 | 2024-04-11 | 136.08 | 1082.51 | |
SO64069_1 | 98 | 17792 | 588 | 10 | 2024-04-16 | 19.24 | 2024-04-04 | 769.49 | 1 | SO64069 | 2024-04-11 | 61.56 | 419.78 | |
SO64069_2 | 98 | 17792 | 478 | 10 | 2024-04-16 | 0.25 | 2024-04-04 | 9.99 | 2 | SO64069 | 2024-04-11 | 0.80 | 3.74 | |
SO64069_3 | 98 | 17792 | 222 | 10 | 2024-04-16 | 0.87 | 2024-04-04 | 34.99 | 3 | SO64069 | 2024-04-11 | 2.80 | 13.09 | |
SO64069_4 | 98 | 17792 | 225 | 10 | 2024-04-16 | 0.22 | 2024-04-04 | 8.99 | 4 | SO64069 | 2024-04-11 | 0.72 | 6.92 | |
SO64070_1 | 98 | 16829 | 361 | 10 | 2024-04-16 | 57.37 | 2024-04-04 | 2294.99 | 1 | SO64070 | 2024-04-11 | 183.60 | 1251.98 | |
SO64070_2 | 98 | 16829 | 478 | 10 | 2024-04-16 | 0.25 | 2024-04-04 | 9.99 | 2 | SO64070 | 2024-04-11 | 0.80 | 3.74 | |
SO64070_3 | 98 | 16829 | 222 | 10 | 2024-04-16 | 0.87 | 2024-04-04 | 34.99 | 3 | SO64070 | 2024-04-11 | 2.80 | 13.09 | |
SO64070_4 | 98 | 16829 | 225 | 10 | 2024-04-16 | 0.22 | 2024-04-04 | 8.99 | 4 | SO64070 | 2024-04-11 | 0.72 | 6.92 | |
SO64071_1 | 98 | 16822 | 359 | 10 | 2024-04-16 | 57.37 | 2024-04-04 | 2294.99 | 1 | SO64071 | 2024-04-11 | 183.60 | 1251.98 | |
SO64071_2 | 98 | 16822 | 478 | 10 | 2024-04-16 | 0.25 | 2024-04-04 | 9.99 | 2 | SO64071 | 2024-04-11 | 0.80 | 3.74 | |
SO64094_1 | 98 | 24554 | 528 | 10 | 2024-04-16 | 0.12 | 2024-04-04 | 4.99 | 1 | SO64094 | 2024-04-11 | 0.40 | 1.87 | |
SO64094_2 | 98 | 24554 | 536 | 10 | 2024-04-16 | 0.75 | 2024-04-04 | 29.99 | 2 | SO64094 | 2024-04-11 | 2.40 | 11.22 | |
SO64094_3 | 98 | 24554 | 222 | 10 | 2024-04-16 | 0.87 | 2024-04-04 | 34.99 | 3 | SO64094 | 2024-04-11 | 2.80 | 13.09 | |
SO64096_1 | 98 | 27165 | 529 | 10 | 2024-04-16 | 0.10 | 2024-04-04 | 3.99 | 1 | SO64096 | 2024-04-11 | 0.32 | 1.49 | |
SO64114_1 | 98 | 27141 | 584 | 10 | 2024-04-16 | 13.50 | 2024-04-04 | 539.99 | 1 | SO64114 | 2024-04-11 | 43.20 | 343.65 | |
SO64114_2 | 98 | 27141 | 214 | 10 | 2024-04-16 | 0.87 | 2024-04-04 | 34.99 | 2 | SO64114 | 2024-04-11 | 2.80 | 13.09 | |
SO64124_1 | 98 | 22309 | 583 | 10 | 2024-04-17 | 42.52 | 2024-04-05 | 1700.99 | 1 | SO64124 | 2024-04-12 | 136.08 | 1082.51 | |
SO64124_2 | 98 | 22309 | 222 | 10 | 2024-04-17 | 0.87 | 2024-04-05 | 34.99 | 2 | SO64124 | 2024-04-12 | 2.80 | 13.09 | |
SO64124_3 | 98 | 22309 | 237 | 10 | 2024-04-17 | 1.25 | 2024-04-05 | 49.99 | 3 | SO64124 | 2024-04-12 | 4.00 | 38.49 | |
SO64128_1 | 98 | 12874 | 363 | 10 | 2024-04-17 | 57.37 | 2024-04-05 | 2294.99 | 1 | SO64128 | 2024-04-12 | 183.60 | 1251.98 | |
SO64128_2 | 98 | 12874 | 487 | 10 | 2024-04-17 | 1.37 | 2024-04-05 | 54.99 | 2 | SO64128 | 2024-04-12 | 4.40 | 20.57 | |
SO64128_3 | 98 | 12874 | 480 | 10 | 2024-04-17 | 0.06 | 2024-04-05 | 2.29 | 3 | SO64128 | 2024-04-12 | 0.18 | 0.86 | |
SO64144_1 | 98 | 20599 | 528 | 10 | 2024-04-17 | 0.12 | 2024-04-05 | 4.99 | 1 | SO64144 | 2024-04-12 | 0.40 | 1.87 | |
SO64144_2 | 98 | 20599 | 535 | 10 | 2024-04-17 | 0.62 | 2024-04-05 | 24.99 | 2 | SO64144 | 2024-04-12 | 2.00 | 9.35 | |
SO64144_3 | 98 | 20599 | 480 | 2 | 10 | 2024-04-17 | 0.06 | 2024-04-05 | 2.29 | 3 | SO64144 | 2024-04-12 | 0.18 | 0.86 |
SO64146_1 | 98 | 20907 | 536 | 10 | 2024-04-17 | 0.75 | 2024-04-05 | 29.99 | 1 | SO64146 | 2024-04-12 | 2.40 | 11.22 | |
SO64146_2 | 98 | 20907 | 480 | 2 | 10 | 2024-04-17 | 0.06 | 2024-04-05 | 2.29 | 2 | SO64146 | 2024-04-12 | 0.18 | 0.86 |
SO44432_1 | 98 | 14165 | 314 | 10 | 2021-12-23 | 89.46 | 2021-12-11 | 3578.27 | 1 | SO44432 | 2021-12-18 | 286.26 | 2171.29 | |
SO44439_1 | 98 | 14195 | 310 | 10 | 2021-12-25 | 89.46 | 2021-12-13 | 3578.27 | 1 | SO44439 | 2021-12-20 | 286.26 | 2171.29 | |
SO44452_1 | 98 | 20164 | 332 | 10 | 2021-12-29 | 17.48 | 2021-12-17 | 699.10 | 1 | SO44452 | 2021-12-24 | 55.93 | 413.15 | |
SO44460_1 | 98 | 20150 | 334 | 10 | 2021-12-30 | 17.48 | 2021-12-18 | 699.10 | 1 | SO44460 | 2021-12-25 | 55.93 | 413.15 | |
SO44462_1 | 98 | 14155 | 311 | 10 | 2021-12-31 | 89.46 | 2021-12-19 | 3578.27 | 1 | SO44462 | 2021-12-26 | 286.26 | 2171.29 | |
SO44602_1 | 98 | 14702 | 314 | 10 | 2022-01-09 | 89.46 | 2021-12-28 | 3578.27 | 1 | SO44602 | 2022-01-04 | 286.26 | 2171.29 | |
SO44603_1 | 98 | 20167 | 342 | 10 | 2022-01-09 | 17.48 | 2021-12-28 | 699.10 | 1 | SO44603 | 2022-01-04 | 55.93 | 413.15 | |
SO44636_1 | 98 | 14705 | 314 | 10 | 2022-01-14 | 89.46 | 2022-01-02 | 3578.27 | 1 | SO44636 | 2022-01-09 | 286.26 | 2171.29 | |
SO44645_1 | 98 | 11344 | 344 | 10 | 2022-01-15 | 85.00 | 2022-01-03 | 3399.99 | 1 | SO44645 | 2022-01-10 | 272.00 | 1912.15 | |
SO44651_1 | 98 | 14720 | 313 | 10 | 2022-01-16 | 89.46 | 2022-01-04 | 3578.27 | 1 | SO44651 | 2022-01-11 | 286.26 | 2171.29 |
Generated 2024-09-21 02:54:21.056 UTC