[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 244 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44363_1 | 100 | 28285 | 312 | 1 | 2022-01-31 | 89.46 | 2022-01-19 | 3578.27 | 1 | SO44363 | 2022-01-26 | 286.26 | 2171.29 | |
SO44378_1 | 100 | 25903 | 349 | 1 | 2022-02-02 | 84.37 | 2022-01-21 | 3374.99 | 1 | SO44378 | 2022-01-28 | 270.00 | 1898.09 | |
SO44394_1 | 100 | 28246 | 313 | 1 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44394 | 2022-01-30 | 286.26 | 2171.29 | |
SO44395_1 | 100 | 28339 | 314 | 1 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44395 | 2022-01-30 | 286.26 | 2171.29 | |
SO44399_1 | 100 | 28240 | 311 | 1 | 2022-02-05 | 89.46 | 2022-01-24 | 3578.27 | 1 | SO44399 | 2022-01-31 | 286.26 | 2171.29 | |
SO44429_1 | 100 | 28583 | 314 | 1 | 2022-02-11 | 89.46 | 2022-01-30 | 3578.27 | 1 | SO44429 | 2022-02-06 | 286.26 | 2171.29 | |
SO44433_1 | 100 | 28270 | 312 | 1 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO44433 | 2022-02-07 | 286.26 | 2171.29 | |
SO44435_1 | 100 | 28573 | 312 | 1 | 2022-02-13 | 89.46 | 2022-02-01 | 3578.27 | 1 | SO44435 | 2022-02-08 | 286.26 | 2171.29 | |
SO44442_1 | 100 | 14599 | 334 | 1 | 2022-02-14 | 17.48 | 2022-02-02 | 699.10 | 1 | SO44442 | 2022-02-09 | 55.93 | 413.15 | |
SO44448_1 | 100 | 28264 | 311 | 1 | 2022-02-18 | 89.46 | 2022-02-06 | 3578.27 | 1 | SO44448 | 2022-02-13 | 286.26 | 2171.29 | |
SO44451_1 | 100 | 28295 | 313 | 1 | 2022-02-18 | 89.46 | 2022-02-06 | 3578.27 | 1 | SO44451 | 2022-02-13 | 286.26 | 2171.29 | |
SO44457_1 | 100 | 28196 | 311 | 1 | 2022-02-19 | 89.46 | 2022-02-07 | 3578.27 | 1 | SO44457 | 2022-02-14 | 286.26 | 2171.29 | |
SO62302_1 | 100 | 27198 | 530 | 1 | 2024-05-11 | 0.12 | 2024-04-29 | 4.99 | 1 | SO62302 | 2024-05-06 | 0.40 | 1.87 | |
SO62302_2 | 100 | 27198 | 541 | 1 | 2024-05-11 | 0.72 | 2024-04-29 | 28.99 | 2 | SO62302 | 2024-05-06 | 2.32 | 10.84 | |
SO62302_3 | 100 | 27198 | 487 | 1 | 2024-05-11 | 1.37 | 2024-04-29 | 54.99 | 3 | SO62302 | 2024-05-06 | 4.40 | 20.57 | |
SO62302_4 | 100 | 27198 | 228 | 1 | 2024-05-11 | 1.25 | 2024-04-29 | 49.99 | 4 | SO62302 | 2024-05-06 | 4.00 | 38.49 | |
SO62302_5 | 100 | 27198 | 225 | 1 | 2024-05-11 | 0.22 | 2024-04-29 | 8.99 | 5 | SO62302 | 2024-05-06 | 0.72 | 6.92 | |
SO62306_1 | 100 | 21397 | 477 | 1 | 2024-05-11 | 0.12 | 2024-04-29 | 4.99 | 1 | SO62306 | 2024-05-06 | 0.40 | 1.87 | |
SO62306_2 | 100 | 21397 | 478 | 1 | 2024-05-11 | 0.25 | 2024-04-29 | 9.99 | 2 | SO62306 | 2024-05-06 | 0.80 | 3.74 | |
SO62306_3 | 100 | 21397 | 222 | 1 | 2024-05-11 | 0.87 | 2024-04-29 | 34.99 | 3 | SO62306 | 2024-05-06 | 2.80 | 13.09 | |
SO62307_1 | 100 | 18890 | 474 | 1 | 2024-05-11 | 1.75 | 2024-04-29 | 69.99 | 1 | SO62307 | 2024-05-06 | 5.60 | 26.18 | |
SO62307_2 | 100 | 18890 | 481 | 1 | 2024-05-11 | 0.22 | 2024-04-29 | 8.99 | 2 | SO62307 | 2024-05-06 | 0.72 | 3.36 | |
SO62313_1 | 100 | 20089 | 477 | 1 | 2024-05-11 | 0.12 | 2024-04-29 | 4.99 | 1 | SO62313 | 2024-05-06 | 0.40 | 1.87 | |
SO62315_1 | 100 | 14396 | 528 | 1 | 2024-05-11 | 0.12 | 2024-04-29 | 4.99 | 1 | SO62315 | 2024-05-06 | 0.40 | 1.87 | |
SO62315_2 | 100 | 14396 | 485 | 1 | 2024-05-11 | 0.55 | 2024-04-29 | 21.98 | 2 | SO62315 | 2024-05-06 | 1.76 | 8.22 | |
SO62315_3 | 100 | 14396 | 231 | 1 | 2024-05-11 | 1.25 | 2024-04-29 | 49.99 | 3 | SO62315 | 2024-05-06 | 4.00 | 38.49 | |
SO62316_1 | 100 | 13379 | 485 | 1 | 2024-05-11 | 0.55 | 2024-04-29 | 21.98 | 1 | SO62316 | 2024-05-06 | 1.76 | 8.22 | |
SO62316_2 | 100 | 13379 | 480 | 1 | 2024-05-11 | 0.06 | 2024-04-29 | 2.29 | 2 | SO62316 | 2024-05-06 | 0.18 | 0.86 | |
SO62337_1 | 100 | 22716 | 605 | 1 | 2024-05-11 | 13.50 | 2024-04-29 | 539.99 | 1 | SO62337 | 2024-05-06 | 43.20 | 343.65 | |
SO62337_2 | 100 | 22716 | 479 | 1 | 2024-05-11 | 0.22 | 2024-04-29 | 8.99 | 2 | SO62337 | 2024-05-06 | 0.72 | 3.36 | |
SO62337_3 | 100 | 22716 | 477 | 1 | 2024-05-11 | 0.12 | 2024-04-29 | 4.99 | 3 | SO62337 | 2024-05-06 | 0.40 | 1.87 | |
SO62338_1 | 100 | 20480 | 382 | 1 | 2024-05-11 | 28.01 | 2024-04-29 | 1120.49 | 1 | SO62338 | 2024-05-06 | 89.64 | 713.08 | |
SO62338_2 | 100 | 20480 | 214 | 1 | 2024-05-11 | 0.87 | 2024-04-29 | 34.99 | 2 | SO62338 | 2024-05-06 | 2.80 | 13.09 | |
SO62354_1 | 100 | 29226 | 529 | 1 | 2024-05-12 | 0.10 | 2024-04-30 | 3.99 | 1 | SO62354 | 2024-05-07 | 0.32 | 1.49 | |
SO62354_2 | 100 | 29226 | 217 | 1 | 2024-05-12 | 0.87 | 2024-04-30 | 34.99 | 2 | SO62354 | 2024-05-07 | 2.80 | 13.09 | |
SO62359_1 | 100 | 21905 | 478 | 1 | 2024-05-12 | 0.25 | 2024-04-30 | 9.99 | 1 | SO62359 | 2024-05-07 | 0.80 | 3.74 | |
SO62359_2 | 100 | 21905 | 477 | 1 | 2024-05-12 | 0.12 | 2024-04-30 | 4.99 | 2 | SO62359 | 2024-05-07 | 0.40 | 1.87 | |
SO62375_1 | 100 | 13395 | 485 | 1 | 2024-05-12 | 0.55 | 2024-04-30 | 21.98 | 1 | SO62375 | 2024-05-07 | 1.76 | 8.22 | |
SO62380_1 | 100 | 12437 | 355 | 1 | 2024-05-12 | 58.00 | 2024-04-30 | 2319.99 | 1 | SO62380 | 2024-05-07 | 185.60 | 1265.62 | |
SO62380_2 | 100 | 12437 | 485 | 1 | 2024-05-12 | 0.55 | 2024-04-30 | 21.98 | 2 | SO62380 | 2024-05-07 | 1.76 | 8.22 | |
SO62380_3 | 100 | 12437 | 225 | 1 | 2024-05-12 | 0.22 | 2024-04-30 | 8.99 | 3 | SO62380 | 2024-05-07 | 0.72 | 6.92 | |
SO62380_4 | 100 | 12437 | 490 | 1 | 2024-05-12 | 1.35 | 2024-04-30 | 53.99 | 4 | SO62380 | 2024-05-07 | 4.32 | 41.57 | |
SO62387_1 | 100 | 26041 | 561 | 1 | 2024-05-12 | 59.60 | 2024-04-30 | 2384.07 | 1 | SO62387 | 2024-05-07 | 190.73 | 1481.94 | |
SO62387_2 | 100 | 26041 | 479 | 1 | 2024-05-12 | 0.22 | 2024-04-30 | 8.99 | 2 | SO62387 | 2024-05-07 | 0.72 | 3.36 | |
SO62387_3 | 100 | 26041 | 477 | 1 | 2024-05-12 | 0.12 | 2024-04-30 | 4.99 | 3 | SO62387 | 2024-05-07 | 0.40 | 1.87 | |
SO62387_4 | 100 | 26041 | 487 | 1 | 2024-05-12 | 1.37 | 2024-04-30 | 54.99 | 4 | SO62387 | 2024-05-07 | 4.40 | 20.57 | |
SO62387_5 | 100 | 26041 | 484 | 1 | 2024-05-12 | 0.20 | 2024-04-30 | 7.95 | 5 | SO62387 | 2024-05-07 | 0.64 | 2.97 | |
SO62389_1 | 100 | 22872 | 584 | 1 | 2024-05-12 | 13.50 | 2024-04-30 | 539.99 | 1 | SO62389 | 2024-05-07 | 43.20 | 343.65 | |
SO62390_1 | 100 | 18471 | 584 | 1 | 2024-05-12 | 13.50 | 2024-04-30 | 539.99 | 1 | SO62390 | 2024-05-07 | 43.20 | 343.65 | |
SO62418_1 | 100 | 21770 | 478 | 1 | 2024-05-13 | 0.25 | 2024-05-01 | 9.99 | 1 | SO62418 | 2024-05-08 | 0.80 | 3.74 | |
SO62418_2 | 100 | 21770 | 477 | 1 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 2 | SO62418 | 2024-05-08 | 0.40 | 1.87 | |
SO62418_3 | 100 | 21770 | 482 | 1 | 2024-05-13 | 0.22 | 2024-05-01 | 8.99 | 3 | SO62418 | 2024-05-08 | 0.72 | 3.36 | |
SO62419_1 | 100 | 20780 | 478 | 1 | 2024-05-13 | 0.25 | 2024-05-01 | 9.99 | 1 | SO62419 | 2024-05-08 | 0.80 | 3.74 | |
SO62420_1 | 100 | 18323 | 477 | 1 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 1 | SO62420 | 2024-05-08 | 0.40 | 1.87 | |
SO62420_2 | 100 | 18323 | 217 | 1 | 2024-05-13 | 0.87 | 2024-05-01 | 34.99 | 2 | SO62420 | 2024-05-08 | 2.80 | 13.09 | |
SO62422_1 | 100 | 18074 | 477 | 1 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 1 | SO62422 | 2024-05-08 | 0.40 | 1.87 | |
SO62422_2 | 100 | 18074 | 490 | 1 | 2024-05-13 | 1.35 | 2024-05-01 | 53.99 | 2 | SO62422 | 2024-05-08 | 4.32 | 41.57 | |
SO62425_1 | 100 | 14028 | 485 | 1 | 2024-05-13 | 0.55 | 2024-05-01 | 21.98 | 1 | SO62425 | 2024-05-08 | 1.76 | 8.22 | |
SO62425_2 | 100 | 14028 | 478 | 1 | 2024-05-13 | 0.25 | 2024-05-01 | 9.99 | 2 | SO62425 | 2024-05-08 | 0.80 | 3.74 | |
SO62425_3 | 100 | 14028 | 477 | 1 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 3 | SO62425 | 2024-05-08 | 0.40 | 1.87 | |
SO62425_4 | 100 | 14028 | 487 | 1 | 2024-05-13 | 1.37 | 2024-05-01 | 54.99 | 4 | SO62425 | 2024-05-08 | 4.40 | 20.57 | |
SO62441_1 | 100 | 16732 | 372 | 1 | 2024-05-13 | 61.08 | 2024-05-01 | 2443.35 | 1 | SO62441 | 2024-05-08 | 195.47 | 1554.95 | |
SO62441_2 | 100 | 16732 | 484 | 1 | 2024-05-13 | 0.20 | 2024-05-01 | 7.95 | 2 | SO62441 | 2024-05-08 | 0.64 | 2.97 | |
SO62445_1 | 100 | 12084 | 353 | 2 | 1 | 2024-05-13 | 58.00 | 2024-05-01 | 2319.99 | 1 | SO62445 | 2024-05-08 | 185.60 | 1265.62 |
SO62445_2 | 100 | 12084 | 485 | 1 | 2024-05-13 | 0.55 | 2024-05-01 | 21.98 | 2 | SO62445 | 2024-05-08 | 1.76 | 8.22 | |
SO62445_3 | 100 | 12084 | 478 | 1 | 2024-05-13 | 0.25 | 2024-05-01 | 9.99 | 3 | SO62445 | 2024-05-08 | 0.80 | 3.74 | |
SO62445_4 | 100 | 12084 | 477 | 1 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 4 | SO62445 | 2024-05-08 | 0.40 | 1.87 | |
SO62445_5 | 100 | 12084 | 234 | 1 | 2024-05-13 | 1.25 | 2024-05-01 | 49.99 | 5 | SO62445 | 2024-05-08 | 4.00 | 38.49 | |
SO62446_1 | 100 | 14439 | 361 | 1 | 2024-05-13 | 57.37 | 2024-05-01 | 2294.99 | 1 | SO62446 | 2024-05-08 | 183.60 | 1251.98 | |
SO62446_2 | 100 | 14439 | 478 | 1 | 2024-05-13 | 0.25 | 2024-05-01 | 9.99 | 2 | SO62446 | 2024-05-08 | 0.80 | 3.74 | |
SO62446_3 | 100 | 14439 | 477 | 1 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 3 | SO62446 | 2024-05-08 | 0.40 | 1.87 | |
SO62446_4 | 100 | 14439 | 480 | 1 | 2024-05-13 | 0.06 | 2024-05-01 | 2.29 | 4 | SO62446 | 2024-05-08 | 0.18 | 0.86 | |
SO62460_1 | 100 | 29174 | 565 | 1 | 2024-05-13 | 18.56 | 2024-05-01 | 742.35 | 1 | SO62460 | 2024-05-08 | 59.39 | 461.44 | |
SO62460_2 | 100 | 29174 | 479 | 1 | 2024-05-13 | 0.22 | 2024-05-01 | 8.99 | 2 | SO62460 | 2024-05-08 | 0.72 | 3.36 | |
SO62460_3 | 100 | 29174 | 477 | 1 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 3 | SO62460 | 2024-05-08 | 0.40 | 1.87 | |
SO62461_1 | 100 | 25982 | 573 | 1 | 2024-05-13 | 59.60 | 2024-05-01 | 2384.07 | 1 | SO62461 | 2024-05-08 | 190.73 | 1481.94 | |
SO55890_1 | 100 | 17367 | 472 | 1 | 2024-02-01 | 1.59 | 2024-01-20 | 63.50 | 1 | SO55890 | 2024-01-27 | 5.08 | 23.75 | |
SO55890_2 | 100 | 17367 | 477 | 1 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 2 | SO55890 | 2024-01-27 | 0.40 | 1.87 | |
SO55893_1 | 100 | 15774 | 528 | 1 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 1 | SO55893 | 2024-01-27 | 0.40 | 1.87 | |
SO55893_2 | 100 | 15774 | 483 | 1 | 2024-02-01 | 3.00 | 2024-01-20 | 120.00 | 2 | SO55893 | 2024-01-27 | 9.60 | 44.88 | |
SO55894_1 | 100 | 16716 | 528 | 1 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 1 | SO55894 | 2024-01-27 | 0.40 | 1.87 | |
SO55894_2 | 100 | 16716 | 478 | 1 | 2024-02-01 | 0.25 | 2024-01-20 | 9.99 | 2 | SO55894 | 2024-01-27 | 0.80 | 3.74 | |
SO55894_3 | 100 | 16716 | 477 | 1 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 3 | SO55894 | 2024-01-27 | 0.40 | 1.87 | |
SO55894_4 | 100 | 16716 | 484 | 1 | 2024-02-01 | 0.20 | 2024-01-20 | 7.95 | 4 | SO55894 | 2024-01-27 | 0.64 | 2.97 | |
SO55895_1 | 100 | 15315 | 528 | 1 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 1 | SO55895 | 2024-01-27 | 0.40 | 1.87 | |
SO55907_1 | 100 | 12454 | 485 | 1 | 2024-02-01 | 0.55 | 2024-01-20 | 21.98 | 1 | SO55907 | 2024-01-27 | 1.76 | 8.22 | |
SO55907_2 | 100 | 12454 | 478 | 1 | 2024-02-01 | 0.25 | 2024-01-20 | 9.99 | 2 | SO55907 | 2024-01-27 | 0.80 | 3.74 | |
SO55907_3 | 100 | 12454 | 477 | 1 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 3 | SO55907 | 2024-01-27 | 0.40 | 1.87 | |
SO55907_4 | 100 | 12454 | 214 | 1 | 2024-02-01 | 0.87 | 2024-01-20 | 34.99 | 4 | SO55907 | 2024-01-27 | 2.80 | 13.09 | |
SO55913_1 | 100 | 13102 | 363 | 1 | 2024-02-01 | 57.37 | 2024-01-20 | 2294.99 | 1 | SO55913 | 2024-01-27 | 183.60 | 1251.98 | |
SO55913_2 | 100 | 13102 | 485 | 1 | 2024-02-01 | 0.55 | 2024-01-20 | 21.98 | 2 | SO55913 | 2024-01-27 | 1.76 | 8.22 | |
SO55913_3 | 100 | 13102 | 478 | 1 | 2024-02-01 | 0.25 | 2024-01-20 | 9.99 | 3 | SO55913 | 2024-01-27 | 0.80 | 3.74 | |
SO55913_4 | 100 | 13102 | 477 | 1 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 4 | SO55913 | 2024-01-27 | 0.40 | 1.87 | |
SO55913_5 | 100 | 13102 | 487 | 1 | 2024-02-01 | 1.37 | 2024-01-20 | 54.99 | 5 | SO55913 | 2024-01-27 | 4.40 | 20.57 | |
SO55916_1 | 100 | 26331 | 585 | 1 | 2024-02-01 | 18.56 | 2024-01-20 | 742.35 | 1 | SO55916 | 2024-01-27 | 59.39 | 461.44 | |
SO55916_2 | 100 | 26331 | 225 | 1 | 2024-02-01 | 0.22 | 2024-01-20 | 8.99 | 2 | SO55916 | 2024-01-27 | 0.72 | 6.92 |
Generated 2024-11-10 08:25:27.404 UTC