[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '8' > < SKIP 1427 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56486_1 | 100 | 13697 | 357 | 8 | 2024-02-13 | 58.00 | 2024-02-01 | 2319.99 | 1 | SO56486 | 2024-02-08 | 185.60 | 1265.62 | |
SO56486_2 | 100 | 13697 | 478 | 8 | 2024-02-13 | 0.25 | 2024-02-01 | 9.99 | 2 | SO56486 | 2024-02-08 | 0.80 | 3.74 | |
SO56486_3 | 100 | 13697 | 477 | 8 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 3 | SO56486 | 2024-02-08 | 0.40 | 1.87 | |
SO56486_4 | 100 | 13697 | 484 | 8 | 2024-02-13 | 0.20 | 2024-02-01 | 7.95 | 4 | SO56486 | 2024-02-08 | 0.64 | 2.97 | |
SO56514_1 | 100 | 21914 | 477 | 8 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 1 | SO56514 | 2024-02-08 | 0.40 | 1.87 | |
SO56514_2 | 100 | 21914 | 214 | 8 | 2024-02-13 | 0.87 | 2024-02-01 | 34.99 | 2 | SO56514 | 2024-02-08 | 2.80 | 13.09 | |
SO56515_1 | 100 | 19178 | 539 | 8 | 2024-02-13 | 0.62 | 2024-02-01 | 24.99 | 1 | SO56515 | 2024-02-08 | 2.00 | 9.35 | |
SO56517_1 | 100 | 24876 | 538 | 8 | 2024-02-13 | 0.54 | 2024-02-01 | 21.49 | 1 | SO56517 | 2024-02-08 | 1.72 | 8.04 | |
SO56517_2 | 100 | 24876 | 529 | 8 | 2024-02-13 | 0.10 | 2024-02-01 | 3.99 | 2 | SO56517 | 2024-02-08 | 0.32 | 1.49 | |
SO56517_3 | 100 | 24876 | 463 | 8 | 2024-02-13 | 0.61 | 2024-02-01 | 24.49 | 3 | SO56517 | 2024-02-08 | 1.96 | 9.16 | |
SO56520_1 | 100 | 27960 | 530 | 8 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 1 | SO56520 | 2024-02-08 | 0.40 | 1.87 | |
SO56520_2 | 100 | 27960 | 480 | 2 | 8 | 2024-02-13 | 0.06 | 2024-02-01 | 2.29 | 2 | SO56520 | 2024-02-08 | 0.18 | 0.86 |
SO56539_1 | 100 | 15684 | 561 | 8 | 2024-02-13 | 59.60 | 2024-02-01 | 2384.07 | 1 | SO56539 | 2024-02-08 | 190.73 | 1481.94 | |
SO56539_2 | 100 | 15684 | 541 | 8 | 2024-02-13 | 0.72 | 2024-02-01 | 28.99 | 2 | SO56539 | 2024-02-08 | 2.32 | 10.84 | |
SO56539_3 | 100 | 15684 | 530 | 8 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 3 | SO56539 | 2024-02-08 | 0.40 | 1.87 | |
SO56539_4 | 100 | 15684 | 467 | 8 | 2024-02-13 | 0.61 | 2024-02-01 | 24.49 | 4 | SO56539 | 2024-02-08 | 1.96 | 9.16 | |
SO56552_1 | 100 | 22621 | 600 | 8 | 2024-02-14 | 13.50 | 2024-02-02 | 539.99 | 1 | SO56552 | 2024-02-09 | 43.20 | 294.58 | |
SO56552_2 | 100 | 22621 | 478 | 8 | 2024-02-14 | 0.25 | 2024-02-02 | 9.99 | 2 | SO56552 | 2024-02-09 | 0.80 | 3.74 | |
SO56552_3 | 100 | 22621 | 477 | 8 | 2024-02-14 | 0.12 | 2024-02-02 | 4.99 | 3 | SO56552 | 2024-02-09 | 0.40 | 1.87 | |
SO56552_4 | 100 | 22621 | 217 | 8 | 2024-02-14 | 0.87 | 2024-02-02 | 34.99 | 4 | SO56552 | 2024-02-09 | 2.80 | 13.09 | |
SO56570_1 | 100 | 21115 | 477 | 8 | 2024-02-14 | 0.12 | 2024-02-02 | 4.99 | 1 | SO56570 | 2024-02-09 | 0.40 | 1.87 | |
SO56573_1 | 100 | 27826 | 538 | 8 | 2024-02-14 | 0.54 | 2024-02-02 | 21.49 | 1 | SO56573 | 2024-02-09 | 1.72 | 8.04 | |
SO56573_2 | 100 | 27826 | 480 | 8 | 2024-02-14 | 0.06 | 2024-02-02 | 2.29 | 2 | SO56573 | 2024-02-09 | 0.18 | 0.86 | |
SO56579_1 | 100 | 12379 | 237 | 8 | 2024-02-14 | 1.25 | 2024-02-02 | 49.99 | 1 | SO56579 | 2024-02-09 | 4.00 | 38.49 | |
SO56580_1 | 100 | 11424 | 222 | 8 | 2024-02-14 | 0.87 | 2024-02-02 | 34.99 | 1 | SO56580 | 2024-02-09 | 2.80 | 13.09 | |
SO56580_2 | 100 | 11424 | 225 | 8 | 2024-02-14 | 0.22 | 2024-02-02 | 8.99 | 2 | SO56580 | 2024-02-09 | 0.72 | 6.92 | |
SO56594_1 | 100 | 11481 | 584 | 8 | 2024-02-14 | 13.50 | 2024-02-02 | 539.99 | 1 | SO56594 | 2024-02-09 | 43.20 | 343.65 | |
SO56594_2 | 100 | 11481 | 479 | 8 | 2024-02-14 | 0.22 | 2024-02-02 | 8.99 | 2 | SO56594 | 2024-02-09 | 0.72 | 3.36 | |
SO56594_3 | 100 | 11481 | 477 | 8 | 2024-02-14 | 0.12 | 2024-02-02 | 4.99 | 3 | SO56594 | 2024-02-09 | 0.40 | 1.87 | |
SO56630_1 | 100 | 25629 | 538 | 8 | 2024-02-15 | 0.54 | 2024-02-03 | 21.49 | 1 | SO56630 | 2024-02-10 | 1.72 | 8.04 | |
SO56630_2 | 100 | 25629 | 480 | 8 | 2024-02-15 | 0.06 | 2024-02-03 | 2.29 | 2 | SO56630 | 2024-02-10 | 0.18 | 0.86 | |
SO56631_1 | 100 | 29435 | 541 | 8 | 2024-02-15 | 0.72 | 2024-02-03 | 28.99 | 1 | SO56631 | 2024-02-10 | 2.32 | 10.84 | |
SO56631_2 | 100 | 29435 | 530 | 8 | 2024-02-15 | 0.12 | 2024-02-03 | 4.99 | 2 | SO56631 | 2024-02-10 | 0.40 | 1.87 | |
SO56631_3 | 100 | 29435 | 222 | 8 | 2024-02-15 | 0.87 | 2024-02-03 | 34.99 | 3 | SO56631 | 2024-02-10 | 2.80 | 13.09 | |
SO56638_1 | 100 | 27883 | 567 | 8 | 2024-02-15 | 18.56 | 2024-02-03 | 742.35 | 1 | SO56638 | 2024-02-10 | 59.39 | 461.44 | |
SO56638_2 | 100 | 27883 | 530 | 8 | 2024-02-15 | 0.12 | 2024-02-03 | 4.99 | 2 | SO56638 | 2024-02-10 | 0.40 | 1.87 | |
SO56638_3 | 100 | 27883 | 541 | 8 | 2024-02-15 | 0.72 | 2024-02-03 | 28.99 | 3 | SO56638 | 2024-02-10 | 2.32 | 10.84 | |
SO56638_4 | 100 | 27883 | 480 | 2 | 8 | 2024-02-15 | 0.06 | 2024-02-03 | 2.29 | 4 | SO56638 | 2024-02-10 | 0.18 | 0.86 |
SO56649_1 | 100 | 24723 | 582 | 8 | 2024-02-16 | 42.52 | 2024-02-04 | 1700.99 | 1 | SO56649 | 2024-02-11 | 136.08 | 1082.51 | |
SO56649_2 | 100 | 24723 | 539 | 8 | 2024-02-16 | 0.62 | 2024-02-04 | 24.99 | 2 | SO56649 | 2024-02-11 | 2.00 | 9.35 | |
SO56649_3 | 100 | 24723 | 473 | 8 | 2024-02-16 | 1.59 | 2024-02-04 | 63.50 | 3 | SO56649 | 2024-02-11 | 5.08 | 23.75 | |
SO56649_4 | 100 | 24723 | 529 | 8 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 4 | SO56649 | 2024-02-11 | 0.32 | 1.49 | |
SO56666_1 | 100 | 19259 | 529 | 8 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 1 | SO56666 | 2024-02-11 | 0.32 | 1.49 | |
SO56666_2 | 100 | 19259 | 539 | 8 | 2024-02-16 | 0.62 | 2024-02-04 | 24.99 | 2 | SO56666 | 2024-02-11 | 2.00 | 9.35 | |
SO56669_1 | 100 | 17652 | 529 | 8 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 1 | SO56669 | 2024-02-11 | 0.32 | 1.49 | |
SO53216_3 | 100 | 15708 | 217 | 8 | 2023-12-19 | 0.87 | 2023-12-07 | 34.99 | 3 | SO53216 | 2023-12-14 | 2.80 | 13.09 | |
SO53218_1 | 100 | 14688 | 537 | 8 | 2023-12-19 | 0.88 | 2023-12-07 | 35.00 | 1 | SO53218 | 2023-12-14 | 2.80 | 13.09 | |
SO53218_2 | 100 | 14688 | 528 | 8 | 2023-12-19 | 0.12 | 2023-12-07 | 4.99 | 2 | SO53218 | 2023-12-14 | 0.40 | 1.87 | |
SO53218_3 | 100 | 14688 | 222 | 8 | 2023-12-19 | 0.87 | 2023-12-07 | 34.99 | 3 | SO53218 | 2023-12-14 | 2.80 | 13.09 | |
SO53222_1 | 100 | 17111 | 477 | 8 | 2023-12-19 | 0.12 | 2023-12-07 | 4.99 | 1 | SO53222 | 2023-12-14 | 0.40 | 1.87 | |
SO53223_1 | 100 | 26899 | 538 | 8 | 2023-12-19 | 0.54 | 2023-12-07 | 21.49 | 1 | SO53223 | 2023-12-14 | 1.72 | 8.04 | |
SO53223_2 | 100 | 26899 | 480 | 8 | 2023-12-19 | 0.06 | 2023-12-07 | 2.29 | 2 | SO53223 | 2023-12-14 | 0.18 | 0.86 | |
SO53227_1 | 100 | 27321 | 541 | 8 | 2023-12-19 | 0.72 | 2023-12-07 | 28.99 | 1 | SO53227 | 2023-12-14 | 2.32 | 10.84 | |
SO53240_1 | 100 | 11421 | 363 | 2 | 8 | 2023-12-20 | 57.37 | 2023-12-08 | 2294.99 | 1 | SO53240 | 2023-12-15 | 183.60 | 1251.98 |
SO53241_1 | 100 | 11423 | 361 | 8 | 2023-12-20 | 57.37 | 2023-12-08 | 2294.99 | 1 | SO53241 | 2023-12-15 | 183.60 | 1251.98 | |
SO53241_2 | 100 | 11423 | 485 | 8 | 2023-12-20 | 0.55 | 2023-12-08 | 21.98 | 2 | SO53241 | 2023-12-15 | 1.76 | 8.22 |
Generated 2024-11-10 11:43:28.557 UTC