[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2093 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44395_1 | 100 | 28339 | 314 | 1 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44395 | 2022-02-01 | 286.26 | 2171.29 | |
SO55769_1 | 100 | 14243 | 485 | 1 | 2024-02-01 | 0.55 | 2024-01-20 | 21.98 | 1 | SO55769 | 2024-01-27 | 1.76 | 8.22 | |
SO62324_1 | 98 | 14993 | 541 | 10 | 2024-05-13 | 0.72 | 2024-05-01 | 28.99 | 1 | SO62324 | 2024-05-08 | 2.32 | 10.84 | |
SO68862_1 | 6 | 15152 | 361 | 9 | 2024-08-17 | 57.37 | 2024-08-05 | 2294.99 | 1 | SO68862 | 2024-08-12 | 183.60 | 1251.98 | |
SO44396_1 | 100 | 25901 | 345 | 4 | 2022-02-06 | 85.00 | 2022-01-25 | 3399.99 | 1 | SO44396 | 2022-02-01 | 272.00 | 1912.15 | |
SO55769_2 | 100 | 14243 | 231 | 1 | 2024-02-01 | 1.25 | 2024-01-20 | 49.99 | 2 | SO55769 | 2024-01-27 | 4.00 | 38.49 | |
SO62324_2 | 98 | 14993 | 530 | 10 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 2 | SO62324 | 2024-05-08 | 0.40 | 1.87 | |
SO68862_2 | 6 | 15152 | 537 | 9 | 2024-08-17 | 0.88 | 2024-08-05 | 35.00 | 2 | SO68862 | 2024-08-12 | 2.80 | 13.09 | |
SO44397_1 | 100 | 14596 | 330 | 4 | 2022-02-06 | 17.48 | 2022-01-25 | 699.10 | 1 | SO44397 | 2022-02-01 | 55.93 | 413.15 | |
SO55770_1 | 100 | 15273 | 528 | 4 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 1 | SO55770 | 2024-01-27 | 0.40 | 1.87 | |
SO62324_3 | 98 | 14993 | 217 | 10 | 2024-05-13 | 0.87 | 2024-05-01 | 34.99 | 3 | SO62324 | 2024-05-08 | 2.80 | 13.09 | |
SO68862_3 | 6 | 15152 | 485 | 9 | 2024-08-17 | 0.55 | 2024-08-05 | 21.98 | 3 | SO68862 | 2024-08-12 | 1.76 | 8.22 | |
SO44398_1 | 6 | 17733 | 312 | 9 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44398 | 2022-02-01 | 286.26 | 2171.29 | |
SO55770_2 | 100 | 15273 | 222 | 4 | 2024-02-01 | 0.87 | 2024-01-20 | 34.99 | 2 | SO55770 | 2024-01-27 | 2.80 | 13.09 | |
SO62324_4 | 98 | 14993 | 225 | 10 | 2024-05-13 | 0.22 | 2024-05-01 | 8.99 | 4 | SO62324 | 2024-05-08 | 0.72 | 6.92 | |
SO68862_4 | 6 | 15152 | 471 | 9 | 2024-08-17 | 1.59 | 2024-08-05 | 63.50 | 4 | SO68862 | 2024-08-12 | 5.08 | 23.75 | |
SO44399_1 | 100 | 28240 | 311 | 1 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44399 | 2022-02-02 | 286.26 | 2171.29 | |
SO55770_3 | 100 | 15273 | 471 | 4 | 2024-02-01 | 1.59 | 2024-01-20 | 63.50 | 3 | SO55770 | 2024-01-27 | 5.08 | 23.75 | |
SO62325_1 | 100 | 27326 | 541 | 7 | 2024-05-13 | 0.72 | 2024-05-01 | 28.99 | 1 | SO62325 | 2024-05-08 | 2.32 | 10.84 | |
SO68863_1 | 6 | 26029 | 388 | 9 | 2024-08-17 | 28.01 | 2024-08-05 | 1120.49 | 1 | SO68863 | 2024-08-12 | 89.64 | 713.08 | |
SO44400_1 | 100 | 28588 | 312 | 4 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44400 | 2022-02-02 | 286.26 | 2171.29 | |
SO55771_1 | 19 | 18407 | 485 | 6 | 2024-02-01 | 0.55 | 2024-01-20 | 21.98 | 1 | SO55771 | 2024-01-27 | 1.76 | 8.22 | |
SO62325_2 | 100 | 27326 | 530 | 7 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 2 | SO62325 | 2024-05-08 | 0.40 | 1.87 | |
SO68863_2 | 6 | 26029 | 539 | 9 | 2024-08-17 | 0.62 | 2024-08-05 | 24.99 | 2 | SO68863 | 2024-08-12 | 2.00 | 9.35 | |
SO44401_1 | 6 | 17515 | 312 | 9 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44401 | 2022-02-02 | 286.26 | 2171.29 | |
SO55771_2 | 19 | 18407 | 481 | 6 | 2024-02-01 | 0.22 | 2024-01-20 | 8.99 | 2 | SO55771 | 2024-01-27 | 0.72 | 3.36 | |
SO62325_3 | 100 | 27326 | 228 | 7 | 2024-05-13 | 1.25 | 2024-05-01 | 49.99 | 3 | SO62325 | 2024-05-08 | 4.00 | 38.49 | |
SO68863_3 | 6 | 26029 | 480 | 2 | 9 | 2024-08-17 | 0.06 | 2024-08-05 | 2.29 | 3 | SO68863 | 2024-08-12 | 0.18 | 0.86 |
SO44402_1 | 29 | 13666 | 314 | 8 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO44402 | 2022-02-03 | 286.26 | 2171.29 | |
SO55772_1 | 98 | 19926 | 528 | 10 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 1 | SO55772 | 2024-01-27 | 0.40 | 1.87 | |
SO62326_1 | 100 | 13827 | 530 | 8 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 1 | SO62326 | 2024-05-08 | 0.40 | 1.87 | |
SO68864_1 | 6 | 21256 | 583 | 9 | 2024-08-17 | 42.52 | 2024-08-05 | 1700.99 | 1 | SO68864 | 2024-08-12 | 136.08 | 1082.51 | |
SO44403_1 | 19 | 19844 | 350 | 6 | 2022-02-08 | 84.37 | 2022-01-27 | 3374.99 | 1 | SO44403 | 2022-02-03 | 270.00 | 1898.09 | |
SO55772_2 | 98 | 19926 | 222 | 10 | 2024-02-01 | 0.87 | 2024-01-20 | 34.99 | 2 | SO55772 | 2024-01-27 | 2.80 | 13.09 | |
SO62326_2 | 100 | 13827 | 465 | 8 | 2024-05-13 | 0.61 | 2024-05-01 | 24.49 | 2 | SO62326 | 2024-05-08 | 1.96 | 9.16 | |
SO68864_2 | 6 | 21256 | 222 | 9 | 2024-08-17 | 0.87 | 2024-08-05 | 34.99 | 2 | SO68864 | 2024-08-12 | 2.80 | 13.09 | |
SO44404_1 | 100 | 28221 | 314 | 4 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44404 | 2022-02-04 | 286.26 | 2171.29 | |
SO55773_1 | 100 | 14422 | 540 | 8 | 2024-02-01 | 0.82 | 2024-01-20 | 32.60 | 1 | SO55773 | 2024-01-27 | 2.61 | 12.19 | |
SO62327_1 | 100 | 11737 | 528 | 4 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 1 | SO62327 | 2024-05-08 | 0.40 | 1.87 | |
SO68865_1 | 6 | 15642 | 580 | 9 | 2024-08-17 | 42.52 | 2024-08-05 | 1700.99 | 1 | SO68865 | 2024-08-12 | 136.08 | 1082.51 | |
SO44405_1 | 100 | 28224 | 310 | 4 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44405 | 2022-02-04 | 286.26 | 2171.29 | |
SO55773_2 | 100 | 14422 | 529 | 8 | 2024-02-01 | 0.10 | 2024-01-20 | 3.99 | 2 | SO55773 | 2024-01-27 | 0.32 | 1.49 | |
SO62327_2 | 100 | 11737 | 537 | 4 | 2024-05-13 | 0.88 | 2024-05-01 | 35.00 | 2 | SO62327 | 2024-05-08 | 2.80 | 13.09 | |
SO68866_1 | 6 | 21980 | 581 | 9 | 2024-08-17 | 42.52 | 2024-08-05 | 1700.99 | 1 | SO68866 | 2024-08-12 | 136.08 | 1082.51 | |
SO44406_1 | 100 | 28299 | 313 | 4 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44406 | 2022-02-04 | 286.26 | 2171.29 | |
SO55773_3 | 100 | 14422 | 480 | 8 | 2024-02-01 | 0.06 | 2024-01-20 | 2.29 | 3 | SO55773 | 2024-01-27 | 0.18 | 0.86 | |
SO62327_3 | 100 | 11737 | 480 | 4 | 2024-05-13 | 0.06 | 2024-05-01 | 2.29 | 3 | SO62327 | 2024-05-08 | 0.18 | 0.86 | |
SO68866_2 | 6 | 21980 | 529 | 9 | 2024-08-17 | 0.10 | 2024-08-05 | 3.99 | 2 | SO68866 | 2024-08-12 | 0.32 | 1.49 | |
SO44407_1 | 6 | 11077 | 351 | 9 | 2022-02-09 | 84.37 | 2022-01-28 | 3374.99 | 1 | SO44407 | 2022-02-04 | 270.00 | 1898.09 | |
SO55774_1 | 100 | 14943 | 485 | 8 | 2024-02-01 | 0.55 | 2024-01-20 | 21.98 | 1 | SO55774 | 2024-01-27 | 1.76 | 8.22 | |
SO62328_1 | 100 | 11975 | 537 | 4 | 2024-05-13 | 0.88 | 2024-05-01 | 35.00 | 1 | SO62328 | 2024-05-08 | 2.80 | 13.09 | |
SO68866_3 | 6 | 21980 | 539 | 9 | 2024-08-17 | 0.62 | 2024-08-05 | 24.99 | 3 | SO68866 | 2024-08-12 | 2.00 | 9.35 | |
SO44408_1 | 6 | 11103 | 351 | 9 | 2022-02-09 | 84.37 | 2022-01-28 | 3374.99 | 1 | SO44408 | 2022-02-04 | 270.00 | 1898.09 | |
SO55774_2 | 100 | 14943 | 478 | 8 | 2024-02-01 | 0.25 | 2024-01-20 | 9.99 | 2 | SO55774 | 2024-01-27 | 0.80 | 3.74 | |
SO62328_2 | 100 | 11975 | 528 | 4 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 2 | SO62328 | 2024-05-08 | 0.40 | 1.87 | |
SO68866_4 | 6 | 21980 | 480 | 9 | 2024-08-17 | 0.06 | 2024-08-05 | 2.29 | 4 | SO68866 | 2024-08-12 | 0.18 | 0.86 | |
SO44409_1 | 6 | 25563 | 320 | 9 | 2022-02-09 | 17.48 | 2022-01-28 | 699.10 | 1 | SO44409 | 2022-02-04 | 55.93 | 413.15 | |
SO55774_3 | 100 | 14943 | 477 | 8 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 3 | SO55774 | 2024-01-27 | 0.40 | 1.87 | |
SO62328_3 | 100 | 11975 | 483 | 4 | 2024-05-13 | 3.00 | 2024-05-01 | 120.00 | 3 | SO62328 | 2024-05-08 | 9.60 | 44.88 | |
SO68866_5 | 6 | 21980 | 486 | 9 | 2024-08-17 | 3.98 | 2024-08-05 | 159.00 | 5 | SO68866 | 2024-08-12 | 12.72 | 59.47 | |
SO44410_1 | 100 | 28223 | 310 | 4 | 2022-02-10 | 89.46 | 2022-01-29 | 3578.27 | 1 | SO44410 | 2022-02-05 | 286.26 | 2171.29 | |
SO55775_1 | 100 | 18014 | 473 | 7 | 2024-02-01 | 1.59 | 2024-01-20 | 63.50 | 1 | SO55775 | 2024-01-27 | 5.08 | 23.75 |
Generated 2024-11-13 00:56:34.250 UTC