[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1564 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO52462_1 | 100 | 19531 | 386 | 4 | 2023-12-04 | 28.01 | 2023-11-22 | 1120.49 | 1 | SO52462 | 2023-11-29 | 89.64 | 713.08 | |
SO52462_2 | 100 | 19531 | 214 | 4 | 2023-12-04 | 0.87 | 2023-11-22 | 34.99 | 2 | SO52462 | 2023-11-29 | 2.80 | 13.09 | |
SO52462_3 | 100 | 19531 | 463 | 4 | 2023-12-04 | 0.61 | 2023-11-22 | 24.49 | 3 | SO52462 | 2023-11-29 | 1.96 | 9.16 | |
SO52486_1 | 100 | 27996 | 530 | 4 | 2023-12-05 | 0.12 | 2023-11-23 | 4.99 | 1 | SO52486 | 2023-11-30 | 0.40 | 1.87 | |
SO52486_2 | 100 | 27996 | 487 | 4 | 2023-12-05 | 1.37 | 2023-11-23 | 54.99 | 2 | SO52486 | 2023-11-30 | 4.40 | 20.57 | |
SO52486_3 | 100 | 27996 | 484 | 4 | 2023-12-05 | 0.20 | 2023-11-23 | 7.95 | 3 | SO52486 | 2023-11-30 | 0.64 | 2.97 | |
SO52490_1 | 100 | 22090 | 536 | 4 | 2023-12-05 | 0.75 | 2023-11-23 | 29.99 | 1 | SO52490 | 2023-11-30 | 2.40 | 11.22 | |
SO52490_2 | 100 | 22090 | 480 | 2 | 4 | 2023-12-05 | 0.06 | 2023-11-23 | 2.29 | 2 | SO52490 | 2023-11-30 | 0.18 | 0.86 |
SO52492_1 | 100 | 22052 | 478 | 4 | 2023-12-05 | 0.25 | 2023-11-23 | 9.99 | 1 | SO52492 | 2023-11-30 | 0.80 | 3.74 | |
SO52492_2 | 100 | 22052 | 477 | 4 | 2023-12-05 | 0.12 | 2023-11-23 | 4.99 | 2 | SO52492 | 2023-11-30 | 0.40 | 1.87 | |
SO52494_1 | 100 | 18967 | 474 | 4 | 2023-12-05 | 1.75 | 2023-11-23 | 69.99 | 1 | SO52494 | 2023-11-30 | 5.60 | 26.18 | |
SO52494_2 | 100 | 18967 | 489 | 4 | 2023-12-05 | 1.35 | 2023-11-23 | 53.99 | 2 | SO52494 | 2023-11-30 | 4.32 | 41.57 | |
SO52494_3 | 100 | 18967 | 225 | 4 | 2023-12-05 | 0.22 | 2023-11-23 | 8.99 | 3 | SO52494 | 2023-11-30 | 0.72 | 6.92 | |
SO52497_1 | 100 | 18687 | 467 | 2 | 4 | 2023-12-05 | 0.61 | 2023-11-23 | 24.49 | 1 | SO52497 | 2023-11-30 | 1.96 | 9.16 |
SO52497_2 | 100 | 18687 | 474 | 4 | 2023-12-05 | 1.75 | 2023-11-23 | 69.99 | 2 | SO52497 | 2023-11-30 | 5.60 | 26.18 | |
SO52499_1 | 100 | 15414 | 528 | 4 | 2023-12-05 | 0.12 | 2023-11-23 | 4.99 | 1 | SO52499 | 2023-11-30 | 0.40 | 1.87 | |
SO52500_1 | 100 | 15469 | 528 | 4 | 2023-12-05 | 0.12 | 2023-11-23 | 4.99 | 1 | SO52500 | 2023-11-30 | 0.40 | 1.87 | |
SO52500_2 | 100 | 15469 | 214 | 4 | 2023-12-05 | 0.87 | 2023-11-23 | 34.99 | 2 | SO52500 | 2023-11-30 | 2.80 | 13.09 | |
SO52510_1 | 100 | 13339 | 485 | 4 | 2023-12-05 | 0.55 | 2023-11-23 | 21.98 | 1 | SO52510 | 2023-11-30 | 1.76 | 8.22 | |
SO52510_2 | 100 | 13339 | 482 | 4 | 2023-12-05 | 0.22 | 2023-11-23 | 8.99 | 2 | SO52510 | 2023-11-30 | 0.72 | 3.36 | |
SO52511_1 | 100 | 13854 | 589 | 4 | 2023-12-05 | 19.24 | 2023-11-23 | 769.49 | 1 | SO52511 | 2023-11-30 | 61.56 | 419.78 | |
SO52511_2 | 100 | 13854 | 536 | 4 | 2023-12-05 | 0.75 | 2023-11-23 | 29.99 | 2 | SO52511 | 2023-11-30 | 2.40 | 11.22 | |
SO52511_3 | 100 | 13854 | 528 | 4 | 2023-12-05 | 0.12 | 2023-11-23 | 4.99 | 3 | SO52511 | 2023-11-30 | 0.40 | 1.87 | |
SO52512_1 | 100 | 11016 | 363 | 4 | 2023-12-05 | 57.37 | 2023-11-23 | 2294.99 | 1 | SO52512 | 2023-11-30 | 183.60 | 1251.98 | |
SO52512_2 | 100 | 11016 | 537 | 4 | 2023-12-05 | 0.88 | 2023-11-23 | 35.00 | 2 | SO52512 | 2023-11-30 | 2.80 | 13.09 | |
SO52512_3 | 100 | 11016 | 480 | 4 | 2023-12-05 | 0.06 | 2023-11-23 | 2.29 | 3 | SO52512 | 2023-11-30 | 0.18 | 0.86 | |
SO52515_1 | 100 | 12052 | 355 | 4 | 2023-12-05 | 58.00 | 2023-11-23 | 2319.99 | 1 | SO52515 | 2023-11-30 | 185.60 | 1265.62 | |
SO52515_2 | 100 | 12052 | 537 | 4 | 2023-12-05 | 0.88 | 2023-11-23 | 35.00 | 2 | SO52515 | 2023-11-30 | 2.80 | 13.09 | |
SO52515_3 | 100 | 12052 | 480 | 4 | 2023-12-05 | 0.06 | 2023-11-23 | 2.29 | 3 | SO52515 | 2023-11-30 | 0.18 | 0.86 | |
SO52517_1 | 100 | 28673 | 585 | 4 | 2023-12-05 | 18.56 | 2023-11-23 | 742.35 | 1 | SO52517 | 2023-11-30 | 59.39 | 461.44 | |
SO52517_2 | 100 | 28673 | 217 | 4 | 2023-12-05 | 0.87 | 2023-11-23 | 34.99 | 2 | SO52517 | 2023-11-30 | 2.80 | 13.09 | |
SO52517_3 | 100 | 28673 | 463 | 4 | 2023-12-05 | 0.61 | 2023-11-23 | 24.49 | 3 | SO52517 | 2023-11-30 | 1.96 | 9.16 | |
SO52520_1 | 100 | 21309 | 390 | 4 | 2023-12-05 | 28.01 | 2023-11-23 | 1120.49 | 1 | SO52520 | 2023-11-30 | 89.64 | 713.08 | |
SO52520_2 | 100 | 21309 | 491 | 4 | 2023-12-05 | 1.35 | 2023-11-23 | 53.99 | 2 | SO52520 | 2023-11-30 | 4.32 | 41.57 | |
SO52520_3 | 100 | 21309 | 225 | 4 | 2023-12-05 | 0.22 | 2023-11-23 | 8.99 | 3 | SO52520 | 2023-11-30 | 0.72 | 6.92 | |
SO52524_1 | 100 | 11793 | 217 | 4 | 2023-12-06 | 0.87 | 2023-11-24 | 34.99 | 1 | SO52524 | 2023-12-01 | 2.80 | 13.09 | |
SO52536_1 | 100 | 26123 | 535 | 4 | 2023-12-06 | 0.62 | 2023-11-24 | 24.99 | 1 | SO52536 | 2023-12-01 | 2.00 | 9.35 | |
SO52536_2 | 100 | 26123 | 528 | 4 | 2023-12-06 | 0.12 | 2023-11-24 | 4.99 | 2 | SO52536 | 2023-12-01 | 0.40 | 1.87 | |
SO52536_3 | 100 | 26123 | 217 | 4 | 2023-12-06 | 0.87 | 2023-11-24 | 34.99 | 3 | SO52536 | 2023-12-01 | 2.80 | 13.09 | |
SO52539_1 | 100 | 22055 | 478 | 4 | 2023-12-06 | 0.25 | 2023-11-24 | 9.99 | 1 | SO52539 | 2023-12-01 | 0.80 | 3.74 | |
SO52539_2 | 100 | 22055 | 477 | 4 | 2023-12-06 | 0.12 | 2023-11-24 | 4.99 | 2 | SO52539 | 2023-12-01 | 0.40 | 1.87 | |
SO52539_3 | 100 | 22055 | 225 | 4 | 2023-12-06 | 0.22 | 2023-11-24 | 8.99 | 3 | SO52539 | 2023-12-01 | 0.72 | 6.92 | |
SO52545_1 | 100 | 14901 | 528 | 4 | 2023-12-06 | 0.12 | 2023-11-24 | 4.99 | 1 | SO52545 | 2023-12-01 | 0.40 | 1.87 | |
SO52545_2 | 100 | 14901 | 480 | 2 | 4 | 2023-12-06 | 0.06 | 2023-11-24 | 2.29 | 2 | SO52545 | 2023-12-01 | 0.18 | 0.86 |
SO52558_1 | 100 | 11065 | 537 | 4 | 2023-12-06 | 0.88 | 2023-11-24 | 35.00 | 1 | SO52558 | 2023-12-01 | 2.80 | 13.09 | |
SO52558_2 | 100 | 11065 | 480 | 4 | 2023-12-06 | 0.06 | 2023-11-24 | 2.29 | 2 | SO52558 | 2023-12-01 | 0.18 | 0.86 | |
SO52558_3 | 100 | 11065 | 486 | 4 | 2023-12-06 | 3.98 | 2023-11-24 | 159.00 | 3 | SO52558 | 2023-12-01 | 12.72 | 59.47 | |
SO52565_1 | 100 | 11831 | 353 | 4 | 2023-12-06 | 58.00 | 2023-11-24 | 2319.99 | 1 | SO52565 | 2023-12-01 | 185.60 | 1265.62 | |
SO52565_2 | 100 | 11831 | 217 | 4 | 2023-12-06 | 0.87 | 2023-11-24 | 34.99 | 2 | SO52565 | 2023-12-01 | 2.80 | 13.09 | |
SO52566_1 | 100 | 11227 | 361 | 4 | 2023-12-06 | 57.37 | 2023-11-24 | 2294.99 | 1 | SO52566 | 2023-12-01 | 183.60 | 1251.98 | |
SO52566_2 | 100 | 11227 | 485 | 4 | 2023-12-06 | 0.55 | 2023-11-24 | 21.98 | 2 | SO52566 | 2023-12-01 | 1.76 | 8.22 | |
SO52566_3 | 100 | 11227 | 477 | 4 | 2023-12-06 | 0.12 | 2023-11-24 | 4.99 | 3 | SO52566 | 2023-12-01 | 0.40 | 1.87 | |
SO52566_4 | 100 | 11227 | 478 | 4 | 2023-12-06 | 0.25 | 2023-11-24 | 9.99 | 4 | SO52566 | 2023-12-01 | 0.80 | 3.74 | |
SO52567_1 | 100 | 11329 | 355 | 4 | 2023-12-06 | 58.00 | 2023-11-24 | 2319.99 | 1 | SO52567 | 2023-12-01 | 185.60 | 1265.62 | |
SO52571_1 | 100 | 19402 | 390 | 4 | 2023-12-06 | 28.01 | 2023-11-24 | 1120.49 | 1 | SO52571 | 2023-12-01 | 89.64 | 713.08 | |
SO52571_2 | 100 | 19402 | 479 | 4 | 2023-12-06 | 0.22 | 2023-11-24 | 8.99 | 2 | SO52571 | 2023-12-01 | 0.72 | 3.36 |
Generated 2024-11-10 17:15:18.896 UTC