[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 415 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO62147_1 | 100 | 26616 | 586 | 1 | 2024-05-08 | 18.56 | 2024-04-26 | 742.35 | 1 | SO62147 | 2024-05-03 | 59.39 | 461.44 | |
SO68685_3 | 6 | 24453 | 222 | 9 | 2024-08-13 | 0.87 | 2024-08-01 | 34.99 | 3 | SO68685 | 2024-08-08 | 2.80 | 13.09 | |
SO43801_1 | 98 | 13583 | 311 | 10 | 2021-11-15 | 89.46 | 2021-11-03 | 3578.27 | 1 | SO43801 | 2021-11-10 | 286.26 | 2171.29 | |
SO55601_2 | 98 | 14771 | 479 | 10 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55601 | 2024-01-22 | 0.72 | 3.36 | |
SO62147_2 | 100 | 26616 | 225 | 1 | 2024-05-08 | 0.22 | 2024-04-26 | 8.99 | 2 | SO62147 | 2024-05-03 | 0.72 | 6.92 | |
SO68686_1 | 6 | 13158 | 476 | 9 | 2024-08-13 | 1.75 | 2024-08-01 | 69.99 | 1 | SO68686 | 2024-08-08 | 5.60 | 26.18 | |
SO43802_1 | 39 | 11593 | 312 | 7 | 2021-11-15 | 89.46 | 2021-11-03 | 3578.27 | 1 | SO43802 | 2021-11-10 | 286.26 | 2171.29 | |
SO55601_3 | 98 | 14771 | 477 | 10 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 3 | SO55601 | 2024-01-22 | 0.40 | 1.87 | |
SO62148_1 | 19 | 22247 | 573 | 6 | 2024-05-08 | 59.60 | 2024-04-26 | 2384.07 | 1 | SO62148 | 2024-05-03 | 190.73 | 1481.94 | |
SO68686_2 | 6 | 13158 | 225 | 9 | 2024-08-13 | 0.22 | 2024-08-01 | 8.99 | 2 | SO68686 | 2024-08-08 | 0.72 | 6.92 | |
SO43803_1 | 19 | 21741 | 314 | 6 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO43803 | 2021-11-11 | 286.26 | 2171.29 | |
SO55602_1 | 98 | 12385 | 585 | 10 | 2024-01-27 | 18.56 | 2024-01-15 | 742.35 | 1 | SO55602 | 2024-01-22 | 59.39 | 461.44 | |
SO62148_2 | 19 | 22247 | 479 | 6 | 2024-05-08 | 0.22 | 2024-04-26 | 8.99 | 2 | SO62148 | 2024-05-03 | 0.72 | 3.36 | |
SO68687_1 | 98 | 13794 | 359 | 10 | 2024-08-13 | 57.37 | 2024-08-01 | 2294.99 | 1 | SO68687 | 2024-08-08 | 183.60 | 1251.98 | |
SO43804_1 | 98 | 13585 | 310 | 10 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO43804 | 2021-11-11 | 286.26 | 2171.29 | |
SO55603_1 | 6 | 27339 | 605 | 9 | 2024-01-27 | 13.50 | 2024-01-15 | 539.99 | 1 | SO55603 | 2024-01-22 | 43.20 | 343.65 | |
SO62148_3 | 19 | 22247 | 477 | 6 | 2024-05-08 | 0.12 | 2024-04-26 | 4.99 | 3 | SO62148 | 2024-05-03 | 0.40 | 1.87 | |
SO68687_2 | 98 | 13794 | 537 | 10 | 2024-08-13 | 0.88 | 2024-08-01 | 35.00 | 2 | SO68687 | 2024-08-08 | 2.80 | 13.09 | |
SO43805_1 | 100 | 14510 | 328 | 1 | 2021-11-16 | 17.48 | 2021-11-04 | 699.10 | 1 | SO43805 | 2021-11-11 | 55.93 | 413.15 | |
SO55603_2 | 6 | 27339 | 477 | 9 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 2 | SO55603 | 2024-01-22 | 0.40 | 1.87 | |
SO62148_4 | 19 | 22247 | 480 | 2 | 6 | 2024-05-08 | 0.06 | 2024-04-26 | 2.29 | 4 | SO62148 | 2024-05-03 | 0.18 | 0.86 |
SO68687_3 | 98 | 13794 | 528 | 10 | 2024-08-13 | 0.12 | 2024-08-01 | 4.99 | 3 | SO68687 | 2024-08-08 | 0.40 | 1.87 | |
SO43806_1 | 6 | 16523 | 312 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO43806 | 2021-11-11 | 286.26 | 2171.29 | |
SO55603_3 | 6 | 27339 | 479 | 9 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 3 | SO55603 | 2024-01-22 | 0.72 | 3.36 | |
SO62149_1 | 100 | 23239 | 605 | 4 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62149 | 2024-05-03 | 43.20 | 343.65 | |
SO68687_4 | 98 | 13794 | 222 | 10 | 2024-08-13 | 0.87 | 2024-08-01 | 34.99 | 4 | SO68687 | 2024-08-08 | 2.80 | 13.09 | |
SO43807_1 | 39 | 11611 | 312 | 7 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43807 | 2021-11-12 | 286.26 | 2171.29 | |
SO55604_1 | 6 | 29289 | 573 | 9 | 2024-01-27 | 59.60 | 2024-01-15 | 2384.07 | 1 | SO55604 | 2024-01-22 | 190.73 | 1481.94 | |
SO62150_1 | 100 | 23195 | 584 | 1 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62150 | 2024-05-03 | 43.20 | 343.65 | |
SO68688_1 | 98 | 18625 | 600 | 10 | 2024-08-13 | 13.50 | 2024-08-01 | 539.99 | 1 | SO68688 | 2024-08-08 | 43.20 | 294.58 | |
SO43808_1 | 29 | 13259 | 313 | 8 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43808 | 2021-11-12 | 286.26 | 2171.29 | |
SO55604_2 | 6 | 29289 | 479 | 9 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55604 | 2024-01-22 | 0.72 | 3.36 | |
SO62150_2 | 100 | 23195 | 477 | 1 | 2024-05-08 | 0.12 | 2024-04-26 | 4.99 | 2 | SO62150 | 2024-05-03 | 0.40 | 1.87 | |
SO68688_2 | 98 | 18625 | 535 | 10 | 2024-08-13 | 0.62 | 2024-08-01 | 24.99 | 2 | SO68688 | 2024-08-08 | 2.00 | 9.35 | |
SO43809_1 | 6 | 16350 | 310 | 9 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43809 | 2021-11-12 | 286.26 | 2171.29 | |
SO55604_3 | 6 | 29289 | 477 | 9 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 3 | SO55604 | 2024-01-22 | 0.40 | 1.87 | |
SO62150_3 | 100 | 23195 | 479 | 1 | 2024-05-08 | 0.22 | 2024-04-26 | 8.99 | 3 | SO62150 | 2024-05-03 | 0.72 | 3.36 | |
SO68688_3 | 98 | 18625 | 528 | 10 | 2024-08-13 | 0.12 | 2024-08-01 | 4.99 | 3 | SO68688 | 2024-08-08 | 0.40 | 1.87 | |
SO43810_1 | 6 | 11004 | 345 | 9 | 2021-11-17 | 85.00 | 2021-11-05 | 3399.99 | 1 | SO43810 | 2021-11-12 | 272.00 | 1912.15 | |
SO55604_4 | 6 | 29289 | 222 | 9 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 4 | SO55604 | 2024-01-22 | 2.80 | 13.09 | |
SO62150_4 | 100 | 23195 | 222 | 1 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 4 | SO62150 | 2024-05-03 | 2.80 | 13.09 | |
SO68688_4 | 98 | 18625 | 480 | 2 | 10 | 2024-08-13 | 0.06 | 2024-08-01 | 2.29 | 4 | SO68688 | 2024-08-08 | 0.18 | 0.86 |
SO43811_1 | 6 | 11026 | 346 | 9 | 2021-11-17 | 85.00 | 2021-11-05 | 3399.99 | 1 | SO43811 | 2021-11-12 | 272.00 | 1912.15 | |
SO55605_1 | 6 | 19094 | 378 | 9 | 2024-01-27 | 61.08 | 2024-01-15 | 2443.35 | 1 | SO55605 | 2024-01-22 | 195.47 | 1554.95 | |
SO62150_5 | 100 | 23195 | 234 | 1 | 2024-05-08 | 1.25 | 2024-04-26 | 49.99 | 5 | SO62150 | 2024-05-03 | 4.00 | 38.49 | |
SO68689_1 | 100 | 11638 | 480 | 4 | 2024-08-13 | 0.06 | 2024-08-01 | 2.29 | 1 | SO68689 | 2024-08-08 | 0.18 | 0.86 | |
SO43812_1 | 100 | 27662 | 312 | 4 | 2021-11-18 | 89.46 | 2021-11-06 | 3578.27 | 1 | SO43812 | 2021-11-13 | 286.26 | 2171.29 | |
SO55606_1 | 6 | 17280 | 380 | 9 | 2024-01-27 | 61.08 | 2024-01-15 | 2443.35 | 1 | SO55606 | 2024-01-22 | 195.47 | 1554.95 | |
SO62151_1 | 100 | 20395 | 388 | 4 | 2024-05-08 | 28.01 | 2024-04-26 | 1120.49 | 1 | SO62151 | 2024-05-03 | 89.64 | 713.08 | |
SO68690_1 | 100 | 29257 | 529 | 4 | 2024-08-13 | 0.10 | 2024-08-01 | 3.99 | 1 | SO68690 | 2024-08-08 | 0.32 | 1.49 | |
SO43813_1 | 39 | 28390 | 350 | 7 | 2021-11-18 | 84.37 | 2021-11-06 | 3374.99 | 1 | SO43813 | 2021-11-13 | 270.00 | 1898.09 | |
SO55606_2 | 6 | 17280 | 479 | 9 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55606 | 2024-01-22 | 0.72 | 3.36 | |
SO62151_2 | 100 | 20395 | 214 | 4 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 2 | SO62151 | 2024-05-03 | 2.80 | 13.09 | |
SO68690_2 | 100 | 29257 | 480 | 4 | 2024-08-13 | 0.06 | 2024-08-01 | 2.29 | 2 | SO68690 | 2024-08-08 | 0.18 | 0.86 | |
SO43814_1 | 100 | 25866 | 350 | 1 | 2021-11-18 | 84.37 | 2021-11-06 | 3374.99 | 1 | SO43814 | 2021-11-13 | 270.00 | 1898.09 | |
SO55606_3 | 6 | 17280 | 477 | 9 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 3 | SO55606 | 2024-01-22 | 0.40 | 1.87 |
Generated 2024-11-10 22:11:18.100 UTC