[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 1542 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56384_2 | 6 | 23424 | 465 | 9 | 2023-12-22 | 0.61 | 2023-12-10 | 24.49 | 2 | SO56384 | 2023-12-17 | 1.96 | 9.16 | |
SO69300_2 | 6 | 21570 | 540 | 9 | 2024-07-01 | 0.82 | 2024-06-19 | 32.60 | 2 | SO69300 | 2024-06-26 | 2.61 | 12.19 | |
SO45178_1 | 6 | 11456 | 347 | 9 | 2022-03-21 | 85.00 | 2022-03-09 | 3399.99 | 1 | SO45178 | 2022-03-16 | 272.00 | 1912.15 | |
SO56385_1 | 6 | 14860 | 530 | 9 | 2023-12-22 | 0.12 | 2023-12-10 | 4.99 | 1 | SO56385 | 2023-12-17 | 0.40 | 1.87 | |
SO69300_3 | 6 | 21570 | 529 | 9 | 2024-07-01 | 0.10 | 2024-06-19 | 3.99 | 3 | SO69300 | 2024-06-26 | 0.32 | 1.49 | |
SO45179_1 | 6 | 11457 | 351 | 9 | 2022-03-21 | 84.37 | 2022-03-09 | 3374.99 | 1 | SO45179 | 2022-03-16 | 270.00 | 1898.09 | |
SO56385_2 | 6 | 14860 | 214 | 9 | 2023-12-22 | 0.87 | 2023-12-10 | 34.99 | 2 | SO56385 | 2023-12-17 | 2.80 | 13.09 | |
SO69300_4 | 6 | 21570 | 214 | 9 | 2024-07-01 | 0.87 | 2024-06-19 | 34.99 | 4 | SO69300 | 2024-06-26 | 2.80 | 13.09 | |
SO45182_1 | 6 | 18769 | 312 | 9 | 2022-03-22 | 89.46 | 2022-03-10 | 3578.27 | 1 | SO45182 | 2022-03-17 | 286.26 | 2171.29 | |
SO56386_1 | 6 | 13617 | 487 | 9 | 2023-12-22 | 1.37 | 2023-12-10 | 54.99 | 1 | SO56386 | 2023-12-17 | 4.40 | 20.57 | |
SO69300_5 | 6 | 21570 | 482 | 9 | 2024-07-01 | 0.22 | 2024-06-19 | 8.99 | 5 | SO69300 | 2024-06-26 | 0.72 | 3.36 | |
SO45183_1 | 6 | 25711 | 334 | 9 | 2022-03-22 | 17.48 | 2022-03-10 | 699.10 | 1 | SO45183 | 2022-03-17 | 55.93 | 413.15 | |
SO56386_2 | 6 | 13617 | 484 | 9 | 2023-12-22 | 0.20 | 2023-12-10 | 7.95 | 2 | SO56386 | 2023-12-17 | 0.64 | 2.97 | |
SO69311_1 | 6 | 15126 | 539 | 9 | 2024-07-02 | 0.62 | 2024-06-20 | 24.99 | 1 | SO69311 | 2024-06-27 | 2.00 | 9.35 | |
SO45184_1 | 6 | 25717 | 320 | 9 | 2022-03-22 | 17.48 | 2022-03-10 | 699.10 | 1 | SO45184 | 2022-03-17 | 55.93 | 413.15 | |
SO56387_1 | 6 | 16635 | 540 | 9 | 2023-12-22 | 0.82 | 2023-12-10 | 32.60 | 1 | SO56387 | 2023-12-17 | 2.61 | 12.19 | |
SO69311_2 | 6 | 15126 | 480 | 9 | 2024-07-02 | 0.06 | 2024-06-20 | 2.29 | 2 | SO69311 | 2024-06-27 | 0.18 | 0.86 | |
SO45190_1 | 6 | 18931 | 313 | 9 | 2022-03-23 | 89.46 | 2022-03-11 | 3578.27 | 1 | SO45190 | 2022-03-18 | 286.26 | 2171.29 | |
SO56387_2 | 6 | 16635 | 529 | 9 | 2023-12-22 | 0.10 | 2023-12-10 | 3.99 | 2 | SO56387 | 2023-12-17 | 0.32 | 1.49 | |
SO69312_1 | 6 | 17501 | 485 | 9 | 2024-07-02 | 0.55 | 2024-06-20 | 21.98 | 1 | SO69312 | 2024-06-27 | 1.76 | 8.22 | |
SO45195_1 | 6 | 18929 | 313 | 9 | 2022-03-24 | 89.46 | 2022-03-12 | 3578.27 | 1 | SO45195 | 2022-03-19 | 286.26 | 2171.29 | |
SO56387_3 | 6 | 16635 | 480 | 9 | 2023-12-22 | 0.06 | 2023-12-10 | 2.29 | 3 | SO56387 | 2023-12-17 | 0.18 | 0.86 | |
SO69313_1 | 6 | 24369 | 477 | 9 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO69313 | 2024-06-27 | 0.40 | 1.87 | |
SO45196_1 | 6 | 18739 | 311 | 9 | 2022-03-24 | 89.46 | 2022-03-12 | 3578.27 | 1 | SO45196 | 2022-03-19 | 286.26 | 2171.29 | |
SO56424_1 | 6 | 22966 | 581 | 9 | 2023-12-22 | 42.52 | 2023-12-10 | 1700.99 | 1 | SO56424 | 2023-12-17 | 136.08 | 1082.51 | |
SO69314_1 | 6 | 20269 | 477 | 9 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO69314 | 2024-06-27 | 0.40 | 1.87 | |
SO45197_1 | 6 | 18902 | 314 | 9 | 2022-03-24 | 89.46 | 2022-03-12 | 3578.27 | 1 | SO45197 | 2022-03-19 | 286.26 | 2171.29 | |
SO56424_2 | 6 | 22966 | 222 | 9 | 2023-12-22 | 0.87 | 2023-12-10 | 34.99 | 2 | SO56424 | 2023-12-17 | 2.80 | 13.09 | |
SO69315_1 | 6 | 15730 | 222 | 9 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 1 | SO69315 | 2024-06-27 | 2.80 | 13.09 | |
SO45202_1 | 6 | 19094 | 314 | 9 | 2022-03-25 | 89.46 | 2022-03-13 | 3578.27 | 1 | SO45202 | 2022-03-20 | 286.26 | 2171.29 | |
SO56425_1 | 6 | 19099 | 378 | 9 | 2023-12-22 | 61.08 | 2023-12-10 | 2443.35 | 1 | SO56425 | 2023-12-17 | 195.47 | 1554.95 | |
SO69316_1 | 6 | 15140 | 217 | 9 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 1 | SO69316 | 2024-06-27 | 2.80 | 13.09 | |
SO45203_1 | 6 | 18907 | 314 | 9 | 2022-03-25 | 89.46 | 2022-03-13 | 3578.27 | 1 | SO45203 | 2022-03-20 | 286.26 | 2171.29 | |
SO56425_2 | 6 | 19099 | 225 | 9 | 2023-12-22 | 0.22 | 2023-12-10 | 8.99 | 2 | SO56425 | 2023-12-17 | 0.72 | 6.92 | |
SO69371_1 | 6 | 15227 | 359 | 9 | 2024-07-02 | 57.37 | 2024-06-20 | 2294.99 | 1 | SO69371 | 2024-06-27 | 183.60 | 1251.98 | |
SO45204_1 | 6 | 11460 | 345 | 9 | 2022-03-25 | 85.00 | 2022-03-13 | 3399.99 | 1 | SO45204 | 2022-03-20 | 272.00 | 1912.15 | |
SO56425_3 | 6 | 19099 | 484 | 9 | 2023-12-22 | 0.20 | 2023-12-10 | 7.95 | 3 | SO56425 | 2023-12-17 | 0.64 | 2.97 | |
SO69371_2 | 6 | 15227 | 528 | 9 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 2 | SO69371 | 2024-06-27 | 0.40 | 1.87 | |
SO45211_1 | 6 | 18724 | 311 | 9 | 2022-03-26 | 89.46 | 2022-03-14 | 3578.27 | 1 | SO45211 | 2022-03-21 | 286.26 | 2171.29 | |
SO56429_1 | 6 | 28113 | 586 | 9 | 2023-12-22 | 18.56 | 2023-12-10 | 742.35 | 1 | SO56429 | 2023-12-17 | 59.39 | 461.44 | |
SO69371_3 | 6 | 15227 | 537 | 9 | 2024-07-02 | 0.88 | 2024-06-20 | 35.00 | 3 | SO69371 | 2024-06-27 | 2.80 | 13.09 | |
SO45212_1 | 6 | 18729 | 314 | 9 | 2022-03-26 | 89.46 | 2022-03-14 | 3578.27 | 1 | SO45212 | 2022-03-21 | 286.26 | 2171.29 | |
SO56429_2 | 6 | 28113 | 486 | 9 | 2023-12-22 | 3.98 | 2023-12-10 | 159.00 | 2 | SO56429 | 2023-12-17 | 12.72 | 59.47 | |
SO69371_4 | 6 | 15227 | 485 | 9 | 2024-07-02 | 0.55 | 2024-06-20 | 21.98 | 4 | SO69371 | 2024-06-27 | 1.76 | 8.22 | |
SO45213_1 | 6 | 11464 | 349 | 9 | 2022-03-26 | 84.37 | 2022-03-14 | 3374.99 | 1 | SO45213 | 2022-03-21 | 270.00 | 1898.09 | |
SO56430_1 | 6 | 23540 | 386 | 9 | 2023-12-23 | 28.01 | 2023-12-11 | 1120.49 | 1 | SO56430 | 2023-12-18 | 89.64 | 713.08 | |
SO69371_5 | 6 | 15227 | 471 | 9 | 2024-07-02 | 1.59 | 2024-06-20 | 63.50 | 5 | SO69371 | 2024-06-27 | 5.08 | 23.75 | |
SO45223_1 | 6 | 18930 | 312 | 9 | 2022-03-28 | 89.46 | 2022-03-16 | 3578.27 | 1 | SO45223 | 2022-03-23 | 286.26 | 2171.29 | |
SO56430_2 | 6 | 23540 | 488 | 9 | 2023-12-23 | 1.35 | 2023-12-11 | 53.99 | 2 | SO56430 | 2023-12-18 | 4.32 | 41.57 | |
SO69372_1 | 6 | 26027 | 388 | 9 | 2024-07-02 | 28.01 | 2024-06-20 | 1120.49 | 1 | SO69372 | 2024-06-27 | 89.64 | 713.08 | |
SO45224_1 | 6 | 18723 | 311 | 9 | 2022-03-28 | 89.46 | 2022-03-16 | 3578.27 | 1 | SO45224 | 2022-03-23 | 286.26 | 2171.29 | |
SO56430_3 | 6 | 23540 | 225 | 9 | 2023-12-23 | 0.22 | 2023-12-11 | 8.99 | 3 | SO56430 | 2023-12-18 | 0.72 | 6.92 | |
SO69372_2 | 6 | 26027 | 214 | 9 | 2024-07-02 | 0.87 | 2024-06-20 | 34.99 | 2 | SO69372 | 2024-06-27 | 2.80 | 13.09 | |
SO45228_1 | 6 | 18768 | 314 | 9 | 2022-03-29 | 89.46 | 2022-03-17 | 3578.27 | 1 | SO45228 | 2022-03-24 | 286.26 | 2171.29 | |
SO56431_1 | 6 | 14344 | 539 | 9 | 2023-12-23 | 0.62 | 2023-12-11 | 24.99 | 1 | SO56431 | 2023-12-18 | 2.00 | 9.35 | |
SO69373_1 | 6 | 29294 | 606 | 2 | 9 | 2024-07-02 | 13.50 | 2024-06-20 | 539.99 | 1 | SO69373 | 2024-06-27 | 43.20 | 343.65 |
Generated 2024-09-20 13:39:19.643 UTC