[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > SKIP 1000 < SKIP 2455 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO54204_1 | 98 | 16444 | 587 | 10 | 2024-01-04 | 19.24 | 2023-12-23 | 769.49 | 1 | SO54204 | 2023-12-30 | 61.56 | 419.78 | |
SO54204_2 | 98 | 16444 | 228 | 10 | 2024-01-04 | 1.25 | 2023-12-23 | 49.99 | 2 | SO54204 | 2023-12-30 | 4.00 | 38.49 | |
SO54204_3 | 98 | 16444 | 482 | 10 | 2024-01-04 | 0.22 | 2023-12-23 | 8.99 | 3 | SO54204 | 2023-12-30 | 0.72 | 3.36 | |
SO54226_1 | 98 | 22554 | 477 | 10 | 2024-01-04 | 0.12 | 2023-12-23 | 4.99 | 1 | SO54226 | 2023-12-30 | 0.40 | 1.87 | |
SO54228_1 | 98 | 27788 | 529 | 10 | 2024-01-04 | 0.10 | 2023-12-23 | 3.99 | 1 | SO54228 | 2023-12-30 | 0.32 | 1.49 | |
SO54228_2 | 98 | 27788 | 480 | 10 | 2024-01-04 | 0.06 | 2023-12-23 | 2.29 | 2 | SO54228 | 2023-12-30 | 0.18 | 0.86 | |
SO54246_1 | 98 | 22686 | 384 | 10 | 2024-01-04 | 28.01 | 2023-12-23 | 1120.49 | 1 | SO54246 | 2023-12-30 | 89.64 | 713.08 | |
SO54246_2 | 98 | 22686 | 539 | 10 | 2024-01-04 | 0.62 | 2023-12-23 | 24.99 | 2 | SO54246 | 2023-12-30 | 2.00 | 9.35 | |
SO54246_3 | 98 | 22686 | 529 | 10 | 2024-01-04 | 0.10 | 2023-12-23 | 3.99 | 3 | SO54246 | 2023-12-30 | 0.32 | 1.49 | |
SO54246_4 | 98 | 22686 | 214 | 10 | 2024-01-04 | 0.87 | 2023-12-23 | 34.99 | 4 | SO54246 | 2023-12-30 | 2.80 | 13.09 | |
SO54246_5 | 98 | 22686 | 231 | 10 | 2024-01-04 | 1.25 | 2023-12-23 | 49.99 | 5 | SO54246 | 2023-12-30 | 4.00 | 38.49 | |
SO54246_6 | 98 | 22686 | 225 | 10 | 2024-01-04 | 0.22 | 2023-12-23 | 8.99 | 6 | SO54246 | 2023-12-30 | 0.72 | 6.92 | |
SO54248_1 | 98 | 23751 | 384 | 10 | 2024-01-04 | 28.01 | 2023-12-23 | 1120.49 | 1 | SO54248 | 2023-12-30 | 89.64 | 713.08 | |
SO54248_2 | 98 | 23751 | 217 | 10 | 2024-01-04 | 0.87 | 2023-12-23 | 34.99 | 2 | SO54248 | 2023-12-30 | 2.80 | 13.09 | |
SO54252_1 | 98 | 12292 | 363 | 10 | 2024-01-05 | 57.37 | 2023-12-24 | 2294.99 | 1 | SO54252 | 2023-12-31 | 183.60 | 1251.98 | |
SO54252_2 | 98 | 12292 | 483 | 10 | 2024-01-05 | 3.00 | 2023-12-24 | 120.00 | 2 | SO54252 | 2023-12-31 | 9.60 | 44.88 | |
SO54265_1 | 98 | 19471 | 374 | 10 | 2024-01-05 | 61.08 | 2023-12-24 | 2443.35 | 1 | SO54265 | 2023-12-31 | 195.47 | 1554.95 | |
SO54265_2 | 98 | 19471 | 214 | 10 | 2024-01-05 | 0.87 | 2023-12-24 | 34.99 | 2 | SO54265 | 2023-12-31 | 2.80 | 13.09 | |
SO54267_1 | 98 | 11604 | 357 | 10 | 2024-01-05 | 58.00 | 2023-12-24 | 2319.99 | 1 | SO54267 | 2023-12-31 | 185.60 | 1265.62 | |
SO54267_2 | 98 | 11604 | 478 | 10 | 2024-01-05 | 0.25 | 2023-12-24 | 9.99 | 2 | SO54267 | 2023-12-31 | 0.80 | 3.74 | |
SO54267_3 | 98 | 11604 | 225 | 10 | 2024-01-05 | 0.22 | 2023-12-24 | 8.99 | 3 | SO54267 | 2023-12-31 | 0.72 | 6.92 | |
SO54267_4 | 98 | 11604 | 477 | 10 | 2024-01-05 | 0.12 | 2023-12-24 | 4.99 | 4 | SO54267 | 2023-12-31 | 0.40 | 1.87 | |
SO54286_1 | 98 | 20714 | 529 | 10 | 2024-01-05 | 0.10 | 2023-12-24 | 3.99 | 1 | SO54286 | 2023-12-31 | 0.32 | 1.49 | |
SO54286_2 | 98 | 20714 | 539 | 10 | 2024-01-05 | 0.62 | 2023-12-24 | 24.99 | 2 | SO54286 | 2023-12-31 | 2.00 | 9.35 | |
SO54286_3 | 98 | 20714 | 486 | 10 | 2024-01-05 | 3.98 | 2023-12-24 | 159.00 | 3 | SO54286 | 2023-12-31 | 12.72 | 59.47 | |
SO54288_1 | 98 | 14953 | 476 | 10 | 2024-01-05 | 1.75 | 2023-12-24 | 69.99 | 1 | SO54288 | 2023-12-31 | 5.60 | 26.18 | |
SO54288_2 | 98 | 14953 | 471 | 10 | 2024-01-05 | 1.59 | 2023-12-24 | 63.50 | 2 | SO54288 | 2023-12-31 | 5.08 | 23.75 | |
SO54290_1 | 98 | 19334 | 539 | 10 | 2024-01-05 | 0.62 | 2023-12-24 | 24.99 | 1 | SO54290 | 2023-12-31 | 2.00 | 9.35 | |
SO54290_2 | 98 | 19334 | 529 | 10 | 2024-01-05 | 0.10 | 2023-12-24 | 3.99 | 2 | SO54290 | 2023-12-31 | 0.32 | 1.49 | |
SO54290_3 | 98 | 19334 | 217 | 10 | 2024-01-05 | 0.87 | 2023-12-24 | 34.99 | 3 | SO54290 | 2023-12-31 | 2.80 | 13.09 | |
SO54291_1 | 98 | 11419 | 538 | 10 | 2024-01-05 | 0.54 | 2023-12-24 | 21.49 | 1 | SO54291 | 2023-12-31 | 1.72 | 8.04 | |
SO54291_2 | 98 | 11419 | 480 | 10 | 2024-01-05 | 0.06 | 2023-12-24 | 2.29 | 2 | SO54291 | 2023-12-31 | 0.18 | 0.86 | |
SO54291_3 | 98 | 11419 | 486 | 10 | 2024-01-05 | 3.98 | 2023-12-24 | 159.00 | 3 | SO54291 | 2023-12-31 | 12.72 | 59.47 | |
SO54300_1 | 98 | 12286 | 570 | 13 | 10 | 2024-01-05 | 18.56 | 2023-12-24 | 742.35 | 1 | SO54300 | 2023-12-31 | 59.39 | 461.44 |
SO54300_2 | 98 | 12286 | 479 | 10 | 2024-01-05 | 0.22 | 2023-12-24 | 8.99 | 2 | SO54300 | 2023-12-31 | 0.72 | 3.36 | |
SO54300_3 | 98 | 12286 | 477 | 10 | 2024-01-05 | 0.12 | 2023-12-24 | 4.99 | 3 | SO54300 | 2023-12-31 | 0.40 | 1.87 | |
SO54300_4 | 98 | 12286 | 214 | 10 | 2024-01-05 | 0.87 | 2023-12-24 | 34.99 | 4 | SO54300 | 2023-12-31 | 2.80 | 13.09 | |
SO54300_5 | 98 | 12286 | 225 | 10 | 2024-01-05 | 0.22 | 2023-12-24 | 8.99 | 5 | SO54300 | 2023-12-31 | 0.72 | 6.92 | |
SO54301_1 | 98 | 11238 | 578 | 10 | 2024-01-05 | 30.37 | 2023-12-24 | 1214.85 | 1 | SO54301 | 2023-12-31 | 97.19 | 755.15 | |
SO54301_2 | 98 | 11238 | 214 | 10 | 2024-01-05 | 0.87 | 2023-12-24 | 34.99 | 2 | SO54301 | 2023-12-31 | 2.80 | 13.09 | |
SO54311_1 | 98 | 25748 | 584 | 10 | 2024-01-05 | 13.50 | 2023-12-24 | 539.99 | 1 | SO54311 | 2023-12-31 | 43.20 | 343.65 | |
SO54342_1 | 98 | 19060 | 485 | 10 | 2024-01-06 | 0.55 | 2023-12-25 | 21.98 | 1 | SO54342 | 2024-01-01 | 1.76 | 8.22 | |
SO54342_2 | 98 | 19060 | 484 | 10 | 2024-01-06 | 0.20 | 2023-12-25 | 7.95 | 2 | SO54342 | 2024-01-01 | 0.64 | 2.97 | |
SO54346_1 | 98 | 17193 | 537 | 10 | 2024-01-06 | 0.88 | 2023-12-25 | 35.00 | 1 | SO54346 | 2024-01-01 | 2.80 | 13.09 | |
SO54346_2 | 98 | 17193 | 528 | 10 | 2024-01-06 | 0.12 | 2023-12-25 | 4.99 | 2 | SO54346 | 2024-01-01 | 0.40 | 1.87 | |
SO54346_3 | 98 | 17193 | 214 | 10 | 2024-01-06 | 0.87 | 2023-12-25 | 34.99 | 3 | SO54346 | 2024-01-01 | 2.80 | 13.09 | |
SO54347_1 | 98 | 19520 | 539 | 10 | 2024-01-06 | 0.62 | 2023-12-25 | 24.99 | 1 | SO54347 | 2024-01-01 | 2.00 | 9.35 | |
SO54347_2 | 98 | 19520 | 491 | 10 | 2024-01-06 | 1.35 | 2023-12-25 | 53.99 | 2 | SO54347 | 2024-01-01 | 4.32 | 41.57 | |
SO54347_3 | 98 | 19520 | 225 | 10 | 2024-01-06 | 0.22 | 2023-12-25 | 8.99 | 3 | SO54347 | 2024-01-01 | 0.72 | 6.92 | |
SO54350_1 | 98 | 14194 | 541 | 10 | 2024-01-06 | 0.72 | 2023-12-25 | 28.99 | 1 | SO54350 | 2024-01-01 | 2.32 | 10.84 | |
SO54350_2 | 98 | 14194 | 530 | 10 | 2024-01-06 | 0.12 | 2023-12-25 | 4.99 | 2 | SO54350 | 2024-01-01 | 0.40 | 1.87 | |
SO54350_3 | 98 | 14194 | 214 | 10 | 2024-01-06 | 0.87 | 2023-12-25 | 34.99 | 3 | SO54350 | 2024-01-01 | 2.80 | 13.09 | |
SO54359_1 | 98 | 12282 | 568 | 13 | 10 | 2024-01-06 | 18.56 | 2023-12-25 | 742.35 | 1 | SO54359 | 2024-01-01 | 59.39 | 461.44 |
SO54375_1 | 98 | 27839 | 576 | 10 | 2024-01-06 | 59.60 | 2023-12-25 | 2384.07 | 1 | SO54375 | 2024-01-01 | 190.73 | 1481.94 | |
SO54375_2 | 98 | 27839 | 222 | 10 | 2024-01-06 | 0.87 | 2023-12-25 | 34.99 | 2 | SO54375 | 2024-01-01 | 2.80 | 13.09 | |
SO54378_1 | 98 | 12315 | 353 | 2 | 10 | 2024-01-07 | 58.00 | 2023-12-26 | 2319.99 | 1 | SO54378 | 2024-01-02 | 185.60 | 1265.62 |
SO54378_2 | 98 | 12315 | 478 | 10 | 2024-01-07 | 0.25 | 2023-12-26 | 9.99 | 2 | SO54378 | 2024-01-02 | 0.80 | 3.74 | |
SO54378_3 | 98 | 12315 | 477 | 10 | 2024-01-07 | 0.12 | 2023-12-26 | 4.99 | 3 | SO54378 | 2024-01-02 | 0.40 | 1.87 | |
SO54404_1 | 98 | 23769 | 477 | 10 | 2024-01-07 | 0.12 | 2023-12-26 | 4.99 | 1 | SO54404 | 2024-01-02 | 0.40 | 1.87 | |
SO54404_2 | 98 | 23769 | 465 | 10 | 2024-01-07 | 0.61 | 2023-12-26 | 24.49 | 2 | SO54404 | 2024-01-02 | 1.96 | 9.16 |
Generated 2024-11-10 06:21:26.395 UTC