[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 292 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55867_1 | 6 | 16522 | 384 | 9 | 2023-12-12 | 28.01 | 2023-11-30 | 1120.49 | 1 | SO55867 | 2023-12-07 | 89.64 | 713.08 |
SO44184_1 | 6 | 17247 | 314 | 9 | 2021-11-12 | 89.46 | 2021-10-31 | 3578.27 | 1 | SO44184 | 2021-11-07 | 286.26 | 2171.29 |
SO55871_1 | 6 | 15261 | 529 | 9 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 1 | SO55871 | 2023-12-07 | 0.32 | 1.49 |
SO44185_1 | 6 | 17280 | 310 | 9 | 2021-11-12 | 89.46 | 2021-10-31 | 3578.27 | 1 | SO44185 | 2021-11-07 | 286.26 | 2171.29 |
SO55871_2 | 6 | 15261 | 539 | 9 | 2023-12-12 | 0.62 | 2023-11-30 | 24.99 | 2 | SO55871 | 2023-12-07 | 2.00 | 9.35 |
SO44187_1 | 6 | 17069 | 313 | 9 | 2021-11-14 | 89.46 | 2021-11-02 | 3578.27 | 1 | SO44187 | 2021-11-09 | 286.26 | 2171.29 |
SO55871_3 | 6 | 15261 | 465 | 9 | 2023-12-12 | 0.61 | 2023-11-30 | 24.49 | 3 | SO55871 | 2023-12-07 | 1.96 | 9.16 |
SO44190_1 | 6 | 11061 | 348 | 9 | 2021-11-15 | 84.37 | 2021-11-03 | 3374.99 | 1 | SO44190 | 2021-11-10 | 270.00 | 1898.09 |
SO55872_1 | 6 | 24375 | 538 | 9 | 2023-12-12 | 0.54 | 2023-11-30 | 21.49 | 1 | SO55872 | 2023-12-07 | 1.72 | 8.04 |
SO44191_1 | 6 | 17248 | 310 | 9 | 2021-11-15 | 89.46 | 2021-11-03 | 3578.27 | 1 | SO44191 | 2021-11-10 | 286.26 | 2171.29 |
SO55872_2 | 6 | 24375 | 480 | 9 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 2 | SO55872 | 2023-12-07 | 0.18 | 0.86 |
SO44194_1 | 6 | 17064 | 310 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO44194 | 2021-11-11 | 286.26 | 2171.29 |
SO55872_3 | 6 | 24375 | 484 | 9 | 2023-12-12 | 0.20 | 2023-11-30 | 7.95 | 3 | SO55872 | 2023-12-07 | 0.64 | 2.97 |
SO44195_1 | 6 | 17249 | 313 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO44195 | 2021-11-11 | 286.26 | 2171.29 |
SO55873_1 | 6 | 29116 | 478 | 9 | 2023-12-12 | 0.25 | 2023-11-30 | 9.99 | 1 | SO55873 | 2023-12-07 | 0.80 | 3.74 |
SO44196_1 | 6 | 17295 | 314 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO44196 | 2021-11-11 | 286.26 | 2171.29 |
SO55873_2 | 6 | 29116 | 477 | 9 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 2 | SO55873 | 2023-12-07 | 0.40 | 1.87 |
SO44199_1 | 6 | 17259 | 313 | 9 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO44199 | 2021-11-12 | 286.26 | 2171.29 |
SO55873_3 | 6 | 29116 | 480 | 9 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 3 | SO55873 | 2023-12-07 | 0.18 | 0.86 |
SO44200_1 | 6 | 17312 | 311 | 9 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO44200 | 2021-11-12 | 286.26 | 2171.29 |
SO55874_1 | 6 | 16615 | 540 | 9 | 2023-12-12 | 0.82 | 2023-11-30 | 32.60 | 1 | SO55874 | 2023-12-07 | 2.61 | 12.19 |
SO44205_1 | 6 | 17285 | 312 | 9 | 2021-11-18 | 89.46 | 2021-11-06 | 3578.27 | 1 | SO44205 | 2021-11-13 | 286.26 | 2171.29 |
SO55874_2 | 6 | 16615 | 529 | 9 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 2 | SO55874 | 2023-12-07 | 0.32 | 1.49 |
SO44209_1 | 6 | 17257 | 311 | 9 | 2021-11-19 | 89.46 | 2021-11-07 | 3578.27 | 1 | SO44209 | 2021-11-14 | 286.26 | 2171.29 |
SO55874_3 | 6 | 16615 | 480 | 9 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 3 | SO55874 | 2023-12-07 | 0.18 | 0.86 |
SO44213_1 | 6 | 17351 | 310 | 9 | 2021-11-20 | 89.46 | 2021-11-08 | 3578.27 | 1 | SO44213 | 2021-11-15 | 286.26 | 2171.29 |
SO55875_1 | 6 | 18271 | 225 | 9 | 2023-12-12 | 0.22 | 2023-11-30 | 8.99 | 1 | SO55875 | 2023-12-07 | 0.72 | 6.92 |
SO44214_1 | 6 | 17332 | 311 | 9 | 2021-11-20 | 89.46 | 2021-11-08 | 3578.27 | 1 | SO44214 | 2021-11-15 | 286.26 | 2171.29 |
SO55876_1 | 6 | 14683 | 487 | 9 | 2023-12-12 | 1.37 | 2023-11-30 | 54.99 | 1 | SO55876 | 2023-12-07 | 4.40 | 20.57 |
SO44220_1 | 6 | 11060 | 345 | 9 | 2021-11-21 | 85.00 | 2021-11-09 | 3399.99 | 1 | SO44220 | 2021-11-16 | 272.00 | 1912.15 |
SO55879_1 | 6 | 11749 | 535 | 9 | 2023-12-12 | 0.62 | 2023-11-30 | 24.99 | 1 | SO55879 | 2023-12-07 | 2.00 | 9.35 |
SO44221_1 | 6 | 17255 | 314 | 9 | 2021-11-21 | 89.46 | 2021-11-09 | 3578.27 | 1 | SO44221 | 2021-11-16 | 286.26 | 2171.29 |
SO55914_1 | 6 | 28117 | 605 | 9 | 2023-12-12 | 13.50 | 2023-11-30 | 539.99 | 1 | SO55914 | 2023-12-07 | 43.20 | 343.65 |
SO44222_1 | 6 | 17258 | 311 | 9 | 2021-11-21 | 89.46 | 2021-11-09 | 3578.27 | 1 | SO44222 | 2021-11-16 | 286.26 | 2171.29 |
SO55914_2 | 6 | 28117 | 538 | 9 | 2023-12-12 | 0.54 | 2023-11-30 | 21.49 | 2 | SO55914 | 2023-12-07 | 1.72 | 8.04 |
SO44230_1 | 6 | 17241 | 312 | 9 | 2021-11-23 | 89.46 | 2021-11-11 | 3578.27 | 1 | SO44230 | 2021-11-18 | 286.26 | 2171.29 |
SO55914_3 | 6 | 28117 | 529 | 9 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 3 | SO55914 | 2023-12-07 | 0.32 | 1.49 |
SO44232_1 | 6 | 17334 | 312 | 9 | 2021-11-23 | 89.46 | 2021-11-11 | 3578.27 | 1 | SO44232 | 2021-11-18 | 286.26 | 2171.29 |
SO55915_1 | 6 | 12669 | 363 | 9 | 2023-12-12 | 57.37 | 2023-11-30 | 2294.99 | 1 | SO55915 | 2023-12-07 | 183.60 | 1251.98 |
SO44237_1 | 6 | 17056 | 310 | 9 | 2021-11-24 | 89.46 | 2021-11-12 | 3578.27 | 1 | SO44237 | 2021-11-19 | 286.26 | 2171.29 |
SO55915_2 | 6 | 12669 | 487 | 9 | 2023-12-12 | 1.37 | 2023-11-30 | 54.99 | 2 | SO55915 | 2023-12-07 | 4.40 | 20.57 |
SO44238_1 | 6 | 17079 | 311 | 9 | 2021-11-24 | 89.46 | 2021-11-12 | 3578.27 | 1 | SO44238 | 2021-11-19 | 286.26 | 2171.29 |
SO55915_3 | 6 | 12669 | 484 | 9 | 2023-12-12 | 0.20 | 2023-11-30 | 7.95 | 3 | SO55915 | 2023-12-07 | 0.64 | 2.97 |
SO44243_1 | 6 | 17278 | 312 | 9 | 2021-11-25 | 89.46 | 2021-11-13 | 3578.27 | 1 | SO44243 | 2021-11-20 | 286.26 | 2171.29 |
SO55917_1 | 6 | 12337 | 355 | 9 | 2023-12-12 | 58.00 | 2023-11-30 | 2319.99 | 1 | SO55917 | 2023-12-07 | 185.60 | 1265.62 |
SO44244_1 | 6 | 17329 | 312 | 9 | 2021-11-25 | 89.46 | 2021-11-13 | 3578.27 | 1 | SO44244 | 2021-11-20 | 286.26 | 2171.29 |
SO55917_2 | 6 | 12337 | 478 | 9 | 2023-12-12 | 0.25 | 2023-11-30 | 9.99 | 2 | SO55917 | 2023-12-07 | 0.80 | 3.74 |
SO44245_1 | 6 | 25556 | 330 | 9 | 2021-11-25 | 17.48 | 2021-11-13 | 699.10 | 1 | SO44245 | 2021-11-20 | 55.93 | 413.15 |
SO55917_3 | 6 | 12337 | 225 | 9 | 2023-12-12 | 0.22 | 2023-11-30 | 8.99 | 3 | SO55917 | 2023-12-07 | 0.72 | 6.92 |
SO44247_1 | 6 | 17233 | 310 | 9 | 2021-11-26 | 89.46 | 2021-11-14 | 3578.27 | 1 | SO44247 | 2021-11-21 | 286.26 | 2171.29 |
SO55917_4 | 6 | 12337 | 477 | 9 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 4 | SO55917 | 2023-12-07 | 0.40 | 1.87 |
SO44248_1 | 6 | 17240 | 313 | 9 | 2021-11-26 | 89.46 | 2021-11-14 | 3578.27 | 1 | SO44248 | 2021-11-21 | 286.26 | 2171.29 |
SO55922_1 | 6 | 16519 | 388 | 9 | 2023-12-13 | 28.01 | 2023-12-01 | 1120.49 | 1 | SO55922 | 2023-12-08 | 89.64 | 713.08 |
SO44256_1 | 6 | 17232 | 312 | 9 | 2021-11-28 | 89.46 | 2021-11-16 | 3578.27 | 1 | SO44256 | 2021-11-23 | 286.26 | 2171.29 |
SO55922_2 | 6 | 16519 | 488 | 9 | 2023-12-13 | 1.35 | 2023-12-01 | 53.99 | 2 | SO55922 | 2023-12-08 | 4.32 | 41.57 |
SO44263_1 | 6 | 17279 | 310 | 9 | 2021-11-29 | 89.46 | 2021-11-17 | 3578.27 | 1 | SO44263 | 2021-11-24 | 286.26 | 2171.29 |
SO55926_1 | 6 | 12007 | 577 | 9 | 2023-12-13 | 30.37 | 2023-12-01 | 1214.85 | 1 | SO55926 | 2023-12-08 | 97.19 | 755.15 |
SO44264_1 | 6 | 17286 | 313 | 9 | 2021-11-29 | 89.46 | 2021-11-17 | 3578.27 | 1 | SO44264 | 2021-11-24 | 286.26 | 2171.29 |
SO55926_2 | 6 | 12007 | 530 | 9 | 2023-12-13 | 0.12 | 2023-12-01 | 4.99 | 2 | SO55926 | 2023-12-08 | 0.40 | 1.87 |
SO44265_1 | 6 | 25557 | 320 | 9 | 2021-11-29 | 17.48 | 2021-11-17 | 699.10 | 1 | SO44265 | 2021-11-24 | 55.93 | 413.15 |
SO55926_3 | 6 | 12007 | 541 | 9 | 2023-12-13 | 0.72 | 2023-12-01 | 28.99 | 3 | SO55926 | 2023-12-08 | 2.32 | 10.84 |
SO44266_1 | 6 | 25559 | 336 | 9 | 2021-11-29 | 17.48 | 2021-11-17 | 699.10 | 1 | SO44266 | 2021-11-24 | 55.93 | 413.15 |
SO55926_4 | 6 | 12007 | 217 | 9 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 4 | SO55926 | 2023-12-08 | 2.80 | 13.09 |
SO44275_1 | 6 | 17256 | 311 | 9 | 2021-12-02 | 89.46 | 2021-11-20 | 3578.27 | 1 | SO44275 | 2021-11-27 | 286.26 | 2171.29 |
SO55928_1 | 6 | 18278 | 528 | 9 | 2023-12-13 | 0.12 | 2023-12-01 | 4.99 | 1 | SO55928 | 2023-12-08 | 0.40 | 1.87 |
SO44276_1 | 6 | 17277 | 313 | 9 | 2021-12-02 | 89.46 | 2021-11-20 | 3578.27 | 1 | SO44276 | 2021-11-27 | 286.26 | 2171.29 |
SO55928_2 | 6 | 18278 | 536 | 9 | 2023-12-13 | 0.75 | 2023-12-01 | 29.99 | 2 | SO55928 | 2023-12-08 | 2.40 | 11.22 |
SO44277_1 | 6 | 17288 | 311 | 9 | 2021-12-02 | 89.46 | 2021-11-20 | 3578.27 | 1 | SO44277 | 2021-11-27 | 286.26 | 2171.29 |
SO55928_3 | 6 | 18278 | 214 | 9 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 3 | SO55928 | 2023-12-08 | 2.80 | 13.09 |
SO44278_1 | 6 | 17293 | 310 | 9 | 2021-12-02 | 89.46 | 2021-11-20 | 3578.27 | 1 | SO44278 | 2021-11-27 | 286.26 | 2171.29 |
SO55928_4 | 6 | 18278 | 491 | 9 | 2023-12-13 | 1.35 | 2023-12-01 | 53.99 | 4 | SO55928 | 2023-12-08 | 4.32 | 41.57 |
SO44279_1 | 6 | 17326 | 313 | 9 | 2021-12-02 | 89.46 | 2021-11-20 | 3578.27 | 1 | SO44279 | 2021-11-27 | 286.26 | 2171.29 |
SO55929_1 | 6 | 19625 | 538 | 9 | 2023-12-13 | 0.54 | 2023-12-01 | 21.49 | 1 | SO55929 | 2023-12-08 | 1.72 | 8.04 |
SO44323_1 | 6 | 11072 | 344 | 9 | 2021-12-03 | 85.00 | 2021-11-21 | 3399.99 | 1 | SO44323 | 2021-11-28 | 272.00 | 1912.15 |
SO55929_2 | 6 | 19625 | 480 | 9 | 2023-12-13 | 0.06 | 2023-12-01 | 2.29 | 2 | SO55929 | 2023-12-08 | 0.18 | 0.86 |
SO44325_1 | 6 | 11095 | 351 | 9 | 2021-12-04 | 84.37 | 2021-11-22 | 3374.99 | 1 | SO44325 | 2021-11-29 | 270.00 | 1898.09 |
SO55930_1 | 6 | 19572 | 538 | 9 | 2023-12-13 | 0.54 | 2023-12-01 | 21.49 | 1 | SO55930 | 2023-12-08 | 1.72 | 8.04 |
SO44326_1 | 6 | 17728 | 312 | 9 | 2021-12-04 | 89.46 | 2021-11-22 | 3578.27 | 1 | SO44326 | 2021-11-29 | 286.26 | 2171.29 |
SO55930_2 | 6 | 19572 | 480 | 9 | 2023-12-13 | 0.06 | 2023-12-01 | 2.29 | 2 | SO55930 | 2023-12-08 | 0.18 | 0.86 |
SO44328_1 | 6 | 17921 | 310 | 9 | 2021-12-05 | 89.46 | 2021-11-23 | 3578.27 | 1 | SO44328 | 2021-11-30 | 286.26 | 2171.29 |
SO55931_1 | 6 | 15024 | 536 | 9 | 2023-12-13 | 0.75 | 2023-12-01 | 29.99 | 1 | SO55931 | 2023-12-08 | 2.40 | 11.22 |
SO44329_1 | 6 | 17904 | 311 | 9 | 2021-12-05 | 89.46 | 2021-11-23 | 3578.27 | 1 | SO44329 | 2021-11-30 | 286.26 | 2171.29 |
SO55931_2 | 6 | 15024 | 528 | 9 | 2023-12-13 | 0.12 | 2023-12-01 | 4.99 | 2 | SO55931 | 2023-12-08 | 0.40 | 1.87 |
SO44332_1 | 6 | 17510 | 310 | 9 | 2021-12-06 | 89.46 | 2021-11-24 | 3578.27 | 1 | SO44332 | 2021-12-01 | 286.26 | 2171.29 |
SO55931_3 | 6 | 15024 | 217 | 9 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 3 | SO55931 | 2023-12-08 | 2.80 | 13.09 |
SO44337_1 | 6 | 11097 | 351 | 9 | 2021-12-07 | 84.37 | 2021-11-25 | 3374.99 | 1 | SO44337 | 2021-12-02 | 270.00 | 1898.09 |
SO55959_1 | 6 | 29196 | 573 | 9 | 2023-12-13 | 59.60 | 2023-12-01 | 2384.07 | 1 | SO55959 | 2023-12-08 | 190.73 | 1481.94 |
SO44338_1 | 6 | 18188 | 314 | 9 | 2021-12-07 | 89.46 | 2021-11-25 | 3578.27 | 1 | SO44338 | 2021-12-02 | 286.26 | 2171.29 |
SO55959_2 | 6 | 29196 | 490 | 9 | 2023-12-13 | 1.35 | 2023-12-01 | 53.99 | 2 | SO55959 | 2023-12-08 | 4.32 | 41.57 |
SO44339_1 | 6 | 18189 | 311 | 9 | 2021-12-07 | 89.46 | 2021-11-25 | 3578.27 | 1 | SO44339 | 2021-12-02 | 286.26 | 2171.29 |
SO55960_1 | 6 | 19095 | 376 | 9 | 2023-12-13 | 61.08 | 2023-12-01 | 2443.35 | 1 | SO55960 | 2023-12-08 | 195.47 | 1554.95 |
SO44340_1 | 6 | 17354 | 314 | 9 | 2021-12-07 | 89.46 | 2021-11-25 | 3578.27 | 1 | SO44340 | 2021-12-02 | 286.26 | 2171.29 |
SO55960_2 | 6 | 19095 | 214 | 9 | 2023-12-13 | 0.87 | 2023-12-01 | 34.99 | 2 | SO55960 | 2023-12-08 | 2.80 | 13.09 |
SO44343_1 | 6 | 17920 | 314 | 9 | 2021-12-08 | 89.46 | 2021-11-26 | 3578.27 | 1 | SO44343 | 2021-12-03 | 286.26 | 2171.29 |
SO55961_1 | 6 | 12000 | 363 | 9 | 2023-12-13 | 57.37 | 2023-12-01 | 2294.99 | 1 | SO55961 | 2023-12-08 | 183.60 | 1251.98 |
SO44347_1 | 6 | 17911 | 312 | 9 | 2021-12-09 | 89.46 | 2021-11-27 | 3578.27 | 1 | SO44347 | 2021-12-04 | 286.26 | 2171.29 |
Generated 2024-09-20 18:42:02.337 UTC