[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 1598 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46806_1 | 6 | 21195 | 370 | 9 | 2022-11-11 | 61.08 | 2022-10-30 | 2443.35 | 1 | SO46806 | 2022-11-06 | 195.47 | 1518.79 | |
SO56386_1 | 6 | 13617 | 487 | 9 | 2024-02-15 | 1.37 | 2024-02-03 | 54.99 | 1 | SO56386 | 2024-02-10 | 4.40 | 20.57 | |
SO62402_1 | 6 | 26035 | 529 | 9 | 2024-05-17 | 0.10 | 2024-05-05 | 3.99 | 1 | SO62402 | 2024-05-12 | 0.32 | 1.49 | |
SO68891_3 | 6 | 19672 | 217 | 9 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 3 | SO68891 | 2024-08-15 | 2.80 | 13.09 | |
SO46807_1 | 6 | 12339 | 354 | 9 | 2022-11-11 | 51.79 | 2022-10-30 | 2071.42 | 1 | SO46807 | 2022-11-06 | 165.71 | 1117.86 | |
SO56386_2 | 6 | 13617 | 484 | 9 | 2024-02-15 | 0.20 | 2024-02-03 | 7.95 | 2 | SO56386 | 2024-02-10 | 0.64 | 2.97 | |
SO62402_2 | 6 | 26035 | 538 | 9 | 2024-05-17 | 0.54 | 2024-05-05 | 21.49 | 2 | SO62402 | 2024-05-12 | 1.72 | 8.04 | |
SO68892_1 | 6 | 14685 | 530 | 9 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 1 | SO68892 | 2024-08-15 | 0.40 | 1.87 | |
SO46808_1 | 6 | 12347 | 360 | 9 | 2022-11-11 | 51.23 | 2022-10-30 | 2049.10 | 1 | SO46808 | 2022-11-06 | 163.93 | 1105.81 | |
SO56387_1 | 6 | 16635 | 540 | 9 | 2024-02-15 | 0.82 | 2024-02-03 | 32.60 | 1 | SO56387 | 2024-02-10 | 2.61 | 12.19 | |
SO62402_3 | 6 | 26035 | 472 | 9 | 2024-05-17 | 1.59 | 2024-05-05 | 63.50 | 3 | SO62402 | 2024-05-12 | 5.08 | 23.75 | |
SO68892_2 | 6 | 14685 | 217 | 9 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 2 | SO68892 | 2024-08-15 | 2.80 | 13.09 | |
SO46818_1 | 6 | 21211 | 369 | 2 | 9 | 2022-11-12 | 61.08 | 2022-10-31 | 2443.35 | 1 | SO46818 | 2022-11-07 | 195.47 | 1518.79 |
SO56387_2 | 6 | 16635 | 529 | 9 | 2024-02-15 | 0.10 | 2024-02-03 | 3.99 | 2 | SO56387 | 2024-02-10 | 0.32 | 1.49 | |
SO62403_1 | 6 | 19962 | 538 | 9 | 2024-05-17 | 0.54 | 2024-05-05 | 21.49 | 1 | SO62403 | 2024-05-12 | 1.72 | 8.04 | |
SO68892_3 | 6 | 14685 | 463 | 9 | 2024-08-20 | 0.61 | 2024-08-08 | 24.49 | 3 | SO68892 | 2024-08-15 | 1.96 | 9.16 | |
SO46819_1 | 6 | 21001 | 368 | 9 | 2022-11-12 | 61.08 | 2022-10-31 | 2443.35 | 1 | SO46819 | 2022-11-07 | 195.47 | 1518.79 | |
SO56387_3 | 6 | 16635 | 480 | 9 | 2024-02-15 | 0.06 | 2024-02-03 | 2.29 | 3 | SO56387 | 2024-02-10 | 0.18 | 0.86 | |
SO62403_2 | 6 | 19962 | 225 | 9 | 2024-05-17 | 0.22 | 2024-05-05 | 8.99 | 2 | SO62403 | 2024-05-12 | 0.72 | 6.92 | |
SO68893_1 | 6 | 28941 | 478 | 9 | 2024-08-20 | 0.25 | 2024-08-08 | 9.99 | 1 | SO68893 | 2024-08-15 | 0.80 | 3.74 | |
SO46824_1 | 6 | 24608 | 385 | 9 | 2022-11-13 | 25.01 | 2022-11-01 | 1000.44 | 1 | SO46824 | 2022-11-08 | 80.04 | 605.65 | |
SO56424_1 | 6 | 22966 | 581 | 9 | 2024-02-15 | 42.52 | 2024-02-03 | 1700.99 | 1 | SO56424 | 2024-02-10 | 136.08 | 1082.51 | |
SO62404_1 | 6 | 23569 | 530 | 9 | 2024-05-17 | 0.12 | 2024-05-05 | 4.99 | 1 | SO62404 | 2024-05-12 | 0.40 | 1.87 | |
SO68893_2 | 6 | 28941 | 477 | 9 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 2 | SO68893 | 2024-08-15 | 0.40 | 1.87 | |
SO46825_1 | 6 | 12574 | 354 | 9 | 2022-11-13 | 51.79 | 2022-11-01 | 2071.42 | 1 | SO46825 | 2022-11-08 | 165.71 | 1117.86 | |
SO56424_2 | 6 | 22966 | 222 | 9 | 2024-02-15 | 0.87 | 2024-02-03 | 34.99 | 2 | SO56424 | 2024-02-10 | 2.80 | 13.09 | |
SO62404_2 | 6 | 23569 | 222 | 9 | 2024-05-17 | 0.87 | 2024-05-05 | 34.99 | 2 | SO62404 | 2024-05-12 | 2.80 | 13.09 | |
SO68893_3 | 6 | 28941 | 487 | 9 | 2024-08-20 | 1.37 | 2024-08-08 | 54.99 | 3 | SO68893 | 2024-08-15 | 4.40 | 20.57 | |
SO46826_1 | 6 | 12575 | 360 | 9 | 2022-11-13 | 51.23 | 2022-11-01 | 2049.10 | 1 | SO46826 | 2022-11-08 | 163.93 | 1105.81 | |
SO56425_1 | 6 | 19099 | 378 | 9 | 2024-02-15 | 61.08 | 2024-02-03 | 2443.35 | 1 | SO56425 | 2024-02-10 | 195.47 | 1554.95 | |
SO62405_1 | 6 | 12372 | 480 | 9 | 2024-05-17 | 0.06 | 2024-05-05 | 2.29 | 1 | SO62405 | 2024-05-12 | 0.18 | 0.86 | |
SO68894_1 | 6 | 28933 | 463 | 9 | 2024-08-20 | 0.61 | 2024-08-08 | 24.49 | 1 | SO68894 | 2024-08-15 | 1.96 | 9.16 | |
SO46833_1 | 6 | 12360 | 354 | 9 | 2022-11-14 | 51.79 | 2022-11-02 | 2071.42 | 1 | SO46833 | 2022-11-09 | 165.71 | 1117.86 | |
SO56425_2 | 6 | 19099 | 225 | 9 | 2024-02-15 | 0.22 | 2024-02-03 | 8.99 | 2 | SO56425 | 2024-02-10 | 0.72 | 6.92 | |
SO62453_1 | 6 | 23434 | 583 | 9 | 2024-05-17 | 42.52 | 2024-05-05 | 1700.99 | 1 | SO62453 | 2024-05-12 | 136.08 | 1082.51 | |
SO68894_2 | 6 | 28933 | 530 | 9 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 2 | SO68894 | 2024-08-15 | 0.40 | 1.87 | |
SO46843_1 | 6 | 21168 | 375 | 9 | 2022-11-15 | 54.54 | 2022-11-03 | 2181.56 | 1 | SO46843 | 2022-11-10 | 174.53 | 1320.68 | |
SO56425_3 | 6 | 19099 | 484 | 9 | 2024-02-15 | 0.20 | 2024-02-03 | 7.95 | 3 | SO56425 | 2024-02-10 | 0.64 | 2.97 | |
SO62454_1 | 6 | 20606 | 374 | 2 | 9 | 2024-05-17 | 61.08 | 2024-05-05 | 2443.35 | 1 | SO62454 | 2024-05-12 | 195.47 | 1554.95 |
SO68895_1 | 6 | 13042 | 217 | 9 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 1 | SO68895 | 2024-08-15 | 2.80 | 13.09 | |
SO46844_1 | 6 | 12343 | 358 | 9 | 2022-11-15 | 51.23 | 2022-11-03 | 2049.10 | 1 | SO46844 | 2022-11-10 | 163.93 | 1105.81 | |
SO56429_1 | 6 | 28113 | 586 | 9 | 2024-02-15 | 18.56 | 2024-02-03 | 742.35 | 1 | SO56429 | 2024-02-10 | 59.39 | 461.44 | |
SO62454_2 | 6 | 20606 | 540 | 9 | 2024-05-17 | 0.82 | 2024-05-05 | 32.60 | 2 | SO62454 | 2024-05-12 | 2.61 | 12.19 | |
SO68895_2 | 6 | 13042 | 467 | 9 | 2024-08-20 | 0.61 | 2024-08-08 | 24.49 | 2 | SO68895 | 2024-08-15 | 1.96 | 9.16 | |
SO46853_1 | 6 | 21192 | 368 | 9 | 2022-11-16 | 61.08 | 2022-11-04 | 2443.35 | 1 | SO46853 | 2022-11-11 | 195.47 | 1518.79 | |
SO56429_2 | 6 | 28113 | 486 | 9 | 2024-02-15 | 3.98 | 2024-02-03 | 159.00 | 2 | SO56429 | 2024-02-10 | 12.72 | 59.47 | |
SO62455_1 | 6 | 20259 | 378 | 9 | 2024-05-17 | 61.08 | 2024-05-05 | 2443.35 | 1 | SO62455 | 2024-05-12 | 195.47 | 1554.95 | |
SO68896_1 | 6 | 16634 | 540 | 9 | 2024-08-20 | 0.82 | 2024-08-08 | 32.60 | 1 | SO68896 | 2024-08-15 | 2.61 | 12.19 | |
SO46854_1 | 6 | 20997 | 375 | 9 | 2022-11-16 | 54.54 | 2022-11-04 | 2181.56 | 1 | SO46854 | 2022-11-11 | 174.53 | 1320.68 | |
SO56430_1 | 6 | 23540 | 386 | 9 | 2024-02-16 | 28.01 | 2024-02-04 | 1120.49 | 1 | SO56430 | 2024-02-11 | 89.64 | 713.08 | |
SO62455_2 | 6 | 20259 | 484 | 9 | 2024-05-17 | 0.20 | 2024-05-05 | 7.95 | 2 | SO62455 | 2024-05-12 | 0.64 | 2.97 | |
SO68896_2 | 6 | 16634 | 529 | 9 | 2024-08-20 | 0.10 | 2024-08-08 | 3.99 | 2 | SO68896 | 2024-08-15 | 0.32 | 1.49 | |
SO46860_1 | 6 | 21180 | 371 | 9 | 2022-11-17 | 54.54 | 2022-11-05 | 2181.56 | 1 | SO46860 | 2022-11-12 | 174.53 | 1320.68 | |
SO56430_2 | 6 | 23540 | 488 | 9 | 2024-02-16 | 1.35 | 2024-02-04 | 53.99 | 2 | SO56430 | 2024-02-11 | 4.32 | 41.57 | |
SO62456_1 | 6 | 24506 | 382 | 9 | 2024-05-17 | 28.01 | 2024-05-05 | 1120.49 | 1 | SO62456 | 2024-05-12 | 89.64 | 713.08 | |
SO68896_3 | 6 | 16634 | 217 | 9 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 3 | SO68896 | 2024-08-15 | 2.80 | 13.09 | |
SO46861_1 | 6 | 21214 | 377 | 9 | 2022-11-17 | 54.54 | 2022-11-05 | 2181.56 | 1 | SO46861 | 2022-11-12 | 174.53 | 1320.68 | |
SO56430_3 | 6 | 23540 | 225 | 9 | 2024-02-16 | 0.22 | 2024-02-04 | 8.99 | 3 | SO56430 | 2024-02-11 | 0.72 | 6.92 | |
SO62457_1 | 6 | 25138 | 384 | 9 | 2024-05-17 | 28.01 | 2024-05-05 | 1120.49 | 1 | SO62457 | 2024-05-12 | 89.64 | 713.08 | |
SO68931_1 | 6 | 15221 | 363 | 9 | 2024-08-20 | 57.37 | 2024-08-08 | 2294.99 | 1 | SO68931 | 2024-08-15 | 183.60 | 1251.98 | |
SO46873_1 | 6 | 21167 | 377 | 9 | 2022-11-19 | 54.54 | 2022-11-07 | 2181.56 | 1 | SO46873 | 2022-11-14 | 174.53 | 1320.68 | |
SO56431_1 | 6 | 14344 | 539 | 9 | 2024-02-16 | 0.62 | 2024-02-04 | 24.99 | 1 | SO56431 | 2024-02-11 | 2.00 | 9.35 | |
SO62458_1 | 6 | 12251 | 598 | 9 | 2024-05-17 | 13.50 | 2024-05-05 | 539.99 | 1 | SO62458 | 2024-05-12 | 43.20 | 294.58 | |
SO68931_2 | 6 | 15221 | 485 | 9 | 2024-08-20 | 0.55 | 2024-08-08 | 21.98 | 2 | SO68931 | 2024-08-15 | 1.76 | 8.22 | |
SO46874_1 | 6 | 24606 | 381 | 9 | 2022-11-19 | 25.01 | 2022-11-07 | 1000.44 | 1 | SO46874 | 2022-11-14 | 80.04 | 605.65 | |
SO56431_2 | 6 | 14344 | 529 | 9 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 2 | SO56431 | 2024-02-11 | 0.32 | 1.49 | |
SO62458_2 | 6 | 12251 | 478 | 9 | 2024-05-17 | 0.25 | 2024-05-05 | 9.99 | 2 | SO62458 | 2024-05-12 | 0.80 | 3.74 | |
SO68931_3 | 6 | 15221 | 463 | 9 | 2024-08-20 | 0.61 | 2024-08-08 | 24.49 | 3 | SO68931 | 2024-08-15 | 1.96 | 9.16 | |
SO46881_1 | 6 | 12572 | 354 | 9 | 2022-11-20 | 51.79 | 2022-11-08 | 2071.42 | 1 | SO46881 | 2022-11-15 | 165.71 | 1117.86 | |
SO56431_3 | 6 | 14344 | 222 | 9 | 2024-02-16 | 0.87 | 2024-02-04 | 34.99 | 3 | SO56431 | 2024-02-11 | 2.80 | 13.09 | |
SO62459_1 | 6 | 13644 | 357 | 2 | 9 | 2024-05-17 | 58.00 | 2024-05-05 | 2319.99 | 1 | SO62459 | 2024-05-12 | 185.60 | 1265.62 |
SO68931_4 | 6 | 15221 | 222 | 9 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 4 | SO68931 | 2024-08-15 | 2.80 | 13.09 | |
SO46882_1 | 6 | 25960 | 343 | 9 | 2022-11-20 | 19.57 | 2022-11-08 | 782.99 | 1 | SO46882 | 2022-11-15 | 62.64 | 486.71 | |
SO56432_1 | 6 | 15147 | 529 | 9 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 1 | SO56432 | 2024-02-11 | 0.32 | 1.49 | |
SO62469_1 | 6 | 14301 | 585 | 9 | 2024-05-17 | 18.56 | 2024-05-05 | 742.35 | 1 | SO62469 | 2024-05-12 | 59.39 | 461.44 | |
SO68932_1 | 6 | 15151 | 363 | 2 | 9 | 2024-08-20 | 57.37 | 2024-08-08 | 2294.99 | 1 | SO68932 | 2024-08-15 | 183.60 | 1251.98 |
SO46887_1 | 6 | 12340 | 362 | 2 | 9 | 2022-11-21 | 51.23 | 2022-11-09 | 2049.10 | 1 | SO46887 | 2022-11-16 | 163.93 | 1105.81 |
SO56432_2 | 6 | 15147 | 481 | 9 | 2024-02-16 | 0.22 | 2024-02-04 | 8.99 | 2 | SO56432 | 2024-02-11 | 0.72 | 3.36 | |
SO62469_2 | 6 | 14301 | 481 | 9 | 2024-05-17 | 0.22 | 2024-05-05 | 8.99 | 2 | SO62469 | 2024-05-12 | 0.72 | 3.36 | |
SO68933_1 | 6 | 26192 | 390 | 9 | 2024-08-20 | 28.01 | 2024-08-08 | 1120.49 | 1 | SO68933 | 2024-08-15 | 89.64 | 713.08 | |
SO46888_1 | 6 | 26021 | 325 | 9 | 2022-11-21 | 19.57 | 2022-11-09 | 782.99 | 1 | SO46888 | 2022-11-16 | 62.64 | 486.71 | |
SO56432_3 | 6 | 15147 | 539 | 9 | 2024-02-16 | 0.62 | 2024-02-04 | 24.99 | 3 | SO56432 | 2024-02-11 | 2.00 | 9.35 | |
SO62470_1 | 6 | 28351 | 584 | 9 | 2024-05-17 | 13.50 | 2024-05-05 | 539.99 | 1 | SO62470 | 2024-05-12 | 43.20 | 343.65 | |
SO68934_1 | 6 | 26025 | 382 | 9 | 2024-08-20 | 28.01 | 2024-08-08 | 1120.49 | 1 | SO68934 | 2024-08-15 | 89.64 | 713.08 | |
SO46897_1 | 6 | 21179 | 368 | 9 | 2022-11-22 | 61.08 | 2022-11-10 | 2443.35 | 1 | SO46897 | 2022-11-17 | 195.47 | 1518.79 | |
SO56433_1 | 6 | 15026 | 539 | 9 | 2024-02-16 | 0.62 | 2024-02-04 | 24.99 | 1 | SO56433 | 2024-02-11 | 2.00 | 9.35 | |
SO62470_2 | 6 | 28351 | 214 | 9 | 2024-05-17 | 0.87 | 2024-05-05 | 34.99 | 2 | SO62470 | 2024-05-12 | 2.80 | 13.09 | |
SO68934_2 | 6 | 26025 | 477 | 9 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 2 | SO68934 | 2024-08-15 | 0.40 | 1.87 | |
SO46898_1 | 6 | 21205 | 369 | 2 | 9 | 2022-11-22 | 61.08 | 2022-11-10 | 2443.35 | 1 | SO46898 | 2022-11-17 | 195.47 | 1518.79 |
SO56434_1 | 6 | 17291 | 536 | 9 | 2024-02-16 | 0.75 | 2024-02-04 | 29.99 | 1 | SO56434 | 2024-02-11 | 2.40 | 11.22 | |
SO62471_1 | 6 | 13981 | 535 | 9 | 2024-05-18 | 0.62 | 2024-05-06 | 24.99 | 1 | SO62471 | 2024-05-13 | 2.00 | 9.35 | |
SO68934_3 | 6 | 26025 | 479 | 9 | 2024-08-20 | 0.22 | 2024-08-08 | 8.99 | 3 | SO68934 | 2024-08-15 | 0.72 | 3.36 | |
SO46900_1 | 6 | 21194 | 375 | 9 | 2022-11-23 | 54.54 | 2022-11-11 | 2181.56 | 1 | SO46900 | 2022-11-18 | 174.53 | 1320.68 | |
SO56434_2 | 6 | 17291 | 480 | 2 | 9 | 2024-02-16 | 0.06 | 2024-02-04 | 2.29 | 2 | SO56434 | 2024-02-11 | 0.18 | 0.86 |
SO62471_2 | 6 | 13981 | 480 | 9 | 2024-05-18 | 0.06 | 2024-05-06 | 2.29 | 2 | SO62471 | 2024-05-13 | 0.18 | 0.86 | |
SO68935_1 | 6 | 21259 | 581 | 9 | 2024-08-20 | 42.52 | 2024-08-08 | 1700.99 | 1 | SO68935 | 2024-08-15 | 136.08 | 1082.51 |
Generated 2024-11-14 05:49:43.877 UTC