[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 2264 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71317_1 | 19 | 15494 | 537 | 6 | 2024-09-16 | 0.88 | 2024-09-04 | 35.00 | 1 | SO71317 | 2024-09-11 | 2.80 | 13.09 | |
SO71317_2 | 19 | 15494 | 528 | 6 | 2024-09-16 | 0.12 | 2024-09-04 | 4.99 | 2 | SO71317 | 2024-09-11 | 0.40 | 1.87 | |
SO71317_3 | 19 | 15494 | 485 | 6 | 2024-09-16 | 0.55 | 2024-09-04 | 21.98 | 3 | SO71317 | 2024-09-11 | 1.76 | 8.22 | |
SO71317_4 | 19 | 15494 | 471 | 6 | 2024-09-16 | 1.59 | 2024-09-04 | 63.50 | 4 | SO71317 | 2024-09-11 | 5.08 | 23.75 | |
SO71321_1 | 19 | 20034 | 363 | 6 | 2024-09-16 | 57.37 | 2024-09-04 | 2294.99 | 1 | SO71321 | 2024-09-11 | 183.60 | 1251.98 | |
SO71321_2 | 19 | 20034 | 537 | 6 | 2024-09-16 | 0.88 | 2024-09-04 | 35.00 | 2 | SO71321 | 2024-09-11 | 2.80 | 13.09 | |
SO71321_3 | 19 | 20034 | 528 | 6 | 2024-09-16 | 0.12 | 2024-09-04 | 4.99 | 3 | SO71321 | 2024-09-11 | 0.40 | 1.87 | |
SO71321_4 | 19 | 20034 | 217 | 6 | 2024-09-16 | 0.87 | 2024-09-04 | 34.99 | 4 | SO71321 | 2024-09-11 | 2.80 | 13.09 | |
SO71351_1 | 19 | 11277 | 484 | 6 | 2024-09-17 | 0.20 | 2024-09-05 | 7.95 | 1 | SO71351 | 2024-09-12 | 0.64 | 2.97 | |
SO71373_1 | 19 | 19411 | 536 | 6 | 2024-09-17 | 0.75 | 2024-09-05 | 29.99 | 1 | SO71373 | 2024-09-12 | 2.40 | 11.22 | |
SO71377_1 | 19 | 11276 | 477 | 6 | 2024-09-17 | 0.12 | 2024-09-05 | 4.99 | 1 | SO71377 | 2024-09-12 | 0.40 | 1.87 | |
SO71378_1 | 19 | 11287 | 477 | 6 | 2024-09-17 | 0.12 | 2024-09-05 | 4.99 | 1 | SO71378 | 2024-09-12 | 0.40 | 1.87 | |
SO71378_2 | 19 | 11287 | 487 | 6 | 2024-09-17 | 1.37 | 2024-09-05 | 54.99 | 2 | SO71378 | 2024-09-12 | 4.40 | 20.57 | |
SO71383_1 | 19 | 21490 | 528 | 6 | 2024-09-17 | 0.12 | 2024-09-05 | 4.99 | 1 | SO71383 | 2024-09-12 | 0.40 | 1.87 | |
SO71383_2 | 19 | 21490 | 480 | 2 | 6 | 2024-09-17 | 0.06 | 2024-09-05 | 2.29 | 2 | SO71383 | 2024-09-12 | 0.18 | 0.86 |
SO71384_1 | 19 | 20756 | 528 | 6 | 2024-09-17 | 0.12 | 2024-09-05 | 4.99 | 1 | SO71384 | 2024-09-12 | 0.40 | 1.87 | |
SO71384_2 | 19 | 20756 | 480 | 2 | 6 | 2024-09-17 | 0.06 | 2024-09-05 | 2.29 | 2 | SO71384 | 2024-09-12 | 0.18 | 0.86 |
SO71385_1 | 19 | 20783 | 528 | 6 | 2024-09-17 | 0.12 | 2024-09-05 | 4.99 | 1 | SO71385 | 2024-09-12 | 0.40 | 1.87 | |
SO71385_2 | 19 | 20783 | 217 | 6 | 2024-09-17 | 0.87 | 2024-09-05 | 34.99 | 2 | SO71385 | 2024-09-12 | 2.80 | 13.09 | |
SO71401_1 | 19 | 19646 | 485 | 6 | 2024-09-17 | 0.55 | 2024-09-05 | 21.98 | 1 | SO71401 | 2024-09-12 | 1.76 | 8.22 | |
SO71401_2 | 19 | 19646 | 473 | 6 | 2024-09-17 | 1.59 | 2024-09-05 | 63.50 | 2 | SO71401 | 2024-09-12 | 5.08 | 23.75 | |
SO71405_1 | 19 | 16121 | 595 | 6 | 2024-09-17 | 14.12 | 2024-09-05 | 564.99 | 1 | SO71405 | 2024-09-12 | 45.20 | 308.22 | |
SO71405_2 | 19 | 16121 | 535 | 6 | 2024-09-17 | 0.62 | 2024-09-05 | 24.99 | 2 | SO71405 | 2024-09-12 | 2.00 | 9.35 | |
SO71405_3 | 19 | 16121 | 465 | 6 | 2024-09-17 | 0.61 | 2024-09-05 | 24.49 | 3 | SO71405 | 2024-09-12 | 1.96 | 9.16 | |
SO71420_1 | 19 | 17861 | 580 | 6 | 2024-09-17 | 42.52 | 2024-09-05 | 1700.99 | 1 | SO71420 | 2024-09-12 | 136.08 | 1082.51 | |
SO71420_2 | 19 | 17861 | 479 | 6 | 2024-09-17 | 0.22 | 2024-09-05 | 8.99 | 2 | SO71420 | 2024-09-12 | 0.72 | 3.36 | |
SO71420_3 | 19 | 17861 | 477 | 6 | 2024-09-17 | 0.12 | 2024-09-05 | 4.99 | 3 | SO71420 | 2024-09-12 | 0.40 | 1.87 | |
SO71420_4 | 19 | 17861 | 214 | 6 | 2024-09-17 | 0.87 | 2024-09-05 | 34.99 | 4 | SO71420 | 2024-09-12 | 2.80 | 13.09 | |
SO71436_1 | 19 | 11211 | 539 | 6 | 2024-09-18 | 0.62 | 2024-09-06 | 24.99 | 1 | SO71436 | 2024-09-13 | 2.00 | 9.35 | |
SO71436_2 | 19 | 11211 | 480 | 6 | 2024-09-18 | 0.06 | 2024-09-06 | 2.29 | 2 | SO71436 | 2024-09-13 | 0.18 | 0.86 | |
SO71442_1 | 19 | 26077 | 528 | 6 | 2024-09-18 | 0.12 | 2024-09-06 | 4.99 | 1 | SO71442 | 2024-09-13 | 0.40 | 1.87 | |
SO71442_2 | 19 | 26077 | 480 | 2 | 6 | 2024-09-18 | 0.06 | 2024-09-06 | 2.29 | 2 | SO71442 | 2024-09-13 | 0.18 | 0.86 |
SO71446_1 | 19 | 21777 | 485 | 6 | 2024-09-18 | 0.55 | 2024-09-06 | 21.98 | 1 | SO71446 | 2024-09-13 | 1.76 | 8.22 | |
SO71446_2 | 19 | 21777 | 486 | 6 | 2024-09-18 | 3.98 | 2024-09-06 | 159.00 | 2 | SO71446 | 2024-09-13 | 12.72 | 59.47 | |
SO71456_1 | 19 | 11131 | 537 | 6 | 2024-09-18 | 0.88 | 2024-09-06 | 35.00 | 1 | SO71456 | 2024-09-13 | 2.80 | 13.09 | |
SO71456_2 | 19 | 11131 | 485 | 6 | 2024-09-18 | 0.55 | 2024-09-06 | 21.98 | 2 | SO71456 | 2024-09-13 | 1.76 | 8.22 | |
SO71458_1 | 19 | 14582 | 528 | 6 | 2024-09-18 | 0.12 | 2024-09-06 | 4.99 | 1 | SO71458 | 2024-09-13 | 0.40 | 1.87 | |
SO71458_2 | 19 | 14582 | 537 | 6 | 2024-09-18 | 0.88 | 2024-09-06 | 35.00 | 2 | SO71458 | 2024-09-13 | 2.80 | 13.09 | |
SO71458_3 | 19 | 14582 | 478 | 6 | 2024-09-18 | 0.25 | 2024-09-06 | 9.99 | 3 | SO71458 | 2024-09-13 | 0.80 | 3.74 | |
SO71483_1 | 19 | 17655 | 582 | 6 | 2024-09-18 | 42.52 | 2024-09-06 | 1700.99 | 1 | SO71483 | 2024-09-13 | 136.08 | 1082.51 | |
SO58390_2 | 19 | 15511 | 485 | 6 | 2024-03-15 | 0.55 | 2024-03-03 | 21.98 | 2 | SO58390 | 2024-03-10 | 1.76 | 8.22 | |
SO58390_3 | 19 | 15511 | 214 | 6 | 2024-03-15 | 0.87 | 2024-03-03 | 34.99 | 3 | SO58390 | 2024-03-10 | 2.80 | 13.09 | |
SO58393_1 | 19 | 16764 | 582 | 6 | 2024-03-15 | 42.52 | 2024-03-03 | 1700.99 | 1 | SO58393 | 2024-03-10 | 136.08 | 1082.51 | |
SO58393_2 | 19 | 16764 | 465 | 6 | 2024-03-15 | 0.61 | 2024-03-03 | 24.49 | 2 | SO58393 | 2024-03-10 | 1.96 | 9.16 | |
SO58393_3 | 19 | 16764 | 222 | 6 | 2024-03-15 | 0.87 | 2024-03-03 | 34.99 | 3 | SO58393 | 2024-03-10 | 2.80 | 13.09 | |
SO58417_1 | 19 | 11520 | 484 | 6 | 2024-03-16 | 0.20 | 2024-03-04 | 7.95 | 1 | SO58417 | 2024-03-11 | 0.64 | 2.97 | |
SO58424_1 | 19 | 11287 | 480 | 6 | 2024-03-16 | 0.06 | 2024-03-04 | 2.29 | 1 | SO58424 | 2024-03-11 | 0.18 | 0.86 | |
SO58429_1 | 19 | 11078 | 528 | 6 | 2024-03-16 | 0.12 | 2024-03-04 | 4.99 | 1 | SO58429 | 2024-03-11 | 0.40 | 1.87 | |
SO58429_2 | 19 | 11078 | 535 | 6 | 2024-03-16 | 0.62 | 2024-03-04 | 24.99 | 2 | SO58429 | 2024-03-11 | 2.00 | 9.35 | |
SO58431_1 | 19 | 20086 | 529 | 6 | 2024-03-16 | 0.10 | 2024-03-04 | 3.99 | 1 | SO58431 | 2024-03-11 | 0.32 | 1.49 | |
SO58431_2 | 19 | 20086 | 540 | 6 | 2024-03-16 | 0.82 | 2024-03-04 | 32.60 | 2 | SO58431 | 2024-03-11 | 2.61 | 12.19 | |
SO58431_3 | 19 | 20086 | 214 | 6 | 2024-03-16 | 0.87 | 2024-03-04 | 34.99 | 3 | SO58431 | 2024-03-11 | 2.80 | 13.09 | |
SO58437_1 | 19 | 12928 | 476 | 6 | 2024-03-16 | 1.75 | 2024-03-04 | 69.99 | 1 | SO58437 | 2024-03-11 | 5.60 | 26.18 | |
SO58437_2 | 19 | 12928 | 467 | 2 | 6 | 2024-03-16 | 0.61 | 2024-03-04 | 24.49 | 2 | SO58437 | 2024-03-11 | 1.96 | 9.16 |
SO58442_1 | 19 | 24621 | 477 | 6 | 2024-03-16 | 0.12 | 2024-03-04 | 4.99 | 1 | SO58442 | 2024-03-11 | 0.40 | 1.87 | |
SO58442_2 | 19 | 24621 | 484 | 6 | 2024-03-16 | 0.20 | 2024-03-04 | 7.95 | 2 | SO58442 | 2024-03-11 | 0.64 | 2.97 | |
SO58455_1 | 19 | 13345 | 361 | 6 | 2024-03-16 | 57.37 | 2024-03-04 | 2294.99 | 1 | SO58455 | 2024-03-11 | 183.60 | 1251.98 | |
SO58455_2 | 19 | 13345 | 485 | 6 | 2024-03-16 | 0.55 | 2024-03-04 | 21.98 | 2 | SO58455 | 2024-03-11 | 1.76 | 8.22 | |
SO58488_1 | 19 | 11631 | 539 | 6 | 2024-03-17 | 0.62 | 2024-03-05 | 24.99 | 1 | SO58488 | 2024-03-12 | 2.00 | 9.35 | |
SO58488_2 | 19 | 11631 | 529 | 6 | 2024-03-17 | 0.10 | 2024-03-05 | 3.99 | 2 | SO58488 | 2024-03-12 | 0.32 | 1.49 | |
SO58488_3 | 19 | 11631 | 480 | 6 | 2024-03-17 | 0.06 | 2024-03-05 | 2.29 | 3 | SO58488 | 2024-03-12 | 0.18 | 0.86 | |
SO58488_4 | 19 | 11631 | 484 | 6 | 2024-03-17 | 0.20 | 2024-03-05 | 7.95 | 4 | SO58488 | 2024-03-12 | 0.64 | 2.97 | |
SO58489_1 | 19 | 11507 | 214 | 6 | 2024-03-17 | 0.87 | 2024-03-05 | 34.99 | 1 | SO58489 | 2024-03-12 | 2.80 | 13.09 | |
SO58490_1 | 19 | 11078 | 539 | 6 | 2024-03-17 | 0.62 | 2024-03-05 | 24.99 | 1 | SO58490 | 2024-03-12 | 2.00 | 9.35 | |
SO58490_2 | 19 | 11078 | 231 | 6 | 2024-03-17 | 1.25 | 2024-03-05 | 49.99 | 2 | SO58490 | 2024-03-12 | 4.00 | 38.49 | |
SO58495_1 | 19 | 20084 | 540 | 6 | 2024-03-17 | 0.82 | 2024-03-05 | 32.60 | 1 | SO58495 | 2024-03-12 | 2.61 | 12.19 | |
SO58495_2 | 19 | 20084 | 529 | 6 | 2024-03-17 | 0.10 | 2024-03-05 | 3.99 | 2 | SO58495 | 2024-03-12 | 0.32 | 1.49 | |
SO58495_3 | 19 | 20084 | 480 | 6 | 2024-03-17 | 0.06 | 2024-03-05 | 2.29 | 3 | SO58495 | 2024-03-12 | 0.18 | 0.86 | |
SO58499_1 | 19 | 11331 | 536 | 6 | 2024-03-17 | 0.75 | 2024-03-05 | 29.99 | 1 | SO58499 | 2024-03-12 | 2.40 | 11.22 | |
SO58502_1 | 19 | 12984 | 478 | 6 | 2024-03-17 | 0.25 | 2024-03-05 | 9.99 | 1 | SO58502 | 2024-03-12 | 0.80 | 3.74 | |
SO58502_2 | 19 | 12984 | 477 | 6 | 2024-03-17 | 0.12 | 2024-03-05 | 4.99 | 2 | SO58502 | 2024-03-12 | 0.40 | 1.87 | |
SO58502_3 | 19 | 12984 | 225 | 6 | 2024-03-17 | 0.22 | 2024-03-05 | 8.99 | 3 | SO58502 | 2024-03-12 | 0.72 | 6.92 | |
SO58515_1 | 19 | 13936 | 537 | 6 | 2024-03-17 | 0.88 | 2024-03-05 | 35.00 | 1 | SO58515 | 2024-03-12 | 2.80 | 13.09 | |
SO58516_1 | 19 | 19224 | 485 | 6 | 2024-03-17 | 0.55 | 2024-03-05 | 21.98 | 1 | SO58516 | 2024-03-12 | 1.76 | 8.22 | |
SO58516_2 | 19 | 19224 | 228 | 6 | 2024-03-17 | 1.25 | 2024-03-05 | 49.99 | 2 | SO58516 | 2024-03-12 | 4.00 | 38.49 | |
SO58517_1 | 19 | 16902 | 485 | 6 | 2024-03-17 | 0.55 | 2024-03-05 | 21.98 | 1 | SO58517 | 2024-03-12 | 1.76 | 8.22 | |
SO58517_2 | 19 | 16902 | 483 | 6 | 2024-03-17 | 3.00 | 2024-03-05 | 120.00 | 2 | SO58517 | 2024-03-12 | 9.60 | 44.88 | |
SO58520_1 | 19 | 16791 | 581 | 6 | 2024-03-17 | 42.52 | 2024-03-05 | 1700.99 | 1 | SO58520 | 2024-03-12 | 136.08 | 1082.51 | |
SO58520_2 | 19 | 16791 | 529 | 6 | 2024-03-17 | 0.10 | 2024-03-05 | 3.99 | 2 | SO58520 | 2024-03-12 | 0.32 | 1.49 | |
SO58520_3 | 19 | 16791 | 539 | 6 | 2024-03-17 | 0.62 | 2024-03-05 | 24.99 | 3 | SO58520 | 2024-03-12 | 2.00 | 9.35 | |
SO58521_1 | 19 | 15993 | 594 | 6 | 2024-03-17 | 14.12 | 2024-03-05 | 564.99 | 1 | SO58521 | 2024-03-12 | 45.20 | 308.22 | |
SO58521_2 | 19 | 15993 | 535 | 6 | 2024-03-17 | 0.62 | 2024-03-05 | 24.99 | 2 | SO58521 | 2024-03-12 | 2.00 | 9.35 | |
SO58521_3 | 19 | 15993 | 528 | 6 | 2024-03-17 | 0.12 | 2024-03-05 | 4.99 | 3 | SO58521 | 2024-03-12 | 0.40 | 1.87 | |
SO58521_4 | 19 | 15993 | 480 | 2 | 6 | 2024-03-17 | 0.06 | 2024-03-05 | 2.29 | 4 | SO58521 | 2024-03-12 | 0.18 | 0.86 |
SO58550_1 | 19 | 11287 | 530 | 6 | 2024-03-18 | 0.12 | 2024-03-06 | 4.99 | 1 | SO58550 | 2024-03-13 | 0.40 | 1.87 | |
SO58550_2 | 19 | 11287 | 487 | 6 | 2024-03-18 | 1.37 | 2024-03-06 | 54.99 | 2 | SO58550 | 2024-03-13 | 4.40 | 20.57 | |
SO58550_3 | 19 | 11287 | 484 | 6 | 2024-03-18 | 0.20 | 2024-03-06 | 7.95 | 3 | SO58550 | 2024-03-13 | 0.64 | 2.97 | |
SO58552_1 | 19 | 11215 | 529 | 6 | 2024-03-18 | 0.10 | 2024-03-06 | 3.99 | 1 | SO58552 | 2024-03-13 | 0.32 | 1.49 | |
SO58552_2 | 19 | 11215 | 539 | 6 | 2024-03-18 | 0.62 | 2024-03-06 | 24.99 | 2 | SO58552 | 2024-03-13 | 2.00 | 9.35 | |
SO58552_3 | 19 | 11215 | 486 | 6 | 2024-03-18 | 3.98 | 2024-03-06 | 159.00 | 3 | SO58552 | 2024-03-13 | 12.72 | 59.47 | |
SO58556_1 | 19 | 11330 | 540 | 6 | 2024-03-18 | 0.82 | 2024-03-06 | 32.60 | 1 | SO58556 | 2024-03-13 | 2.61 | 12.19 | |
SO58556_2 | 19 | 11330 | 529 | 6 | 2024-03-18 | 0.10 | 2024-03-06 | 3.99 | 2 | SO58556 | 2024-03-13 | 0.32 | 1.49 | |
SO58556_3 | 19 | 11330 | 222 | 6 | 2024-03-18 | 0.87 | 2024-03-06 | 34.99 | 3 | SO58556 | 2024-03-13 | 2.80 | 13.09 | |
SO58557_1 | 19 | 11330 | 540 | 6 | 2024-03-18 | 0.82 | 2024-03-06 | 32.60 | 1 | SO58557 | 2024-03-13 | 2.61 | 12.19 | |
SO58557_2 | 19 | 11330 | 529 | 6 | 2024-03-18 | 0.10 | 2024-03-06 | 3.99 | 2 | SO58557 | 2024-03-13 | 0.32 | 1.49 | |
SO58557_3 | 19 | 11330 | 480 | 6 | 2024-03-18 | 0.06 | 2024-03-06 | 2.29 | 3 | SO58557 | 2024-03-13 | 0.18 | 0.86 |
Generated 2024-11-10 23:49:23.254 UTC