[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 514 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43930_1 | 100 | 28038 | 312 | 4 | 2021-10-06 | 89.46 | 2021-09-24 | 3578.27 | 1 | SO43930 | 2021-10-01 | 286.26 | 2171.29 | |
SO55635_4 | 100 | 15883 | 225 | 4 | 2023-12-08 | 0.22 | 2023-11-26 | 8.99 | 4 | SO55635 | 2023-12-03 | 0.72 | 6.92 | |
SO62176_1 | 100 | 17873 | 580 | 8 | 2024-03-19 | 42.52 | 2024-03-07 | 1700.99 | 1 | SO62176 | 2024-03-14 | 136.08 | 1082.51 | |
SO43931_1 | 29 | 13548 | 313 | 8 | 2021-10-06 | 89.46 | 2021-09-24 | 3578.27 | 1 | SO43931 | 2021-10-01 | 286.26 | 2171.29 | |
SO55636_1 | 100 | 15384 | 528 | 1 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55636 | 2023-12-03 | 0.40 | 1.87 | |
SO62176_2 | 100 | 17873 | 228 | 8 | 2024-03-19 | 1.25 | 2024-03-07 | 49.99 | 2 | SO62176 | 2024-03-14 | 4.00 | 38.49 | |
SO43932_1 | 6 | 16741 | 314 | 9 | 2021-10-06 | 89.46 | 2021-09-24 | 3578.27 | 1 | SO43932 | 2021-10-01 | 286.26 | 2171.29 | |
SO55636_2 | 100 | 15384 | 480 | 2 | 1 | 2023-12-08 | 0.06 | 2023-11-26 | 2.29 | 2 | SO55636 | 2023-12-03 | 0.18 | 0.86 |
SO62176_3 | 100 | 17873 | 225 | 8 | 2024-03-19 | 0.22 | 2024-03-07 | 8.99 | 3 | SO62176 | 2024-03-14 | 0.72 | 6.92 | |
SO43933_1 | 6 | 11031 | 347 | 9 | 2021-10-06 | 85.00 | 2021-09-24 | 3399.99 | 1 | SO43933 | 2021-10-01 | 272.00 | 1912.15 | |
SO55637_1 | 100 | 17342 | 528 | 1 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55637 | 2023-12-03 | 0.40 | 1.87 | |
SO62177_1 | 100 | 15357 | 353 | 8 | 2024-03-19 | 58.00 | 2024-03-07 | 2319.99 | 1 | SO62177 | 2024-03-14 | 185.60 | 1265.62 | |
SO43934_1 | 6 | 11034 | 346 | 9 | 2021-10-06 | 85.00 | 2021-09-24 | 3399.99 | 1 | SO43934 | 2021-10-01 | 272.00 | 1912.15 | |
SO55637_2 | 100 | 17342 | 222 | 1 | 2023-12-08 | 0.87 | 2023-11-26 | 34.99 | 2 | SO55637 | 2023-12-03 | 2.80 | 13.09 | |
SO62177_2 | 100 | 15357 | 477 | 8 | 2024-03-19 | 0.12 | 2024-03-07 | 4.99 | 2 | SO62177 | 2024-03-14 | 0.40 | 1.87 | |
SO43935_1 | 98 | 20048 | 334 | 10 | 2021-10-07 | 17.48 | 2021-09-25 | 699.10 | 1 | SO43935 | 2021-10-02 | 55.93 | 413.15 | |
SO55638_1 | 19 | 23498 | 528 | 6 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55638 | 2023-12-03 | 0.40 | 1.87 | |
SO62177_3 | 100 | 15357 | 478 | 8 | 2024-03-19 | 0.25 | 2024-03-07 | 9.99 | 3 | SO62177 | 2024-03-14 | 0.80 | 3.74 | |
SO43936_1 | 100 | 28065 | 311 | 4 | 2021-10-07 | 89.46 | 2021-09-25 | 3578.27 | 1 | SO43936 | 2021-10-02 | 286.26 | 2171.29 | |
SO55639_1 | 19 | 19645 | 528 | 6 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55639 | 2023-12-03 | 0.40 | 1.87 | |
SO62177_4 | 100 | 15357 | 217 | 8 | 2024-03-19 | 0.87 | 2024-03-07 | 34.99 | 4 | SO62177 | 2024-03-14 | 2.80 | 13.09 | |
SO43937_1 | 6 | 17047 | 312 | 9 | 2021-10-07 | 89.46 | 2021-09-25 | 3578.27 | 1 | SO43937 | 2021-10-02 | 286.26 | 2171.29 | |
SO55639_2 | 19 | 19645 | 217 | 6 | 2023-12-08 | 0.87 | 2023-11-26 | 34.99 | 2 | SO55639 | 2023-12-03 | 2.80 | 13.09 | |
SO62178_1 | 100 | 12211 | 359 | 7 | 2024-03-19 | 57.37 | 2024-03-07 | 2294.99 | 1 | SO62178 | 2024-03-14 | 183.60 | 1251.98 | |
SO43938_1 | 6 | 16686 | 310 | 9 | 2021-10-07 | 89.46 | 2021-09-25 | 3578.27 | 1 | SO43938 | 2021-10-02 | 286.26 | 2171.29 | |
SO55640_1 | 100 | 15260 | 485 | 4 | 2023-12-08 | 0.55 | 2023-11-26 | 21.98 | 1 | SO55640 | 2023-12-03 | 1.76 | 8.22 | |
SO62178_2 | 100 | 12211 | 214 | 7 | 2024-03-19 | 0.87 | 2024-03-07 | 34.99 | 2 | SO62178 | 2024-03-14 | 2.80 | 13.09 | |
SO43939_1 | 6 | 16659 | 312 | 9 | 2021-10-07 | 89.46 | 2021-09-25 | 3578.27 | 1 | SO43939 | 2021-10-02 | 286.26 | 2171.29 | |
SO55640_2 | 100 | 15260 | 478 | 4 | 2023-12-08 | 0.25 | 2023-11-26 | 9.99 | 2 | SO55640 | 2023-12-03 | 0.80 | 3.74 | |
SO62179_1 | 100 | 11646 | 488 | 1 | 2024-03-19 | 1.35 | 2024-03-07 | 53.99 | 1 | SO62179 | 2024-03-14 | 4.32 | 41.57 | |
SO43940_1 | 6 | 25294 | 336 | 9 | 2021-10-07 | 17.48 | 2021-09-25 | 699.10 | 1 | SO43940 | 2021-10-02 | 55.93 | 413.15 | |
SO55640_3 | 100 | 15260 | 477 | 4 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 3 | SO55640 | 2023-12-03 | 0.40 | 1.87 | |
SO62180_1 | 19 | 28776 | 480 | 4 | 2024-03-19 | 0.06 | 2024-03-07 | 2.29 | 1 | SO62180 | 2024-03-14 | 0.18 | 0.86 | |
SO43941_1 | 98 | 13600 | 314 | 10 | 2021-10-08 | 89.46 | 2021-09-26 | 3578.27 | 1 | SO43941 | 2021-10-03 | 286.26 | 2171.29 | |
SO55640_4 | 100 | 15260 | 225 | 4 | 2023-12-08 | 0.22 | 2023-11-26 | 8.99 | 4 | SO55640 | 2023-12-03 | 0.72 | 6.92 | |
SO62181_1 | 100 | 28855 | 539 | 4 | 2024-03-19 | 0.62 | 2024-03-07 | 24.99 | 1 | SO62181 | 2024-03-14 | 2.00 | 9.35 | |
SO43942_1 | 6 | 17051 | 310 | 9 | 2021-10-08 | 89.46 | 2021-09-26 | 3578.27 | 1 | SO43942 | 2021-10-03 | 286.26 | 2171.29 | |
SO55641_1 | 100 | 16396 | 535 | 8 | 2023-12-08 | 0.62 | 2023-11-26 | 24.99 | 1 | SO55641 | 2023-12-03 | 2.00 | 9.35 | |
SO62181_2 | 100 | 28855 | 529 | 4 | 2024-03-19 | 0.10 | 2024-03-07 | 3.99 | 2 | SO62181 | 2024-03-14 | 0.32 | 1.49 | |
SO43943_1 | 100 | 14565 | 338 | 4 | 2021-10-08 | 17.48 | 2021-09-26 | 699.10 | 1 | SO43943 | 2021-10-03 | 55.93 | 413.15 | |
SO55641_2 | 100 | 16396 | 528 | 8 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 2 | SO55641 | 2023-12-03 | 0.40 | 1.87 | |
SO62181_3 | 100 | 28855 | 465 | 4 | 2024-03-19 | 0.61 | 2024-03-07 | 24.49 | 3 | SO62181 | 2024-03-14 | 1.96 | 9.16 | |
SO43944_1 | 6 | 11054 | 344 | 9 | 2021-10-08 | 85.00 | 2021-09-26 | 3399.99 | 1 | SO43944 | 2021-10-03 | 272.00 | 1912.15 | |
SO55641_3 | 100 | 16396 | 480 | 2 | 8 | 2023-12-08 | 0.06 | 2023-11-26 | 2.29 | 3 | SO55641 | 2023-12-03 | 0.18 | 0.86 |
SO62181_4 | 100 | 28855 | 234 | 4 | 2024-03-19 | 1.25 | 2024-03-07 | 49.99 | 4 | SO62181 | 2024-03-14 | 4.00 | 38.49 | |
SO43945_1 | 6 | 16675 | 310 | 9 | 2021-10-08 | 89.46 | 2021-09-26 | 3578.27 | 1 | SO43945 | 2021-10-03 | 286.26 | 2171.29 | |
SO55642_1 | 98 | 16459 | 528 | 10 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO55642 | 2023-12-03 | 0.40 | 1.87 | |
SO62182_1 | 100 | 27391 | 530 | 1 | 2024-03-19 | 0.12 | 2024-03-07 | 4.99 | 1 | SO62182 | 2024-03-14 | 0.40 | 1.87 | |
SO43946_1 | 6 | 16687 | 313 | 9 | 2021-10-08 | 89.46 | 2021-09-26 | 3578.27 | 1 | SO43946 | 2021-10-03 | 286.26 | 2171.29 | |
SO55642_2 | 98 | 16459 | 222 | 10 | 2023-12-08 | 0.87 | 2023-11-26 | 34.99 | 2 | SO55642 | 2023-12-03 | 2.80 | 13.09 | |
SO62182_2 | 100 | 27391 | 541 | 1 | 2024-03-19 | 0.72 | 2024-03-07 | 28.99 | 2 | SO62182 | 2024-03-14 | 2.32 | 10.84 | |
SO43947_1 | 6 | 16712 | 310 | 9 | 2021-10-08 | 89.46 | 2021-09-26 | 3578.27 | 1 | SO43947 | 2021-10-03 | 286.26 | 2171.29 | |
SO55643_1 | 19 | 21471 | 485 | 6 | 2023-12-08 | 0.55 | 2023-11-26 | 21.98 | 1 | SO55643 | 2023-12-03 | 1.76 | 8.22 | |
SO62183_1 | 100 | 27506 | 529 | 4 | 2024-03-19 | 0.10 | 2024-03-07 | 3.99 | 1 | SO62183 | 2024-03-14 | 0.32 | 1.49 | |
SO43948_1 | 6 | 11047 | 345 | 9 | 2021-10-08 | 85.00 | 2021-09-26 | 3399.99 | 1 | SO43948 | 2021-10-03 | 272.00 | 1912.15 | |
SO55643_2 | 19 | 21471 | 478 | 6 | 2023-12-08 | 0.25 | 2023-11-26 | 9.99 | 2 | SO55643 | 2023-12-03 | 0.80 | 3.74 | |
SO62183_2 | 100 | 27506 | 538 | 4 | 2024-03-19 | 0.54 | 2024-03-07 | 21.49 | 2 | SO62183 | 2024-03-14 | 1.72 | 8.04 | |
SO43949_1 | 100 | 27726 | 310 | 4 | 2021-10-09 | 89.46 | 2021-09-27 | 3578.27 | 1 | SO43949 | 2021-10-04 | 286.26 | 2171.29 | |
SO55644_1 | 98 | 20868 | 536 | 10 | 2023-12-08 | 0.75 | 2023-11-26 | 29.99 | 1 | SO55644 | 2023-12-03 | 2.40 | 11.22 | |
SO62183_3 | 100 | 27506 | 484 | 4 | 2024-03-19 | 0.20 | 2024-03-07 | 7.95 | 3 | SO62183 | 2024-03-14 | 0.64 | 2.97 |
Generated 2024-09-20 09:36:31.542 UTC