[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 685 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44174_1 | 6 | 17229 | 311 | 9 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO44174 | 2021-11-05 | 286.26 | 2171.29 | |
SO55693_3 | 100 | 29049 | 234 | 1 | 2023-12-09 | 1.25 | 2023-11-27 | 49.99 | 3 | SO55693 | 2023-12-04 | 4.00 | 38.49 | |
SO44175_1 | 6 | 17246 | 313 | 9 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO44175 | 2021-11-05 | 286.26 | 2171.29 | |
SO55693_4 | 100 | 29049 | 463 | 1 | 2023-12-09 | 0.61 | 2023-11-27 | 24.49 | 4 | SO55693 | 2023-12-04 | 1.96 | 9.16 | |
SO44176_1 | 39 | 12220 | 314 | 7 | 2021-11-11 | 89.46 | 2021-10-30 | 3578.27 | 1 | SO44176 | 2021-11-06 | 286.26 | 2171.29 | |
SO55694_1 | 19 | 11677 | 538 | 6 | 2023-12-09 | 0.54 | 2023-11-27 | 21.49 | 1 | SO55694 | 2023-12-04 | 1.72 | 8.04 | |
SO44177_1 | 98 | 11337 | 350 | 10 | 2021-11-11 | 84.37 | 2021-10-30 | 3374.99 | 1 | SO44177 | 2021-11-06 | 270.00 | 1898.09 | |
SO55695_1 | 19 | 11276 | 535 | 6 | 2023-12-09 | 0.62 | 2023-11-27 | 24.99 | 1 | SO55695 | 2023-12-04 | 2.00 | 9.35 | |
SO44178_1 | 100 | 28097 | 312 | 4 | 2021-11-11 | 89.46 | 2021-10-30 | 3578.27 | 1 | SO44178 | 2021-11-06 | 286.26 | 2171.29 | |
SO55695_2 | 19 | 11276 | 528 | 6 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 2 | SO55695 | 2023-12-04 | 0.40 | 1.87 | |
SO44179_1 | 100 | 25888 | 350 | 1 | 2021-11-11 | 84.37 | 2021-10-30 | 3374.99 | 1 | SO44179 | 2021-11-06 | 270.00 | 1898.09 | |
SO55696_1 | 100 | 25351 | 535 | 1 | 2023-12-09 | 0.62 | 2023-11-27 | 24.99 | 1 | SO55696 | 2023-12-04 | 2.00 | 9.35 | |
SO44180_1 | 6 | 11058 | 347 | 9 | 2021-11-11 | 85.00 | 2021-10-30 | 3399.99 | 1 | SO44180 | 2021-11-06 | 272.00 | 1912.15 | |
SO55696_2 | 100 | 25351 | 463 | 1 | 2023-12-09 | 0.61 | 2023-11-27 | 24.49 | 2 | SO55696 | 2023-12-04 | 1.96 | 9.16 | |
SO44181_1 | 6 | 17294 | 312 | 9 | 2021-11-11 | 89.46 | 2021-10-30 | 3578.27 | 1 | SO44181 | 2021-11-06 | 286.26 | 2171.29 | |
SO55697_1 | 19 | 11501 | 530 | 6 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 1 | SO55697 | 2023-12-04 | 0.40 | 1.87 | |
SO44182_1 | 6 | 17299 | 310 | 9 | 2021-11-11 | 89.46 | 2021-10-30 | 3578.27 | 1 | SO44182 | 2021-11-06 | 286.26 | 2171.29 | |
SO55698_1 | 100 | 23732 | 536 | 1 | 2023-12-09 | 0.75 | 2023-11-27 | 29.99 | 1 | SO55698 | 2023-12-04 | 2.40 | 11.22 | |
SO44183_1 | 100 | 28158 | 310 | 4 | 2021-11-12 | 89.46 | 2021-10-31 | 3578.27 | 1 | SO44183 | 2021-11-07 | 286.26 | 2171.29 | |
SO55698_2 | 100 | 23732 | 528 | 1 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 2 | SO55698 | 2023-12-04 | 0.40 | 1.87 | |
SO44184_1 | 6 | 17247 | 314 | 9 | 2021-11-12 | 89.46 | 2021-10-31 | 3578.27 | 1 | SO44184 | 2021-11-07 | 286.26 | 2171.29 | |
SO55698_3 | 100 | 23732 | 478 | 1 | 2023-12-09 | 0.25 | 2023-11-27 | 9.99 | 3 | SO55698 | 2023-12-04 | 0.80 | 3.74 | |
SO44185_1 | 6 | 17280 | 310 | 9 | 2021-11-12 | 89.46 | 2021-10-31 | 3578.27 | 1 | SO44185 | 2021-11-07 | 286.26 | 2171.29 | |
SO55698_4 | 100 | 23732 | 477 | 1 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 4 | SO55698 | 2023-12-04 | 0.40 | 1.87 | |
SO44186_1 | 100 | 25889 | 347 | 4 | 2021-11-14 | 85.00 | 2021-11-02 | 3399.99 | 1 | SO44186 | 2021-11-09 | 272.00 | 1912.15 | |
SO55698_5 | 100 | 23732 | 463 | 1 | 2023-12-09 | 0.61 | 2023-11-27 | 24.49 | 5 | SO55698 | 2023-12-04 | 1.96 | 9.16 | |
SO44187_1 | 6 | 17069 | 313 | 9 | 2021-11-14 | 89.46 | 2021-11-02 | 3578.27 | 1 | SO44187 | 2021-11-09 | 286.26 | 2171.29 | |
SO55699_1 | 19 | 18322 | 528 | 6 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 1 | SO55699 | 2023-12-04 | 0.40 | 1.87 | |
SO44188_1 | 98 | 20052 | 334 | 10 | 2021-11-15 | 17.48 | 2021-11-03 | 699.10 | 1 | SO44188 | 2021-11-10 | 55.93 | 413.15 | |
SO55699_2 | 19 | 18322 | 536 | 6 | 2023-12-09 | 0.75 | 2023-11-27 | 29.99 | 2 | SO55699 | 2023-12-04 | 2.40 | 11.22 | |
SO44189_1 | 98 | 20054 | 322 | 10 | 2021-11-15 | 17.48 | 2021-11-03 | 699.10 | 1 | SO44189 | 2021-11-10 | 55.93 | 413.15 | |
SO55699_3 | 19 | 18322 | 485 | 6 | 2023-12-09 | 0.55 | 2023-11-27 | 21.98 | 3 | SO55699 | 2023-12-04 | 1.76 | 8.22 | |
SO44190_1 | 6 | 11061 | 348 | 9 | 2021-11-15 | 84.37 | 2021-11-03 | 3374.99 | 1 | SO44190 | 2021-11-10 | 270.00 | 1898.09 | |
SO55699_4 | 19 | 18322 | 478 | 6 | 2023-12-09 | 0.25 | 2023-11-27 | 9.99 | 4 | SO55699 | 2023-12-04 | 0.80 | 3.74 | |
SO44191_1 | 6 | 17248 | 310 | 9 | 2021-11-15 | 89.46 | 2021-11-03 | 3578.27 | 1 | SO44191 | 2021-11-10 | 286.26 | 2171.29 | |
SO55699_5 | 19 | 18322 | 477 | 6 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 5 | SO55699 | 2023-12-04 | 0.40 | 1.87 | |
SO44192_1 | 29 | 13570 | 312 | 8 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO44192 | 2021-11-11 | 286.26 | 2171.29 | |
SO55699_6 | 19 | 18322 | 463 | 6 | 2023-12-09 | 0.61 | 2023-11-27 | 24.49 | 6 | SO55699 | 2023-12-04 | 1.96 | 9.16 | |
SO44193_1 | 100 | 28164 | 312 | 4 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO44193 | 2021-11-11 | 286.26 | 2171.29 | |
SO55700_1 | 19 | 14626 | 540 | 6 | 2023-12-09 | 0.82 | 2023-11-27 | 32.60 | 1 | SO55700 | 2023-12-04 | 2.61 | 12.19 | |
SO44194_1 | 6 | 17064 | 310 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO44194 | 2021-11-11 | 286.26 | 2171.29 | |
SO55701_1 | 100 | 22081 | 536 | 1 | 2023-12-09 | 0.75 | 2023-11-27 | 29.99 | 1 | SO55701 | 2023-12-04 | 2.40 | 11.22 | |
SO44195_1 | 6 | 17249 | 313 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO44195 | 2021-11-11 | 286.26 | 2171.29 | |
SO55702_1 | 100 | 22244 | 536 | 1 | 2023-12-09 | 0.75 | 2023-11-27 | 29.99 | 1 | SO55702 | 2023-12-04 | 2.40 | 11.22 | |
SO44196_1 | 6 | 17295 | 314 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO44196 | 2021-11-11 | 286.26 | 2171.29 | |
SO55703_1 | 19 | 14353 | 478 | 6 | 2023-12-09 | 0.25 | 2023-11-27 | 9.99 | 1 | SO55703 | 2023-12-04 | 0.80 | 3.74 | |
SO44197_1 | 100 | 28096 | 312 | 4 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO44197 | 2021-11-12 | 286.26 | 2171.29 | |
SO55703_2 | 19 | 14353 | 477 | 6 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 2 | SO55703 | 2023-12-04 | 0.40 | 1.87 | |
SO44198_1 | 100 | 28150 | 310 | 4 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO44198 | 2021-11-12 | 286.26 | 2171.29 | |
SO55704_1 | 19 | 27100 | 477 | 6 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 1 | SO55704 | 2023-12-04 | 0.40 | 1.87 | |
SO44199_1 | 6 | 17259 | 313 | 9 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO44199 | 2021-11-12 | 286.26 | 2171.29 | |
SO55704_2 | 19 | 27100 | 480 | 2 | 6 | 2023-12-09 | 0.06 | 2023-11-27 | 2.29 | 2 | SO55704 | 2023-12-04 | 0.18 | 0.86 |
SO44200_1 | 6 | 17312 | 311 | 9 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO44200 | 2021-11-12 | 286.26 | 2171.29 | |
SO55705_1 | 100 | 17122 | 477 | 4 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 1 | SO55705 | 2023-12-04 | 0.40 | 1.87 | |
SO44201_1 | 39 | 12254 | 313 | 7 | 2021-11-18 | 89.46 | 2021-11-06 | 3578.27 | 1 | SO44201 | 2021-11-13 | 286.26 | 2171.29 | |
SO55705_2 | 100 | 17122 | 489 | 4 | 2023-12-09 | 1.35 | 2023-11-27 | 53.99 | 2 | SO55705 | 2023-12-04 | 4.32 | 41.57 | |
SO44202_1 | 100 | 28159 | 311 | 4 | 2021-11-18 | 89.46 | 2021-11-06 | 3578.27 | 1 | SO44202 | 2021-11-13 | 286.26 | 2171.29 | |
SO55706_1 | 19 | 21815 | 528 | 6 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 1 | SO55706 | 2023-12-04 | 0.40 | 1.87 | |
SO44203_1 | 100 | 28149 | 312 | 4 | 2021-11-18 | 89.46 | 2021-11-06 | 3578.27 | 1 | SO44203 | 2021-11-13 | 286.26 | 2171.29 | |
SO55706_2 | 19 | 21815 | 222 | 6 | 2023-12-09 | 0.87 | 2023-11-27 | 34.99 | 2 | SO55706 | 2023-12-04 | 2.80 | 13.09 | |
SO44204_1 | 100 | 14580 | 336 | 4 | 2021-11-18 | 17.48 | 2021-11-06 | 699.10 | 1 | SO44204 | 2021-11-13 | 55.93 | 413.15 | |
SO55706_3 | 19 | 21815 | 465 | 6 | 2023-12-09 | 0.61 | 2023-11-27 | 24.49 | 3 | SO55706 | 2023-12-04 | 1.96 | 9.16 |
Generated 2024-09-20 11:52:51.211 UTC