[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1409 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
SO62189_2 | 100 | 23191 | 536 | 1 | 2024-05-09 | 0.75 | 2024-04-27 | 29.99 | 2 | SO62189 | 2024-05-04 | 2.40 | 11.22 | |
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 | |
SO62190_1 | 19 | 16247 | 478 | 6 | 2024-05-09 | 0.25 | 2024-04-27 | 9.99 | 1 | SO62190 | 2024-05-04 | 0.80 | 3.74 | |
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 | |
SO62190_2 | 19 | 16247 | 477 | 6 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 2 | SO62190 | 2024-05-04 | 0.40 | 1.87 | |
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 | |
SO62191_1 | 100 | 20635 | 477 | 1 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62191 | 2024-05-04 | 0.40 | 1.87 | |
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 | |
SO62191_2 | 100 | 20635 | 478 | 1 | 2024-05-09 | 0.25 | 2024-04-27 | 9.99 | 2 | SO62191 | 2024-05-04 | 0.80 | 3.74 | |
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 | |
SO62191_3 | 100 | 20635 | 217 | 1 | 2024-05-09 | 0.87 | 2024-04-27 | 34.99 | 3 | SO62191 | 2024-05-04 | 2.80 | 13.09 | |
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 | |
SO62192_1 | 100 | 21612 | 478 | 1 | 2024-05-09 | 0.25 | 2024-04-27 | 9.99 | 1 | SO62192 | 2024-05-04 | 0.80 | 3.74 | |
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 | |
SO62192_2 | 100 | 21612 | 477 | 1 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 2 | SO62192 | 2024-05-04 | 0.40 | 1.87 | |
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 | |
SO62193_1 | 19 | 17422 | 475 | 6 | 2024-05-09 | 1.75 | 2024-04-27 | 69.99 | 1 | SO62193 | 2024-05-04 | 5.60 | 26.18 | |
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 | |
SO62193_2 | 19 | 17422 | 225 | 6 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 2 | SO62193 | 2024-05-04 | 0.72 | 6.92 | |
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 | |
SO62194_1 | 19 | 13350 | 477 | 6 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62194 | 2024-05-04 | 0.40 | 1.87 | |
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 | |
SO55634_2 | 100 | 18799 | 231 | 4 | 2024-01-28 | 1.25 | 2024-01-16 | 49.99 | 2 | SO55634 | 2024-01-23 | 4.00 | 38.49 | |
SO62194_2 | 19 | 13350 | 482 | 6 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 2 | SO62194 | 2024-05-04 | 0.72 | 3.36 | |
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 | |
SO55635_1 | 100 | 15883 | 528 | 4 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55635 | 2024-01-23 | 0.40 | 1.87 | |
SO62195_1 | 100 | 17577 | 477 | 4 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62195 | 2024-05-04 | 0.40 | 1.87 | |
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 | |
SO55635_2 | 100 | 15883 | 485 | 4 | 2024-01-28 | 0.55 | 2024-01-16 | 21.98 | 2 | SO55635 | 2024-01-23 | 1.76 | 8.22 | |
SO62195_2 | 100 | 17577 | 214 | 4 | 2024-05-09 | 0.87 | 2024-04-27 | 34.99 | 2 | SO62195 | 2024-05-04 | 2.80 | 13.09 | |
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 | |
SO55635_3 | 100 | 15883 | 489 | 4 | 2024-01-28 | 1.35 | 2024-01-16 | 53.99 | 3 | SO55635 | 2024-01-23 | 4.32 | 41.57 | |
SO62196_1 | 100 | 16356 | 528 | 4 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62196 | 2024-05-04 | 0.40 | 1.87 | |
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 | |
SO55635_4 | 100 | 15883 | 225 | 4 | 2024-01-28 | 0.22 | 2024-01-16 | 8.99 | 4 | SO55635 | 2024-01-23 | 0.72 | 6.92 | |
SO62196_2 | 100 | 16356 | 480 | 2 | 4 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 2 | SO62196 | 2024-05-04 | 0.18 | 0.86 |
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 | |
SO55636_1 | 100 | 15384 | 528 | 1 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55636 | 2024-01-23 | 0.40 | 1.87 | |
SO62197_1 | 100 | 15837 | 528 | 1 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62197 | 2024-05-04 | 0.40 | 1.87 | |
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 | |
SO55636_2 | 100 | 15384 | 480 | 2 | 1 | 2024-01-28 | 0.06 | 2024-01-16 | 2.29 | 2 | SO55636 | 2024-01-23 | 0.18 | 0.86 |
SO62197_2 | 100 | 15837 | 217 | 1 | 2024-05-09 | 0.87 | 2024-04-27 | 34.99 | 2 | SO62197 | 2024-05-04 | 2.80 | 13.09 | |
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 | |
SO55637_1 | 100 | 17342 | 528 | 1 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55637 | 2024-01-23 | 0.40 | 1.87 | |
SO62198_1 | 19 | 19801 | 485 | 6 | 2024-05-09 | 0.55 | 2024-04-27 | 21.98 | 1 | SO62198 | 2024-05-04 | 1.76 | 8.22 | |
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 | |
SO55637_2 | 100 | 17342 | 222 | 1 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 2 | SO55637 | 2024-01-23 | 2.80 | 13.09 | |
SO62198_2 | 19 | 19801 | 477 | 6 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 2 | SO62198 | 2024-05-04 | 0.40 | 1.87 | |
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 | |
SO55638_1 | 19 | 23498 | 528 | 6 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55638 | 2024-01-23 | 0.40 | 1.87 | |
SO62198_3 | 19 | 19801 | 478 | 6 | 2024-05-09 | 0.25 | 2024-04-27 | 9.99 | 3 | SO62198 | 2024-05-04 | 0.80 | 3.74 | |
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 | |
SO55639_1 | 19 | 19645 | 528 | 6 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55639 | 2024-01-23 | 0.40 | 1.87 | |
SO62198_4 | 19 | 19801 | 481 | 6 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 4 | SO62198 | 2024-05-04 | 0.72 | 3.36 | |
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 | |
SO55639_2 | 19 | 19645 | 217 | 6 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 2 | SO55639 | 2024-01-23 | 2.80 | 13.09 | |
SO62199_1 | 100 | 12752 | 476 | 7 | 2024-05-09 | 1.75 | 2024-04-27 | 69.99 | 1 | SO62199 | 2024-05-04 | 5.60 | 26.18 | |
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 | |
SO55640_1 | 100 | 15260 | 485 | 4 | 2024-01-28 | 0.55 | 2024-01-16 | 21.98 | 1 | SO55640 | 2024-01-23 | 1.76 | 8.22 | |
SO62199_2 | 100 | 12752 | 237 | 7 | 2024-05-09 | 1.25 | 2024-04-27 | 49.99 | 2 | SO62199 | 2024-05-04 | 4.00 | 38.49 | |
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 | |
SO55640_2 | 100 | 15260 | 478 | 4 | 2024-01-28 | 0.25 | 2024-01-16 | 9.99 | 2 | SO55640 | 2024-01-23 | 0.80 | 3.74 | |
SO62200_1 | 98 | 26216 | 529 | 10 | 2024-05-09 | 0.10 | 2024-04-27 | 3.99 | 1 | SO62200 | 2024-05-04 | 0.32 | 1.49 | |
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 | |
SO55640_3 | 100 | 15260 | 477 | 4 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 3 | SO55640 | 2024-01-23 | 0.40 | 1.87 | |
SO62200_2 | 98 | 26216 | 222 | 10 | 2024-05-09 | 0.87 | 2024-04-27 | 34.99 | 2 | SO62200 | 2024-05-04 | 2.80 | 13.09 | |
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 | |
SO55640_4 | 100 | 15260 | 225 | 4 | 2024-01-28 | 0.22 | 2024-01-16 | 8.99 | 4 | SO55640 | 2024-01-23 | 0.72 | 6.92 | |
SO62200_3 | 98 | 26216 | 491 | 10 | 2024-05-09 | 1.35 | 2024-04-27 | 53.99 | 3 | SO62200 | 2024-05-04 | 4.32 | 41.57 | |
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 | |
SO55641_1 | 100 | 16396 | 535 | 8 | 2024-01-28 | 0.62 | 2024-01-16 | 24.99 | 1 | SO55641 | 2024-01-23 | 2.00 | 9.35 | |
SO62201_1 | 100 | 23772 | 529 | 8 | 2024-05-09 | 0.10 | 2024-04-27 | 3.99 | 1 | SO62201 | 2024-05-04 | 0.32 | 1.49 | |
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 | |
SO55641_2 | 100 | 16396 | 528 | 8 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 2 | SO55641 | 2024-01-23 | 0.40 | 1.87 | |
SO62201_2 | 100 | 23772 | 214 | 8 | 2024-05-09 | 0.87 | 2024-04-27 | 34.99 | 2 | SO62201 | 2024-05-04 | 2.80 | 13.09 | |
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 | |
SO55641_3 | 100 | 16396 | 480 | 2 | 8 | 2024-01-28 | 0.06 | 2024-01-16 | 2.29 | 3 | SO55641 | 2024-01-23 | 0.18 | 0.86 |
SO62202_1 | 98 | 11434 | 538 | 10 | 2024-05-09 | 0.54 | 2024-04-27 | 21.49 | 1 | SO62202 | 2024-05-04 | 1.72 | 8.04 | |
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 | |
SO55642_1 | 98 | 16459 | 528 | 10 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55642 | 2024-01-23 | 0.40 | 1.87 | |
SO62203_1 | 98 | 12633 | 541 | 10 | 2024-05-09 | 0.72 | 2024-04-27 | 28.99 | 1 | SO62203 | 2024-05-04 | 2.32 | 10.84 | |
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 | |
SO55642_2 | 98 | 16459 | 222 | 10 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 2 | SO55642 | 2024-01-23 | 2.80 | 13.09 | |
SO62203_2 | 98 | 12633 | 530 | 10 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 2 | SO62203 | 2024-05-04 | 0.40 | 1.87 | |
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 | |
SO55643_1 | 19 | 21471 | 485 | 6 | 2024-01-28 | 0.55 | 2024-01-16 | 21.98 | 1 | SO55643 | 2024-01-23 | 1.76 | 8.22 | |
SO62203_3 | 98 | 12633 | 480 | 2 | 10 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 3 | SO62203 | 2024-05-04 | 0.18 | 0.86 |
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 | |
SO55643_2 | 19 | 21471 | 478 | 6 | 2024-01-28 | 0.25 | 2024-01-16 | 9.99 | 2 | SO55643 | 2024-01-23 | 0.80 | 3.74 | |
SO62204_1 | 98 | 28748 | 538 | 10 | 2024-05-09 | 0.54 | 2024-04-27 | 21.49 | 1 | SO62204 | 2024-05-04 | 1.72 | 8.04 | |
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 | |
SO55644_1 | 98 | 20868 | 536 | 10 | 2024-01-28 | 0.75 | 2024-01-16 | 29.99 | 1 | SO55644 | 2024-01-23 | 2.40 | 11.22 | |
SO62204_2 | 98 | 28748 | 480 | 10 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 2 | SO62204 | 2024-05-04 | 0.18 | 0.86 |
Generated 2024-11-10 17:09:25.674 UTC