[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1598 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50571_1 | 100 | 15890 | 343 | 4 | 2023-09-15 | 19.57 | 2023-09-03 | 782.99 | 1 | SO50571 | 2023-09-10 | 62.64 | 486.71 | |
SO50572_1 | 100 | 15899 | 329 | 4 | 2023-09-15 | 19.57 | 2023-09-03 | 782.99 | 1 | SO50572 | 2023-09-10 | 62.64 | 486.71 | |
SO62107_1 | 100 | 21346 | 478 | 4 | 2024-05-08 | 0.25 | 2024-04-26 | 9.99 | 1 | SO62107 | 2024-05-03 | 0.80 | 3.74 | |
SO62107_2 | 100 | 21346 | 477 | 4 | 2024-05-08 | 0.12 | 2024-04-26 | 4.99 | 2 | SO62107 | 2024-05-03 | 0.40 | 1.87 | |
SO62109_1 | 100 | 19882 | 474 | 4 | 2024-05-08 | 1.75 | 2024-04-26 | 69.99 | 1 | SO62109 | 2024-05-03 | 5.60 | 26.18 | |
SO62109_2 | 100 | 19882 | 488 | 4 | 2024-05-08 | 1.35 | 2024-04-26 | 53.99 | 2 | SO62109 | 2024-05-03 | 4.32 | 41.57 | |
SO62113_1 | 100 | 18061 | 477 | 4 | 2024-05-08 | 0.12 | 2024-04-26 | 4.99 | 1 | SO62113 | 2024-05-03 | 0.40 | 1.87 | |
SO62117_1 | 100 | 13656 | 485 | 4 | 2024-05-08 | 0.55 | 2024-04-26 | 21.98 | 1 | SO62117 | 2024-05-03 | 1.76 | 8.22 | |
SO62117_2 | 100 | 13656 | 222 | 4 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 2 | SO62117 | 2024-05-03 | 2.80 | 13.09 | |
SO62128_1 | 100 | 14590 | 588 | 4 | 2024-05-08 | 19.24 | 2024-04-26 | 769.49 | 1 | SO62128 | 2024-05-03 | 61.56 | 419.78 | |
SO62128_2 | 100 | 14590 | 474 | 4 | 2024-05-08 | 1.75 | 2024-04-26 | 69.99 | 2 | SO62128 | 2024-05-03 | 5.60 | 26.18 | |
SO62128_3 | 100 | 14590 | 228 | 4 | 2024-05-08 | 1.25 | 2024-04-26 | 49.99 | 3 | SO62128 | 2024-05-03 | 4.00 | 38.49 | |
SO62128_4 | 100 | 14590 | 225 | 4 | 2024-05-08 | 0.22 | 2024-04-26 | 8.99 | 4 | SO62128 | 2024-05-03 | 0.72 | 6.92 | |
SO62129_1 | 100 | 15986 | 600 | 4 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62129 | 2024-05-03 | 43.20 | 294.58 | |
SO62129_2 | 100 | 15986 | 478 | 4 | 2024-05-08 | 0.25 | 2024-04-26 | 9.99 | 2 | SO62129 | 2024-05-03 | 0.80 | 3.74 | |
SO62129_3 | 100 | 15986 | 477 | 4 | 2024-05-08 | 0.12 | 2024-04-26 | 4.99 | 3 | SO62129 | 2024-05-03 | 0.40 | 1.87 | |
SO62129_4 | 100 | 15986 | 217 | 4 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 4 | SO62129 | 2024-05-03 | 2.80 | 13.09 | |
SO62129_5 | 100 | 15986 | 234 | 4 | 2024-05-08 | 1.25 | 2024-04-26 | 49.99 | 5 | SO62129 | 2024-05-03 | 4.00 | 38.49 | |
SO62131_1 | 100 | 19714 | 598 | 4 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62131 | 2024-05-03 | 43.20 | 294.58 | |
SO62131_2 | 100 | 19714 | 225 | 4 | 2024-05-08 | 0.22 | 2024-04-26 | 8.99 | 2 | SO62131 | 2024-05-03 | 0.72 | 6.92 | |
SO62133_1 | 100 | 14400 | 361 | 4 | 2024-05-08 | 57.37 | 2024-04-26 | 2294.99 | 1 | SO62133 | 2024-05-03 | 183.60 | 1251.98 | |
SO62133_2 | 100 | 14400 | 537 | 4 | 2024-05-08 | 0.88 | 2024-04-26 | 35.00 | 2 | SO62133 | 2024-05-03 | 2.80 | 13.09 | |
SO62133_3 | 100 | 14400 | 528 | 4 | 2024-05-08 | 0.12 | 2024-04-26 | 4.99 | 3 | SO62133 | 2024-05-03 | 0.40 | 1.87 | |
SO62133_4 | 100 | 14400 | 485 | 4 | 2024-05-08 | 0.55 | 2024-04-26 | 21.98 | 4 | SO62133 | 2024-05-03 | 1.76 | 8.22 | |
SO62146_1 | 100 | 25840 | 577 | 4 | 2024-05-08 | 30.37 | 2024-04-26 | 1214.85 | 1 | SO62146 | 2024-05-03 | 97.19 | 755.15 | |
SO62146_2 | 100 | 25840 | 214 | 4 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 2 | SO62146 | 2024-05-03 | 2.80 | 13.09 | |
SO62149_1 | 100 | 23239 | 605 | 4 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62149 | 2024-05-03 | 43.20 | 343.65 | |
SO62151_1 | 100 | 20395 | 388 | 4 | 2024-05-08 | 28.01 | 2024-04-26 | 1120.49 | 1 | SO62151 | 2024-05-03 | 89.64 | 713.08 | |
SO62151_2 | 100 | 20395 | 214 | 4 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 2 | SO62151 | 2024-05-03 | 2.80 | 13.09 | |
SO62151_3 | 100 | 20395 | 467 | 2 | 4 | 2024-05-08 | 0.61 | 2024-04-26 | 24.49 | 3 | SO62151 | 2024-05-03 | 1.96 | 9.16 |
SO62158_1 | 100 | 12894 | 477 | 4 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62158 | 2024-05-04 | 0.40 | 1.87 | |
SO62158_2 | 100 | 12894 | 479 | 4 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 2 | SO62158 | 2024-05-04 | 0.72 | 3.36 | |
SO62180_1 | 19 | 28776 | 480 | 4 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 1 | SO62180 | 2024-05-04 | 0.18 | 0.86 | |
SO62181_1 | 100 | 28855 | 539 | 4 | 2024-05-09 | 0.62 | 2024-04-27 | 24.99 | 1 | SO62181 | 2024-05-04 | 2.00 | 9.35 | |
SO62181_2 | 100 | 28855 | 529 | 4 | 2024-05-09 | 0.10 | 2024-04-27 | 3.99 | 2 | SO62181 | 2024-05-04 | 0.32 | 1.49 | |
SO62181_3 | 100 | 28855 | 465 | 4 | 2024-05-09 | 0.61 | 2024-04-27 | 24.49 | 3 | SO62181 | 2024-05-04 | 1.96 | 9.16 | |
SO62181_4 | 100 | 28855 | 234 | 4 | 2024-05-09 | 1.25 | 2024-04-27 | 49.99 | 4 | SO62181 | 2024-05-04 | 4.00 | 38.49 | |
SO62183_1 | 100 | 27506 | 529 | 4 | 2024-05-09 | 0.10 | 2024-04-27 | 3.99 | 1 | SO62183 | 2024-05-04 | 0.32 | 1.49 | |
SO62183_2 | 100 | 27506 | 538 | 4 | 2024-05-09 | 0.54 | 2024-04-27 | 21.49 | 2 | SO62183 | 2024-05-04 | 1.72 | 8.04 | |
SO62183_3 | 100 | 27506 | 484 | 4 | 2024-05-09 | 0.20 | 2024-04-27 | 7.95 | 3 | SO62183 | 2024-05-04 | 0.64 | 2.97 | |
SO62185_1 | 100 | 26583 | 530 | 4 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62185 | 2024-05-04 | 0.40 | 1.87 | |
SO62185_2 | 100 | 26583 | 541 | 4 | 2024-05-09 | 0.72 | 2024-04-27 | 28.99 | 2 | SO62185 | 2024-05-04 | 2.32 | 10.84 | |
SO62185_3 | 100 | 26583 | 480 | 2 | 4 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 3 | SO62185 | 2024-05-04 | 0.18 | 0.86 |
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 | |
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 | |
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 | |
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 |
SO62206_1 | 100 | 11258 | 537 | 4 | 2024-05-09 | 0.88 | 2024-04-27 | 35.00 | 1 | SO62206 | 2024-05-04 | 2.80 | 13.09 | |
SO62210_1 | 100 | 18942 | 587 | 4 | 2024-05-09 | 19.24 | 2024-04-27 | 769.49 | 1 | SO62210 | 2024-05-04 | 61.56 | 419.78 | |
SO62210_2 | 100 | 18942 | 536 | 4 | 2024-05-09 | 0.75 | 2024-04-27 | 29.99 | 2 | SO62210 | 2024-05-04 | 2.40 | 11.22 | |
SO62210_3 | 100 | 18942 | 528 | 4 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 3 | SO62210 | 2024-05-04 | 0.40 | 1.87 | |
SO62210_4 | 100 | 18942 | 485 | 4 | 2024-05-09 | 0.55 | 2024-04-27 | 21.98 | 4 | SO62210 | 2024-05-04 | 1.76 | 8.22 | |
SO62210_5 | 100 | 18942 | 487 | 4 | 2024-05-09 | 1.37 | 2024-04-27 | 54.99 | 5 | SO62210 | 2024-05-04 | 4.40 | 20.57 | |
SO62210_6 | 100 | 18942 | 484 | 4 | 2024-05-09 | 0.20 | 2024-04-27 | 7.95 | 6 | SO62210 | 2024-05-04 | 0.64 | 2.97 | |
SO62211_1 | 100 | 14639 | 587 | 4 | 2024-05-09 | 19.24 | 2024-04-27 | 769.49 | 1 | SO62211 | 2024-05-04 | 61.56 | 419.78 | |
SO62211_2 | 100 | 14639 | 225 | 4 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 2 | SO62211 | 2024-05-04 | 0.72 | 6.92 |
Generated 2024-11-10 15:38:12.142 UTC