[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2594 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO70063_2 | 100 | 17581 | 478 | 4 | 2024-09-01 | 0.25 | 2024-08-20 | 9.99 | 2 | SO70063 | 2024-08-27 | 0.80 | 3.74 | |
SO48280_1 | 100 | 13487 | 377 | 4 | 2023-03-27 | 54.54 | 2023-03-15 | 2181.56 | 1 | SO48280 | 2023-03-22 | 174.53 | 1320.68 | |
SO63533_5 | 100 | 12755 | 478 | 4 | 2024-05-31 | 0.25 | 2024-05-19 | 9.99 | 5 | SO63533 | 2024-05-26 | 0.80 | 3.74 | |
SO70063_3 | 100 | 17581 | 477 | 4 | 2024-09-01 | 0.12 | 2024-08-20 | 4.99 | 3 | SO70063 | 2024-08-27 | 0.40 | 1.87 | |
SO48281_1 | 100 | 13492 | 371 | 4 | 2023-03-27 | 54.54 | 2023-03-15 | 2181.56 | 1 | SO48281 | 2023-03-22 | 174.53 | 1320.68 | |
SO63540_1 | 100 | 26106 | 562 | 4 | 2024-05-31 | 59.60 | 2024-05-19 | 2384.07 | 1 | SO63540 | 2024-05-26 | 190.73 | 1481.94 | |
SO70063_4 | 100 | 17581 | 222 | 4 | 2024-09-01 | 0.87 | 2024-08-20 | 34.99 | 4 | SO70063 | 2024-08-27 | 2.80 | 13.09 | |
SO48282_1 | 100 | 26540 | 362 | 2 | 4 | 2023-03-27 | 51.23 | 2023-03-15 | 2049.10 | 1 | SO48282 | 2023-03-22 | 163.93 | 1105.81 |
SO63540_2 | 100 | 26106 | 225 | 4 | 2024-05-31 | 0.22 | 2024-05-19 | 8.99 | 2 | SO63540 | 2024-05-26 | 0.72 | 6.92 | |
SO70063_5 | 100 | 17581 | 465 | 4 | 2024-09-01 | 0.61 | 2024-08-20 | 24.49 | 5 | SO70063 | 2024-08-27 | 1.96 | 9.16 | |
SO48283_1 | 100 | 15389 | 323 | 4 | 2023-03-27 | 19.57 | 2023-03-15 | 782.99 | 1 | SO48283 | 2023-03-22 | 62.64 | 486.71 | |
SO63542_1 | 100 | 23318 | 604 | 4 | 2024-05-31 | 13.50 | 2024-05-19 | 539.99 | 1 | SO63542 | 2024-05-26 | 43.20 | 343.65 | |
SO70077_1 | 100 | 26003 | 578 | 4 | 2024-09-01 | 30.37 | 2024-08-20 | 1214.85 | 1 | SO70077 | 2024-08-27 | 97.19 | 755.15 | |
SO48403_1 | 100 | 14285 | 383 | 4 | 2023-03-28 | 25.01 | 2023-03-16 | 1000.44 | 1 | SO48403 | 2023-03-23 | 80.04 | 605.65 | |
SO63542_2 | 100 | 23318 | 538 | 4 | 2024-05-31 | 0.54 | 2024-05-19 | 21.49 | 2 | SO63542 | 2024-05-26 | 1.72 | 8.04 | |
SO70077_2 | 100 | 26003 | 541 | 4 | 2024-09-01 | 0.72 | 2024-08-20 | 28.99 | 2 | SO70077 | 2024-08-27 | 2.32 | 10.84 | |
SO48406_1 | 100 | 15473 | 327 | 4 | 2023-03-28 | 19.57 | 2023-03-16 | 782.99 | 1 | SO48406 | 2023-03-23 | 62.64 | 486.71 | |
SO63543_1 | 100 | 23081 | 606 | 4 | 2024-05-31 | 13.50 | 2024-05-19 | 539.99 | 1 | SO63543 | 2024-05-26 | 43.20 | 343.65 | |
SO70077_3 | 100 | 26003 | 530 | 4 | 2024-09-01 | 0.12 | 2024-08-20 | 4.99 | 3 | SO70077 | 2024-08-27 | 0.40 | 1.87 | |
SO48410_1 | 100 | 26649 | 358 | 4 | 2023-03-28 | 51.23 | 2023-03-16 | 2049.10 | 1 | SO48410 | 2023-03-23 | 163.93 | 1105.81 | |
SO63543_2 | 100 | 23081 | 477 | 4 | 2024-05-31 | 0.12 | 2024-05-19 | 4.99 | 2 | SO63543 | 2024-05-26 | 0.40 | 1.87 | |
SO70077_4 | 100 | 26003 | 463 | 4 | 2024-09-01 | 0.61 | 2024-08-20 | 24.49 | 4 | SO70077 | 2024-08-27 | 1.96 | 9.16 | |
SO48413_1 | 100 | 14288 | 383 | 4 | 2023-03-29 | 25.01 | 2023-03-17 | 1000.44 | 1 | SO48413 | 2023-03-24 | 80.04 | 605.65 | |
SO63543_3 | 100 | 23081 | 479 | 4 | 2024-05-31 | 0.22 | 2024-05-19 | 8.99 | 3 | SO63543 | 2024-05-26 | 0.72 | 3.36 | |
SO70081_1 | 100 | 21615 | 388 | 4 | 2024-09-01 | 28.01 | 2024-08-20 | 1120.49 | 1 | SO70081 | 2024-08-27 | 89.64 | 713.08 | |
SO48415_1 | 100 | 26634 | 356 | 4 | 2023-03-29 | 51.79 | 2023-03-17 | 2071.42 | 1 | SO48415 | 2023-03-24 | 165.71 | 1117.86 | |
SO63543_4 | 100 | 23081 | 487 | 4 | 2024-05-31 | 1.37 | 2024-05-19 | 54.99 | 4 | SO63543 | 2024-05-26 | 4.40 | 20.57 | |
SO70081_2 | 100 | 21615 | 222 | 4 | 2024-09-01 | 0.87 | 2024-08-20 | 34.99 | 2 | SO70081 | 2024-08-27 | 2.80 | 13.09 | |
SO48426_1 | 100 | 14253 | 383 | 4 | 2023-03-30 | 25.01 | 2023-03-18 | 1000.44 | 1 | SO48426 | 2023-03-25 | 80.04 | 605.65 | |
SO63563_1 | 100 | 11731 | 222 | 4 | 2024-06-01 | 0.87 | 2024-05-20 | 34.99 | 1 | SO63563 | 2024-05-27 | 2.80 | 13.09 | |
SO70082_1 | 100 | 18780 | 581 | 4 | 2024-09-01 | 42.52 | 2024-08-20 | 1700.99 | 1 | SO70082 | 2024-08-27 | 136.08 | 1082.51 | |
SO48427_1 | 100 | 14289 | 389 | 4 | 2023-03-30 | 25.01 | 2023-03-18 | 1000.44 | 1 | SO48427 | 2023-03-25 | 80.04 | 605.65 | |
SO63566_1 | 100 | 27426 | 538 | 4 | 2024-06-01 | 0.54 | 2024-05-20 | 21.49 | 1 | SO63566 | 2024-05-27 | 1.72 | 8.04 | |
SO70082_2 | 100 | 18780 | 237 | 4 | 2024-09-01 | 1.25 | 2024-08-20 | 49.99 | 2 | SO70082 | 2024-08-27 | 4.00 | 38.49 | |
SO48430_1 | 100 | 26633 | 360 | 4 | 2023-03-30 | 51.23 | 2023-03-18 | 2049.10 | 1 | SO48430 | 2023-03-25 | 163.93 | 1105.81 | |
SO63566_2 | 100 | 27426 | 480 | 4 | 2024-06-01 | 0.06 | 2024-05-20 | 2.29 | 2 | SO63566 | 2024-05-27 | 0.18 | 0.86 | |
SO70082_3 | 100 | 18780 | 482 | 4 | 2024-09-01 | 0.22 | 2024-08-20 | 8.99 | 3 | SO70082 | 2024-08-27 | 0.72 | 3.36 | |
SO48437_1 | 100 | 15466 | 325 | 4 | 2023-03-31 | 19.57 | 2023-03-19 | 782.99 | 1 | SO48437 | 2023-03-26 | 62.64 | 486.71 | |
SO63567_1 | 100 | 25103 | 529 | 4 | 2024-06-01 | 0.10 | 2024-05-20 | 3.99 | 1 | SO63567 | 2024-05-27 | 0.32 | 1.49 | |
SO70099_1 | 100 | 11805 | 491 | 4 | 2024-09-02 | 1.35 | 2024-08-21 | 53.99 | 1 | SO70099 | 2024-08-28 | 4.32 | 41.57 | |
SO48444_1 | 100 | 26618 | 362 | 2 | 4 | 2023-04-01 | 51.23 | 2023-03-20 | 2049.10 | 1 | SO48444 | 2023-03-27 | 163.93 | 1105.81 |
SO63567_2 | 100 | 25103 | 540 | 4 | 2024-06-01 | 0.82 | 2024-05-20 | 32.60 | 2 | SO63567 | 2024-05-27 | 2.61 | 12.19 | |
SO70106_1 | 100 | 27462 | 538 | 4 | 2024-09-02 | 0.54 | 2024-08-21 | 21.49 | 1 | SO70106 | 2024-08-28 | 1.72 | 8.04 | |
SO48445_1 | 100 | 15411 | 343 | 4 | 2023-04-01 | 19.57 | 2023-03-20 | 782.99 | 1 | SO48445 | 2023-03-27 | 62.64 | 486.71 | |
SO63567_3 | 100 | 25103 | 488 | 4 | 2024-06-01 | 1.35 | 2024-05-20 | 53.99 | 3 | SO63567 | 2024-05-27 | 4.32 | 41.57 | |
SO70106_2 | 100 | 27462 | 529 | 4 | 2024-09-02 | 0.10 | 2024-08-21 | 3.99 | 2 | SO70106 | 2024-08-28 | 0.32 | 1.49 | |
SO48447_1 | 100 | 15471 | 327 | 4 | 2023-04-01 | 19.57 | 2023-03-20 | 782.99 | 1 | SO48447 | 2023-03-27 | 62.64 | 486.71 | |
SO63568_1 | 100 | 26639 | 535 | 4 | 2024-06-01 | 0.62 | 2024-05-20 | 24.99 | 1 | SO63568 | 2024-05-27 | 2.00 | 9.35 | |
SO70106_3 | 100 | 27462 | 480 | 4 | 2024-09-02 | 0.06 | 2024-08-21 | 2.29 | 3 | SO70106 | 2024-08-28 | 0.18 | 0.86 | |
SO48450_1 | 100 | 26645 | 362 | 2 | 4 | 2023-04-01 | 51.23 | 2023-03-20 | 2049.10 | 1 | SO48450 | 2023-03-27 | 163.93 | 1105.81 |
SO63568_2 | 100 | 26639 | 463 | 4 | 2024-06-01 | 0.61 | 2024-05-20 | 24.49 | 2 | SO63568 | 2024-05-27 | 1.96 | 9.16 | |
SO70106_4 | 100 | 27462 | 484 | 4 | 2024-09-02 | 0.20 | 2024-08-21 | 7.95 | 4 | SO70106 | 2024-08-28 | 0.64 | 2.97 | |
SO48464_1 | 100 | 13734 | 375 | 4 | 2023-04-03 | 54.54 | 2023-03-22 | 2181.56 | 1 | SO48464 | 2023-03-29 | 174.53 | 1320.68 | |
SO63570_1 | 100 | 23052 | 536 | 4 | 2024-06-01 | 0.75 | 2024-05-20 | 29.99 | 1 | SO63570 | 2024-05-27 | 2.40 | 11.22 | |
SO70108_1 | 100 | 26648 | 535 | 4 | 2024-09-02 | 0.62 | 2024-08-21 | 24.99 | 1 | SO70108 | 2024-08-28 | 2.00 | 9.35 | |
SO48465_1 | 100 | 26626 | 356 | 4 | 2023-04-03 | 51.79 | 2023-03-22 | 2071.42 | 1 | SO48465 | 2023-03-29 | 165.71 | 1117.86 |
Generated 2024-11-13 07:19:11.645 UTC