[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 1244 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56895_1 | 100 | 11630 | 353 | 1 | 2023-12-31 | 58.00 | 2023-12-19 | 2319.99 | 1 | SO56895 | 2023-12-26 | 185.60 | 1265.62 | |
SO45471_1 | 100 | 29280 | 313 | 1 | 2022-04-26 | 89.46 | 2022-04-14 | 3578.27 | 1 | SO45471 | 2022-04-21 | 286.26 | 2171.29 | |
SO56895_2 | 100 | 11630 | 537 | 1 | 2023-12-31 | 0.88 | 2023-12-19 | 35.00 | 2 | SO56895 | 2023-12-26 | 2.80 | 13.09 | |
SO45478_1 | 100 | 29354 | 313 | 1 | 2022-04-27 | 89.46 | 2022-04-15 | 3578.27 | 1 | SO45478 | 2022-04-22 | 286.26 | 2171.29 | |
SO56896_1 | 100 | 12929 | 357 | 1 | 2023-12-31 | 58.00 | 2023-12-19 | 2319.99 | 1 | SO56896 | 2023-12-26 | 185.60 | 1265.62 | |
SO45486_1 | 100 | 14737 | 324 | 1 | 2022-04-28 | 17.48 | 2022-04-16 | 699.10 | 1 | SO45486 | 2022-04-23 | 55.93 | 413.15 | |
SO56896_2 | 100 | 12929 | 485 | 1 | 2023-12-31 | 0.55 | 2023-12-19 | 21.98 | 2 | SO56896 | 2023-12-26 | 1.76 | 8.22 | |
SO45500_1 | 100 | 11189 | 312 | 1 | 2022-04-30 | 89.46 | 2022-04-18 | 3578.27 | 1 | SO45500 | 2022-04-25 | 286.26 | 2171.29 | |
SO56896_3 | 100 | 12929 | 214 | 1 | 2023-12-31 | 0.87 | 2023-12-19 | 34.99 | 3 | SO56896 | 2023-12-26 | 2.80 | 13.09 | |
SO45501_1 | 100 | 25993 | 350 | 1 | 2022-04-30 | 84.37 | 2022-04-18 | 3374.99 | 1 | SO45501 | 2022-04-25 | 270.00 | 1898.09 | |
SO56904_1 | 100 | 22880 | 604 | 1 | 2023-12-31 | 13.50 | 2023-12-19 | 539.99 | 1 | SO56904 | 2023-12-26 | 43.20 | 343.65 | |
SO45581_1 | 100 | 11263 | 313 | 1 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45581 | 2022-04-28 | 286.26 | 2171.29 | |
SO56904_2 | 100 | 22880 | 479 | 1 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 2 | SO56904 | 2023-12-26 | 0.72 | 3.36 | |
SO45583_1 | 100 | 11274 | 311 | 1 | 2022-05-03 | 89.46 | 2022-04-21 | 3578.27 | 1 | SO45583 | 2022-04-28 | 286.26 | 2171.29 | |
SO56911_1 | 100 | 28599 | 484 | 1 | 2024-01-01 | 0.20 | 2023-12-20 | 7.95 | 1 | SO56911 | 2023-12-27 | 0.64 | 2.97 | |
SO45594_1 | 100 | 11282 | 312 | 1 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45594 | 2022-04-30 | 286.26 | 2171.29 | |
SO56912_1 | 19 | 28783 | 217 | 1 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 1 | SO56912 | 2023-12-27 | 2.80 | 13.09 | |
SO45598_1 | 100 | 14744 | 340 | 1 | 2022-05-05 | 17.48 | 2022-04-23 | 699.10 | 1 | SO45598 | 2022-04-30 | 55.93 | 413.15 | |
SO56921_1 | 100 | 26696 | 541 | 1 | 2024-01-01 | 0.72 | 2023-12-20 | 28.99 | 1 | SO56921 | 2023-12-27 | 2.32 | 10.84 | |
SO45603_1 | 100 | 11296 | 312 | 1 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45603 | 2022-05-01 | 286.26 | 2171.29 | |
SO56921_2 | 100 | 26696 | 530 | 1 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 2 | SO56921 | 2023-12-27 | 0.40 | 1.87 | |
SO45604_1 | 100 | 11317 | 314 | 1 | 2022-05-06 | 89.46 | 2022-04-24 | 3578.27 | 1 | SO45604 | 2022-05-01 | 286.26 | 2171.29 | |
SO56921_3 | 100 | 26696 | 222 | 1 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 3 | SO56921 | 2023-12-27 | 2.80 | 13.09 | |
SO45610_1 | 100 | 11303 | 310 | 1 | 2022-05-07 | 89.46 | 2022-04-25 | 3578.27 | 1 | SO45610 | 2022-05-02 | 286.26 | 2171.29 | |
SO56923_1 | 100 | 21782 | 478 | 1 | 2024-01-01 | 0.25 | 2023-12-20 | 9.99 | 1 | SO56923 | 2023-12-27 | 0.80 | 3.74 | |
SO45611_1 | 100 | 11535 | 310 | 1 | 2022-05-07 | 89.46 | 2022-04-25 | 3578.27 | 1 | SO45611 | 2022-05-02 | 286.26 | 2171.29 | |
SO56923_2 | 100 | 21782 | 477 | 1 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 2 | SO56923 | 2023-12-27 | 0.40 | 1.87 | |
SO45613_1 | 100 | 11522 | 314 | 1 | 2022-05-08 | 89.46 | 2022-04-26 | 3578.27 | 1 | SO45613 | 2022-05-03 | 286.26 | 2171.29 | |
SO56923_3 | 100 | 21782 | 217 | 1 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 3 | SO56923 | 2023-12-27 | 2.80 | 13.09 | |
SO45626_1 | 100 | 11259 | 310 | 1 | 2022-05-09 | 89.46 | 2022-04-27 | 3578.27 | 1 | SO45626 | 2022-05-04 | 286.26 | 2171.29 | |
SO56951_1 | 100 | 28845 | 567 | 1 | 2024-01-01 | 18.56 | 2023-12-20 | 742.35 | 1 | SO56951 | 2023-12-27 | 59.39 | 461.44 | |
SO45636_1 | 100 | 11302 | 311 | 1 | 2022-05-11 | 89.46 | 2022-04-29 | 3578.27 | 1 | SO45636 | 2022-05-06 | 286.26 | 2171.29 | |
SO56952_1 | 100 | 22074 | 584 | 1 | 2024-01-01 | 13.50 | 2023-12-20 | 539.99 | 1 | SO56952 | 2023-12-27 | 43.20 | 343.65 | |
SO45637_1 | 100 | 11525 | 314 | 1 | 2022-05-11 | 89.46 | 2022-04-29 | 3578.27 | 1 | SO45637 | 2022-05-06 | 286.26 | 2171.29 | |
SO56952_2 | 100 | 22074 | 479 | 1 | 2024-01-01 | 0.22 | 2023-12-20 | 8.99 | 2 | SO56952 | 2023-12-27 | 0.72 | 3.36 | |
SO45657_1 | 100 | 11266 | 311 | 1 | 2022-05-15 | 89.46 | 2022-05-03 | 3578.27 | 1 | SO45657 | 2022-05-10 | 286.26 | 2171.29 | |
SO69061_1 | 100 | 12912 | 355 | 1 | 2024-06-28 | 58.00 | 2024-06-16 | 2319.99 | 1 | SO69061 | 2024-06-23 | 185.60 | 1265.62 | |
SO69062_1 | 100 | 12913 | 355 | 1 | 2024-06-28 | 58.00 | 2024-06-16 | 2319.99 | 1 | SO69062 | 2024-06-23 | 185.60 | 1265.62 | |
SO69062_2 | 100 | 12913 | 485 | 1 | 2024-06-28 | 0.55 | 2024-06-16 | 21.98 | 2 | SO69062 | 2024-06-23 | 1.76 | 8.22 | |
SO69062_3 | 100 | 12913 | 480 | 1 | 2024-06-28 | 0.06 | 2024-06-16 | 2.29 | 3 | SO69062 | 2024-06-23 | 0.18 | 0.86 | |
SO69074_1 | 100 | 27117 | 574 | 1 | 2024-06-28 | 59.60 | 2024-06-16 | 2384.07 | 1 | SO69074 | 2024-06-23 | 190.73 | 1481.94 | |
SO69074_2 | 100 | 27117 | 222 | 1 | 2024-06-28 | 0.87 | 2024-06-16 | 34.99 | 2 | SO69074 | 2024-06-23 | 2.80 | 13.09 | |
SO69076_1 | 100 | 25970 | 560 | 1 | 2024-06-28 | 30.37 | 2024-06-16 | 1214.85 | 1 | SO69076 | 2024-06-23 | 97.19 | 755.15 | |
SO69076_2 | 100 | 25970 | 479 | 1 | 2024-06-28 | 0.22 | 2024-06-16 | 8.99 | 2 | SO69076 | 2024-06-23 | 0.72 | 3.36 | |
SO69076_3 | 100 | 25970 | 477 | 1 | 2024-06-28 | 0.12 | 2024-06-16 | 4.99 | 3 | SO69076 | 2024-06-23 | 0.40 | 1.87 | |
SO69079_1 | 100 | 19209 | 606 | 1 | 2024-06-28 | 13.50 | 2024-06-16 | 539.99 | 1 | SO69079 | 2024-06-23 | 43.20 | 343.65 | |
SO69079_2 | 100 | 19209 | 217 | 1 | 2024-06-28 | 0.87 | 2024-06-16 | 34.99 | 2 | SO69079 | 2024-06-23 | 2.80 | 13.09 | |
SO69080_1 | 100 | 19803 | 584 | 1 | 2024-06-28 | 13.50 | 2024-06-16 | 539.99 | 1 | SO69080 | 2024-06-23 | 43.20 | 343.65 | |
SO69080_2 | 100 | 19803 | 214 | 1 | 2024-06-28 | 0.87 | 2024-06-16 | 34.99 | 2 | SO69080 | 2024-06-23 | 2.80 | 13.09 | |
SO69110_1 | 100 | 20687 | 478 | 1 | 2024-06-29 | 0.25 | 2024-06-17 | 9.99 | 1 | SO69110 | 2024-06-24 | 0.80 | 3.74 | |
SO69112_1 | 100 | 17451 | 477 | 1 | 2024-06-29 | 0.12 | 2024-06-17 | 4.99 | 1 | SO69112 | 2024-06-24 | 0.40 | 1.87 | |
SO69112_2 | 100 | 17451 | 222 | 1 | 2024-06-29 | 0.87 | 2024-06-17 | 34.99 | 2 | SO69112 | 2024-06-24 | 2.80 | 13.09 | |
SO69114_1 | 100 | 18316 | 528 | 1 | 2024-06-29 | 0.12 | 2024-06-17 | 4.99 | 1 | SO69114 | 2024-06-24 | 0.40 | 1.87 | |
SO69114_2 | 100 | 18316 | 480 | 2 | 1 | 2024-06-29 | 0.06 | 2024-06-17 | 2.29 | 2 | SO69114 | 2024-06-24 | 0.18 | 0.86 |
SO69115_1 | 100 | 15938 | 528 | 1 | 2024-06-29 | 0.12 | 2024-06-17 | 4.99 | 1 | SO69115 | 2024-06-24 | 0.40 | 1.87 | |
SO69115_2 | 100 | 15938 | 480 | 2 | 1 | 2024-06-29 | 0.06 | 2024-06-17 | 2.29 | 2 | SO69115 | 2024-06-24 | 0.18 | 0.86 |
SO69129_1 | 100 | 16882 | 363 | 2 | 1 | 2024-06-29 | 57.37 | 2024-06-17 | 2294.99 | 1 | SO69129 | 2024-06-24 | 183.60 | 1251.98 |
SO69146_1 | 100 | 27455 | 561 | 1 | 2024-06-29 | 59.60 | 2024-06-17 | 2384.07 | 1 | SO69146 | 2024-06-24 | 190.73 | 1481.94 | |
SO69146_2 | 100 | 27455 | 479 | 1 | 2024-06-29 | 0.22 | 2024-06-17 | 8.99 | 2 | SO69146 | 2024-06-24 | 0.72 | 3.36 | |
SO69146_3 | 100 | 27455 | 477 | 1 | 2024-06-29 | 0.12 | 2024-06-17 | 4.99 | 3 | SO69146 | 2024-06-24 | 0.40 | 1.87 | |
SO69146_4 | 100 | 27455 | 473 | 1 | 2024-06-29 | 1.59 | 2024-06-17 | 63.50 | 4 | SO69146 | 2024-06-24 | 5.08 | 23.75 | |
SO69147_1 | 100 | 27116 | 573 | 1 | 2024-06-29 | 59.60 | 2024-06-17 | 2384.07 | 1 | SO69147 | 2024-06-24 | 190.73 | 1481.94 |
Generated 2024-09-20 10:30:03.727 UTC