[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1433 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55725_3 | 98 | 11247 | 234 | 10 | 2024-01-29 | 1.25 | 2024-01-17 | 49.99 | 3 | SO55725 | 2024-01-24 | 4.00 | 38.49 | |
SO45036_1 | 100 | 28846 | 311 | 4 | 2022-04-24 | 89.46 | 2022-04-12 | 3578.27 | 1 | SO45036 | 2022-04-19 | 286.26 | 2171.29 | |
SO55726_1 | 6 | 20985 | 605 | 9 | 2024-01-29 | 13.50 | 2024-01-17 | 539.99 | 1 | SO55726 | 2024-01-24 | 43.20 | 343.65 | |
SO45037_1 | 6 | 25704 | 332 | 9 | 2022-04-24 | 17.48 | 2022-04-12 | 699.10 | 1 | SO45037 | 2022-04-19 | 55.93 | 413.15 | |
SO55727_1 | 6 | 20992 | 604 | 9 | 2024-01-29 | 13.50 | 2024-01-17 | 539.99 | 1 | SO55727 | 2024-01-24 | 43.20 | 343.65 | |
SO45078_1 | 100 | 12494 | 313 | 7 | 2022-04-25 | 89.46 | 2022-04-13 | 3578.27 | 1 | SO45078 | 2022-04-20 | 286.26 | 2171.29 | |
SO55727_2 | 6 | 20992 | 538 | 9 | 2024-01-29 | 0.54 | 2024-01-17 | 21.49 | 2 | SO55727 | 2024-01-24 | 1.72 | 8.04 | |
SO45079_1 | 100 | 29255 | 312 | 4 | 2022-04-25 | 89.46 | 2022-04-13 | 3578.27 | 1 | SO45079 | 2022-04-20 | 286.26 | 2171.29 | |
SO55728_1 | 100 | 24804 | 562 | 4 | 2024-01-29 | 59.60 | 2024-01-17 | 2384.07 | 1 | SO55728 | 2024-01-24 | 190.73 | 1481.94 | |
SO45080_1 | 100 | 14657 | 332 | 1 | 2022-04-25 | 17.48 | 2022-04-13 | 699.10 | 1 | SO45080 | 2022-04-20 | 55.93 | 413.15 | |
SO55729_1 | 19 | 21354 | 606 | 6 | 2024-01-29 | 13.50 | 2024-01-17 | 539.99 | 1 | SO55729 | 2024-01-24 | 43.20 | 343.65 | |
SO45081_1 | 19 | 26782 | 338 | 6 | 2022-04-25 | 17.48 | 2022-04-13 | 699.10 | 1 | SO45081 | 2022-04-20 | 55.93 | 413.15 | |
SO55729_2 | 19 | 21354 | 222 | 6 | 2024-01-29 | 0.87 | 2024-01-17 | 34.99 | 2 | SO55729 | 2024-01-24 | 2.80 | 13.09 | |
SO45082_1 | 6 | 11455 | 350 | 9 | 2022-04-25 | 84.37 | 2022-04-13 | 3374.99 | 1 | SO45082 | 2022-04-20 | 270.00 | 1898.09 | |
SO55730_1 | 100 | 22046 | 605 | 1 | 2024-01-29 | 13.50 | 2024-01-17 | 539.99 | 1 | SO55730 | 2024-01-24 | 43.20 | 343.65 | |
SO45083_1 | 98 | 14947 | 312 | 10 | 2022-04-26 | 89.46 | 2022-04-14 | 3578.27 | 1 | SO45083 | 2022-04-21 | 286.26 | 2171.29 | |
SO55730_2 | 100 | 22046 | 538 | 1 | 2024-01-29 | 0.54 | 2024-01-17 | 21.49 | 2 | SO55730 | 2024-01-24 | 1.72 | 8.04 | |
SO45084_1 | 100 | 29143 | 310 | 4 | 2022-04-26 | 89.46 | 2022-04-14 | 3578.27 | 1 | SO45084 | 2022-04-21 | 286.26 | 2171.29 | |
SO55730_3 | 100 | 22046 | 480 | 1 | 2024-01-29 | 0.06 | 2024-01-17 | 2.29 | 3 | SO55730 | 2024-01-24 | 0.18 | 0.86 | |
SO45085_1 | 6 | 18746 | 312 | 9 | 2022-04-26 | 89.46 | 2022-04-14 | 3578.27 | 1 | SO45085 | 2022-04-21 | 286.26 | 2171.29 | |
SO55731_1 | 100 | 16504 | 604 | 4 | 2024-01-29 | 13.50 | 2024-01-17 | 539.99 | 1 | SO55731 | 2024-01-24 | 43.20 | 343.65 | |
SO45086_1 | 6 | 18747 | 314 | 9 | 2022-04-26 | 89.46 | 2022-04-14 | 3578.27 | 1 | SO45086 | 2022-04-21 | 286.26 | 2171.29 | |
SO55731_2 | 100 | 16504 | 479 | 4 | 2024-01-29 | 0.22 | 2024-01-17 | 8.99 | 2 | SO55731 | 2024-01-24 | 0.72 | 3.36 | |
SO45087_1 | 98 | 11388 | 350 | 10 | 2022-04-27 | 84.37 | 2022-04-15 | 3374.99 | 1 | SO45087 | 2022-04-22 | 270.00 | 1898.09 | |
SO55731_3 | 100 | 16504 | 477 | 4 | 2024-01-29 | 0.12 | 2024-01-17 | 4.99 | 3 | SO55731 | 2024-01-24 | 0.40 | 1.87 | |
SO45088_1 | 98 | 11398 | 345 | 10 | 2022-04-27 | 85.00 | 2022-04-15 | 3399.99 | 1 | SO45088 | 2022-04-22 | 272.00 | 1912.15 | |
SO55731_4 | 100 | 16504 | 214 | 4 | 2024-01-29 | 0.87 | 2024-01-17 | 34.99 | 4 | SO55731 | 2024-01-24 | 2.80 | 13.09 | |
SO55732_1 | 100 | 19775 | 382 | 2 | 4 | 2024-01-29 | 28.01 | 2024-01-17 | 1120.49 | 1 | SO55732 | 2024-01-24 | 89.64 | 713.08 |
SO55732_2 | 100 | 19775 | 225 | 4 | 2024-01-29 | 0.22 | 2024-01-17 | 8.99 | 2 | SO55732 | 2024-01-24 | 0.72 | 6.92 | |
SO55732_3 | 100 | 19775 | 490 | 4 | 2024-01-29 | 1.35 | 2024-01-17 | 53.99 | 3 | SO55732 | 2024-01-24 | 4.32 | 41.57 | |
SO55733_1 | 100 | 20166 | 384 | 8 | 2024-01-29 | 28.01 | 2024-01-17 | 1120.49 | 1 | SO55733 | 2024-01-24 | 89.64 | 713.08 | |
SO55733_2 | 100 | 20166 | 539 | 8 | 2024-01-29 | 0.62 | 2024-01-17 | 24.99 | 2 | SO55733 | 2024-01-24 | 2.00 | 9.35 | |
SO55733_3 | 100 | 20166 | 529 | 8 | 2024-01-29 | 0.10 | 2024-01-17 | 3.99 | 3 | SO55733 | 2024-01-24 | 0.32 | 1.49 | |
SO55733_4 | 100 | 20166 | 217 | 8 | 2024-01-29 | 0.87 | 2024-01-17 | 34.99 | 4 | SO55733 | 2024-01-24 | 2.80 | 13.09 | |
SO55734_1 | 98 | 23774 | 390 | 10 | 2024-01-29 | 28.01 | 2024-01-17 | 1120.49 | 1 | SO55734 | 2024-01-24 | 89.64 | 713.08 | |
SO55734_2 | 98 | 23774 | 539 | 10 | 2024-01-29 | 0.62 | 2024-01-17 | 24.99 | 2 | SO55734 | 2024-01-24 | 2.00 | 9.35 | |
SO55734_3 | 98 | 23774 | 529 | 10 | 2024-01-29 | 0.10 | 2024-01-17 | 3.99 | 3 | SO55734 | 2024-01-24 | 0.32 | 1.49 | |
SO55734_4 | 98 | 23774 | 214 | 10 | 2024-01-29 | 0.87 | 2024-01-17 | 34.99 | 4 | SO55734 | 2024-01-24 | 2.80 | 13.09 | |
SO55734_5 | 98 | 23774 | 237 | 2 | 10 | 2024-01-29 | 1.25 | 2024-01-17 | 49.99 | 5 | SO55734 | 2024-01-24 | 4.00 | 38.49 |
SO45089_1 | 100 | 25977 | 351 | 4 | 2022-04-27 | 84.37 | 2022-04-15 | 3374.99 | 1 | SO45089 | 2022-04-22 | 270.00 | 1898.09 | |
SO45090_1 | 100 | 29170 | 310 | 4 | 2022-04-27 | 89.46 | 2022-04-15 | 3578.27 | 1 | SO45090 | 2022-04-22 | 286.26 | 2171.29 | |
SO45091_1 | 6 | 18909 | 314 | 9 | 2022-04-27 | 89.46 | 2022-04-15 | 3578.27 | 1 | SO45091 | 2022-04-22 | 286.26 | 2171.29 | |
SO45092_1 | 6 | 18899 | 313 | 9 | 2022-04-27 | 89.46 | 2022-04-15 | 3578.27 | 1 | SO45092 | 2022-04-22 | 286.26 | 2171.29 | |
SO45093_1 | 6 | 18906 | 312 | 9 | 2022-04-27 | 89.46 | 2022-04-15 | 3578.27 | 1 | SO45093 | 2022-04-22 | 286.26 | 2171.29 | |
SO45094_1 | 19 | 22785 | 310 | 6 | 2022-04-27 | 89.46 | 2022-04-15 | 3578.27 | 1 | SO45094 | 2022-04-22 | 286.26 | 2171.29 | |
SO45095_1 | 98 | 11394 | 344 | 10 | 2022-04-28 | 85.00 | 2022-04-16 | 3399.99 | 1 | SO45095 | 2022-04-23 | 272.00 | 1912.15 | |
SO45096_1 | 100 | 12483 | 312 | 7 | 2022-04-28 | 89.46 | 2022-04-16 | 3578.27 | 1 | SO45096 | 2022-04-23 | 286.26 | 2171.29 | |
SO45097_1 | 100 | 29151 | 313 | 4 | 2022-04-28 | 89.46 | 2022-04-16 | 3578.27 | 1 | SO45097 | 2022-04-23 | 286.26 | 2171.29 | |
SO45098_1 | 100 | 29167 | 310 | 1 | 2022-04-28 | 89.46 | 2022-04-16 | 3578.27 | 1 | SO45098 | 2022-04-23 | 286.26 | 2171.29 | |
SO45099_1 | 100 | 29174 | 312 | 1 | 2022-04-28 | 89.46 | 2022-04-16 | 3578.27 | 1 | SO45099 | 2022-04-23 | 286.26 | 2171.29 | |
SO45100_1 | 100 | 19428 | 326 | 8 | 2022-04-29 | 17.48 | 2022-04-17 | 699.10 | 1 | SO45100 | 2022-04-24 | 55.93 | 413.15 | |
SO45101_1 | 19 | 22748 | 313 | 6 | 2022-04-29 | 89.46 | 2022-04-17 | 3578.27 | 1 | SO45101 | 2022-04-24 | 286.26 | 2171.29 | |
SO45102_1 | 100 | 29274 | 310 | 4 | 2022-04-29 | 89.46 | 2022-04-17 | 3578.27 | 1 | SO45102 | 2022-04-24 | 286.26 | 2171.29 | |
SO45103_1 | 100 | 29140 | 310 | 1 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO45103 | 2022-04-25 | 286.26 | 2171.29 | |
SO45104_1 | 100 | 29142 | 310 | 4 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO45104 | 2022-04-25 | 286.26 | 2171.29 | |
SO45105_1 | 19 | 22765 | 312 | 6 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO45105 | 2022-04-25 | 286.26 | 2171.29 | |
SO45106_1 | 19 | 19987 | 348 | 6 | 2022-04-30 | 84.37 | 2022-04-18 | 3374.99 | 1 | SO45106 | 2022-04-25 | 270.00 | 1898.09 | |
SO45107_1 | 100 | 29275 | 312 | 4 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO45107 | 2022-04-25 | 286.26 | 2171.29 | |
SO45108_1 | 19 | 22975 | 310 | 6 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO45108 | 2022-04-25 | 286.26 | 2171.29 | |
SO45109_1 | 98 | 14937 | 311 | 10 | 2022-05-01 | 89.46 | 2022-04-19 | 3578.27 | 1 | SO45109 | 2022-04-26 | 286.26 | 2171.29 | |
SO45110_1 | 6 | 18710 | 311 | 9 | 2022-05-01 | 89.46 | 2022-04-19 | 3578.27 | 1 | SO45110 | 2022-04-26 | 286.26 | 2171.29 | |
SO45111_1 | 6 | 25713 | 326 | 9 | 2022-05-01 | 17.48 | 2022-04-19 | 699.10 | 1 | SO45111 | 2022-04-26 | 55.93 | 413.15 | |
SO45112_1 | 98 | 20558 | 324 | 10 | 2022-05-01 | 17.48 | 2022-04-19 | 699.10 | 1 | SO45112 | 2022-04-26 | 55.93 | 413.15 | |
SO45113_1 | 100 | 29141 | 313 | 4 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45113 | 2022-04-27 | 286.26 | 2171.29 | |
SO45114_1 | 100 | 29146 | 310 | 1 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45114 | 2022-04-27 | 286.26 | 2171.29 | |
SO45115_1 | 100 | 25984 | 348 | 4 | 2022-05-02 | 84.37 | 2022-04-20 | 3374.99 | 1 | SO45115 | 2022-04-27 | 270.00 | 1898.09 | |
SO45116_1 | 100 | 29204 | 311 | 1 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45116 | 2022-04-27 | 286.26 | 2171.29 | |
SO45117_1 | 100 | 14727 | 342 | 1 | 2022-05-02 | 17.48 | 2022-04-20 | 699.10 | 1 | SO45117 | 2022-04-27 | 55.93 | 413.15 | |
SO45118_1 | 6 | 18722 | 314 | 9 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45118 | 2022-04-27 | 286.26 | 2171.29 | |
SO45119_1 | 6 | 18740 | 314 | 9 | 2022-05-02 | 89.46 | 2022-04-20 | 3578.27 | 1 | SO45119 | 2022-04-27 | 286.26 | 2171.29 | |
SO45120_1 | 6 | 11751 | 344 | 9 | 2022-05-02 | 85.00 | 2022-04-20 | 3399.99 | 1 | SO45120 | 2022-04-27 | 272.00 | 1912.15 | |
SO45121_1 | 100 | 29169 | 310 | 1 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45121 | 2022-04-28 | 286.26 | 2171.29 | |
SO45122_1 | 100 | 29236 | 314 | 4 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45122 | 2022-04-28 | 286.26 | 2171.29 | |
SO45123_1 | 19 | 22971 | 311 | 6 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45123 | 2022-04-28 | 286.26 | 2171.29 | |
SO45124_1 | 6 | 18725 | 313 | 9 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45124 | 2022-04-28 | 286.26 | 2171.29 | |
SO45125_1 | 6 | 18708 | 312 | 9 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45125 | 2022-04-28 | 286.26 | 2171.29 | |
SO45126_1 | 100 | 12480 | 311 | 7 | 2022-05-04 | 89.46 | 2022-04-22 | 3578.27 | 1 | SO45126 | 2022-04-29 | 286.26 | 2171.29 | |
SO45127_1 | 100 | 29158 | 313 | 1 | 2022-05-04 | 89.46 | 2022-04-22 | 3578.27 | 1 | SO45127 | 2022-04-29 | 286.26 | 2171.29 | |
SO45128_1 | 6 | 18726 | 310 | 9 | 2022-05-04 | 89.46 | 2022-04-22 | 3578.27 | 1 | SO45128 | 2022-04-29 | 286.26 | 2171.29 | |
SO45129_1 | 6 | 11759 | 350 | 9 | 2022-05-04 | 84.37 | 2022-04-22 | 3374.99 | 1 | SO45129 | 2022-04-29 | 270.00 | 1898.09 | |
SO45130_1 | 98 | 14975 | 313 | 10 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45130 | 2022-04-30 | 286.26 | 2171.29 | |
SO45131_1 | 100 | 25979 | 344 | 1 | 2022-05-05 | 85.00 | 2022-04-23 | 3399.99 | 1 | SO45131 | 2022-04-30 | 272.00 | 1912.15 | |
SO45132_1 | 100 | 25985 | 350 | 4 | 2022-05-05 | 84.37 | 2022-04-23 | 3374.99 | 1 | SO45132 | 2022-04-30 | 270.00 | 1898.09 | |
SO45133_1 | 100 | 29163 | 314 | 1 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45133 | 2022-04-30 | 286.26 | 2171.29 | |
SO45134_1 | 19 | 22895 | 314 | 6 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45134 | 2022-04-30 | 286.26 | 2171.29 | |
SO45135_1 | 100 | 29264 | 310 | 4 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45135 | 2022-04-30 | 286.26 | 2171.29 | |
SO45136_1 | 6 | 19084 | 312 | 9 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45136 | 2022-04-30 | 286.26 | 2171.29 | |
SO45137_1 | 6 | 18735 | 310 | 9 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45137 | 2022-04-30 | 286.26 | 2171.29 | |
SO45138_1 | 6 | 11452 | 349 | 9 | 2022-05-05 | 84.37 | 2022-04-23 | 3374.99 | 1 | SO45138 | 2022-04-30 | 270.00 | 1898.09 | |
SO45139_1 | 100 | 12468 | 314 | 7 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45139 | 2022-05-01 | 286.26 | 2171.29 | |
SO45140_1 | 100 | 12485 | 312 | 7 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45140 | 2022-05-01 | 286.26 | 2171.29 | |
SO45141_1 | 100 | 29222 | 312 | 4 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45141 | 2022-05-01 | 286.26 | 2171.29 | |
SO45142_1 | 19 | 22901 | 311 | 6 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45142 | 2022-05-01 | 286.26 | 2171.29 | |
SO45143_1 | 100 | 29278 | 310 | 4 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45143 | 2022-05-01 | 286.26 | 2171.29 | |
SO45144_1 | 6 | 19093 | 311 | 9 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45144 | 2022-05-01 | 286.26 | 2171.29 | |
SO45145_1 | 6 | 18716 | 314 | 9 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45145 | 2022-05-01 | 286.26 | 2171.29 |
Generated 2024-11-10 19:31:05.250 UTC