[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 1718 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO64226_1 | 6 | 25240 | 390 | 9 | 2024-06-08 | 28.01 | 2024-05-27 | 1120.49 | 1 | SO64226 | 2024-06-03 | 89.64 | 713.08 | |
SO64227_1 | 6 | 21183 | 372 | 9 | 2024-06-08 | 61.08 | 2024-05-27 | 2443.35 | 1 | SO64227 | 2024-06-03 | 195.47 | 1554.95 | |
SO64227_2 | 6 | 21183 | 540 | 9 | 2024-06-08 | 0.82 | 2024-05-27 | 32.60 | 2 | SO64227 | 2024-06-03 | 2.61 | 12.19 | |
SO64228_1 | 6 | 14045 | 363 | 2 | 9 | 2024-06-08 | 57.37 | 2024-05-27 | 2294.99 | 1 | SO64228 | 2024-06-03 | 183.60 | 1251.98 |
SO64228_2 | 6 | 14045 | 485 | 9 | 2024-06-08 | 0.55 | 2024-05-27 | 21.98 | 2 | SO64228 | 2024-06-03 | 1.76 | 8.22 | |
SO64228_3 | 6 | 14045 | 489 | 9 | 2024-06-08 | 1.35 | 2024-05-27 | 53.99 | 3 | SO64228 | 2024-06-03 | 4.32 | 41.57 | |
SO64229_1 | 6 | 11997 | 359 | 9 | 2024-06-08 | 57.37 | 2024-05-27 | 2294.99 | 1 | SO64229 | 2024-06-03 | 183.60 | 1251.98 | |
SO64229_2 | 6 | 11997 | 485 | 9 | 2024-06-08 | 0.55 | 2024-05-27 | 21.98 | 2 | SO64229 | 2024-06-03 | 1.76 | 8.22 | |
SO64229_3 | 6 | 11997 | 491 | 9 | 2024-06-08 | 1.35 | 2024-05-27 | 53.99 | 3 | SO64229 | 2024-06-03 | 4.32 | 41.57 | |
SO64229_4 | 6 | 11997 | 225 | 9 | 2024-06-08 | 0.22 | 2024-05-27 | 8.99 | 4 | SO64229 | 2024-06-03 | 0.72 | 6.92 | |
SO64243_1 | 6 | 29087 | 568 | 9 | 2024-06-08 | 18.56 | 2024-05-27 | 742.35 | 1 | SO64243 | 2024-06-03 | 59.39 | 461.44 | |
SO64243_2 | 6 | 29087 | 479 | 9 | 2024-06-08 | 0.22 | 2024-05-27 | 8.99 | 2 | SO64243 | 2024-06-03 | 0.72 | 3.36 | |
SO64243_3 | 6 | 29087 | 477 | 9 | 2024-06-08 | 0.12 | 2024-05-27 | 4.99 | 3 | SO64243 | 2024-06-03 | 0.40 | 1.87 | |
SO64243_4 | 6 | 29087 | 489 | 9 | 2024-06-08 | 1.35 | 2024-05-27 | 53.99 | 4 | SO64243 | 2024-06-03 | 4.32 | 41.57 | |
SO64244_1 | 6 | 12001 | 562 | 9 | 2024-06-08 | 59.60 | 2024-05-27 | 2384.07 | 1 | SO64244 | 2024-06-03 | 190.73 | 1481.94 | |
SO64244_2 | 6 | 12001 | 217 | 9 | 2024-06-08 | 0.87 | 2024-05-27 | 34.99 | 2 | SO64244 | 2024-06-03 | 2.80 | 13.09 | |
SO64245_1 | 6 | 13005 | 535 | 9 | 2024-06-09 | 0.62 | 2024-05-28 | 24.99 | 1 | SO64245 | 2024-06-04 | 2.00 | 9.35 | |
SO64245_2 | 6 | 13005 | 528 | 9 | 2024-06-09 | 0.12 | 2024-05-28 | 4.99 | 2 | SO64245 | 2024-06-04 | 0.40 | 1.87 | |
SO64245_3 | 6 | 13005 | 214 | 9 | 2024-06-09 | 0.87 | 2024-05-28 | 34.99 | 3 | SO64245 | 2024-06-04 | 2.80 | 13.09 | |
SO64246_1 | 6 | 11366 | 535 | 9 | 2024-06-09 | 0.62 | 2024-05-28 | 24.99 | 1 | SO64246 | 2024-06-04 | 2.00 | 9.35 | |
SO64246_2 | 6 | 11366 | 480 | 9 | 2024-06-09 | 0.06 | 2024-05-28 | 2.29 | 2 | SO64246 | 2024-06-04 | 0.18 | 0.86 | |
SO64247_1 | 6 | 25245 | 529 | 9 | 2024-06-09 | 0.10 | 2024-05-28 | 3.99 | 1 | SO64247 | 2024-06-04 | 0.32 | 1.49 | |
SO64247_2 | 6 | 25245 | 487 | 9 | 2024-06-09 | 1.37 | 2024-05-28 | 54.99 | 2 | SO64247 | 2024-06-04 | 4.40 | 20.57 | |
SO64282_1 | 6 | 25822 | 386 | 9 | 2024-06-09 | 28.01 | 2024-05-28 | 1120.49 | 1 | SO64282 | 2024-06-04 | 89.64 | 713.08 | |
SO64283_1 | 6 | 21201 | 380 | 9 | 2024-06-09 | 61.08 | 2024-05-28 | 2443.35 | 1 | SO64283 | 2024-06-04 | 195.47 | 1554.95 | |
SO64283_2 | 6 | 21201 | 214 | 9 | 2024-06-09 | 0.87 | 2024-05-28 | 34.99 | 2 | SO64283 | 2024-06-04 | 2.80 | 13.09 | |
SO64284_1 | 6 | 20626 | 374 | 9 | 2024-06-09 | 61.08 | 2024-05-28 | 2443.35 | 1 | SO64284 | 2024-06-04 | 195.47 | 1554.95 | |
SO64284_2 | 6 | 20626 | 479 | 9 | 2024-06-09 | 0.22 | 2024-05-28 | 8.99 | 2 | SO64284 | 2024-06-04 | 0.72 | 3.36 | |
SO64284_3 | 6 | 20626 | 484 | 9 | 2024-06-09 | 0.20 | 2024-05-28 | 7.95 | 3 | SO64284 | 2024-06-04 | 0.64 | 2.97 | |
SO64294_1 | 6 | 11977 | 573 | 9 | 2024-06-09 | 59.60 | 2024-05-28 | 2384.07 | 1 | SO64294 | 2024-06-04 | 190.73 | 1481.94 | |
SO64294_2 | 6 | 11977 | 477 | 9 | 2024-06-09 | 0.12 | 2024-05-28 | 4.99 | 2 | SO64294 | 2024-06-04 | 0.40 | 1.87 | |
SO64294_3 | 6 | 11977 | 471 | 9 | 2024-06-09 | 1.59 | 2024-05-28 | 63.50 | 3 | SO64294 | 2024-06-04 | 5.08 | 23.75 | |
SO64294_4 | 6 | 11977 | 479 | 9 | 2024-06-09 | 0.22 | 2024-05-28 | 8.99 | 4 | SO64294 | 2024-06-04 | 0.72 | 3.36 | |
SO64295_1 | 6 | 14055 | 566 | 9 | 2024-06-09 | 18.56 | 2024-05-28 | 742.35 | 1 | SO64295 | 2024-06-04 | 59.39 | 461.44 | |
SO64295_2 | 6 | 14055 | 225 | 9 | 2024-06-09 | 0.22 | 2024-05-28 | 8.99 | 2 | SO64295 | 2024-06-04 | 0.72 | 6.92 | |
SO64296_1 | 6 | 12000 | 562 | 9 | 2024-06-09 | 59.60 | 2024-05-28 | 2384.07 | 1 | SO64296 | 2024-06-04 | 190.73 | 1481.94 | |
SO64296_2 | 6 | 12000 | 541 | 9 | 2024-06-09 | 0.72 | 2024-05-28 | 28.99 | 2 | SO64296 | 2024-06-04 | 2.32 | 10.84 | |
SO64296_3 | 6 | 12000 | 530 | 9 | 2024-06-09 | 0.12 | 2024-05-28 | 4.99 | 3 | SO64296 | 2024-06-04 | 0.40 | 1.87 | |
SO64296_4 | 6 | 12000 | 487 | 9 | 2024-06-09 | 1.37 | 2024-05-28 | 54.99 | 4 | SO64296 | 2024-06-04 | 4.40 | 20.57 | |
SO64297_1 | 6 | 17502 | 374 | 9 | 2024-06-10 | 61.08 | 2024-05-29 | 2443.35 | 1 | SO64297 | 2024-06-05 | 195.47 | 1554.95 | |
SO64297_2 | 6 | 17502 | 479 | 9 | 2024-06-10 | 0.22 | 2024-05-29 | 8.99 | 2 | SO64297 | 2024-06-05 | 0.72 | 3.36 | |
SO64297_3 | 6 | 17502 | 477 | 9 | 2024-06-10 | 0.12 | 2024-05-29 | 4.99 | 3 | SO64297 | 2024-06-05 | 0.40 | 1.87 | |
SO64297_4 | 6 | 17502 | 217 | 9 | 2024-06-10 | 0.87 | 2024-05-29 | 34.99 | 4 | SO64297 | 2024-06-05 | 2.80 | 13.09 | |
SO64298_1 | 6 | 14067 | 528 | 9 | 2024-06-10 | 0.12 | 2024-05-29 | 4.99 | 1 | SO64298 | 2024-06-05 | 0.40 | 1.87 | |
SO64298_2 | 6 | 14067 | 535 | 9 | 2024-06-10 | 0.62 | 2024-05-29 | 24.99 | 2 | SO64298 | 2024-06-05 | 2.00 | 9.35 | |
SO64298_3 | 6 | 14067 | 217 | 9 | 2024-06-10 | 0.87 | 2024-05-29 | 34.99 | 3 | SO64298 | 2024-06-05 | 2.80 | 13.09 | |
SO64299_1 | 6 | 19610 | 529 | 9 | 2024-06-10 | 0.10 | 2024-05-29 | 3.99 | 1 | SO64299 | 2024-06-05 | 0.32 | 1.49 | |
SO64299_2 | 6 | 19610 | 538 | 9 | 2024-06-10 | 0.54 | 2024-05-29 | 21.49 | 2 | SO64299 | 2024-06-05 | 1.72 | 8.04 | |
SO64299_3 | 6 | 19610 | 463 | 9 | 2024-06-10 | 0.61 | 2024-05-29 | 24.49 | 3 | SO64299 | 2024-06-05 | 1.96 | 9.16 | |
SO64300_1 | 6 | 23521 | 485 | 9 | 2024-06-10 | 0.55 | 2024-05-29 | 21.98 | 1 | SO64300 | 2024-06-05 | 1.76 | 8.22 | |
SO64301_1 | 6 | 16729 | 485 | 9 | 2024-06-10 | 0.55 | 2024-05-29 | 21.98 | 1 | SO64301 | 2024-06-05 | 1.76 | 8.22 | |
SO64301_2 | 6 | 16729 | 484 | 9 | 2024-06-10 | 0.20 | 2024-05-29 | 7.95 | 2 | SO64301 | 2024-06-05 | 0.64 | 2.97 | |
SO64302_1 | 6 | 15603 | 478 | 9 | 2024-06-10 | 0.25 | 2024-05-29 | 9.99 | 1 | SO64302 | 2024-06-05 | 0.80 | 3.74 | |
SO64302_2 | 6 | 15603 | 477 | 9 | 2024-06-10 | 0.12 | 2024-05-29 | 4.99 | 2 | SO64302 | 2024-06-05 | 0.40 | 1.87 | |
SO64303_1 | 6 | 16606 | 540 | 9 | 2024-06-10 | 0.82 | 2024-05-29 | 32.60 | 1 | SO64303 | 2024-06-05 | 2.61 | 12.19 | |
SO64303_2 | 6 | 16606 | 480 | 9 | 2024-06-10 | 0.06 | 2024-05-29 | 2.29 | 2 | SO64303 | 2024-06-05 | 0.18 | 0.86 | |
SO64304_1 | 6 | 16167 | 540 | 9 | 2024-06-10 | 0.82 | 2024-05-29 | 32.60 | 1 | SO64304 | 2024-06-05 | 2.61 | 12.19 | |
SO64305_1 | 6 | 16692 | 529 | 9 | 2024-06-10 | 0.10 | 2024-05-29 | 3.99 | 1 | SO64305 | 2024-06-05 | 0.32 | 1.49 | |
SO64305_2 | 6 | 16692 | 480 | 9 | 2024-06-10 | 0.06 | 2024-05-29 | 2.29 | 2 | SO64305 | 2024-06-05 | 0.18 | 0.86 | |
SO64358_1 | 6 | 23545 | 582 | 9 | 2024-06-10 | 42.52 | 2024-05-29 | 1700.99 | 1 | SO64358 | 2024-06-05 | 136.08 | 1082.51 |
Generated 2024-11-11 00:24:28.525 UTC