[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 1377 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63926_1 | 19 | 15997 | 353 | 6 | 2024-06-03 | 58.00 | 2024-05-22 | 2319.99 | 1 | SO63926 | 2024-05-29 | 185.60 | 1265.62 | |
SO70350_4 | 19 | 19844 | 222 | 6 | 2024-09-02 | 0.87 | 2024-08-21 | 34.99 | 4 | SO70350 | 2024-08-28 | 2.80 | 13.09 | |
SO45502_1 | 100 | 28173 | 314 | 6 | 2022-06-20 | 89.46 | 2022-06-08 | 3578.27 | 1 | SO45502 | 2022-06-15 | 286.26 | 2171.29 | |
SO56254_3 | 19 | 12202 | 480 | 6 | 2024-02-08 | 0.06 | 2024-01-27 | 2.29 | 3 | SO56254 | 2024-02-03 | 0.18 | 0.86 | |
SO63926_2 | 19 | 15997 | 537 | 6 | 2024-06-03 | 0.88 | 2024-05-22 | 35.00 | 2 | SO63926 | 2024-05-29 | 2.80 | 13.09 | |
SO70350_5 | 19 | 19844 | 489 | 6 | 2024-09-02 | 1.35 | 2024-08-21 | 53.99 | 5 | SO70350 | 2024-08-28 | 4.32 | 41.57 | |
SO45503_1 | 19 | 22995 | 314 | 6 | 2022-06-20 | 89.46 | 2022-06-08 | 3578.27 | 1 | SO45503 | 2022-06-15 | 286.26 | 2171.29 | |
SO56271_1 | 19 | 21336 | 605 | 6 | 2024-02-08 | 13.50 | 2024-01-27 | 539.99 | 1 | SO56271 | 2024-02-03 | 43.20 | 343.65 | |
SO63926_3 | 19 | 15997 | 528 | 6 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 3 | SO63926 | 2024-05-29 | 0.40 | 1.87 | |
SO70350_6 | 19 | 19844 | 225 | 6 | 2024-09-02 | 0.22 | 2024-08-21 | 8.99 | 6 | SO70350 | 2024-08-28 | 0.72 | 6.92 | |
SO45510_1 | 19 | 22998 | 310 | 6 | 2022-06-21 | 89.46 | 2022-06-09 | 3578.27 | 1 | SO45510 | 2022-06-16 | 286.26 | 2171.29 | |
SO56271_2 | 19 | 21336 | 479 | 6 | 2024-02-08 | 0.22 | 2024-01-27 | 8.99 | 2 | SO56271 | 2024-02-03 | 0.72 | 3.36 | |
SO63926_4 | 19 | 15997 | 480 | 6 | 2024-06-03 | 0.06 | 2024-05-22 | 2.29 | 4 | SO63926 | 2024-05-29 | 0.18 | 0.86 | |
SO70366_1 | 19 | 20350 | 384 | 6 | 2024-09-02 | 28.01 | 2024-08-21 | 1120.49 | 1 | SO70366 | 2024-08-28 | 89.64 | 713.08 | |
SO45514_1 | 100 | 28051 | 314 | 6 | 2022-06-22 | 89.46 | 2022-06-10 | 3578.27 | 1 | SO45514 | 2022-06-17 | 286.26 | 2171.29 | |
SO56271_3 | 19 | 21336 | 484 | 6 | 2024-02-08 | 0.20 | 2024-01-27 | 7.95 | 3 | SO56271 | 2024-02-03 | 0.64 | 2.97 | |
SO63927_1 | 19 | 16000 | 359 | 6 | 2024-06-03 | 57.37 | 2024-05-22 | 2294.99 | 1 | SO63927 | 2024-05-29 | 183.60 | 1251.98 | |
SO70366_2 | 19 | 20350 | 214 | 6 | 2024-09-02 | 0.87 | 2024-08-21 | 34.99 | 2 | SO70366 | 2024-08-28 | 2.80 | 13.09 | |
SO45582_1 | 100 | 28656 | 312 | 6 | 2022-06-23 | 89.46 | 2022-06-11 | 3578.27 | 1 | SO45582 | 2022-06-18 | 286.26 | 2171.29 | |
SO56281_1 | 19 | 11277 | 530 | 6 | 2024-02-09 | 0.12 | 2024-01-28 | 4.99 | 1 | SO56281 | 2024-02-04 | 0.40 | 1.87 | |
SO63927_2 | 19 | 16000 | 485 | 6 | 2024-06-03 | 0.55 | 2024-05-22 | 21.98 | 2 | SO63927 | 2024-05-29 | 1.76 | 8.22 | |
SO70367_1 | 19 | 20373 | 386 | 6 | 2024-09-02 | 28.01 | 2024-08-21 | 1120.49 | 1 | SO70367 | 2024-08-28 | 89.64 | 713.08 | |
SO45614_1 | 19 | 23385 | 312 | 6 | 2022-06-28 | 89.46 | 2022-06-16 | 3578.27 | 1 | SO45614 | 2022-06-23 | 286.26 | 2171.29 | |
SO56281_2 | 19 | 11277 | 487 | 6 | 2024-02-09 | 1.37 | 2024-01-28 | 54.99 | 2 | SO56281 | 2024-02-04 | 4.40 | 20.57 | |
SO63927_3 | 19 | 16000 | 478 | 6 | 2024-06-03 | 0.25 | 2024-05-22 | 9.99 | 3 | SO63927 | 2024-05-29 | 0.80 | 3.74 | |
SO70367_2 | 19 | 20373 | 217 | 6 | 2024-09-02 | 0.87 | 2024-08-21 | 34.99 | 2 | SO70367 | 2024-08-28 | 2.80 | 13.09 | |
SO45635_1 | 19 | 23351 | 313 | 6 | 2022-07-01 | 89.46 | 2022-06-19 | 3578.27 | 1 | SO45635 | 2022-06-26 | 286.26 | 2171.29 | |
SO56281_3 | 19 | 11277 | 484 | 6 | 2024-02-09 | 0.20 | 2024-01-28 | 7.95 | 3 | SO56281 | 2024-02-04 | 0.64 | 2.97 | |
SO63927_4 | 19 | 16000 | 477 | 6 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 4 | SO63927 | 2024-05-29 | 0.40 | 1.87 | |
SO70393_1 | 19 | 17338 | 535 | 6 | 2024-09-03 | 0.62 | 2024-08-22 | 24.99 | 1 | SO70393 | 2024-08-29 | 2.00 | 9.35 | |
SO45641_1 | 19 | 23306 | 311 | 6 | 2022-07-02 | 89.46 | 2022-06-20 | 3578.27 | 1 | SO45641 | 2022-06-27 | 286.26 | 2171.29 | |
SO56282_1 | 19 | 11520 | 529 | 6 | 2024-02-09 | 0.10 | 2024-01-28 | 3.99 | 1 | SO56282 | 2024-02-04 | 0.32 | 1.49 | |
SO63927_5 | 19 | 16000 | 487 | 6 | 2024-06-03 | 1.37 | 2024-05-22 | 54.99 | 5 | SO63927 | 2024-05-29 | 4.40 | 20.57 | |
SO70393_2 | 19 | 17338 | 528 | 6 | 2024-09-03 | 0.12 | 2024-08-22 | 4.99 | 2 | SO70393 | 2024-08-29 | 0.40 | 1.87 | |
SO45650_1 | 100 | 28652 | 312 | 6 | 2022-07-04 | 89.46 | 2022-06-22 | 3578.27 | 1 | SO45650 | 2022-06-29 | 286.26 | 2171.29 | |
SO56282_2 | 19 | 11520 | 217 | 6 | 2024-02-09 | 0.87 | 2024-01-28 | 34.99 | 2 | SO56282 | 2024-02-04 | 2.80 | 13.09 | |
SO63927_6 | 19 | 16000 | 484 | 6 | 2024-06-03 | 0.20 | 2024-05-22 | 7.95 | 6 | SO63927 | 2024-05-29 | 0.64 | 2.97 | |
SO70393_3 | 19 | 17338 | 480 | 2 | 6 | 2024-09-03 | 0.06 | 2024-08-22 | 2.29 | 3 | SO70393 | 2024-08-29 | 0.18 | 0.86 |
SO45680_1 | 19 | 23283 | 310 | 6 | 2022-07-08 | 89.46 | 2022-06-26 | 3578.27 | 1 | SO45680 | 2022-07-03 | 286.26 | 2171.29 | |
SO56282_3 | 19 | 11520 | 465 | 6 | 2024-02-09 | 0.61 | 2024-01-28 | 24.49 | 3 | SO56282 | 2024-02-04 | 1.96 | 9.16 | |
SO63931_1 | 19 | 16810 | 355 | 6 | 2024-06-03 | 58.00 | 2024-05-22 | 2319.99 | 1 | SO63931 | 2024-05-29 | 185.60 | 1265.62 | |
SO70395_1 | 19 | 16071 | 478 | 6 | 2024-09-03 | 0.25 | 2024-08-22 | 9.99 | 1 | SO70395 | 2024-08-29 | 0.80 | 3.74 | |
SO45705_1 | 19 | 23378 | 311 | 6 | 2022-07-12 | 89.46 | 2022-06-30 | 3578.27 | 1 | SO45705 | 2022-07-07 | 286.26 | 2171.29 | |
SO56283_1 | 19 | 11530 | 529 | 6 | 2024-02-09 | 0.10 | 2024-01-28 | 3.99 | 1 | SO56283 | 2024-02-04 | 0.32 | 1.49 | |
SO63931_2 | 19 | 16810 | 480 | 6 | 2024-06-03 | 0.06 | 2024-05-22 | 2.29 | 2 | SO63931 | 2024-05-29 | 0.18 | 0.86 | |
SO70396_1 | 19 | 11501 | 475 | 6 | 2024-09-03 | 1.75 | 2024-08-22 | 69.99 | 1 | SO70396 | 2024-08-29 | 5.60 | 26.18 | |
SO45719_1 | 19 | 20000 | 350 | 6 | 2022-07-14 | 84.37 | 2022-07-02 | 3374.99 | 1 | SO45719 | 2022-07-09 | 270.00 | 1898.09 | |
SO56283_2 | 19 | 11530 | 214 | 6 | 2024-02-09 | 0.87 | 2024-01-28 | 34.99 | 2 | SO56283 | 2024-02-04 | 2.80 | 13.09 | |
SO63962_1 | 19 | 11619 | 529 | 6 | 2024-06-04 | 0.10 | 2024-05-23 | 3.99 | 1 | SO63962 | 2024-05-30 | 0.32 | 1.49 | |
SO70396_2 | 19 | 11501 | 465 | 6 | 2024-09-03 | 0.61 | 2024-08-22 | 24.49 | 2 | SO70396 | 2024-08-29 | 1.96 | 9.16 | |
SO45746_1 | 19 | 23376 | 312 | 6 | 2022-07-18 | 89.46 | 2022-07-06 | 3578.27 | 1 | SO45746 | 2022-07-13 | 286.26 | 2171.29 | |
SO56284_1 | 19 | 11507 | 529 | 6 | 2024-02-09 | 0.10 | 2024-01-28 | 3.99 | 1 | SO56284 | 2024-02-04 | 0.32 | 1.49 | |
SO63962_2 | 19 | 11619 | 538 | 6 | 2024-06-04 | 0.54 | 2024-05-23 | 21.49 | 2 | SO63962 | 2024-05-30 | 1.72 | 8.04 | |
SO70400_1 | 19 | 24637 | 477 | 6 | 2024-09-03 | 0.12 | 2024-08-22 | 4.99 | 1 | SO70400 | 2024-08-29 | 0.40 | 1.87 | |
SO45776_1 | 19 | 23281 | 313 | 6 | 2022-07-23 | 89.46 | 2022-07-11 | 3578.27 | 1 | SO45776 | 2022-07-18 | 286.26 | 2171.29 | |
SO56284_2 | 19 | 11507 | 539 | 6 | 2024-02-09 | 0.62 | 2024-01-28 | 24.99 | 2 | SO56284 | 2024-02-04 | 2.00 | 9.35 | |
SO63965_1 | 19 | 11724 | 478 | 6 | 2024-06-04 | 0.25 | 2024-05-23 | 9.99 | 1 | SO63965 | 2024-05-30 | 0.80 | 3.74 | |
SO70400_2 | 19 | 24637 | 225 | 6 | 2024-09-03 | 0.22 | 2024-08-22 | 8.99 | 2 | SO70400 | 2024-08-29 | 0.72 | 6.92 | |
SO45825_1 | 19 | 23725 | 314 | 6 | 2022-07-26 | 89.46 | 2022-07-14 | 3578.27 | 1 | SO45825 | 2022-07-21 | 286.26 | 2171.29 | |
SO56284_3 | 19 | 11507 | 222 | 6 | 2024-02-09 | 0.87 | 2024-01-28 | 34.99 | 3 | SO56284 | 2024-02-04 | 2.80 | 13.09 | |
SO63965_2 | 19 | 11724 | 477 | 6 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 2 | SO63965 | 2024-05-30 | 0.40 | 1.87 | |
SO70403_1 | 19 | 23134 | 528 | 6 | 2024-09-03 | 0.12 | 2024-08-22 | 4.99 | 1 | SO70403 | 2024-08-29 | 0.40 | 1.87 | |
SO45826_1 | 19 | 23858 | 310 | 6 | 2022-07-26 | 89.46 | 2022-07-14 | 3578.27 | 1 | SO45826 | 2022-07-21 | 286.26 | 2171.29 | |
SO56286_1 | 19 | 11698 | 535 | 6 | 2024-02-09 | 0.62 | 2024-01-28 | 24.99 | 1 | SO56286 | 2024-02-04 | 2.00 | 9.35 | |
SO63967_1 | 19 | 24755 | 477 | 6 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 1 | SO63967 | 2024-05-30 | 0.40 | 1.87 | |
SO70403_2 | 19 | 23134 | 217 | 6 | 2024-09-03 | 0.87 | 2024-08-22 | 34.99 | 2 | SO70403 | 2024-08-29 | 2.80 | 13.09 | |
SO45845_1 | 19 | 23566 | 311 | 6 | 2022-07-29 | 89.46 | 2022-07-17 | 3578.27 | 1 | SO45845 | 2022-07-24 | 286.26 | 2171.29 | |
SO56286_2 | 19 | 11698 | 463 | 6 | 2024-02-09 | 0.61 | 2024-01-28 | 24.49 | 2 | SO56286 | 2024-02-04 | 1.96 | 9.16 | |
SO63967_2 | 19 | 24755 | 222 | 6 | 2024-06-04 | 0.87 | 2024-05-23 | 34.99 | 2 | SO63967 | 2024-05-30 | 2.80 | 13.09 | |
SO70441_1 | 19 | 21710 | 604 | 6 | 2024-09-03 | 13.50 | 2024-08-22 | 539.99 | 1 | SO70441 | 2024-08-29 | 43.20 | 343.65 | |
SO45846_1 | 19 | 23592 | 314 | 6 | 2022-07-29 | 89.46 | 2022-07-17 | 3578.27 | 1 | SO45846 | 2022-07-24 | 286.26 | 2171.29 | |
SO56290_1 | 19 | 19839 | 536 | 6 | 2024-02-09 | 0.75 | 2024-01-28 | 29.99 | 1 | SO56290 | 2024-02-04 | 2.40 | 11.22 | |
SO63968_1 | 19 | 21745 | 485 | 6 | 2024-06-04 | 0.55 | 2024-05-23 | 21.98 | 1 | SO63968 | 2024-05-30 | 1.76 | 8.22 | |
SO70441_2 | 19 | 21710 | 477 | 6 | 2024-09-03 | 0.12 | 2024-08-22 | 4.99 | 2 | SO70441 | 2024-08-29 | 0.40 | 1.87 | |
SO45860_1 | 19 | 23829 | 312 | 6 | 2022-07-31 | 89.46 | 2022-07-19 | 3578.27 | 1 | SO45860 | 2022-07-26 | 286.26 | 2171.29 | |
SO56290_2 | 19 | 19839 | 528 | 6 | 2024-02-09 | 0.12 | 2024-01-28 | 4.99 | 2 | SO56290 | 2024-02-04 | 0.40 | 1.87 | |
SO63968_2 | 19 | 21745 | 478 | 6 | 2024-06-04 | 0.25 | 2024-05-23 | 9.99 | 2 | SO63968 | 2024-05-30 | 0.80 | 3.74 | |
SO70441_3 | 19 | 21710 | 479 | 6 | 2024-09-03 | 0.22 | 2024-08-22 | 8.99 | 3 | SO70441 | 2024-08-29 | 0.72 | 3.36 | |
SO45874_1 | 19 | 20007 | 351 | 6 | 2022-08-03 | 84.37 | 2022-07-22 | 3374.99 | 1 | SO45874 | 2022-07-29 | 270.00 | 1898.09 | |
SO56290_3 | 19 | 19839 | 217 | 6 | 2024-02-09 | 0.87 | 2024-01-28 | 34.99 | 3 | SO56290 | 2024-02-04 | 2.80 | 13.09 | |
SO63968_3 | 19 | 21745 | 477 | 6 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 3 | SO63968 | 2024-05-30 | 0.40 | 1.87 | |
SO70441_4 | 19 | 21710 | 487 | 6 | 2024-09-03 | 1.37 | 2024-08-22 | 54.99 | 4 | SO70441 | 2024-08-29 | 4.40 | 20.57 | |
SO45881_1 | 19 | 23397 | 310 | 6 | 2022-08-04 | 89.46 | 2022-07-23 | 3578.27 | 1 | SO45881 | 2022-07-30 | 286.26 | 2171.29 | |
SO56291_1 | 19 | 15856 | 476 | 6 | 2024-02-09 | 1.75 | 2024-01-28 | 69.99 | 1 | SO56291 | 2024-02-04 | 5.60 | 26.18 | |
SO63968_4 | 19 | 21745 | 214 | 6 | 2024-06-04 | 0.87 | 2024-05-23 | 34.99 | 4 | SO63968 | 2024-05-30 | 2.80 | 13.09 | |
SO70444_1 | 19 | 17691 | 582 | 6 | 2024-09-03 | 42.52 | 2024-08-22 | 1700.99 | 1 | SO70444 | 2024-08-29 | 136.08 | 1082.51 | |
SO45893_1 | 19 | 23842 | 313 | 6 | 2022-08-05 | 89.46 | 2022-07-24 | 3578.27 | 1 | SO45893 | 2022-07-31 | 286.26 | 2171.29 | |
SO56291_2 | 19 | 15856 | 225 | 6 | 2024-02-09 | 0.22 | 2024-01-28 | 8.99 | 2 | SO56291 | 2024-02-04 | 0.72 | 6.92 | |
SO63970_1 | 19 | 23458 | 528 | 6 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 1 | SO63970 | 2024-05-30 | 0.40 | 1.87 | |
SO70444_2 | 19 | 17691 | 465 | 6 | 2024-09-03 | 0.61 | 2024-08-22 | 24.49 | 2 | SO70444 | 2024-08-29 | 1.96 | 9.16 | |
SO45898_1 | 19 | 23830 | 310 | 6 | 2022-08-07 | 89.46 | 2022-07-26 | 3578.27 | 1 | SO45898 | 2022-08-02 | 286.26 | 2171.29 | |
SO56293_1 | 19 | 11808 | 476 | 6 | 2024-02-09 | 1.75 | 2024-01-28 | 69.99 | 1 | SO56293 | 2024-02-04 | 5.60 | 26.18 | |
SO63970_2 | 19 | 23458 | 485 | 6 | 2024-06-04 | 0.55 | 2024-05-23 | 21.98 | 2 | SO63970 | 2024-05-30 | 1.76 | 8.22 | |
SO70444_3 | 19 | 17691 | 489 | 6 | 2024-09-03 | 1.35 | 2024-08-22 | 53.99 | 3 | SO70444 | 2024-08-29 | 4.32 | 41.57 | |
SO45912_1 | 19 | 23819 | 312 | 6 | 2022-08-08 | 89.46 | 2022-07-27 | 3578.27 | 1 | SO45912 | 2022-08-03 | 286.26 | 2171.29 | |
SO56293_2 | 19 | 11808 | 465 | 6 | 2024-02-09 | 0.61 | 2024-01-28 | 24.49 | 2 | SO56293 | 2024-02-04 | 1.96 | 9.16 |
Generated 2024-11-10 20:56:47.243 UTC