[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2097 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55972_1 | 6 | 13639 | 528 | 9 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 1 | SO55972 | 2023-12-09 | 0.40 | 1.87 | |
SO45114_1 | 100 | 29146 | 310 | 1 | 2022-03-12 | 89.46 | 2022-02-28 | 3578.27 | 1 | SO45114 | 2022-03-07 | 286.26 | 2171.29 | |
SO55972_2 | 6 | 13639 | 535 | 9 | 2023-12-14 | 0.62 | 2023-12-02 | 24.99 | 2 | SO55972 | 2023-12-09 | 2.00 | 9.35 | |
SO45115_1 | 100 | 25984 | 348 | 4 | 2022-03-12 | 84.37 | 2022-02-28 | 3374.99 | 1 | SO45115 | 2022-03-07 | 270.00 | 1898.09 | |
SO55972_3 | 6 | 13639 | 214 | 9 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 3 | SO55972 | 2023-12-09 | 2.80 | 13.09 | |
SO45116_1 | 100 | 29204 | 311 | 1 | 2022-03-12 | 89.46 | 2022-02-28 | 3578.27 | 1 | SO45116 | 2022-03-07 | 286.26 | 2171.29 | |
SO55973_1 | 6 | 11045 | 528 | 9 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 1 | SO55973 | 2023-12-09 | 0.40 | 1.87 | |
SO45117_1 | 100 | 14727 | 342 | 1 | 2022-03-12 | 17.48 | 2022-02-28 | 699.10 | 1 | SO45117 | 2022-03-07 | 55.93 | 413.15 | |
SO55973_2 | 6 | 11045 | 535 | 9 | 2023-12-14 | 0.62 | 2023-12-02 | 24.99 | 2 | SO55973 | 2023-12-09 | 2.00 | 9.35 | |
SO45118_1 | 6 | 18722 | 314 | 9 | 2022-03-12 | 89.46 | 2022-02-28 | 3578.27 | 1 | SO45118 | 2022-03-07 | 286.26 | 2171.29 | |
SO55973_3 | 6 | 11045 | 222 | 9 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 3 | SO55973 | 2023-12-09 | 2.80 | 13.09 | |
SO45119_1 | 6 | 18740 | 314 | 9 | 2022-03-12 | 89.46 | 2022-02-28 | 3578.27 | 1 | SO45119 | 2022-03-07 | 286.26 | 2171.29 | |
SO55974_1 | 6 | 16692 | 539 | 9 | 2023-12-14 | 0.62 | 2023-12-02 | 24.99 | 1 | SO55974 | 2023-12-09 | 2.00 | 9.35 | |
SO45120_1 | 6 | 11751 | 344 | 9 | 2022-03-12 | 85.00 | 2022-02-28 | 3399.99 | 1 | SO45120 | 2022-03-07 | 272.00 | 1912.15 | |
SO55975_1 | 6 | 20602 | 538 | 9 | 2023-12-14 | 0.54 | 2023-12-02 | 21.49 | 1 | SO55975 | 2023-12-09 | 1.72 | 8.04 | |
SO45121_1 | 100 | 29169 | 310 | 1 | 2022-03-13 | 89.46 | 2022-03-01 | 3578.27 | 1 | SO45121 | 2022-03-08 | 286.26 | 2171.29 | |
SO55975_2 | 6 | 20602 | 529 | 9 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 2 | SO55975 | 2023-12-09 | 0.32 | 1.49 | |
SO45122_1 | 100 | 29236 | 314 | 4 | 2022-03-13 | 89.46 | 2022-03-01 | 3578.27 | 1 | SO45122 | 2022-03-08 | 286.26 | 2171.29 | |
SO55975_3 | 6 | 20602 | 487 | 9 | 2023-12-14 | 1.37 | 2023-12-02 | 54.99 | 3 | SO55975 | 2023-12-09 | 4.40 | 20.57 | |
SO45123_1 | 19 | 22971 | 311 | 6 | 2022-03-13 | 89.46 | 2022-03-01 | 3578.27 | 1 | SO45123 | 2022-03-08 | 286.26 | 2171.29 | |
SO55976_1 | 6 | 13045 | 222 | 9 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 1 | SO55976 | 2023-12-09 | 2.80 | 13.09 | |
SO45124_1 | 6 | 18725 | 313 | 9 | 2022-03-13 | 89.46 | 2022-03-01 | 3578.27 | 1 | SO45124 | 2022-03-08 | 286.26 | 2171.29 | |
SO55977_1 | 6 | 17254 | 489 | 9 | 2023-12-14 | 1.35 | 2023-12-02 | 53.99 | 1 | SO55977 | 2023-12-09 | 4.32 | 41.57 | |
SO45125_1 | 6 | 18708 | 312 | 9 | 2022-03-13 | 89.46 | 2022-03-01 | 3578.27 | 1 | SO45125 | 2022-03-08 | 286.26 | 2171.29 | |
SO55978_1 | 100 | 16390 | 374 | 2 | 8 | 2023-12-14 | 61.08 | 2023-12-02 | 2443.35 | 1 | SO55978 | 2023-12-09 | 195.47 | 1554.95 |
SO45126_1 | 100 | 12480 | 311 | 7 | 2022-03-14 | 89.46 | 2022-03-02 | 3578.27 | 1 | SO45126 | 2022-03-09 | 286.26 | 2171.29 | |
SO55978_2 | 100 | 16390 | 540 | 8 | 2023-12-14 | 0.82 | 2023-12-02 | 32.60 | 2 | SO55978 | 2023-12-09 | 2.61 | 12.19 | |
SO45127_1 | 100 | 29158 | 313 | 1 | 2022-03-14 | 89.46 | 2022-03-02 | 3578.27 | 1 | SO45127 | 2022-03-09 | 286.26 | 2171.29 | |
SO55979_1 | 100 | 23906 | 378 | 8 | 2023-12-14 | 61.08 | 2023-12-02 | 2443.35 | 1 | SO55979 | 2023-12-09 | 195.47 | 1554.95 | |
SO45128_1 | 6 | 18726 | 310 | 9 | 2022-03-14 | 89.46 | 2022-03-02 | 3578.27 | 1 | SO45128 | 2022-03-09 | 286.26 | 2171.29 | |
SO55980_1 | 100 | 12332 | 376 | 7 | 2023-12-14 | 61.08 | 2023-12-02 | 2443.35 | 1 | SO55980 | 2023-12-09 | 195.47 | 1554.95 | |
SO45129_1 | 6 | 11759 | 350 | 9 | 2022-03-14 | 84.37 | 2022-03-02 | 3374.99 | 1 | SO45129 | 2022-03-09 | 270.00 | 1898.09 | |
SO55980_2 | 100 | 12332 | 529 | 7 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 2 | SO55980 | 2023-12-09 | 0.32 | 1.49 | |
SO45130_1 | 98 | 14975 | 313 | 10 | 2022-03-15 | 89.46 | 2022-03-03 | 3578.27 | 1 | SO45130 | 2022-03-10 | 286.26 | 2171.29 | |
SO55980_3 | 100 | 12332 | 540 | 7 | 2023-12-14 | 0.82 | 2023-12-02 | 32.60 | 3 | SO55980 | 2023-12-09 | 2.61 | 12.19 | |
SO45131_1 | 100 | 25979 | 344 | 1 | 2022-03-15 | 85.00 | 2022-03-03 | 3399.99 | 1 | SO45131 | 2022-03-10 | 272.00 | 1912.15 | |
SO55980_4 | 100 | 12332 | 480 | 7 | 2023-12-14 | 0.06 | 2023-12-02 | 2.29 | 4 | SO55980 | 2023-12-09 | 0.18 | 0.86 | |
SO45132_1 | 100 | 25985 | 350 | 4 | 2022-03-15 | 84.37 | 2022-03-03 | 3374.99 | 1 | SO45132 | 2022-03-10 | 270.00 | 1898.09 | |
SO55981_1 | 100 | 11127 | 529 | 4 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 1 | SO55981 | 2023-12-09 | 0.32 | 1.49 | |
SO45133_1 | 100 | 29163 | 314 | 1 | 2022-03-15 | 89.46 | 2022-03-03 | 3578.27 | 1 | SO45133 | 2022-03-10 | 286.26 | 2171.29 | |
SO55982_1 | 19 | 11176 | 529 | 6 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 1 | SO55982 | 2023-12-09 | 0.32 | 1.49 | |
SO45134_1 | 19 | 22895 | 314 | 6 | 2022-03-15 | 89.46 | 2022-03-03 | 3578.27 | 1 | SO45134 | 2022-03-10 | 286.26 | 2171.29 | |
SO55982_2 | 19 | 11176 | 539 | 6 | 2023-12-14 | 0.62 | 2023-12-02 | 24.99 | 2 | SO55982 | 2023-12-09 | 2.00 | 9.35 | |
SO45135_1 | 100 | 29264 | 310 | 4 | 2022-03-15 | 89.46 | 2022-03-03 | 3578.27 | 1 | SO45135 | 2022-03-10 | 286.26 | 2171.29 | |
SO55982_3 | 19 | 11176 | 214 | 6 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 3 | SO55982 | 2023-12-09 | 2.80 | 13.09 | |
SO45136_1 | 6 | 19084 | 312 | 9 | 2022-03-15 | 89.46 | 2022-03-03 | 3578.27 | 1 | SO45136 | 2022-03-10 | 286.26 | 2171.29 | |
SO55983_1 | 100 | 25929 | 535 | 1 | 2023-12-14 | 0.62 | 2023-12-02 | 24.99 | 1 | SO55983 | 2023-12-09 | 2.00 | 9.35 | |
SO45137_1 | 6 | 18735 | 310 | 9 | 2022-03-15 | 89.46 | 2022-03-03 | 3578.27 | 1 | SO45137 | 2022-03-10 | 286.26 | 2171.29 | |
SO55983_2 | 100 | 25929 | 480 | 1 | 2023-12-14 | 0.06 | 2023-12-02 | 2.29 | 2 | SO55983 | 2023-12-09 | 0.18 | 0.86 | |
SO45138_1 | 6 | 11452 | 349 | 9 | 2022-03-15 | 84.37 | 2022-03-03 | 3374.99 | 1 | SO45138 | 2022-03-10 | 270.00 | 1898.09 | |
SO55984_1 | 100 | 24772 | 529 | 4 | 2023-12-14 | 0.10 | 2023-12-02 | 3.99 | 1 | SO55984 | 2023-12-09 | 0.32 | 1.49 | |
SO45139_1 | 100 | 12468 | 314 | 7 | 2022-03-16 | 89.46 | 2022-03-04 | 3578.27 | 1 | SO45139 | 2022-03-11 | 286.26 | 2171.29 | |
SO55984_2 | 100 | 24772 | 540 | 4 | 2023-12-14 | 0.82 | 2023-12-02 | 32.60 | 2 | SO55984 | 2023-12-09 | 2.61 | 12.19 | |
SO45140_1 | 100 | 12485 | 312 | 7 | 2022-03-16 | 89.46 | 2022-03-04 | 3578.27 | 1 | SO45140 | 2022-03-11 | 286.26 | 2171.29 | |
SO55984_3 | 100 | 24772 | 486 | 4 | 2023-12-14 | 3.98 | 2023-12-02 | 159.00 | 3 | SO55984 | 2023-12-09 | 12.72 | 59.47 | |
SO45141_1 | 100 | 29222 | 312 | 4 | 2022-03-16 | 89.46 | 2022-03-04 | 3578.27 | 1 | SO45141 | 2022-03-11 | 286.26 | 2171.29 | |
SO55985_1 | 100 | 23728 | 528 | 4 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 1 | SO55985 | 2023-12-09 | 0.40 | 1.87 | |
SO45142_1 | 19 | 22901 | 311 | 6 | 2022-03-16 | 89.46 | 2022-03-04 | 3578.27 | 1 | SO45142 | 2022-03-11 | 286.26 | 2171.29 | |
SO55985_2 | 100 | 23728 | 536 | 4 | 2023-12-14 | 0.75 | 2023-12-02 | 29.99 | 2 | SO55985 | 2023-12-09 | 2.40 | 11.22 | |
SO45143_1 | 100 | 29278 | 310 | 4 | 2022-03-16 | 89.46 | 2022-03-04 | 3578.27 | 1 | SO45143 | 2022-03-11 | 286.26 | 2171.29 | |
SO55985_3 | 100 | 23728 | 217 | 4 | 2023-12-14 | 0.87 | 2023-12-02 | 34.99 | 3 | SO55985 | 2023-12-09 | 2.80 | 13.09 | |
SO45144_1 | 6 | 19093 | 311 | 9 | 2022-03-16 | 89.46 | 2022-03-04 | 3578.27 | 1 | SO45144 | 2022-03-11 | 286.26 | 2171.29 |
Generated 2024-09-20 09:58:26.248 UTC