[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1422 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46170_1 | 100 | 12156 | 312 | 4 | 2022-09-04 | 89.46 | 2022-08-23 | 3578.27 | 1 | SO46170 | 2022-08-30 | 286.26 | 2171.29 | |
SO56237_3 | 100 | 27664 | 217 | 4 | 2024-02-12 | 0.87 | 2024-01-31 | 34.99 | 3 | SO56237 | 2024-02-07 | 2.80 | 13.09 | |
SO46177_1 | 100 | 12102 | 312 | 4 | 2022-09-05 | 89.46 | 2022-08-24 | 3578.27 | 1 | SO46177 | 2022-08-31 | 286.26 | 2171.29 | |
SO56239_1 | 100 | 23839 | 536 | 4 | 2024-02-12 | 0.75 | 2024-01-31 | 29.99 | 1 | SO56239 | 2024-02-07 | 2.40 | 11.22 | |
SO46179_1 | 100 | 11983 | 313 | 4 | 2022-09-06 | 89.46 | 2022-08-25 | 3578.27 | 1 | SO46179 | 2022-09-01 | 286.26 | 2171.29 | |
SO56240_1 | 100 | 22747 | 536 | 4 | 2024-02-12 | 0.75 | 2024-01-31 | 29.99 | 1 | SO56240 | 2024-02-07 | 2.40 | 11.22 | |
SO46194_1 | 100 | 11939 | 313 | 4 | 2022-09-08 | 89.46 | 2022-08-27 | 3578.27 | 1 | SO46194 | 2022-09-03 | 286.26 | 2171.29 | |
SO56240_2 | 100 | 22747 | 480 | 2 | 4 | 2024-02-12 | 0.06 | 2024-01-31 | 2.29 | 2 | SO56240 | 2024-02-07 | 0.18 | 0.86 |
SO46197_1 | 100 | 26061 | 347 | 4 | 2022-09-08 | 85.00 | 2022-08-27 | 3399.99 | 1 | SO46197 | 2022-09-03 | 272.00 | 1912.15 | |
SO56241_1 | 100 | 23357 | 536 | 4 | 2024-02-12 | 0.75 | 2024-01-31 | 29.99 | 1 | SO56241 | 2024-02-07 | 2.40 | 11.22 | |
SO46198_1 | 100 | 26089 | 344 | 4 | 2022-09-08 | 85.00 | 2022-08-27 | 3399.99 | 1 | SO46198 | 2022-09-03 | 272.00 | 1912.15 | |
SO56241_2 | 100 | 23357 | 472 | 4 | 2024-02-12 | 1.59 | 2024-01-31 | 63.50 | 2 | SO56241 | 2024-02-07 | 5.08 | 23.75 | |
SO46205_1 | 100 | 12162 | 313 | 4 | 2022-09-09 | 89.46 | 2022-08-28 | 3578.27 | 1 | SO46205 | 2022-09-04 | 286.26 | 2171.29 | |
SO56241_3 | 100 | 23357 | 528 | 4 | 2024-02-12 | 0.12 | 2024-01-31 | 4.99 | 3 | SO56241 | 2024-02-07 | 0.40 | 1.87 | |
SO46207_1 | 100 | 26091 | 348 | 4 | 2022-09-09 | 84.37 | 2022-08-28 | 3374.99 | 1 | SO46207 | 2022-09-04 | 270.00 | 1898.09 | |
SO56246_1 | 100 | 16788 | 477 | 4 | 2024-02-12 | 0.12 | 2024-01-31 | 4.99 | 1 | SO56246 | 2024-02-07 | 0.40 | 1.87 | |
SO46212_1 | 100 | 12173 | 312 | 4 | 2022-09-10 | 89.46 | 2022-08-29 | 3578.27 | 1 | SO46212 | 2022-09-05 | 286.26 | 2171.29 | |
SO56246_2 | 100 | 16788 | 214 | 4 | 2024-02-12 | 0.87 | 2024-01-31 | 34.99 | 2 | SO56246 | 2024-02-07 | 2.80 | 13.09 | |
SO46213_1 | 100 | 12050 | 314 | 4 | 2022-09-10 | 89.46 | 2022-08-29 | 3578.27 | 1 | SO46213 | 2022-09-05 | 286.26 | 2171.29 | |
SO56247_1 | 100 | 16143 | 528 | 4 | 2024-02-12 | 0.12 | 2024-01-31 | 4.99 | 1 | SO56247 | 2024-02-07 | 0.40 | 1.87 | |
SO46214_1 | 100 | 12072 | 311 | 4 | 2022-09-10 | 89.46 | 2022-08-29 | 3578.27 | 1 | SO46214 | 2022-09-05 | 286.26 | 2171.29 | |
SO56247_2 | 100 | 16143 | 485 | 4 | 2024-02-12 | 0.55 | 2024-01-31 | 21.98 | 2 | SO56247 | 2024-02-07 | 1.76 | 8.22 | |
SO46222_1 | 100 | 14891 | 336 | 4 | 2022-09-11 | 17.48 | 2022-08-30 | 699.10 | 1 | SO46222 | 2022-09-06 | 55.93 | 413.15 | |
SO56255_1 | 100 | 11971 | 537 | 4 | 2024-02-12 | 0.88 | 2024-01-31 | 35.00 | 1 | SO56255 | 2024-02-07 | 2.80 | 13.09 | |
SO46223_1 | 100 | 14892 | 326 | 4 | 2022-09-11 | 17.48 | 2022-08-30 | 699.10 | 1 | SO46223 | 2022-09-06 | 55.93 | 413.15 | |
SO56255_2 | 100 | 11971 | 528 | 4 | 2024-02-12 | 0.12 | 2024-01-31 | 4.99 | 2 | SO56255 | 2024-02-07 | 0.40 | 1.87 | |
SO46224_1 | 100 | 14902 | 328 | 4 | 2022-09-11 | 17.48 | 2022-08-30 | 699.10 | 1 | SO46224 | 2022-09-06 | 55.93 | 413.15 | |
SO56255_3 | 100 | 11971 | 214 | 4 | 2024-02-12 | 0.87 | 2024-01-31 | 34.99 | 3 | SO56255 | 2024-02-07 | 2.80 | 13.09 | |
SO46231_1 | 100 | 12016 | 310 | 4 | 2022-09-12 | 89.46 | 2022-08-31 | 3578.27 | 1 | SO46231 | 2022-09-07 | 286.26 | 2171.29 | |
SO56285_1 | 100 | 27533 | 538 | 4 | 2024-02-13 | 0.54 | 2024-02-01 | 21.49 | 1 | SO56285 | 2024-02-08 | 1.72 | 8.04 | |
SO46232_1 | 100 | 12058 | 311 | 4 | 2022-09-12 | 89.46 | 2022-08-31 | 3578.27 | 1 | SO46232 | 2022-09-07 | 286.26 | 2171.29 | |
SO56285_2 | 100 | 27533 | 529 | 4 | 2024-02-13 | 0.10 | 2024-02-01 | 3.99 | 2 | SO56285 | 2024-02-08 | 0.32 | 1.49 | |
SO46234_1 | 100 | 12110 | 312 | 4 | 2022-09-12 | 89.46 | 2022-08-31 | 3578.27 | 1 | SO46234 | 2022-09-07 | 286.26 | 2171.29 | |
SO56287_1 | 100 | 27046 | 541 | 4 | 2024-02-13 | 0.72 | 2024-02-01 | 28.99 | 1 | SO56287 | 2024-02-08 | 2.32 | 10.84 | |
SO46235_1 | 100 | 12151 | 312 | 4 | 2022-09-12 | 89.46 | 2022-08-31 | 3578.27 | 1 | SO46235 | 2022-09-07 | 286.26 | 2171.29 | |
SO56287_2 | 100 | 27046 | 530 | 4 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 2 | SO56287 | 2024-02-08 | 0.40 | 1.87 | |
SO46247_1 | 100 | 14882 | 334 | 4 | 2022-09-14 | 17.48 | 2022-09-02 | 699.10 | 1 | SO46247 | 2022-09-09 | 55.93 | 413.15 | |
SO56287_3 | 100 | 27046 | 480 | 2 | 4 | 2024-02-13 | 0.06 | 2024-02-01 | 2.29 | 3 | SO56287 | 2024-02-08 | 0.18 | 0.86 |
SO46248_1 | 100 | 14896 | 324 | 4 | 2022-09-14 | 17.48 | 2022-09-02 | 699.10 | 1 | SO46248 | 2022-09-09 | 55.93 | 413.15 | |
SO56288_1 | 100 | 25434 | 540 | 4 | 2024-02-13 | 0.82 | 2024-02-01 | 32.60 | 1 | SO56288 | 2024-02-08 | 2.61 | 12.19 | |
SO46253_1 | 100 | 12082 | 311 | 4 | 2022-09-15 | 89.46 | 2022-09-03 | 3578.27 | 1 | SO46253 | 2022-09-10 | 286.26 | 2171.29 | |
SO56288_2 | 100 | 25434 | 529 | 4 | 2024-02-13 | 0.10 | 2024-02-01 | 3.99 | 2 | SO56288 | 2024-02-08 | 0.32 | 1.49 | |
SO46254_1 | 100 | 12096 | 310 | 4 | 2022-09-15 | 89.46 | 2022-09-03 | 3578.27 | 1 | SO46254 | 2022-09-10 | 286.26 | 2171.29 | |
SO56288_3 | 100 | 25434 | 480 | 4 | 2024-02-13 | 0.06 | 2024-02-01 | 2.29 | 3 | SO56288 | 2024-02-08 | 0.18 | 0.86 | |
SO46271_1 | 100 | 12172 | 313 | 4 | 2022-09-18 | 89.46 | 2022-09-06 | 3578.27 | 1 | SO46271 | 2022-09-13 | 286.26 | 2171.29 | |
SO56294_1 | 100 | 18520 | 481 | 4 | 2024-02-13 | 0.22 | 2024-02-01 | 8.99 | 1 | SO56294 | 2024-02-08 | 0.72 | 3.36 | |
SO46273_1 | 100 | 26060 | 351 | 4 | 2022-09-18 | 84.37 | 2022-09-06 | 3374.99 | 1 | SO46273 | 2022-09-13 | 270.00 | 1898.09 | |
SO56294_2 | 100 | 18520 | 475 | 4 | 2024-02-13 | 1.75 | 2024-02-01 | 69.99 | 2 | SO56294 | 2024-02-08 | 5.60 | 26.18 | |
SO46274_1 | 100 | 26070 | 350 | 4 | 2022-09-18 | 84.37 | 2022-09-06 | 3374.99 | 1 | SO46274 | 2022-09-13 | 270.00 | 1898.09 | |
SO56298_1 | 100 | 14122 | 485 | 4 | 2024-02-13 | 0.55 | 2024-02-01 | 21.98 | 1 | SO56298 | 2024-02-08 | 1.76 | 8.22 | |
SO46281_1 | 100 | 26057 | 347 | 4 | 2022-09-19 | 85.00 | 2022-09-07 | 3399.99 | 1 | SO46281 | 2022-09-14 | 272.00 | 1912.15 | |
SO56298_2 | 100 | 14122 | 225 | 4 | 2024-02-13 | 0.22 | 2024-02-01 | 8.99 | 2 | SO56298 | 2024-02-08 | 0.72 | 6.92 | |
SO46282_1 | 100 | 26058 | 345 | 4 | 2022-09-19 | 85.00 | 2022-09-07 | 3399.99 | 1 | SO46282 | 2022-09-14 | 272.00 | 1912.15 | |
SO56308_1 | 100 | 12191 | 537 | 4 | 2024-02-13 | 0.88 | 2024-02-01 | 35.00 | 1 | SO56308 | 2024-02-08 | 2.80 | 13.09 | |
SO46283_1 | 100 | 26093 | 351 | 4 | 2022-09-19 | 84.37 | 2022-09-07 | 3374.99 | 1 | SO46283 | 2022-09-14 | 270.00 | 1898.09 | |
SO56308_2 | 100 | 12191 | 528 | 4 | 2024-02-13 | 0.12 | 2024-02-01 | 4.99 | 2 | SO56308 | 2024-02-08 | 0.40 | 1.87 |
Generated 2024-11-14 23:06:01.586 UTC