[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > SKIP 187 < SKIP 2997 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59087_1 | 98 | 21018 | 583 | 10 | 2024-03-24 | 42.52 | 2024-03-12 | 1700.99 | 1 | SO59087 | 2024-03-19 | 136.08 | 1082.51 | |
SO59087_2 | 98 | 21018 | 539 | 10 | 2024-03-24 | 0.62 | 2024-03-12 | 24.99 | 2 | SO59087 | 2024-03-19 | 2.00 | 9.35 | |
SO59087_3 | 98 | 21018 | 529 | 10 | 2024-03-24 | 0.10 | 2024-03-12 | 3.99 | 3 | SO59087 | 2024-03-19 | 0.32 | 1.49 | |
SO59087_4 | 98 | 21018 | 480 | 10 | 2024-03-24 | 0.06 | 2024-03-12 | 2.29 | 4 | SO59087 | 2024-03-19 | 0.18 | 0.86 | |
SO59089_1 | 98 | 16045 | 590 | 10 | 2024-03-24 | 19.24 | 2024-03-12 | 769.49 | 1 | SO59089 | 2024-03-19 | 61.56 | 419.78 | |
SO59089_2 | 98 | 16045 | 231 | 10 | 2024-03-24 | 1.25 | 2024-03-12 | 49.99 | 2 | SO59089 | 2024-03-19 | 4.00 | 38.49 | |
SO59103_1 | 98 | 21865 | 529 | 10 | 2024-03-24 | 0.10 | 2024-03-12 | 3.99 | 1 | SO59103 | 2024-03-19 | 0.32 | 1.49 | |
SO59103_2 | 98 | 21865 | 539 | 10 | 2024-03-24 | 0.62 | 2024-03-12 | 24.99 | 2 | SO59103 | 2024-03-19 | 2.00 | 9.35 | |
SO59103_3 | 98 | 21865 | 483 | 10 | 2024-03-24 | 3.00 | 2024-03-12 | 120.00 | 3 | SO59103 | 2024-03-19 | 9.60 | 44.88 | |
SO59118_1 | 98 | 14949 | 586 | 10 | 2024-03-24 | 18.56 | 2024-03-12 | 742.35 | 1 | SO59118 | 2024-03-19 | 59.39 | 461.44 | |
SO59118_2 | 98 | 14949 | 217 | 10 | 2024-03-24 | 0.87 | 2024-03-12 | 34.99 | 2 | SO59118 | 2024-03-19 | 2.80 | 13.09 | |
SO59139_1 | 98 | 29382 | 573 | 10 | 2024-03-24 | 59.60 | 2024-03-12 | 2384.07 | 1 | SO59139 | 2024-03-19 | 190.73 | 1481.94 | |
SO59140_1 | 98 | 28416 | 562 | 10 | 2024-03-24 | 59.60 | 2024-03-12 | 2384.07 | 1 | SO59140 | 2024-03-19 | 190.73 | 1481.94 | |
SO59140_2 | 98 | 28416 | 479 | 10 | 2024-03-24 | 0.22 | 2024-03-12 | 8.99 | 2 | SO59140 | 2024-03-19 | 0.72 | 3.36 | |
SO59140_3 | 98 | 28416 | 477 | 10 | 2024-03-24 | 0.12 | 2024-03-12 | 4.99 | 3 | SO59140 | 2024-03-19 | 0.40 | 1.87 | |
SO59140_4 | 98 | 28416 | 222 | 10 | 2024-03-24 | 0.87 | 2024-03-12 | 34.99 | 4 | SO59140 | 2024-03-19 | 2.80 | 13.09 | |
SO67671_2 | 98 | 20849 | 528 | 10 | 2024-07-28 | 0.12 | 2024-07-16 | 4.99 | 2 | SO67671 | 2024-07-23 | 0.40 | 1.87 | |
SO67671_3 | 98 | 20849 | 222 | 10 | 2024-07-28 | 0.87 | 2024-07-16 | 34.99 | 3 | SO67671 | 2024-07-23 | 2.80 | 13.09 | |
SO67676_1 | 98 | 28448 | 538 | 10 | 2024-07-28 | 0.54 | 2024-07-16 | 21.49 | 1 | SO67676 | 2024-07-23 | 1.72 | 8.04 | |
SO67681_1 | 98 | 12598 | 225 | 10 | 2024-07-28 | 0.22 | 2024-07-16 | 8.99 | 1 | SO67681 | 2024-07-23 | 0.72 | 6.92 | |
SO67695_1 | 98 | 29357 | 574 | 10 | 2024-07-28 | 59.60 | 2024-07-16 | 2384.07 | 1 | SO67695 | 2024-07-23 | 190.73 | 1481.94 | |
SO67695_2 | 98 | 29357 | 479 | 10 | 2024-07-28 | 0.22 | 2024-07-16 | 8.99 | 2 | SO67695 | 2024-07-23 | 0.72 | 3.36 | |
SO67695_3 | 98 | 29357 | 477 | 10 | 2024-07-28 | 0.12 | 2024-07-16 | 4.99 | 3 | SO67695 | 2024-07-23 | 0.40 | 1.87 | |
SO67702_1 | 98 | 14712 | 361 | 10 | 2024-07-29 | 57.37 | 2024-07-17 | 2294.99 | 1 | SO67702 | 2024-07-24 | 183.60 | 1251.98 | |
SO67702_2 | 98 | 14712 | 478 | 10 | 2024-07-29 | 0.25 | 2024-07-17 | 9.99 | 2 | SO67702 | 2024-07-24 | 0.80 | 3.74 | |
SO67702_3 | 98 | 14712 | 217 | 10 | 2024-07-29 | 0.87 | 2024-07-17 | 34.99 | 3 | SO67702 | 2024-07-24 | 2.80 | 13.09 | |
SO67704_1 | 98 | 19037 | 363 | 10 | 2024-07-29 | 57.37 | 2024-07-17 | 2294.99 | 1 | SO67704 | 2024-07-24 | 183.60 | 1251.98 | |
SO67704_2 | 98 | 19037 | 483 | 10 | 2024-07-29 | 3.00 | 2024-07-17 | 120.00 | 2 | SO67704 | 2024-07-24 | 9.60 | 44.88 | |
SO67724_1 | 98 | 20881 | 536 | 10 | 2024-07-29 | 0.75 | 2024-07-17 | 29.99 | 1 | SO67724 | 2024-07-24 | 2.40 | 11.22 | |
SO67724_2 | 98 | 20881 | 528 | 10 | 2024-07-29 | 0.12 | 2024-07-17 | 4.99 | 2 | SO67724 | 2024-07-24 | 0.40 | 1.87 | |
SO67724_3 | 98 | 20881 | 214 | 10 | 2024-07-29 | 0.87 | 2024-07-17 | 34.99 | 3 | SO67724 | 2024-07-24 | 2.80 | 13.09 | |
SO67724_4 | 98 | 20881 | 225 | 10 | 2024-07-29 | 0.22 | 2024-07-17 | 8.99 | 4 | SO67724 | 2024-07-24 | 0.72 | 6.92 | |
SO67727_1 | 98 | 18165 | 530 | 10 | 2024-07-29 | 0.12 | 2024-07-17 | 4.99 | 1 | SO67727 | 2024-07-24 | 0.40 | 1.87 | |
SO67727_2 | 98 | 18165 | 214 | 10 | 2024-07-29 | 0.87 | 2024-07-17 | 34.99 | 2 | SO67727 | 2024-07-24 | 2.80 | 13.09 | |
SO67741_1 | 98 | 16829 | 563 | 10 | 2024-07-29 | 59.60 | 2024-07-17 | 2384.07 | 1 | SO67741 | 2024-07-24 | 190.73 | 1481.94 | |
SO67741_2 | 98 | 16829 | 481 | 2 | 10 | 2024-07-29 | 0.22 | 2024-07-17 | 8.99 | 2 | SO67741 | 2024-07-24 | 0.72 | 3.36 |
SO67762_1 | 98 | 27009 | 584 | 10 | 2024-07-29 | 13.50 | 2024-07-17 | 539.99 | 1 | SO67762 | 2024-07-24 | 43.20 | 343.65 | |
SO67762_2 | 98 | 27009 | 217 | 10 | 2024-07-29 | 0.87 | 2024-07-17 | 34.99 | 2 | SO67762 | 2024-07-24 | 2.80 | 13.09 | |
SO67774_1 | 98 | 16428 | 588 | 2 | 10 | 2024-07-30 | 19.24 | 2024-07-18 | 769.49 | 1 | SO67774 | 2024-07-25 | 61.56 | 419.78 |
SO67774_2 | 98 | 16428 | 536 | 10 | 2024-07-30 | 0.75 | 2024-07-18 | 29.99 | 2 | SO67774 | 2024-07-25 | 2.40 | 11.22 | |
SO67774_3 | 98 | 16428 | 528 | 10 | 2024-07-30 | 0.12 | 2024-07-18 | 4.99 | 3 | SO67774 | 2024-07-25 | 0.40 | 1.87 | |
SO67774_4 | 98 | 16428 | 217 | 10 | 2024-07-30 | 0.87 | 2024-07-18 | 34.99 | 4 | SO67774 | 2024-07-25 | 2.80 | 13.09 | |
SO67775_1 | 98 | 17965 | 590 | 10 | 2024-07-30 | 19.24 | 2024-07-18 | 769.49 | 1 | SO67775 | 2024-07-25 | 61.56 | 419.78 | |
SO67775_2 | 98 | 17965 | 228 | 10 | 2024-07-30 | 1.25 | 2024-07-18 | 49.99 | 2 | SO67775 | 2024-07-25 | 4.00 | 38.49 | |
SO67778_1 | 98 | 14155 | 359 | 10 | 2024-07-30 | 57.37 | 2024-07-18 | 2294.99 | 1 | SO67778 | 2024-07-25 | 183.60 | 1251.98 | |
SO67778_2 | 98 | 14155 | 483 | 10 | 2024-07-30 | 3.00 | 2024-07-18 | 120.00 | 2 | SO67778 | 2024-07-25 | 9.60 | 44.88 | |
SO67801_1 | 98 | 14542 | 475 | 10 | 2024-07-30 | 1.75 | 2024-07-18 | 69.99 | 1 | SO67801 | 2024-07-25 | 5.60 | 26.18 | |
SO67801_2 | 98 | 14542 | 225 | 10 | 2024-07-30 | 0.22 | 2024-07-18 | 8.99 | 2 | SO67801 | 2024-07-25 | 0.72 | 6.92 | |
SO67802_1 | 98 | 15701 | 529 | 10 | 2024-07-30 | 0.10 | 2024-07-18 | 3.99 | 1 | SO67802 | 2024-07-25 | 0.32 | 1.49 | |
SO67802_2 | 98 | 15701 | 540 | 10 | 2024-07-30 | 0.82 | 2024-07-18 | 32.60 | 2 | SO67802 | 2024-07-25 | 2.61 | 12.19 | |
SO67802_3 | 98 | 15701 | 222 | 10 | 2024-07-30 | 0.87 | 2024-07-18 | 34.99 | 3 | SO67802 | 2024-07-25 | 2.80 | 13.09 | |
SO67803_1 | 98 | 19050 | 485 | 10 | 2024-07-30 | 0.55 | 2024-07-18 | 21.98 | 1 | SO67803 | 2024-07-25 | 1.76 | 8.22 | |
SO67803_2 | 98 | 19050 | 217 | 10 | 2024-07-30 | 0.87 | 2024-07-18 | 34.99 | 2 | SO67803 | 2024-07-25 | 2.80 | 13.09 | |
SO67805_1 | 98 | 24045 | 477 | 10 | 2024-07-30 | 0.12 | 2024-07-18 | 4.99 | 1 | SO67805 | 2024-07-25 | 0.40 | 1.87 | |
SO67807_1 | 98 | 22496 | 477 | 10 | 2024-07-30 | 0.12 | 2024-07-18 | 4.99 | 1 | SO67807 | 2024-07-25 | 0.40 | 1.87 | |
SO67807_2 | 98 | 22496 | 225 | 10 | 2024-07-30 | 0.22 | 2024-07-18 | 8.99 | 2 | SO67807 | 2024-07-25 | 0.72 | 6.92 | |
SO67807_3 | 98 | 22496 | 214 | 10 | 2024-07-30 | 0.87 | 2024-07-18 | 34.99 | 3 | SO67807 | 2024-07-25 | 2.80 | 13.09 | |
SO67810_1 | 98 | 12567 | 541 | 10 | 2024-07-30 | 0.72 | 2024-07-18 | 28.99 | 1 | SO67810 | 2024-07-25 | 2.32 | 10.84 | |
SO67810_2 | 98 | 12567 | 530 | 10 | 2024-07-30 | 0.12 | 2024-07-18 | 4.99 | 2 | SO67810 | 2024-07-25 | 0.40 | 1.87 | |
SO67811_1 | 98 | 17723 | 530 | 10 | 2024-07-30 | 0.12 | 2024-07-18 | 4.99 | 1 | SO67811 | 2024-07-25 | 0.40 | 1.87 | |
SO67811_2 | 98 | 17723 | 479 | 10 | 2024-07-30 | 0.22 | 2024-07-18 | 8.99 | 2 | SO67811 | 2024-07-25 | 0.72 | 3.36 | |
SO67811_3 | 98 | 17723 | 477 | 10 | 2024-07-30 | 0.12 | 2024-07-18 | 4.99 | 3 | SO67811 | 2024-07-25 | 0.40 | 1.87 |
Generated 2024-11-10 19:17:25.303 UTC