[ROOT] dt FactInternetSale < WHERE DimProductId EQ ALL < SKIP 1250 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55854_4 | 100 | 14887 | 228 | 1 | 2023-09-28 | 1.25 | 2023-09-16 | 49.99 | 4 | SO55854 | 2023-09-23 | 4.00 | 38.49 |
SO55855_1 | 100 | 11617 | 357 | 4 | 2023-09-28 | 58.00 | 2023-09-16 | 2319.99 | 1 | SO55855 | 2023-09-23 | 185.60 | 1265.62 |
SO55855_2 | 100 | 11617 | 537 | 4 | 2023-09-28 | 0.88 | 2023-09-16 | 35.00 | 2 | SO55855 | 2023-09-23 | 2.80 | 13.09 |
SO55855_3 | 100 | 11617 | 480 | 4 | 2023-09-28 | 0.06 | 2023-09-16 | 2.29 | 3 | SO55855 | 2023-09-23 | 0.18 | 0.86 |
SO55856_1 | 100 | 11626 | 363 | 4 | 2023-09-28 | 57.37 | 2023-09-16 | 2294.99 | 1 | SO55856 | 2023-09-23 | 183.60 | 1251.98 |
SO55856_2 | 100 | 11626 | 485 | 4 | 2023-09-28 | 0.55 | 2023-09-16 | 21.98 | 2 | SO55856 | 2023-09-23 | 1.76 | 8.22 |
SO55856_3 | 100 | 11626 | 471 | 4 | 2023-09-28 | 1.59 | 2023-09-16 | 63.50 | 3 | SO55856 | 2023-09-23 | 5.08 | 23.75 |
SO55857_1 | 98 | 29432 | 577 | 10 | 2023-09-28 | 30.37 | 2023-09-16 | 1214.85 | 1 | SO55857 | 2023-09-23 | 97.19 | 755.15 |
SO55857_2 | 98 | 29432 | 479 | 10 | 2023-09-28 | 0.22 | 2023-09-16 | 8.99 | 2 | SO55857 | 2023-09-23 | 0.72 | 3.36 |
SO55857_3 | 98 | 29432 | 477 | 10 | 2023-09-28 | 0.12 | 2023-09-16 | 4.99 | 3 | SO55857 | 2023-09-23 | 0.40 | 1.87 |
SO55857_4 | 98 | 29432 | 489 | 10 | 2023-09-28 | 1.35 | 2023-09-16 | 53.99 | 4 | SO55857 | 2023-09-23 | 4.32 | 41.57 |
SO55857_5 | 98 | 29432 | 465 | 10 | 2023-09-28 | 0.61 | 2023-09-16 | 24.49 | 5 | SO55857 | 2023-09-23 | 1.96 | 9.16 |
SO55858_1 | 6 | 29292 | 225 | 9 | 2023-09-28 | 0.22 | 2023-09-16 | 8.99 | 1 | SO55858 | 2023-09-23 | 0.72 | 6.92 |
SO55858_2 | 6 | 29292 | 561 | 9 | 2023-09-28 | 59.60 | 2023-09-16 | 2384.07 | 2 | SO55858 | 2023-09-23 | 190.73 | 1481.94 |
SO55859_1 | 6 | 12342 | 353 | 9 | 2023-09-28 | 58.00 | 2023-09-16 | 2319.99 | 1 | SO55859 | 2023-09-23 | 185.60 | 1265.62 |
SO55859_2 | 6 | 12342 | 478 | 9 | 2023-09-28 | 0.25 | 2023-09-16 | 9.99 | 2 | SO55859 | 2023-09-23 | 0.80 | 3.74 |
SO55859_3 | 6 | 12342 | 477 | 9 | 2023-09-28 | 0.12 | 2023-09-16 | 4.99 | 3 | SO55859 | 2023-09-23 | 0.40 | 1.87 |
SO55859_4 | 6 | 12342 | 222 | 9 | 2023-09-28 | 0.87 | 2023-09-16 | 34.99 | 4 | SO55859 | 2023-09-23 | 2.80 | 13.09 |
SO55860_1 | 6 | 11112 | 355 | 9 | 2023-09-28 | 58.00 | 2023-09-16 | 2319.99 | 1 | SO55860 | 2023-09-23 | 185.60 | 1265.62 |
SO55860_2 | 6 | 11112 | 485 | 9 | 2023-09-28 | 0.55 | 2023-09-16 | 21.98 | 2 | SO55860 | 2023-09-23 | 1.76 | 8.22 |
SO55860_3 | 6 | 11112 | 486 | 9 | 2023-09-28 | 3.98 | 2023-09-16 | 159.00 | 3 | SO55860 | 2023-09-23 | 12.72 | 59.47 |
SO55861_1 | 100 | 25015 | 562 | 4 | 2023-09-28 | 59.60 | 2023-09-16 | 2384.07 | 1 | SO55861 | 2023-09-23 | 190.73 | 1481.94 |
SO55861_2 | 100 | 25015 | 477 | 4 | 2023-09-28 | 0.12 | 2023-09-16 | 4.99 | 2 | SO55861 | 2023-09-23 | 0.40 | 1.87 |
SO55861_3 | 100 | 25015 | 479 | 4 | 2023-09-28 | 0.22 | 2023-09-16 | 8.99 | 3 | SO55861 | 2023-09-23 | 0.72 | 3.36 |
SO55861_4 | 100 | 25015 | 473 | 4 | 2023-09-28 | 1.59 | 2023-09-16 | 63.50 | 4 | SO55861 | 2023-09-23 | 5.08 | 23.75 |
SO55862_1 | 100 | 24808 | 562 | 4 | 2023-09-28 | 59.60 | 2023-09-16 | 2384.07 | 1 | SO55862 | 2023-09-23 | 190.73 | 1481.94 |
SO55862_2 | 100 | 24808 | 477 | 4 | 2023-09-28 | 0.12 | 2023-09-16 | 4.99 | 2 | SO55862 | 2023-09-23 | 0.40 | 1.87 |
SO55862_3 | 100 | 24808 | 479 | 4 | 2023-09-28 | 0.22 | 2023-09-16 | 8.99 | 3 | SO55862 | 2023-09-23 | 0.72 | 3.36 |
SO55862_4 | 100 | 24808 | 225 | 4 | 2023-09-28 | 0.22 | 2023-09-16 | 8.99 | 4 | SO55862 | 2023-09-23 | 0.72 | 6.92 |
SO55863_1 | 19 | 11328 | 563 | 6 | 2023-09-28 | 59.60 | 2023-09-16 | 2384.07 | 1 | SO55863 | 2023-09-23 | 190.73 | 1481.94 |
SO44152_1 | 98 | 11334 | 346 | 10 | 2021-08-24 | 85.00 | 2021-08-12 | 3399.99 | 1 | SO44152 | 2021-08-19 | 272.00 | 1912.15 |
SO44153_1 | 100 | 28168 | 312 | 4 | 2021-08-24 | 89.46 | 2021-08-12 | 3578.27 | 1 | SO44153 | 2021-08-19 | 286.26 | 2171.29 |
SO44154_1 | 100 | 28181 | 311 | 1 | 2021-08-24 | 89.46 | 2021-08-12 | 3578.27 | 1 | SO44154 | 2021-08-19 | 286.26 | 2171.29 |
SO44155_1 | 100 | 28131 | 313 | 4 | 2021-08-24 | 89.46 | 2021-08-12 | 3578.27 | 1 | SO44155 | 2021-08-19 | 286.26 | 2171.29 |
SO44156_1 | 100 | 25887 | 346 | 1 | 2021-08-24 | 85.00 | 2021-08-12 | 3399.99 | 1 | SO44156 | 2021-08-19 | 272.00 | 1912.15 |
SO44157_1 | 6 | 17055 | 314 | 9 | 2021-08-24 | 89.46 | 2021-08-12 | 3578.27 | 1 | SO44157 | 2021-08-19 | 286.26 | 2171.29 |
SO44158_1 | 29 | 13567 | 311 | 8 | 2021-08-25 | 89.46 | 2021-08-13 | 3578.27 | 1 | SO44158 | 2021-08-20 | 286.26 | 2171.29 |
SO44159_1 | 100 | 28182 | 311 | 4 | 2021-08-25 | 89.46 | 2021-08-13 | 3578.27 | 1 | SO44159 | 2021-08-20 | 286.26 | 2171.29 |
SO44160_1 | 100 | 28186 | 312 | 1 | 2021-08-25 | 89.46 | 2021-08-13 | 3578.27 | 1 | SO44160 | 2021-08-20 | 286.26 | 2171.29 |
SO44161_1 | 98 | 13772 | 314 | 10 | 2021-08-26 | 89.46 | 2021-08-14 | 3578.27 | 1 | SO44161 | 2021-08-21 | 286.26 | 2171.29 |
SO44162_1 | 100 | 28185 | 311 | 4 | 2021-08-26 | 89.46 | 2021-08-14 | 3578.27 | 1 | SO44162 | 2021-08-21 | 286.26 | 2171.29 |
SO44163_1 | 100 | 28193 | 314 | 4 | 2021-08-26 | 89.46 | 2021-08-14 | 3578.27 | 1 | SO44163 | 2021-08-21 | 286.26 | 2171.29 |
SO44164_1 | 100 | 28088 | 310 | 4 | 2021-08-26 | 89.46 | 2021-08-14 | 3578.27 | 1 | SO44164 | 2021-08-21 | 286.26 | 2171.29 |
SO44165_1 | 6 | 17065 | 313 | 9 | 2021-08-26 | 89.46 | 2021-08-14 | 3578.27 | 1 | SO44165 | 2021-08-21 | 286.26 | 2171.29 |
SO44166_1 | 100 | 14581 | 338 | 1 | 2021-08-26 | 17.48 | 2021-08-14 | 699.10 | 1 | SO44166 | 2021-08-21 | 55.93 | 413.15 |
SO44167_1 | 6 | 17308 | 314 | 9 | 2021-08-26 | 89.46 | 2021-08-14 | 3578.27 | 1 | SO44167 | 2021-08-21 | 286.26 | 2171.29 |
SO44168_1 | 39 | 12211 | 313 | 7 | 2021-08-27 | 89.46 | 2021-08-15 | 3578.27 | 1 | SO44168 | 2021-08-22 | 286.26 | 2171.29 |
SO44169_1 | 100 | 28179 | 311 | 1 | 2021-08-27 | 89.46 | 2021-08-15 | 3578.27 | 1 | SO44169 | 2021-08-22 | 286.26 | 2171.29 |
SO55863_2 | 19 | 11328 | 479 | 6 | 2023-09-28 | 0.22 | 2023-09-16 | 8.99 | 2 | SO55863 | 2023-09-23 | 0.72 | 3.36 |
SO44170_1 | 100 | 28183 | 314 | 4 | 2021-08-27 | 89.46 | 2021-08-15 | 3578.27 | 1 | SO44170 | 2021-08-22 | 286.26 | 2171.29 |
SO55863_3 | 19 | 11328 | 477 | 6 | 2023-09-28 | 0.12 | 2023-09-16 | 4.99 | 3 | SO55863 | 2023-09-23 | 0.40 | 1.87 |
SO44171_1 | 100 | 28112 | 313 | 4 | 2021-08-27 | 89.46 | 2021-08-15 | 3578.27 | 1 | SO44171 | 2021-08-22 | 286.26 | 2171.29 |
SO55864_1 | 100 | 25724 | 561 | 8 | 2023-09-28 | 59.60 | 2023-09-16 | 2384.07 | 1 | SO55864 | 2023-09-23 | 190.73 | 1481.94 |
SO44172_1 | 100 | 14584 | 338 | 4 | 2021-08-27 | 17.48 | 2021-08-15 | 699.10 | 1 | SO44172 | 2021-08-22 | 55.93 | 413.15 |
SO55864_2 | 100 | 25724 | 477 | 8 | 2023-09-28 | 0.12 | 2023-09-16 | 4.99 | 2 | SO55864 | 2023-09-23 | 0.40 | 1.87 |
SO44173_1 | 98 | 13784 | 312 | 10 | 2021-08-28 | 89.46 | 2021-08-16 | 3578.27 | 1 | SO44173 | 2021-08-23 | 286.26 | 2171.29 |
SO55864_3 | 100 | 25724 | 479 | 8 | 2023-09-28 | 0.22 | 2023-09-16 | 8.99 | 3 | SO55864 | 2023-09-23 | 0.72 | 3.36 |
SO44174_1 | 6 | 17229 | 311 | 9 | 2021-08-28 | 89.46 | 2021-08-16 | 3578.27 | 1 | SO44174 | 2021-08-23 | 286.26 | 2171.29 |
SO55864_4 | 100 | 25724 | 222 | 8 | 2023-09-28 | 0.87 | 2023-09-16 | 34.99 | 4 | SO55864 | 2023-09-23 | 2.80 | 13.09 |
SO44175_1 | 6 | 17246 | 313 | 9 | 2021-08-28 | 89.46 | 2021-08-16 | 3578.27 | 1 | SO44175 | 2021-08-23 | 286.26 | 2171.29 |
SO55864_5 | 100 | 25724 | 225 | 8 | 2023-09-28 | 0.22 | 2023-09-16 | 8.99 | 5 | SO55864 | 2023-09-23 | 0.72 | 6.92 |
SO44176_1 | 39 | 12220 | 314 | 7 | 2021-08-29 | 89.46 | 2021-08-17 | 3578.27 | 1 | SO44176 | 2021-08-24 | 286.26 | 2171.29 |
Generated 2024-07-08 13:31:31.855 UTC