[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 1970 > < TAKE 48 >
48 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61095_3 | 100 | 14185 | 477 | 7 | 2024-04-26 | 0.12 | 2024-04-14 | 4.99 | 3 | SO61095 | 2024-04-21 | 0.40 | 1.87 | |
SO61095_4 | 100 | 14185 | 217 | 7 | 2024-04-26 | 0.87 | 2024-04-14 | 34.99 | 4 | SO61095 | 2024-04-21 | 2.80 | 13.09 | |
SO61097_1 | 100 | 14773 | 361 | 7 | 2024-04-26 | 57.37 | 2024-04-14 | 2294.99 | 1 | SO61097 | 2024-04-21 | 183.60 | 1251.98 | |
SO61097_2 | 100 | 14773 | 483 | 7 | 2024-04-26 | 3.00 | 2024-04-14 | 120.00 | 2 | SO61097 | 2024-04-21 | 9.60 | 44.88 | |
SO61136_1 | 100 | 16186 | 528 | 7 | 2024-04-26 | 0.12 | 2024-04-14 | 4.99 | 1 | SO61136 | 2024-04-21 | 0.40 | 1.87 | |
SO61136_2 | 100 | 16186 | 535 | 7 | 2024-04-26 | 0.62 | 2024-04-14 | 24.99 | 2 | SO61136 | 2024-04-21 | 2.00 | 9.35 | |
SO61136_3 | 100 | 16186 | 214 | 7 | 2024-04-26 | 0.87 | 2024-04-14 | 34.99 | 3 | SO61136 | 2024-04-21 | 2.80 | 13.09 | |
SO61140_1 | 100 | 16042 | 535 | 7 | 2024-04-26 | 0.62 | 2024-04-14 | 24.99 | 1 | SO61140 | 2024-04-21 | 2.00 | 9.35 | |
SO61141_1 | 100 | 28546 | 475 | 7 | 2024-04-26 | 1.75 | 2024-04-14 | 69.99 | 1 | SO61141 | 2024-04-21 | 5.60 | 26.18 | |
SO61141_2 | 100 | 28546 | 228 | 7 | 2024-04-26 | 1.25 | 2024-04-14 | 49.99 | 2 | SO61141 | 2024-04-21 | 4.00 | 38.49 | |
SO61144_1 | 100 | 19272 | 225 | 7 | 2024-04-26 | 0.22 | 2024-04-14 | 8.99 | 1 | SO61144 | 2024-04-21 | 0.72 | 6.92 | |
SO61144_2 | 100 | 19272 | 477 | 7 | 2024-04-26 | 0.12 | 2024-04-14 | 4.99 | 2 | SO61144 | 2024-04-21 | 0.40 | 1.87 | |
SO61145_1 | 100 | 18040 | 536 | 7 | 2024-04-26 | 0.75 | 2024-04-14 | 29.99 | 1 | SO61145 | 2024-04-21 | 2.40 | 11.22 | |
SO61145_2 | 100 | 18040 | 528 | 7 | 2024-04-26 | 0.12 | 2024-04-14 | 4.99 | 2 | SO61145 | 2024-04-21 | 0.40 | 1.87 | |
SO52729_2 | 100 | 23758 | 489 | 7 | 2023-12-13 | 1.35 | 2023-12-01 | 53.99 | 2 | SO52729 | 2023-12-08 | 4.32 | 41.57 | |
SO52731_1 | 100 | 11378 | 353 | 7 | 2023-12-13 | 58.00 | 2023-12-01 | 2319.99 | 1 | SO52731 | 2023-12-08 | 185.60 | 1265.62 | |
SO52731_2 | 100 | 11378 | 478 | 7 | 2023-12-13 | 0.25 | 2023-12-01 | 9.99 | 2 | SO52731 | 2023-12-08 | 0.80 | 3.74 | |
SO52731_3 | 100 | 11378 | 217 | 7 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 3 | SO52731 | 2023-12-08 | 2.80 | 13.09 | |
SO52748_1 | 100 | 17211 | 528 | 7 | 2023-12-13 | 0.12 | 2023-12-01 | 4.99 | 1 | SO52748 | 2023-12-08 | 0.40 | 1.87 | |
SO52748_2 | 100 | 17211 | 537 | 7 | 2023-12-13 | 0.88 | 2023-12-01 | 35.00 | 2 | SO52748 | 2023-12-08 | 2.80 | 13.09 | |
SO52748_3 | 100 | 17211 | 484 | 7 | 2023-12-13 | 0.20 | 2023-12-01 | 7.95 | 3 | SO52748 | 2023-12-08 | 0.64 | 2.97 | |
SO52749_1 | 100 | 14166 | 485 | 7 | 2023-12-13 | 0.55 | 2023-12-01 | 21.98 | 1 | SO52749 | 2023-12-08 | 1.76 | 8.22 | |
SO52749_2 | 100 | 14166 | 237 | 2 | 7 | 2023-12-13 | 1.25 | 2023-12-01 | 49.99 | 2 | SO52749 | 2023-12-08 | 4.00 | 38.49 |
SO52752_1 | 100 | 19521 | 529 | 7 | 2023-12-13 | 0.10 | 2023-12-01 | 3.99 | 1 | SO52752 | 2023-12-08 | 0.32 | 1.49 | |
SO52752_2 | 100 | 19521 | 228 | 7 | 2023-12-13 | 1.25 | 2023-12-01 | 49.99 | 2 | SO52752 | 2023-12-08 | 4.00 | 38.49 | |
SO52756_1 | 100 | 12514 | 225 | 7 | 2023-12-13 | 0.22 | 2023-12-01 | 8.99 | 1 | SO52756 | 2023-12-08 | 0.72 | 6.92 | |
SO52768_1 | 100 | 19336 | 382 | 7 | 2023-12-13 | 28.01 | 2023-12-01 | 1120.49 | 1 | SO52768 | 2023-12-08 | 89.64 | 713.08 | |
SO52768_2 | 100 | 19336 | 491 | 7 | 2023-12-13 | 1.35 | 2023-12-01 | 53.99 | 2 | SO52768 | 2023-12-08 | 4.32 | 41.57 | |
SO52769_1 | 100 | 19381 | 386 | 7 | 2023-12-13 | 28.01 | 2023-12-01 | 1120.49 | 1 | SO52769 | 2023-12-08 | 89.64 | 713.08 | |
SO52769_2 | 100 | 19381 | 228 | 7 | 2023-12-13 | 1.25 | 2023-12-01 | 49.99 | 2 | SO52769 | 2023-12-08 | 4.00 | 38.49 | |
SO52770_1 | 100 | 21050 | 605 | 7 | 2023-12-13 | 13.50 | 2023-12-01 | 539.99 | 1 | SO52770 | 2023-12-08 | 43.20 | 343.65 | |
SO52770_2 | 100 | 21050 | 225 | 7 | 2023-12-13 | 0.22 | 2023-12-01 | 8.99 | 2 | SO52770 | 2023-12-08 | 0.72 | 6.92 | |
SO52770_3 | 100 | 21050 | 214 | 7 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 3 | SO52770 | 2023-12-08 | 2.80 | 13.09 | |
SO52772_1 | 100 | 21031 | 605 | 7 | 2023-12-13 | 13.50 | 2023-12-01 | 539.99 | 1 | SO52772 | 2023-12-08 | 43.20 | 343.65 | |
SO52772_2 | 100 | 21031 | 479 | 7 | 2023-12-13 | 0.22 | 2023-12-01 | 8.99 | 2 | SO52772 | 2023-12-08 | 0.72 | 3.36 | |
SO52772_3 | 100 | 21031 | 477 | 7 | 2023-12-13 | 0.12 | 2023-12-01 | 4.99 | 3 | SO52772 | 2023-12-08 | 0.40 | 1.87 | |
SO52772_4 | 100 | 21031 | 225 | 7 | 2023-12-13 | 0.22 | 2023-12-01 | 8.99 | 4 | SO52772 | 2023-12-08 | 0.72 | 6.92 | |
SO52772_5 | 100 | 21031 | 214 | 7 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 5 | SO52772 | 2023-12-08 | 2.80 | 13.09 | |
SO52811_1 | 100 | 28391 | 540 | 7 | 2023-12-14 | 0.82 | 2023-12-02 | 32.60 | 1 | SO52811 | 2023-12-09 | 2.61 | 12.19 | |
SO52815_1 | 100 | 21070 | 538 | 7 | 2023-12-14 | 0.54 | 2023-12-02 | 21.49 | 1 | SO52815 | 2023-12-09 | 1.72 | 8.04 | |
SO52815_2 | 100 | 21070 | 225 | 7 | 2023-12-14 | 0.22 | 2023-12-02 | 8.99 | 2 | SO52815 | 2023-12-09 | 0.72 | 6.92 | |
SO52816_1 | 100 | 20146 | 529 | 7 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 1 | SO52816 | 2023-12-09 | 0.32 | 1.49 | |
SO52817_1 | 100 | 19185 | 477 | 7 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 1 | SO52817 | 2023-12-09 | 0.40 | 1.87 | |
SO52817_2 | 100 | 19185 | 488 | 7 | 2023-12-14 | 1.35 | 2023-12-02 | 53.99 | 2 | SO52817 | 2023-12-09 | 4.32 | 41.57 | |
SO52820_1 | 100 | 25672 | 530 | 7 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 1 | SO52820 | 2023-12-09 | 0.40 | 1.87 | |
SO52820_2 | 100 | 25672 | 480 | 2 | 7 | 2023-12-14 | 0.06 | 2023-12-02 | 2.29 | 2 | SO52820 | 2023-12-09 | 0.18 | 0.86 |
SO52840_1 | 100 | 24083 | 564 | 7 | 2023-12-14 | 59.60 | 2023-12-02 | 2384.07 | 1 | SO52840 | 2023-12-09 | 190.73 | 1481.94 | |
SO52840_2 | 100 | 24083 | 214 | 7 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 2 | SO52840 | 2023-12-09 | 2.80 | 13.09 |
Generated 2024-11-13 06:29:31.845 UTC