[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 5537 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47516_1 | 100 | 26309 | 362 | 2 | 4 | 2022-11-13 | 51.23 | 2022-11-01 | 2049.10 | 1 | SO47516 | 2022-11-08 | 163.93 | 1105.81 |
SO56652_2 | 100 | 28287 | 217 | 4 | 2023-12-28 | 0.87 | 2023-12-16 | 34.99 | 2 | SO56652 | 2023-12-23 | 2.80 | 13.09 | |
SO47517_1 | 100 | 15308 | 343 | 4 | 2022-11-13 | 19.57 | 2022-11-01 | 782.99 | 1 | SO47517 | 2022-11-08 | 62.64 | 486.71 | |
SO56652_3 | 100 | 28287 | 473 | 4 | 2023-12-28 | 1.59 | 2023-12-16 | 63.50 | 3 | SO56652 | 2023-12-23 | 5.08 | 23.75 | |
SO47518_1 | 6 | 21946 | 373 | 9 | 2022-11-13 | 54.54 | 2022-11-01 | 2181.56 | 1 | SO47518 | 2022-11-08 | 174.53 | 1320.68 | |
SO56653_1 | 19 | 11530 | 530 | 6 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 1 | SO56653 | 2023-12-23 | 0.40 | 1.87 | |
SO47519_1 | 6 | 26153 | 337 | 9 | 2022-11-13 | 19.57 | 2022-11-01 | 782.99 | 1 | SO47519 | 2022-11-08 | 62.64 | 486.71 | |
SO56654_1 | 19 | 11502 | 539 | 6 | 2023-12-28 | 0.62 | 2023-12-16 | 24.99 | 1 | SO56654 | 2023-12-23 | 2.00 | 9.35 | |
SO47520_1 | 98 | 19263 | 389 | 10 | 2022-11-14 | 25.01 | 2022-11-02 | 1000.44 | 1 | SO47520 | 2022-11-09 | 80.04 | 605.65 | |
SO56654_2 | 19 | 11502 | 529 | 6 | 2023-12-28 | 0.10 | 2023-12-16 | 3.99 | 2 | SO56654 | 2023-12-23 | 0.32 | 1.49 | |
SO47521_1 | 98 | 16445 | 369 | 2 | 10 | 2022-11-14 | 61.08 | 2022-11-02 | 2443.35 | 1 | SO47521 | 2022-11-09 | 195.47 | 1518.79 |
SO56654_3 | 19 | 11502 | 217 | 6 | 2023-12-28 | 0.87 | 2023-12-16 | 34.99 | 3 | SO56654 | 2023-12-23 | 2.80 | 13.09 | |
SO47522_1 | 100 | 14089 | 387 | 4 | 2022-11-14 | 25.01 | 2022-11-02 | 1000.44 | 1 | SO47522 | 2022-11-09 | 80.04 | 605.65 | |
SO56655_1 | 19 | 11498 | 538 | 6 | 2023-12-28 | 0.54 | 2023-12-16 | 21.49 | 1 | SO56655 | 2023-12-23 | 1.72 | 8.04 | |
SO47523_1 | 100 | 13443 | 371 | 1 | 2022-11-14 | 54.54 | 2022-11-02 | 2181.56 | 1 | SO47523 | 2022-11-09 | 174.53 | 1320.68 | |
SO56656_1 | 100 | 26492 | 528 | 4 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 1 | SO56656 | 2023-12-23 | 0.40 | 1.87 | |
SO47524_1 | 6 | 21567 | 370 | 9 | 2022-11-14 | 61.08 | 2022-11-02 | 2443.35 | 1 | SO47524 | 2022-11-09 | 195.47 | 1518.79 | |
SO56656_2 | 100 | 26492 | 535 | 4 | 2023-12-28 | 0.62 | 2023-12-16 | 24.99 | 2 | SO56656 | 2023-12-23 | 2.00 | 9.35 | |
SO47525_1 | 6 | 21889 | 379 | 9 | 2022-11-14 | 54.54 | 2022-11-02 | 2181.56 | 1 | SO47525 | 2022-11-09 | 174.53 | 1320.68 | |
SO56657_1 | 100 | 24768 | 540 | 4 | 2023-12-28 | 0.82 | 2023-12-16 | 32.60 | 1 | SO56657 | 2023-12-23 | 2.61 | 12.19 | |
SO47526_1 | 98 | 12215 | 354 | 10 | 2022-11-14 | 51.79 | 2022-11-02 | 2071.42 | 1 | SO47526 | 2022-11-09 | 165.71 | 1117.86 | |
SO56658_1 | 100 | 20489 | 478 | 1 | 2023-12-28 | 0.25 | 2023-12-16 | 9.99 | 1 | SO56658 | 2023-12-23 | 0.80 | 3.74 | |
SO47527_1 | 100 | 28559 | 360 | 7 | 2022-11-14 | 51.23 | 2022-11-02 | 2049.10 | 1 | SO47527 | 2022-11-09 | 163.93 | 1105.81 | |
SO47528_1 | 100 | 11598 | 352 | 8 | 2022-11-15 | 51.79 | 2022-11-03 | 2071.42 | 1 | SO47528 | 2022-11-10 | 165.71 | 1117.86 | |
SO47529_1 | 100 | 13429 | 377 | 4 | 2022-11-15 | 54.54 | 2022-11-03 | 2181.56 | 1 | SO47529 | 2022-11-10 | 174.53 | 1320.68 | |
SO47530_1 | 100 | 15312 | 329 | 4 | 2022-11-15 | 19.57 | 2022-11-03 | 782.99 | 1 | SO47530 | 2022-11-10 | 62.64 | 486.71 | |
SO47531_1 | 100 | 15325 | 339 | 1 | 2022-11-15 | 19.57 | 2022-11-03 | 782.99 | 1 | SO47531 | 2022-11-10 | 62.64 | 486.71 | |
SO47532_1 | 6 | 24888 | 383 | 9 | 2022-11-15 | 25.01 | 2022-11-03 | 1000.44 | 1 | SO47532 | 2022-11-10 | 80.04 | 605.65 | |
SO47533_1 | 6 | 21886 | 371 | 9 | 2022-11-15 | 54.54 | 2022-11-03 | 2181.56 | 1 | SO47533 | 2022-11-10 | 174.53 | 1320.68 | |
SO47534_1 | 6 | 26148 | 329 | 9 | 2022-11-15 | 19.57 | 2022-11-03 | 782.99 | 1 | SO47534 | 2022-11-10 | 62.64 | 486.71 | |
SO47535_1 | 100 | 14083 | 385 | 1 | 2022-11-16 | 25.01 | 2022-11-04 | 1000.44 | 1 | SO47535 | 2022-11-11 | 80.04 | 605.65 | |
SO56658_2 | 100 | 20489 | 477 | 1 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 2 | SO56658 | 2023-12-23 | 0.40 | 1.87 | |
SO56658_3 | 100 | 20489 | 222 | 1 | 2023-12-28 | 0.87 | 2023-12-16 | 34.99 | 3 | SO56658 | 2023-12-23 | 2.80 | 13.09 | |
SO56659_1 | 100 | 18354 | 477 | 4 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 1 | SO56659 | 2023-12-23 | 0.40 | 1.87 | |
SO47536_1 | 100 | 14088 | 387 | 1 | 2022-11-16 | 25.01 | 2022-11-04 | 1000.44 | 1 | SO47536 | 2022-11-11 | 80.04 | 605.65 | |
SO56659_2 | 100 | 18354 | 484 | 4 | 2023-12-28 | 0.20 | 2023-12-16 | 7.95 | 2 | SO56659 | 2023-12-23 | 0.64 | 2.97 | |
SO47537_1 | 100 | 13436 | 371 | 1 | 2022-11-16 | 54.54 | 2022-11-04 | 2181.56 | 1 | SO47537 | 2022-11-11 | 174.53 | 1320.68 | |
SO56659_3 | 100 | 18354 | 483 | 4 | 2023-12-28 | 3.00 | 2023-12-16 | 120.00 | 3 | SO56659 | 2023-12-23 | 9.60 | 44.88 | |
SO47538_1 | 100 | 13449 | 379 | 1 | 2022-11-16 | 54.54 | 2022-11-04 | 2181.56 | 1 | SO47538 | 2022-11-11 | 174.53 | 1320.68 | |
SO56660_1 | 100 | 17335 | 528 | 4 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 1 | SO56660 | 2023-12-23 | 0.40 | 1.87 | |
SO47539_1 | 98 | 20824 | 329 | 10 | 2022-11-16 | 19.57 | 2022-11-04 | 782.99 | 1 | SO47539 | 2022-11-11 | 62.64 | 486.71 | |
SO56661_1 | 100 | 15331 | 528 | 1 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 1 | SO56661 | 2023-12-23 | 0.40 | 1.87 | |
SO47540_1 | 100 | 26326 | 362 | 2 | 4 | 2022-11-16 | 51.23 | 2022-11-04 | 2049.10 | 1 | SO47540 | 2022-11-11 | 163.93 | 1105.81 |
SO56661_2 | 100 | 15331 | 480 | 2 | 1 | 2023-12-28 | 0.06 | 2023-12-16 | 2.29 | 2 | SO56661 | 2023-12-23 | 0.18 | 0.86 |
SO47541_1 | 100 | 15314 | 341 | 4 | 2022-11-16 | 19.57 | 2022-11-04 | 782.99 | 1 | SO47541 | 2022-11-11 | 62.64 | 486.71 | |
SO56662_1 | 19 | 20500 | 528 | 6 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 1 | SO56662 | 2023-12-23 | 0.40 | 1.87 | |
SO47542_1 | 6 | 21571 | 373 | 9 | 2022-11-16 | 54.54 | 2022-11-04 | 2181.56 | 1 | SO47542 | 2022-11-11 | 174.53 | 1320.68 | |
SO56662_2 | 19 | 20500 | 472 | 6 | 2023-12-28 | 1.59 | 2023-12-16 | 63.50 | 2 | SO56662 | 2023-12-23 | 5.08 | 23.75 | |
SO47543_1 | 6 | 21956 | 377 | 9 | 2022-11-16 | 54.54 | 2022-11-04 | 2181.56 | 1 | SO47543 | 2022-11-11 | 174.53 | 1320.68 | |
SO56663_1 | 100 | 14441 | 485 | 4 | 2023-12-28 | 0.55 | 2023-12-16 | 21.98 | 1 | SO56663 | 2023-12-23 | 1.76 | 8.22 | |
SO47544_1 | 6 | 12694 | 358 | 9 | 2022-11-16 | 51.23 | 2022-11-04 | 2049.10 | 1 | SO47544 | 2022-11-11 | 163.93 | 1105.81 | |
SO56663_2 | 100 | 14441 | 483 | 4 | 2023-12-28 | 3.00 | 2023-12-16 | 120.00 | 2 | SO56663 | 2023-12-23 | 9.60 | 44.88 | |
SO47545_1 | 100 | 28553 | 354 | 7 | 2022-11-16 | 51.79 | 2022-11-04 | 2071.42 | 1 | SO47545 | 2022-11-11 | 165.71 | 1117.86 | |
SO56664_1 | 19 | 18054 | 485 | 6 | 2023-12-28 | 0.55 | 2023-12-16 | 21.98 | 1 | SO56664 | 2023-12-23 | 1.76 | 8.22 | |
SO47546_1 | 100 | 28683 | 360 | 7 | 2022-11-17 | 51.23 | 2022-11-05 | 2049.10 | 1 | SO47546 | 2022-11-12 | 163.93 | 1105.81 | |
SO56664_2 | 19 | 18054 | 478 | 6 | 2023-12-28 | 0.25 | 2023-12-16 | 9.99 | 2 | SO56664 | 2023-12-23 | 0.80 | 3.74 | |
SO47547_1 | 100 | 20166 | 333 | 8 | 2022-11-17 | 19.57 | 2022-11-05 | 782.99 | 1 | SO47547 | 2022-11-12 | 62.64 | 486.71 | |
SO56664_3 | 19 | 18054 | 477 | 6 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 3 | SO56664 | 2023-12-23 | 0.40 | 1.87 | |
SO47548_1 | 98 | 20834 | 331 | 10 | 2022-11-17 | 19.57 | 2022-11-05 | 782.99 | 1 | SO47548 | 2022-11-12 | 62.64 | 486.71 | |
SO56665_1 | 100 | 16302 | 539 | 7 | 2023-12-28 | 0.62 | 2023-12-16 | 24.99 | 1 | SO56665 | 2023-12-23 | 2.00 | 9.35 | |
SO47549_1 | 100 | 19256 | 343 | 7 | 2022-11-17 | 19.57 | 2022-11-05 | 782.99 | 1 | SO47549 | 2022-11-12 | 62.64 | 486.71 | |
SO56666_1 | 100 | 19259 | 529 | 8 | 2023-12-28 | 0.10 | 2023-12-16 | 3.99 | 1 | SO56666 | 2023-12-23 | 0.32 | 1.49 |
Generated 2024-09-21 06:34:42.528 UTC