[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 1000 < SKIP 2170 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO66972_2 | 100 | 14637 | 222 | 1 | 2024-05-29 | 0.87 | 2024-05-17 | 34.99 | 2 | SO66972 | 2024-05-24 | 2.80 | 13.09 | |
SO66973_1 | 100 | 14391 | 485 | 1 | 2024-05-29 | 0.55 | 2024-05-17 | 21.98 | 1 | SO66973 | 2024-05-24 | 1.76 | 8.22 | |
SO66986_1 | 100 | 11196 | 528 | 1 | 2024-05-29 | 0.12 | 2024-05-17 | 4.99 | 1 | SO66986 | 2024-05-24 | 0.40 | 1.87 | |
SO66986_2 | 100 | 11196 | 537 | 1 | 2024-05-29 | 0.88 | 2024-05-17 | 35.00 | 2 | SO66986 | 2024-05-24 | 2.80 | 13.09 | |
SO66986_3 | 100 | 11196 | 483 | 1 | 2024-05-29 | 3.00 | 2024-05-17 | 120.00 | 3 | SO66986 | 2024-05-24 | 9.60 | 44.88 | |
SO66993_1 | 100 | 14754 | 587 | 1 | 2024-05-29 | 19.24 | 2024-05-17 | 769.49 | 1 | SO66993 | 2024-05-24 | 61.56 | 419.78 | |
SO66993_2 | 100 | 14754 | 536 | 1 | 2024-05-29 | 0.75 | 2024-05-17 | 29.99 | 2 | SO66993 | 2024-05-24 | 2.40 | 11.22 | |
SO66993_3 | 100 | 14754 | 480 | 1 | 2024-05-29 | 0.06 | 2024-05-17 | 2.29 | 3 | SO66993 | 2024-05-24 | 0.18 | 0.86 | |
SO67009_1 | 100 | 21147 | 384 | 2 | 1 | 2024-05-29 | 28.01 | 2024-05-17 | 1120.49 | 1 | SO67009 | 2024-05-24 | 89.64 | 713.08 |
SO67009_2 | 100 | 21147 | 214 | 1 | 2024-05-29 | 0.87 | 2024-05-17 | 34.99 | 2 | SO67009 | 2024-05-24 | 2.80 | 13.09 | |
SO67009_3 | 100 | 21147 | 463 | 1 | 2024-05-29 | 0.61 | 2024-05-17 | 24.49 | 3 | SO67009 | 2024-05-24 | 1.96 | 9.16 | |
SO67010_1 | 100 | 21253 | 388 | 1 | 2024-05-29 | 28.01 | 2024-05-17 | 1120.49 | 1 | SO67010 | 2024-05-24 | 89.64 | 713.08 | |
SO67010_2 | 100 | 21253 | 217 | 1 | 2024-05-29 | 0.87 | 2024-05-17 | 34.99 | 2 | SO67010 | 2024-05-24 | 2.80 | 13.09 | |
SO67029_1 | 100 | 11294 | 480 | 1 | 2024-05-30 | 0.06 | 2024-05-18 | 2.29 | 1 | SO67029 | 2024-05-25 | 0.18 | 0.86 | |
SO67033_1 | 100 | 25179 | 529 | 1 | 2024-05-30 | 0.10 | 2024-05-18 | 3.99 | 1 | SO67033 | 2024-05-25 | 0.32 | 1.49 | |
SO67033_2 | 100 | 25179 | 540 | 1 | 2024-05-30 | 0.82 | 2024-05-18 | 32.60 | 2 | SO67033 | 2024-05-25 | 2.61 | 12.19 | |
SO67033_3 | 100 | 25179 | 217 | 1 | 2024-05-30 | 0.87 | 2024-05-18 | 34.99 | 3 | SO67033 | 2024-05-25 | 2.80 | 13.09 | |
SO67034_1 | 100 | 23805 | 540 | 1 | 2024-05-30 | 0.82 | 2024-05-18 | 32.60 | 1 | SO67034 | 2024-05-25 | 2.61 | 12.19 | |
SO67035_1 | 100 | 23782 | 536 | 1 | 2024-05-30 | 0.75 | 2024-05-18 | 29.99 | 1 | SO67035 | 2024-05-25 | 2.40 | 11.22 | |
SO67035_2 | 100 | 23782 | 528 | 1 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 2 | SO67035 | 2024-05-25 | 0.40 | 1.87 | |
SO67035_3 | 100 | 23782 | 222 | 1 | 2024-05-30 | 0.87 | 2024-05-18 | 34.99 | 3 | SO67035 | 2024-05-25 | 2.80 | 13.09 | |
SO67039_1 | 100 | 20514 | 477 | 1 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 1 | SO67039 | 2024-05-25 | 0.40 | 1.87 | |
SO67039_2 | 100 | 20514 | 478 | 1 | 2024-05-30 | 0.25 | 2024-05-18 | 9.99 | 2 | SO67039 | 2024-05-25 | 0.80 | 3.74 | |
SO67039_3 | 100 | 20514 | 222 | 1 | 2024-05-30 | 0.87 | 2024-05-18 | 34.99 | 3 | SO67039 | 2024-05-25 | 2.80 | 13.09 | |
SO67040_1 | 100 | 19649 | 475 | 1 | 2024-05-30 | 1.75 | 2024-05-18 | 69.99 | 1 | SO67040 | 2024-05-25 | 5.60 | 26.18 | |
SO67040_2 | 100 | 19649 | 225 | 1 | 2024-05-30 | 0.22 | 2024-05-18 | 8.99 | 2 | SO67040 | 2024-05-25 | 0.72 | 6.92 | |
SO67042_1 | 100 | 16236 | 528 | 1 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 1 | SO67042 | 2024-05-25 | 0.40 | 1.87 | |
SO67042_2 | 100 | 16236 | 222 | 1 | 2024-05-30 | 0.87 | 2024-05-18 | 34.99 | 2 | SO67042 | 2024-05-25 | 2.80 | 13.09 | |
SO67042_3 | 100 | 16236 | 231 | 1 | 2024-05-30 | 1.25 | 2024-05-18 | 49.99 | 3 | SO67042 | 2024-05-25 | 4.00 | 38.49 | |
SO67042_4 | 100 | 16236 | 225 | 1 | 2024-05-30 | 0.22 | 2024-05-18 | 8.99 | 4 | SO67042 | 2024-05-25 | 0.72 | 6.92 | |
SO69261_2 | 100 | 25915 | 225 | 1 | 2024-07-01 | 0.22 | 2024-06-19 | 8.99 | 2 | SO69261 | 2024-06-26 | 0.72 | 6.92 | |
SO48497_1 | 100 | 26606 | 360 | 1 | 2023-02-11 | 51.23 | 2023-01-30 | 2049.10 | 1 | SO48497 | 2023-02-06 | 163.93 | 1105.81 | |
SO69261_3 | 100 | 25915 | 530 | 1 | 2024-07-01 | 0.12 | 2024-06-19 | 4.99 | 3 | SO69261 | 2024-06-26 | 0.40 | 1.87 | |
SO48507_1 | 100 | 14255 | 389 | 1 | 2023-02-12 | 25.01 | 2023-01-31 | 1000.44 | 1 | SO48507 | 2023-02-07 | 80.04 | 605.65 | |
SO69268_1 | 100 | 21592 | 477 | 1 | 2024-07-01 | 0.12 | 2024-06-19 | 4.99 | 1 | SO69268 | 2024-06-26 | 0.40 | 1.87 | |
SO48525_1 | 100 | 14284 | 385 | 1 | 2023-02-13 | 25.01 | 2023-02-01 | 1000.44 | 1 | SO48525 | 2023-02-08 | 80.04 | 605.65 | |
SO69268_2 | 100 | 21592 | 478 | 1 | 2024-07-01 | 0.25 | 2024-06-19 | 9.99 | 2 | SO69268 | 2024-06-26 | 0.80 | 3.74 | |
SO48529_1 | 100 | 26638 | 360 | 1 | 2023-02-13 | 51.23 | 2023-02-01 | 2049.10 | 1 | SO48529 | 2023-02-08 | 163.93 | 1105.81 | |
SO69268_3 | 100 | 21592 | 225 | 1 | 2024-07-01 | 0.22 | 2024-06-19 | 8.99 | 3 | SO69268 | 2024-06-26 | 0.72 | 6.92 | |
SO48536_1 | 100 | 14256 | 387 | 1 | 2023-02-14 | 25.01 | 2023-02-02 | 1000.44 | 1 | SO48536 | 2023-02-09 | 80.04 | 605.65 | |
SO69269_1 | 100 | 20113 | 476 | 1 | 2024-07-01 | 1.75 | 2024-06-19 | 69.99 | 1 | SO69269 | 2024-06-26 | 5.60 | 26.18 | |
SO48552_1 | 100 | 14242 | 381 | 1 | 2023-02-15 | 25.01 | 2023-02-03 | 1000.44 | 1 | SO48552 | 2023-02-10 | 80.04 | 605.65 | |
SO69275_1 | 100 | 17675 | 528 | 1 | 2024-07-01 | 0.12 | 2024-06-19 | 4.99 | 1 | SO69275 | 2024-06-26 | 0.40 | 1.87 | |
SO48554_1 | 100 | 26622 | 362 | 2 | 1 | 2023-02-15 | 51.23 | 2023-02-03 | 2049.10 | 1 | SO48554 | 2023-02-10 | 163.93 | 1105.81 |
SO69275_2 | 100 | 17675 | 483 | 1 | 2024-07-01 | 3.00 | 2024-06-19 | 120.00 | 2 | SO69275 | 2024-06-26 | 9.60 | 44.88 | |
SO48573_1 | 100 | 15419 | 329 | 1 | 2023-02-17 | 19.57 | 2023-02-05 | 782.99 | 1 | SO48573 | 2023-02-12 | 62.64 | 486.71 | |
SO69288_1 | 100 | 13063 | 363 | 1 | 2024-07-01 | 57.37 | 2024-06-19 | 2294.99 | 1 | SO69288 | 2024-06-26 | 183.60 | 1251.98 | |
SO48574_1 | 100 | 15422 | 321 | 1 | 2023-02-17 | 19.57 | 2023-02-05 | 782.99 | 1 | SO48574 | 2023-02-12 | 62.64 | 486.71 | |
SO69288_2 | 100 | 13063 | 214 | 1 | 2024-07-01 | 0.87 | 2024-06-19 | 34.99 | 2 | SO69288 | 2024-06-26 | 2.80 | 13.09 | |
SO48581_1 | 100 | 26632 | 352 | 1 | 2023-02-18 | 51.79 | 2023-02-06 | 2071.42 | 1 | SO48581 | 2023-02-13 | 165.71 | 1117.86 | |
SO69292_1 | 100 | 15252 | 590 | 1 | 2024-07-01 | 19.24 | 2024-06-19 | 769.49 | 1 | SO69292 | 2024-06-26 | 61.56 | 419.78 | |
SO48594_1 | 100 | 26614 | 362 | 2 | 1 | 2023-02-19 | 51.23 | 2023-02-07 | 2049.10 | 1 | SO48594 | 2023-02-14 | 163.93 | 1105.81 |
SO69329_1 | 100 | 26464 | 535 | 1 | 2024-07-02 | 0.62 | 2024-06-20 | 24.99 | 1 | SO69329 | 2024-06-27 | 2.00 | 9.35 | |
SO48604_1 | 100 | 26609 | 354 | 1 | 2023-02-20 | 51.79 | 2023-02-08 | 2071.42 | 1 | SO48604 | 2023-02-15 | 165.71 | 1117.86 | |
SO69329_2 | 100 | 26464 | 222 | 1 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 2 | SO69329 | 2024-06-27 | 2.80 | 13.09 | |
SO48605_1 | 100 | 26616 | 358 | 1 | 2023-02-20 | 51.23 | 2023-02-08 | 2049.10 | 1 | SO48605 | 2023-02-15 | 163.93 | 1105.81 | |
SO69331_1 | 100 | 23053 | 536 | 1 | 2024-07-02 | 0.75 | 2024-06-20 | 29.99 | 1 | SO69331 | 2024-06-27 | 2.40 | 11.22 | |
SO48608_1 | 100 | 26644 | 358 | 1 | 2023-02-20 | 51.23 | 2023-02-08 | 2049.10 | 1 | SO48608 | 2023-02-15 | 163.93 | 1105.81 | |
SO69331_2 | 100 | 23053 | 528 | 1 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 2 | SO69331 | 2024-06-27 | 0.40 | 1.87 | |
SO48616_1 | 100 | 13721 | 373 | 1 | 2023-02-21 | 54.54 | 2023-02-09 | 2181.56 | 1 | SO48616 | 2023-02-16 | 174.53 | 1320.68 |
Generated 2024-09-20 13:21:05.565 UTC