[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 1882 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71153_1 | 19 | 11215 | 225 | 6 | 2024-07-25 | 0.22 | 2024-07-13 | 8.99 | 1 | SO71153 | 2024-07-20 | 0.72 | 6.92 | |
SO71153_2 | 19 | 11215 | 483 | 6 | 2024-07-25 | 3.00 | 2024-07-13 | 120.00 | 2 | SO71153 | 2024-07-20 | 9.60 | 44.88 | |
SO71164_1 | 19 | 13071 | 536 | 6 | 2024-07-25 | 0.75 | 2024-07-13 | 29.99 | 1 | SO71164 | 2024-07-20 | 2.40 | 11.22 | |
SO71166_1 | 19 | 15974 | 476 | 6 | 2024-07-25 | 1.75 | 2024-07-13 | 69.99 | 1 | SO71166 | 2024-07-20 | 5.60 | 26.18 | |
SO71168_1 | 19 | 26456 | 477 | 6 | 2024-07-25 | 0.12 | 2024-07-13 | 4.99 | 1 | SO71168 | 2024-07-20 | 0.40 | 1.87 | |
SO71168_2 | 19 | 26456 | 214 | 6 | 2024-07-25 | 0.87 | 2024-07-13 | 34.99 | 2 | SO71168 | 2024-07-20 | 2.80 | 13.09 | |
SO71170_1 | 19 | 19026 | 485 | 6 | 2024-07-25 | 0.55 | 2024-07-13 | 21.98 | 1 | SO71170 | 2024-07-20 | 1.76 | 8.22 | |
SO71170_2 | 19 | 19026 | 491 | 6 | 2024-07-25 | 1.35 | 2024-07-13 | 53.99 | 2 | SO71170 | 2024-07-20 | 4.32 | 41.57 | |
SO71179_1 | 19 | 15162 | 537 | 6 | 2024-07-25 | 0.88 | 2024-07-13 | 35.00 | 1 | SO71179 | 2024-07-20 | 2.80 | 13.09 | |
SO71179_2 | 19 | 15162 | 528 | 6 | 2024-07-25 | 0.12 | 2024-07-13 | 4.99 | 2 | SO71179 | 2024-07-20 | 0.40 | 1.87 | |
SO71179_3 | 19 | 15162 | 214 | 6 | 2024-07-25 | 0.87 | 2024-07-13 | 34.99 | 3 | SO71179 | 2024-07-20 | 2.80 | 13.09 | |
SO71182_1 | 19 | 15323 | 590 | 6 | 2024-07-25 | 19.24 | 2024-07-13 | 769.49 | 1 | SO71182 | 2024-07-20 | 61.56 | 419.78 | |
SO71182_2 | 19 | 15323 | 528 | 6 | 2024-07-25 | 0.12 | 2024-07-13 | 4.99 | 2 | SO71182 | 2024-07-20 | 0.40 | 1.87 | |
SO71182_3 | 19 | 15323 | 536 | 6 | 2024-07-25 | 0.75 | 2024-07-13 | 29.99 | 3 | SO71182 | 2024-07-20 | 2.40 | 11.22 | |
SO71207_1 | 19 | 17656 | 584 | 6 | 2024-07-25 | 13.50 | 2024-07-13 | 539.99 | 1 | SO71207 | 2024-07-20 | 43.20 | 343.65 | |
SO71207_2 | 19 | 17656 | 479 | 6 | 2024-07-25 | 0.22 | 2024-07-13 | 8.99 | 2 | SO71207 | 2024-07-20 | 0.72 | 3.36 | |
SO71207_3 | 19 | 17656 | 477 | 6 | 2024-07-25 | 0.12 | 2024-07-13 | 4.99 | 3 | SO71207 | 2024-07-20 | 0.40 | 1.87 | |
SO71207_4 | 19 | 17656 | 463 | 6 | 2024-07-25 | 0.61 | 2024-07-13 | 24.49 | 4 | SO71207 | 2024-07-20 | 1.96 | 9.16 | |
SO71220_1 | 19 | 11502 | 217 | 6 | 2024-07-26 | 0.87 | 2024-07-14 | 34.99 | 1 | SO71220 | 2024-07-21 | 2.80 | 13.09 | |
SO71220_2 | 19 | 11502 | 482 | 6 | 2024-07-26 | 0.22 | 2024-07-14 | 8.99 | 2 | SO71220 | 2024-07-21 | 0.72 | 3.36 | |
SO71233_1 | 19 | 11505 | 491 | 6 | 2024-07-26 | 1.35 | 2024-07-14 | 53.99 | 1 | SO71233 | 2024-07-21 | 4.32 | 41.57 | |
SO71233_2 | 19 | 11505 | 225 | 6 | 2024-07-26 | 0.22 | 2024-07-14 | 8.99 | 2 | SO71233 | 2024-07-21 | 0.72 | 6.92 | |
SO71234_1 | 19 | 11176 | 538 | 6 | 2024-07-26 | 0.54 | 2024-07-14 | 21.49 | 1 | SO71234 | 2024-07-21 | 1.72 | 8.04 | |
SO71235_1 | 19 | 11203 | 539 | 6 | 2024-07-26 | 0.62 | 2024-07-14 | 24.99 | 1 | SO71235 | 2024-07-21 | 2.00 | 9.35 | |
SO71235_2 | 19 | 11203 | 480 | 6 | 2024-07-26 | 0.06 | 2024-07-14 | 2.29 | 2 | SO71235 | 2024-07-21 | 0.18 | 0.86 | |
SO71236_1 | 19 | 11875 | 536 | 6 | 2024-07-26 | 0.75 | 2024-07-14 | 29.99 | 1 | SO71236 | 2024-07-21 | 2.40 | 11.22 | |
SO71236_2 | 19 | 11875 | 528 | 6 | 2024-07-26 | 0.12 | 2024-07-14 | 4.99 | 2 | SO71236 | 2024-07-21 | 0.40 | 1.87 | |
SO71236_3 | 19 | 11875 | 487 | 6 | 2024-07-26 | 1.37 | 2024-07-14 | 54.99 | 3 | SO71236 | 2024-07-21 | 4.40 | 20.57 | |
SO71237_1 | 19 | 17619 | 528 | 6 | 2024-07-26 | 0.12 | 2024-07-14 | 4.99 | 1 | SO71237 | 2024-07-21 | 0.40 | 1.87 | |
SO71237_2 | 19 | 17619 | 536 | 6 | 2024-07-26 | 0.75 | 2024-07-14 | 29.99 | 2 | SO71237 | 2024-07-21 | 2.40 | 11.22 | |
SO71237_3 | 19 | 17619 | 485 | 6 | 2024-07-26 | 0.55 | 2024-07-14 | 21.98 | 3 | SO71237 | 2024-07-21 | 1.76 | 8.22 | |
SO71237_4 | 19 | 17619 | 214 | 6 | 2024-07-26 | 0.87 | 2024-07-14 | 34.99 | 4 | SO71237 | 2024-07-21 | 2.80 | 13.09 | |
SO71240_1 | 19 | 21464 | 485 | 6 | 2024-07-26 | 0.55 | 2024-07-14 | 21.98 | 1 | SO71240 | 2024-07-21 | 1.76 | 8.22 | |
SO71240_2 | 19 | 21464 | 487 | 6 | 2024-07-26 | 1.37 | 2024-07-14 | 54.99 | 2 | SO71240 | 2024-07-21 | 4.40 | 20.57 | |
SO71246_1 | 19 | 13096 | 537 | 6 | 2024-07-26 | 0.88 | 2024-07-14 | 35.00 | 1 | SO71246 | 2024-07-21 | 2.80 | 13.09 | |
SO71246_2 | 19 | 13096 | 528 | 6 | 2024-07-26 | 0.12 | 2024-07-14 | 4.99 | 2 | SO71246 | 2024-07-21 | 0.40 | 1.87 | |
SO71246_3 | 19 | 13096 | 485 | 6 | 2024-07-26 | 0.55 | 2024-07-14 | 21.98 | 3 | SO71246 | 2024-07-21 | 1.76 | 8.22 | |
SO71246_4 | 19 | 13096 | 478 | 6 | 2024-07-26 | 0.25 | 2024-07-14 | 9.99 | 4 | SO71246 | 2024-07-21 | 0.80 | 3.74 | |
SO71246_5 | 19 | 13096 | 477 | 6 | 2024-07-26 | 0.12 | 2024-07-14 | 4.99 | 5 | SO71246 | 2024-07-21 | 0.40 | 1.87 | |
SO71246_6 | 19 | 13096 | 471 | 6 | 2024-07-26 | 1.59 | 2024-07-14 | 63.50 | 6 | SO71246 | 2024-07-21 | 5.08 | 23.75 | |
SO71248_1 | 19 | 18317 | 485 | 6 | 2024-07-26 | 0.55 | 2024-07-14 | 21.98 | 1 | SO71248 | 2024-07-21 | 1.76 | 8.22 | |
SO71251_1 | 19 | 19855 | 359 | 6 | 2024-07-26 | 57.37 | 2024-07-14 | 2294.99 | 1 | SO71251 | 2024-07-21 | 183.60 | 1251.98 | |
SO71251_2 | 19 | 19855 | 478 | 6 | 2024-07-26 | 0.25 | 2024-07-14 | 9.99 | 2 | SO71251 | 2024-07-21 | 0.80 | 3.74 | |
SO71251_3 | 19 | 19855 | 477 | 6 | 2024-07-26 | 0.12 | 2024-07-14 | 4.99 | 3 | SO71251 | 2024-07-21 | 0.40 | 1.87 | |
SO71253_1 | 19 | 18788 | 363 | 6 | 2024-07-26 | 57.37 | 2024-07-14 | 2294.99 | 1 | SO71253 | 2024-07-21 | 183.60 | 1251.98 | |
SO71253_2 | 19 | 18788 | 485 | 6 | 2024-07-26 | 0.55 | 2024-07-14 | 21.98 | 2 | SO71253 | 2024-07-21 | 1.76 | 8.22 | |
SO71253_3 | 19 | 18788 | 222 | 6 | 2024-07-26 | 0.87 | 2024-07-14 | 34.99 | 3 | SO71253 | 2024-07-21 | 2.80 | 13.09 | |
SO71293_1 | 19 | 11223 | 529 | 6 | 2024-07-27 | 0.10 | 2024-07-15 | 3.99 | 1 | SO71293 | 2024-07-22 | 0.32 | 1.49 | |
SO71293_2 | 19 | 11223 | 222 | 6 | 2024-07-27 | 0.87 | 2024-07-15 | 34.99 | 2 | SO71293 | 2024-07-22 | 2.80 | 13.09 | |
SO71296_1 | 19 | 11253 | 539 | 6 | 2024-07-27 | 0.62 | 2024-07-15 | 24.99 | 1 | SO71296 | 2024-07-22 | 2.00 | 9.35 | |
SO71296_2 | 19 | 11253 | 529 | 6 | 2024-07-27 | 0.10 | 2024-07-15 | 3.99 | 2 | SO71296 | 2024-07-22 | 0.32 | 1.49 | |
SO71297_1 | 19 | 16479 | 529 | 6 | 2024-07-27 | 0.10 | 2024-07-15 | 3.99 | 1 | SO71297 | 2024-07-22 | 0.32 | 1.49 | |
SO71297_2 | 19 | 16479 | 540 | 6 | 2024-07-27 | 0.82 | 2024-07-15 | 32.60 | 2 | SO71297 | 2024-07-22 | 2.61 | 12.19 | |
SO71297_3 | 19 | 16479 | 222 | 6 | 2024-07-27 | 0.87 | 2024-07-15 | 34.99 | 3 | SO71297 | 2024-07-22 | 2.80 | 13.09 | |
SO71298_1 | 19 | 11223 | 528 | 6 | 2024-07-27 | 0.12 | 2024-07-15 | 4.99 | 1 | SO71298 | 2024-07-22 | 0.40 | 1.87 | |
SO71298_2 | 19 | 11223 | 535 | 6 | 2024-07-27 | 0.62 | 2024-07-15 | 24.99 | 2 | SO71298 | 2024-07-22 | 2.00 | 9.35 | |
SO71305_1 | 19 | 22219 | 528 | 6 | 2024-07-27 | 0.12 | 2024-07-15 | 4.99 | 1 | SO71305 | 2024-07-22 | 0.40 | 1.87 | |
SO71305_2 | 19 | 22219 | 484 | 6 | 2024-07-27 | 0.20 | 2024-07-15 | 7.95 | 2 | SO71305 | 2024-07-22 | 0.64 | 2.97 | |
SO71315_1 | 19 | 14446 | 537 | 6 | 2024-07-27 | 0.88 | 2024-07-15 | 35.00 | 1 | SO71315 | 2024-07-22 | 2.80 | 13.09 | |
SO71315_2 | 19 | 14446 | 480 | 6 | 2024-07-27 | 0.06 | 2024-07-15 | 2.29 | 2 | SO71315 | 2024-07-22 | 0.18 | 0.86 | |
SO71316_1 | 19 | 16847 | 485 | 6 | 2024-07-27 | 0.55 | 2024-07-15 | 21.98 | 1 | SO71316 | 2024-07-22 | 1.76 | 8.22 | |
SO71316_2 | 19 | 16847 | 222 | 6 | 2024-07-27 | 0.87 | 2024-07-15 | 34.99 | 2 | SO71316 | 2024-07-22 | 2.80 | 13.09 | |
SO71317_1 | 19 | 15494 | 537 | 6 | 2024-07-27 | 0.88 | 2024-07-15 | 35.00 | 1 | SO71317 | 2024-07-22 | 2.80 | 13.09 | |
SO71317_2 | 19 | 15494 | 528 | 6 | 2024-07-27 | 0.12 | 2024-07-15 | 4.99 | 2 | SO71317 | 2024-07-22 | 0.40 | 1.87 | |
SO71317_3 | 19 | 15494 | 485 | 6 | 2024-07-27 | 0.55 | 2024-07-15 | 21.98 | 3 | SO71317 | 2024-07-22 | 1.76 | 8.22 | |
SO71317_4 | 19 | 15494 | 471 | 6 | 2024-07-27 | 1.59 | 2024-07-15 | 63.50 | 4 | SO71317 | 2024-07-22 | 5.08 | 23.75 | |
SO71321_1 | 19 | 20034 | 363 | 6 | 2024-07-27 | 57.37 | 2024-07-15 | 2294.99 | 1 | SO71321 | 2024-07-22 | 183.60 | 1251.98 | |
SO71321_2 | 19 | 20034 | 537 | 6 | 2024-07-27 | 0.88 | 2024-07-15 | 35.00 | 2 | SO71321 | 2024-07-22 | 2.80 | 13.09 | |
SO71321_3 | 19 | 20034 | 528 | 6 | 2024-07-27 | 0.12 | 2024-07-15 | 4.99 | 3 | SO71321 | 2024-07-22 | 0.40 | 1.87 | |
SO71321_4 | 19 | 20034 | 217 | 6 | 2024-07-27 | 0.87 | 2024-07-15 | 34.99 | 4 | SO71321 | 2024-07-22 | 2.80 | 13.09 | |
SO71351_1 | 19 | 11277 | 484 | 6 | 2024-07-28 | 0.20 | 2024-07-16 | 7.95 | 1 | SO71351 | 2024-07-23 | 0.64 | 2.97 | |
SO71373_1 | 19 | 19411 | 536 | 6 | 2024-07-28 | 0.75 | 2024-07-16 | 29.99 | 1 | SO71373 | 2024-07-23 | 2.40 | 11.22 | |
SO71377_1 | 19 | 11276 | 477 | 6 | 2024-07-28 | 0.12 | 2024-07-16 | 4.99 | 1 | SO71377 | 2024-07-23 | 0.40 | 1.87 | |
SO71378_1 | 19 | 11287 | 477 | 6 | 2024-07-28 | 0.12 | 2024-07-16 | 4.99 | 1 | SO71378 | 2024-07-23 | 0.40 | 1.87 | |
SO71378_2 | 19 | 11287 | 487 | 6 | 2024-07-28 | 1.37 | 2024-07-16 | 54.99 | 2 | SO71378 | 2024-07-23 | 4.40 | 20.57 | |
SO71383_1 | 19 | 21490 | 528 | 6 | 2024-07-28 | 0.12 | 2024-07-16 | 4.99 | 1 | SO71383 | 2024-07-23 | 0.40 | 1.87 | |
SO71383_2 | 19 | 21490 | 480 | 2 | 6 | 2024-07-28 | 0.06 | 2024-07-16 | 2.29 | 2 | SO71383 | 2024-07-23 | 0.18 | 0.86 |
SO71384_1 | 19 | 20756 | 528 | 6 | 2024-07-28 | 0.12 | 2024-07-16 | 4.99 | 1 | SO71384 | 2024-07-23 | 0.40 | 1.87 | |
SO71384_2 | 19 | 20756 | 480 | 2 | 6 | 2024-07-28 | 0.06 | 2024-07-16 | 2.29 | 2 | SO71384 | 2024-07-23 | 0.18 | 0.86 |
SO71385_1 | 19 | 20783 | 528 | 6 | 2024-07-28 | 0.12 | 2024-07-16 | 4.99 | 1 | SO71385 | 2024-07-23 | 0.40 | 1.87 | |
SO71385_2 | 19 | 20783 | 217 | 6 | 2024-07-28 | 0.87 | 2024-07-16 | 34.99 | 2 | SO71385 | 2024-07-23 | 2.80 | 13.09 | |
SO71401_1 | 19 | 19646 | 485 | 6 | 2024-07-28 | 0.55 | 2024-07-16 | 21.98 | 1 | SO71401 | 2024-07-23 | 1.76 | 8.22 | |
SO71401_2 | 19 | 19646 | 473 | 6 | 2024-07-28 | 1.59 | 2024-07-16 | 63.50 | 2 | SO71401 | 2024-07-23 | 5.08 | 23.75 | |
SO71405_1 | 19 | 16121 | 595 | 6 | 2024-07-28 | 14.12 | 2024-07-16 | 564.99 | 1 | SO71405 | 2024-07-23 | 45.20 | 308.22 | |
SO71405_2 | 19 | 16121 | 535 | 6 | 2024-07-28 | 0.62 | 2024-07-16 | 24.99 | 2 | SO71405 | 2024-07-23 | 2.00 | 9.35 | |
SO71405_3 | 19 | 16121 | 465 | 6 | 2024-07-28 | 0.61 | 2024-07-16 | 24.49 | 3 | SO71405 | 2024-07-23 | 1.96 | 9.16 | |
SO71420_1 | 19 | 17861 | 580 | 6 | 2024-07-28 | 42.52 | 2024-07-16 | 1700.99 | 1 | SO71420 | 2024-07-23 | 136.08 | 1082.51 | |
SO71420_2 | 19 | 17861 | 479 | 6 | 2024-07-28 | 0.22 | 2024-07-16 | 8.99 | 2 | SO71420 | 2024-07-23 | 0.72 | 3.36 | |
SO71420_3 | 19 | 17861 | 477 | 6 | 2024-07-28 | 0.12 | 2024-07-16 | 4.99 | 3 | SO71420 | 2024-07-23 | 0.40 | 1.87 | |
SO71420_4 | 19 | 17861 | 214 | 6 | 2024-07-28 | 0.87 | 2024-07-16 | 34.99 | 4 | SO71420 | 2024-07-23 | 2.80 | 13.09 | |
SO71436_1 | 19 | 11211 | 539 | 6 | 2024-07-29 | 0.62 | 2024-07-17 | 24.99 | 1 | SO71436 | 2024-07-24 | 2.00 | 9.35 | |
SO71436_2 | 19 | 11211 | 480 | 6 | 2024-07-29 | 0.06 | 2024-07-17 | 2.29 | 2 | SO71436 | 2024-07-24 | 0.18 | 0.86 | |
SO71442_1 | 19 | 26077 | 528 | 6 | 2024-07-29 | 0.12 | 2024-07-17 | 4.99 | 1 | SO71442 | 2024-07-24 | 0.40 | 1.87 | |
SO71442_2 | 19 | 26077 | 480 | 2 | 6 | 2024-07-29 | 0.06 | 2024-07-17 | 2.29 | 2 | SO71442 | 2024-07-24 | 0.18 | 0.86 |
SO71446_1 | 19 | 21777 | 485 | 6 | 2024-07-29 | 0.55 | 2024-07-17 | 21.98 | 1 | SO71446 | 2024-07-24 | 1.76 | 8.22 | |
SO71446_2 | 19 | 21777 | 486 | 6 | 2024-07-29 | 3.98 | 2024-07-17 | 159.00 | 2 | SO71446 | 2024-07-24 | 12.72 | 59.47 | |
SO71456_1 | 19 | 11131 | 537 | 6 | 2024-07-29 | 0.88 | 2024-07-17 | 35.00 | 1 | SO71456 | 2024-07-24 | 2.80 | 13.09 | |
SO71456_2 | 19 | 11131 | 485 | 6 | 2024-07-29 | 0.55 | 2024-07-17 | 21.98 | 2 | SO71456 | 2024-07-24 | 1.76 | 8.22 | |
SO71458_1 | 19 | 14582 | 528 | 6 | 2024-07-29 | 0.12 | 2024-07-17 | 4.99 | 1 | SO71458 | 2024-07-24 | 0.40 | 1.87 | |
SO71458_2 | 19 | 14582 | 537 | 6 | 2024-07-29 | 0.88 | 2024-07-17 | 35.00 | 2 | SO71458 | 2024-07-24 | 2.80 | 13.09 | |
SO71458_3 | 19 | 14582 | 478 | 6 | 2024-07-29 | 0.25 | 2024-07-17 | 9.99 | 3 | SO71458 | 2024-07-24 | 0.80 | 3.74 | |
SO71483_1 | 19 | 17655 | 582 | 6 | 2024-07-29 | 42.52 | 2024-07-17 | 1700.99 | 1 | SO71483 | 2024-07-24 | 136.08 | 1082.51 | |
SO71483_2 | 19 | 17655 | 228 | 6 | 2024-07-29 | 1.25 | 2024-07-17 | 49.99 | 2 | SO71483 | 2024-07-24 | 4.00 | 38.49 | |
SO71515_1 | 19 | 19642 | 529 | 6 | 2024-07-30 | 0.10 | 2024-07-18 | 3.99 | 1 | SO71515 | 2024-07-25 | 0.32 | 1.49 | |
SO71515_2 | 19 | 19642 | 540 | 6 | 2024-07-30 | 0.82 | 2024-07-18 | 32.60 | 2 | SO71515 | 2024-07-25 | 2.61 | 12.19 | |
SO71517_1 | 19 | 17450 | 476 | 6 | 2024-07-30 | 1.75 | 2024-07-18 | 69.99 | 1 | SO71517 | 2024-07-25 | 5.60 | 26.18 | |
SO71517_2 | 19 | 17450 | 491 | 6 | 2024-07-30 | 1.35 | 2024-07-18 | 53.99 | 2 | SO71517 | 2024-07-25 | 4.32 | 41.57 | |
SO71521_1 | 19 | 23552 | 528 | 6 | 2024-07-30 | 0.12 | 2024-07-18 | 4.99 | 1 | SO71521 | 2024-07-25 | 0.40 | 1.87 | |
SO71521_2 | 19 | 23552 | 472 | 6 | 2024-07-30 | 1.59 | 2024-07-18 | 63.50 | 2 | SO71521 | 2024-07-25 | 5.08 | 23.75 | |
SO71521_3 | 19 | 23552 | 214 | 6 | 2024-07-30 | 0.87 | 2024-07-18 | 34.99 | 3 | SO71521 | 2024-07-25 | 2.80 | 13.09 | |
SO71535_1 | 19 | 15748 | 485 | 6 | 2024-07-30 | 0.55 | 2024-07-18 | 21.98 | 1 | SO71535 | 2024-07-25 | 1.76 | 8.22 | |
SO71535_2 | 19 | 15748 | 214 | 6 | 2024-07-30 | 0.87 | 2024-07-18 | 34.99 | 2 | SO71535 | 2024-07-25 | 2.80 | 13.09 |
Generated 2024-09-20 14:37:32.293 UTC