[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > SKIP 187 < SKIP 1939 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO61034_6 | 98 | 14427 | 234 | 10 | 2024-04-24 | 1.25 | 2024-04-12 | 49.99 | 6 | SO61034 | 2024-04-19 | 4.00 | 38.49 | |
SO61038_1 | 98 | 12745 | 357 | 10 | 2024-04-24 | 58.00 | 2024-04-12 | 2319.99 | 1 | SO61038 | 2024-04-19 | 185.60 | 1265.62 | |
SO61038_2 | 98 | 12745 | 485 | 10 | 2024-04-24 | 0.55 | 2024-04-12 | 21.98 | 2 | SO61038 | 2024-04-19 | 1.76 | 8.22 | |
SO61038_3 | 98 | 12745 | 217 | 10 | 2024-04-24 | 0.87 | 2024-04-12 | 34.99 | 3 | SO61038 | 2024-04-19 | 2.80 | 13.09 | |
SO61043_1 | 98 | 18627 | 597 | 10 | 2024-04-24 | 13.50 | 2024-04-12 | 539.99 | 1 | SO61043 | 2024-04-19 | 43.20 | 294.58 | |
SO61043_2 | 98 | 18627 | 225 | 10 | 2024-04-24 | 0.22 | 2024-04-12 | 8.99 | 2 | SO61043 | 2024-04-19 | 0.72 | 6.92 | |
SO61043_3 | 98 | 18627 | 222 | 10 | 2024-04-24 | 0.87 | 2024-04-12 | 34.99 | 3 | SO61043 | 2024-04-19 | 2.80 | 13.09 | |
SO61044_1 | 98 | 20717 | 378 | 10 | 2024-04-24 | 61.08 | 2024-04-12 | 2443.35 | 1 | SO61044 | 2024-04-19 | 195.47 | 1554.95 | |
SO61044_2 | 98 | 20717 | 479 | 10 | 2024-04-24 | 0.22 | 2024-04-12 | 8.99 | 2 | SO61044 | 2024-04-19 | 0.72 | 3.36 | |
SO61044_3 | 98 | 20717 | 477 | 10 | 2024-04-24 | 0.12 | 2024-04-12 | 4.99 | 3 | SO61044 | 2024-04-19 | 0.40 | 1.87 | |
SO61061_1 | 98 | 15612 | 528 | 10 | 2024-04-24 | 0.12 | 2024-04-12 | 4.99 | 1 | SO61061 | 2024-04-19 | 0.40 | 1.87 | |
SO61061_2 | 98 | 15612 | 537 | 10 | 2024-04-24 | 0.88 | 2024-04-12 | 35.00 | 2 | SO61061 | 2024-04-19 | 2.80 | 13.09 | |
SO61061_3 | 98 | 15612 | 222 | 10 | 2024-04-24 | 0.87 | 2024-04-12 | 34.99 | 3 | SO61061 | 2024-04-19 | 2.80 | 13.09 | |
SO61062_1 | 98 | 12739 | 537 | 10 | 2024-04-24 | 0.88 | 2024-04-12 | 35.00 | 1 | SO61062 | 2024-04-19 | 2.80 | 13.09 | |
SO61064_1 | 98 | 21864 | 529 | 10 | 2024-04-24 | 0.10 | 2024-04-12 | 3.99 | 1 | SO61064 | 2024-04-19 | 0.32 | 1.49 | |
SO61064_2 | 98 | 21864 | 539 | 10 | 2024-04-24 | 0.62 | 2024-04-12 | 24.99 | 2 | SO61064 | 2024-04-19 | 2.00 | 9.35 | |
SO61065_1 | 98 | 19498 | 539 | 10 | 2024-04-24 | 0.62 | 2024-04-12 | 24.99 | 1 | SO61065 | 2024-04-19 | 2.00 | 9.35 | |
SO61065_2 | 98 | 19498 | 529 | 10 | 2024-04-24 | 0.10 | 2024-04-12 | 3.99 | 2 | SO61065 | 2024-04-19 | 0.32 | 1.49 | |
SO61065_3 | 98 | 19498 | 480 | 10 | 2024-04-24 | 0.06 | 2024-04-12 | 2.29 | 3 | SO61065 | 2024-04-19 | 0.18 | 0.86 | |
SO61066_1 | 98 | 27842 | 538 | 10 | 2024-04-24 | 0.54 | 2024-04-12 | 21.49 | 1 | SO61066 | 2024-04-19 | 1.72 | 8.04 | |
SO61066_2 | 98 | 27842 | 480 | 10 | 2024-04-24 | 0.06 | 2024-04-12 | 2.29 | 2 | SO61066 | 2024-04-19 | 0.18 | 0.86 | |
SO61078_1 | 98 | 11250 | 586 | 10 | 2024-04-24 | 18.56 | 2024-04-12 | 742.35 | 1 | SO61078 | 2024-04-19 | 59.39 | 461.44 | |
SO61078_2 | 98 | 11250 | 214 | 10 | 2024-04-24 | 0.87 | 2024-04-12 | 34.99 | 2 | SO61078 | 2024-04-19 | 2.80 | 13.09 | |
SO61078_3 | 98 | 11250 | 225 | 10 | 2024-04-24 | 0.22 | 2024-04-12 | 8.99 | 3 | SO61078 | 2024-04-19 | 0.72 | 6.92 | |
SO61096_1 | 98 | 12486 | 361 | 10 | 2024-04-25 | 57.37 | 2024-04-13 | 2294.99 | 1 | SO61096 | 2024-04-20 | 183.60 | 1251.98 | |
SO61096_2 | 98 | 12486 | 478 | 10 | 2024-04-25 | 0.25 | 2024-04-13 | 9.99 | 2 | SO61096 | 2024-04-20 | 0.80 | 3.74 | |
SO61096_3 | 98 | 12486 | 477 | 10 | 2024-04-25 | 0.12 | 2024-04-13 | 4.99 | 3 | SO61096 | 2024-04-20 | 0.40 | 1.87 | |
SO61111_1 | 98 | 17841 | 591 | 10 | 2024-04-25 | 14.12 | 2024-04-13 | 564.99 | 1 | SO61111 | 2024-04-20 | 45.20 | 308.22 | |
SO61111_2 | 98 | 17841 | 485 | 10 | 2024-04-25 | 0.55 | 2024-04-13 | 21.98 | 2 | SO61111 | 2024-04-20 | 1.76 | 8.22 | |
SO61111_3 | 98 | 17841 | 214 | 10 | 2024-04-25 | 0.87 | 2024-04-13 | 34.99 | 3 | SO61111 | 2024-04-20 | 2.80 | 13.09 | |
SO61114_1 | 98 | 12857 | 361 | 10 | 2024-04-25 | 57.37 | 2024-04-13 | 2294.99 | 1 | SO61114 | 2024-04-20 | 183.60 | 1251.98 | |
SO61114_2 | 98 | 12857 | 537 | 10 | 2024-04-25 | 0.88 | 2024-04-13 | 35.00 | 2 | SO61114 | 2024-04-20 | 2.80 | 13.09 | |
SO61114_3 | 98 | 12857 | 528 | 10 | 2024-04-25 | 0.12 | 2024-04-13 | 4.99 | 3 | SO61114 | 2024-04-20 | 0.40 | 1.87 | |
SO61133_1 | 98 | 16932 | 528 | 10 | 2024-04-25 | 0.12 | 2024-04-13 | 4.99 | 1 | SO61133 | 2024-04-20 | 0.40 | 1.87 | |
SO61133_2 | 98 | 16932 | 480 | 2 | 10 | 2024-04-25 | 0.06 | 2024-04-13 | 2.29 | 2 | SO61133 | 2024-04-20 | 0.18 | 0.86 |
SO61139_1 | 98 | 16282 | 485 | 10 | 2024-04-25 | 0.55 | 2024-04-13 | 21.98 | 1 | SO61139 | 2024-04-20 | 1.76 | 8.22 | |
SO61139_2 | 98 | 16282 | 480 | 10 | 2024-04-25 | 0.06 | 2024-04-13 | 2.29 | 2 | SO61139 | 2024-04-20 | 0.18 | 0.86 | |
SO61142_1 | 98 | 24857 | 477 | 10 | 2024-04-25 | 0.12 | 2024-04-13 | 4.99 | 1 | SO61142 | 2024-04-20 | 0.40 | 1.87 | |
SO61143_1 | 98 | 13688 | 535 | 10 | 2024-04-25 | 0.62 | 2024-04-13 | 24.99 | 1 | SO61143 | 2024-04-20 | 2.00 | 9.35 | |
SO61143_2 | 98 | 13688 | 480 | 10 | 2024-04-25 | 0.06 | 2024-04-13 | 2.29 | 2 | SO61143 | 2024-04-20 | 0.18 | 0.86 | |
SO61169_1 | 98 | 26937 | 606 | 10 | 2024-04-25 | 13.50 | 2024-04-13 | 539.99 | 1 | SO61169 | 2024-04-20 | 43.20 | 343.65 | |
SO61169_2 | 98 | 26937 | 538 | 10 | 2024-04-25 | 0.54 | 2024-04-13 | 21.49 | 2 | SO61169 | 2024-04-20 | 1.72 | 8.04 | |
SO61169_3 | 98 | 26937 | 529 | 10 | 2024-04-25 | 0.10 | 2024-04-13 | 3.99 | 3 | SO61169 | 2024-04-20 | 0.32 | 1.49 | |
SO61169_4 | 98 | 26937 | 491 | 10 | 2024-04-25 | 1.35 | 2024-04-13 | 53.99 | 4 | SO61169 | 2024-04-20 | 4.32 | 41.57 | |
SO61170_1 | 98 | 26913 | 584 | 10 | 2024-04-25 | 13.50 | 2024-04-13 | 539.99 | 1 | SO61170 | 2024-04-20 | 43.20 | 343.65 | |
SO61170_2 | 98 | 26913 | 479 | 10 | 2024-04-25 | 0.22 | 2024-04-13 | 8.99 | 2 | SO61170 | 2024-04-20 | 0.72 | 3.36 | |
SO61170_3 | 98 | 26913 | 477 | 10 | 2024-04-25 | 0.12 | 2024-04-13 | 4.99 | 3 | SO61170 | 2024-04-20 | 0.40 | 1.87 | |
SO61170_4 | 98 | 26913 | 488 | 10 | 2024-04-25 | 1.35 | 2024-04-13 | 53.99 | 4 | SO61170 | 2024-04-20 | 4.32 | 41.57 | |
SO61172_1 | 98 | 28446 | 561 | 10 | 2024-04-25 | 59.60 | 2024-04-13 | 2384.07 | 1 | SO61172 | 2024-04-20 | 190.73 | 1481.94 | |
SO61172_2 | 98 | 28446 | 479 | 10 | 2024-04-25 | 0.22 | 2024-04-13 | 8.99 | 2 | SO61172 | 2024-04-20 | 0.72 | 3.36 | |
SO47622_1 | 98 | 20837 | 339 | 10 | 2023-01-19 | 19.57 | 2023-01-07 | 782.99 | 1 | SO47622 | 2023-01-14 | 62.64 | 486.71 | |
SO47627_1 | 98 | 16444 | 370 | 10 | 2023-01-20 | 61.08 | 2023-01-08 | 2443.35 | 1 | SO47627 | 2023-01-15 | 195.47 | 1518.79 | |
SO47628_1 | 98 | 16509 | 369 | 2 | 10 | 2023-01-20 | 61.08 | 2023-01-08 | 2443.35 | 1 | SO47628 | 2023-01-15 | 195.47 | 1518.79 |
SO47635_1 | 98 | 12216 | 354 | 10 | 2023-01-20 | 51.79 | 2023-01-08 | 2071.42 | 1 | SO47635 | 2023-01-15 | 165.71 | 1117.86 | |
SO47643_1 | 98 | 19290 | 389 | 10 | 2023-01-23 | 25.01 | 2023-01-11 | 1000.44 | 1 | SO47643 | 2023-01-18 | 80.04 | 605.65 | |
SO47648_1 | 98 | 12263 | 356 | 10 | 2023-01-23 | 51.79 | 2023-01-11 | 2071.42 | 1 | SO47648 | 2023-01-18 | 165.71 | 1117.86 | |
SO47649_1 | 98 | 16447 | 377 | 10 | 2023-01-24 | 54.54 | 2023-01-12 | 2181.56 | 1 | SO47649 | 2023-01-19 | 174.53 | 1320.68 | |
SO47650_1 | 98 | 16512 | 370 | 10 | 2023-01-24 | 61.08 | 2023-01-12 | 2443.35 | 1 | SO47650 | 2023-01-19 | 195.47 | 1518.79 | |
SO47652_1 | 98 | 20825 | 333 | 10 | 2023-01-24 | 19.57 | 2023-01-12 | 782.99 | 1 | SO47652 | 2023-01-19 | 62.64 | 486.71 | |
SO47731_1 | 98 | 12283 | 362 | 2 | 10 | 2023-01-25 | 51.23 | 2023-01-13 | 2049.10 | 1 | SO47731 | 2023-01-20 | 163.93 | 1105.81 |
SO47739_1 | 98 | 20839 | 329 | 10 | 2023-01-26 | 19.57 | 2023-01-14 | 782.99 | 1 | SO47739 | 2023-01-21 | 62.64 | 486.71 | |
SO47756_1 | 98 | 12272 | 354 | 10 | 2023-01-28 | 51.79 | 2023-01-16 | 2071.42 | 1 | SO47756 | 2023-01-23 | 165.71 | 1117.86 |
Generated 2024-11-13 02:40:11.218 UTC