[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2516 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45175_1 | 100 | 29238 | 313 | 4 | 2022-03-21 | 89.46 | 2022-03-09 | 3578.27 | 1 | SO45175 | 2022-03-16 | 286.26 | 2171.29 | |
SO56118_2 | 100 | 24807 | 217 | 4 | 2023-12-16 | 0.87 | 2023-12-04 | 34.99 | 2 | SO56118 | 2023-12-11 | 2.80 | 13.09 | |
SO45176_1 | 100 | 29254 | 313 | 1 | 2022-03-21 | 89.46 | 2022-03-09 | 3578.27 | 1 | SO45176 | 2022-03-16 | 286.26 | 2171.29 | |
SO56118_3 | 100 | 24807 | 234 | 4 | 2023-12-16 | 1.25 | 2023-12-04 | 49.99 | 3 | SO56118 | 2023-12-11 | 4.00 | 38.49 | |
SO45177_1 | 6 | 18903 | 314 | 9 | 2022-03-21 | 89.46 | 2022-03-09 | 3578.27 | 1 | SO45177 | 2022-03-16 | 286.26 | 2171.29 | |
SO56119_1 | 100 | 22092 | 604 | 1 | 2023-12-16 | 13.50 | 2023-12-04 | 539.99 | 1 | SO56119 | 2023-12-11 | 43.20 | 343.65 | |
SO45178_1 | 6 | 11456 | 347 | 9 | 2022-03-21 | 85.00 | 2022-03-09 | 3399.99 | 1 | SO45178 | 2022-03-16 | 272.00 | 1912.15 | |
SO56119_2 | 100 | 22092 | 538 | 1 | 2023-12-16 | 0.54 | 2023-12-04 | 21.49 | 2 | SO56119 | 2023-12-11 | 1.72 | 8.04 | |
SO45179_1 | 6 | 11457 | 351 | 9 | 2022-03-21 | 84.37 | 2022-03-09 | 3374.99 | 1 | SO45179 | 2022-03-16 | 270.00 | 1898.09 | |
SO56119_3 | 100 | 22092 | 480 | 1 | 2023-12-16 | 0.06 | 2023-12-04 | 2.29 | 3 | SO56119 | 2023-12-11 | 0.18 | 0.86 | |
SO45180_1 | 98 | 15046 | 311 | 10 | 2022-03-22 | 89.46 | 2022-03-10 | 3578.27 | 1 | SO45180 | 2022-03-17 | 286.26 | 2171.29 | |
SO56120_1 | 19 | 25104 | 584 | 6 | 2023-12-16 | 13.50 | 2023-12-04 | 539.99 | 1 | SO56120 | 2023-12-11 | 43.20 | 343.65 | |
SO45181_1 | 98 | 14929 | 310 | 10 | 2022-03-22 | 89.46 | 2022-03-10 | 3578.27 | 1 | SO45181 | 2022-03-17 | 286.26 | 2171.29 | |
SO56120_2 | 19 | 25104 | 217 | 6 | 2023-12-16 | 0.87 | 2023-12-04 | 34.99 | 2 | SO56120 | 2023-12-11 | 2.80 | 13.09 | |
SO45182_1 | 6 | 18769 | 312 | 9 | 2022-03-22 | 89.46 | 2022-03-10 | 3578.27 | 1 | SO45182 | 2022-03-17 | 286.26 | 2171.29 | |
SO56121_1 | 100 | 22054 | 604 | 4 | 2023-12-16 | 13.50 | 2023-12-04 | 539.99 | 1 | SO56121 | 2023-12-11 | 43.20 | 343.65 | |
SO45183_1 | 6 | 25711 | 334 | 9 | 2022-03-22 | 17.48 | 2022-03-10 | 699.10 | 1 | SO45183 | 2022-03-17 | 55.93 | 413.15 | |
SO56121_2 | 100 | 22054 | 538 | 4 | 2023-12-16 | 0.54 | 2023-12-04 | 21.49 | 2 | SO56121 | 2023-12-11 | 1.72 | 8.04 | |
SO45184_1 | 6 | 25717 | 320 | 9 | 2022-03-22 | 17.48 | 2022-03-10 | 699.10 | 1 | SO45184 | 2022-03-17 | 55.93 | 413.15 | |
SO56121_3 | 100 | 22054 | 480 | 4 | 2023-12-16 | 0.06 | 2023-12-04 | 2.29 | 3 | SO56121 | 2023-12-11 | 0.18 | 0.86 | |
SO45185_1 | 98 | 14949 | 310 | 10 | 2022-03-22 | 89.46 | 2022-03-10 | 3578.27 | 1 | SO45185 | 2022-03-17 | 286.26 | 2171.29 | |
SO56122_1 | 19 | 18617 | 386 | 6 | 2023-12-16 | 28.01 | 2023-12-04 | 1120.49 | 1 | SO56122 | 2023-12-11 | 89.64 | 713.08 | |
SO45186_1 | 98 | 14991 | 313 | 10 | 2022-03-23 | 89.46 | 2022-03-11 | 3578.27 | 1 | SO45186 | 2022-03-18 | 286.26 | 2171.29 | |
SO56122_2 | 19 | 18617 | 539 | 6 | 2023-12-16 | 0.62 | 2023-12-04 | 24.99 | 2 | SO56122 | 2023-12-11 | 2.00 | 9.35 | |
SO45187_1 | 98 | 15047 | 310 | 10 | 2022-03-23 | 89.46 | 2022-03-11 | 3578.27 | 1 | SO45187 | 2022-03-18 | 286.26 | 2171.29 | |
SO56122_3 | 19 | 18617 | 480 | 2 | 6 | 2023-12-16 | 0.06 | 2023-12-04 | 2.29 | 3 | SO56122 | 2023-12-11 | 0.18 | 0.86 |
SO45188_1 | 98 | 14861 | 311 | 10 | 2022-03-23 | 89.46 | 2022-03-11 | 3578.27 | 1 | SO45188 | 2022-03-18 | 286.26 | 2171.29 | |
SO56123_1 | 100 | 21089 | 605 | 7 | 2023-12-16 | 13.50 | 2023-12-04 | 539.99 | 1 | SO56123 | 2023-12-11 | 43.20 | 343.65 | |
SO45189_1 | 100 | 29145 | 310 | 1 | 2022-03-23 | 89.46 | 2022-03-11 | 3578.27 | 1 | SO45189 | 2022-03-18 | 286.26 | 2171.29 | |
SO56123_2 | 100 | 21089 | 538 | 7 | 2023-12-16 | 0.54 | 2023-12-04 | 21.49 | 2 | SO56123 | 2023-12-11 | 1.72 | 8.04 | |
SO45190_1 | 6 | 18931 | 313 | 9 | 2022-03-23 | 89.46 | 2022-03-11 | 3578.27 | 1 | SO45190 | 2022-03-18 | 286.26 | 2171.29 | |
SO56124_1 | 98 | 28712 | 574 | 10 | 2023-12-16 | 59.60 | 2023-12-04 | 2384.07 | 1 | SO56124 | 2023-12-11 | 190.73 | 1481.94 | |
SO45191_1 | 100 | 14660 | 328 | 1 | 2022-03-23 | 17.48 | 2022-03-11 | 699.10 | 1 | SO45191 | 2022-03-18 | 55.93 | 413.15 | |
SO56124_2 | 98 | 28712 | 479 | 10 | 2023-12-16 | 0.22 | 2023-12-04 | 8.99 | 2 | SO56124 | 2023-12-11 | 0.72 | 3.36 | |
SO45192_1 | 98 | 14846 | 314 | 10 | 2022-03-24 | 89.46 | 2022-03-12 | 3578.27 | 1 | SO45192 | 2022-03-19 | 286.26 | 2171.29 | |
SO56125_1 | 6 | 24912 | 384 | 9 | 2023-12-17 | 28.01 | 2023-12-05 | 1120.49 | 1 | SO56125 | 2023-12-12 | 89.64 | 713.08 | |
SO45193_1 | 19 | 22889 | 310 | 6 | 2022-03-24 | 89.46 | 2022-03-12 | 3578.27 | 1 | SO45193 | 2022-03-19 | 286.26 | 2171.29 | |
SO56126_1 | 98 | 11615 | 353 | 2 | 10 | 2023-12-17 | 58.00 | 2023-12-05 | 2319.99 | 1 | SO56126 | 2023-12-12 | 185.60 | 1265.62 |
SO45194_1 | 100 | 29221 | 313 | 4 | 2022-03-24 | 89.46 | 2022-03-12 | 3578.27 | 1 | SO45194 | 2022-03-19 | 286.26 | 2171.29 | |
SO56126_2 | 98 | 11615 | 485 | 10 | 2023-12-17 | 0.55 | 2023-12-05 | 21.98 | 2 | SO56126 | 2023-12-12 | 1.76 | 8.22 | |
SO45195_1 | 6 | 18929 | 313 | 9 | 2022-03-24 | 89.46 | 2022-03-12 | 3578.27 | 1 | SO45195 | 2022-03-19 | 286.26 | 2171.29 | |
SO56126_3 | 98 | 11615 | 478 | 10 | 2023-12-17 | 0.25 | 2023-12-05 | 9.99 | 3 | SO56126 | 2023-12-12 | 0.80 | 3.74 | |
SO45196_1 | 6 | 18739 | 311 | 9 | 2022-03-24 | 89.46 | 2022-03-12 | 3578.27 | 1 | SO45196 | 2022-03-19 | 286.26 | 2171.29 | |
SO56126_4 | 98 | 11615 | 477 | 10 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 4 | SO56126 | 2023-12-12 | 0.40 | 1.87 | |
SO45197_1 | 6 | 18902 | 314 | 9 | 2022-03-24 | 89.46 | 2022-03-12 | 3578.27 | 1 | SO45197 | 2022-03-19 | 286.26 | 2171.29 | |
SO56127_1 | 98 | 12648 | 363 | 10 | 2023-12-17 | 57.37 | 2023-12-05 | 2294.99 | 1 | SO56127 | 2023-12-12 | 183.60 | 1251.98 | |
SO45198_1 | 98 | 14847 | 313 | 10 | 2022-03-25 | 89.46 | 2022-03-13 | 3578.27 | 1 | SO45198 | 2022-03-20 | 286.26 | 2171.29 | |
SO56127_2 | 98 | 12648 | 485 | 10 | 2023-12-17 | 0.55 | 2023-12-05 | 21.98 | 2 | SO56127 | 2023-12-12 | 1.76 | 8.22 | |
SO45199_1 | 100 | 29476 | 346 | 8 | 2022-03-25 | 85.00 | 2022-03-13 | 3399.99 | 1 | SO45199 | 2022-03-20 | 272.00 | 1912.15 | |
SO56127_3 | 98 | 12648 | 482 | 10 | 2023-12-17 | 0.22 | 2023-12-05 | 8.99 | 3 | SO56127 | 2023-12-12 | 0.72 | 3.36 | |
SO45200_1 | 100 | 29148 | 311 | 4 | 2022-03-25 | 89.46 | 2022-03-13 | 3578.27 | 1 | SO45200 | 2022-03-20 | 286.26 | 2171.29 | |
SO56128_1 | 6 | 14070 | 577 | 9 | 2023-12-17 | 30.37 | 2023-12-05 | 1214.85 | 1 | SO56128 | 2023-12-12 | 97.19 | 755.15 | |
SO45201_1 | 100 | 29168 | 312 | 4 | 2022-03-25 | 89.46 | 2022-03-13 | 3578.27 | 1 | SO45201 | 2022-03-20 | 286.26 | 2171.29 | |
SO56128_2 | 6 | 14070 | 217 | 9 | 2023-12-17 | 0.87 | 2023-12-05 | 34.99 | 2 | SO56128 | 2023-12-12 | 2.80 | 13.09 | |
SO45202_1 | 6 | 19094 | 314 | 9 | 2022-03-25 | 89.46 | 2022-03-13 | 3578.27 | 1 | SO45202 | 2022-03-20 | 286.26 | 2171.29 | |
SO56129_1 | 6 | 15795 | 539 | 9 | 2023-12-17 | 0.62 | 2023-12-05 | 24.99 | 1 | SO56129 | 2023-12-12 | 2.00 | 9.35 |
Generated 2024-09-20 09:59:46.997 UTC