[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 1964 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48851_1 | 100 | 26717 | 354 | 1 | 2023-05-02 | 51.79 | 2023-04-20 | 2071.42 | 1 | SO48851 | 2023-04-27 | 165.71 | 1117.86 | |
SO57222_3 | 100 | 11014 | 217 | 1 | 2024-02-23 | 0.87 | 2024-02-11 | 34.99 | 3 | SO57222 | 2024-02-18 | 2.80 | 13.09 | |
SO63649_2 | 100 | 17599 | 477 | 1 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 2 | SO63649 | 2024-05-25 | 0.40 | 1.87 | |
SO70214_1 | 100 | 17535 | 355 | 1 | 2024-08-31 | 58.00 | 2024-08-19 | 2319.99 | 1 | SO70214 | 2024-08-26 | 185.60 | 1265.62 | |
SO48852_1 | 100 | 15503 | 325 | 1 | 2023-05-02 | 19.57 | 2023-04-20 | 782.99 | 1 | SO48852 | 2023-04-27 | 62.64 | 486.71 | |
SO57222_4 | 100 | 11014 | 465 | 1 | 2024-02-23 | 0.61 | 2024-02-11 | 24.49 | 4 | SO57222 | 2024-02-18 | 1.96 | 9.16 | |
SO63652_1 | 100 | 13457 | 485 | 1 | 2024-05-30 | 0.55 | 2024-05-18 | 21.98 | 1 | SO63652 | 2024-05-25 | 1.76 | 8.22 | |
SO70214_2 | 100 | 17535 | 485 | 1 | 2024-08-31 | 0.55 | 2024-08-19 | 21.98 | 2 | SO70214 | 2024-08-26 | 1.76 | 8.22 | |
SO48860_1 | 100 | 13849 | 375 | 1 | 2023-05-03 | 54.54 | 2023-04-21 | 2181.56 | 1 | SO48860 | 2023-04-28 | 174.53 | 1320.68 | |
SO57235_1 | 100 | 28871 | 569 | 1 | 2024-02-23 | 18.56 | 2024-02-11 | 742.35 | 1 | SO57235 | 2024-02-18 | 59.39 | 461.44 | |
SO63652_2 | 100 | 13457 | 222 | 1 | 2024-05-30 | 0.87 | 2024-05-18 | 34.99 | 2 | SO63652 | 2024-05-25 | 2.80 | 13.09 | |
SO70214_3 | 100 | 17535 | 471 | 1 | 2024-08-31 | 1.59 | 2024-08-19 | 63.50 | 3 | SO70214 | 2024-08-26 | 5.08 | 23.75 | |
SO48873_1 | 100 | 15499 | 323 | 1 | 2023-05-04 | 19.57 | 2023-04-22 | 782.99 | 1 | SO48873 | 2023-04-29 | 62.64 | 486.71 | |
SO57235_2 | 100 | 28871 | 222 | 1 | 2024-02-23 | 0.87 | 2024-02-11 | 34.99 | 2 | SO57235 | 2024-02-18 | 2.80 | 13.09 | |
SO63653_1 | 100 | 13937 | 473 | 1 | 2024-05-30 | 1.59 | 2024-05-18 | 63.50 | 1 | SO63653 | 2024-05-25 | 5.08 | 23.75 | |
SO70217_1 | 100 | 13248 | 361 | 1 | 2024-08-31 | 57.37 | 2024-08-19 | 2294.99 | 1 | SO70217 | 2024-08-26 | 183.60 | 1251.98 | |
SO48900_1 | 100 | 26734 | 358 | 1 | 2023-05-07 | 51.23 | 2023-04-25 | 2049.10 | 1 | SO48900 | 2023-05-02 | 163.93 | 1105.81 | |
SO57235_3 | 100 | 28871 | 225 | 1 | 2024-02-23 | 0.22 | 2024-02-11 | 8.99 | 3 | SO57235 | 2024-02-18 | 0.72 | 6.92 | |
SO63653_2 | 100 | 13937 | 485 | 1 | 2024-05-30 | 0.55 | 2024-05-18 | 21.98 | 2 | SO63653 | 2024-05-25 | 1.76 | 8.22 | |
SO70217_2 | 100 | 13248 | 478 | 1 | 2024-08-31 | 0.25 | 2024-08-19 | 9.99 | 2 | SO70217 | 2024-08-26 | 0.80 | 3.74 | |
SO48905_1 | 100 | 26814 | 362 | 2 | 1 | 2023-05-08 | 51.23 | 2023-04-26 | 2049.10 | 1 | SO48905 | 2023-05-03 | 163.93 | 1105.81 |
SO57235_4 | 100 | 28871 | 231 | 1 | 2024-02-23 | 1.25 | 2024-02-11 | 49.99 | 4 | SO57235 | 2024-02-18 | 4.00 | 38.49 | |
SO63667_1 | 100 | 12777 | 357 | 1 | 2024-05-30 | 58.00 | 2024-05-18 | 2319.99 | 1 | SO63667 | 2024-05-25 | 185.60 | 1265.62 | |
SO70217_3 | 100 | 13248 | 477 | 1 | 2024-08-31 | 0.12 | 2024-08-19 | 4.99 | 3 | SO70217 | 2024-08-26 | 0.40 | 1.87 | |
SO48907_1 | 100 | 26727 | 362 | 2 | 1 | 2023-05-08 | 51.23 | 2023-04-26 | 2049.10 | 1 | SO48907 | 2023-05-03 | 163.93 | 1105.81 |
SO57259_1 | 100 | 25338 | 535 | 1 | 2024-02-24 | 0.62 | 2024-02-12 | 24.99 | 1 | SO57259 | 2024-02-19 | 2.00 | 9.35 | |
SO63667_2 | 100 | 12777 | 480 | 1 | 2024-05-30 | 0.06 | 2024-05-18 | 2.29 | 2 | SO63667 | 2024-05-25 | 0.18 | 0.86 | |
SO70218_1 | 100 | 12418 | 361 | 1 | 2024-08-31 | 57.37 | 2024-08-19 | 2294.99 | 1 | SO70218 | 2024-08-26 | 183.60 | 1251.98 | |
SO48914_1 | 100 | 26735 | 356 | 1 | 2023-05-09 | 51.79 | 2023-04-27 | 2071.42 | 1 | SO48914 | 2023-05-04 | 165.71 | 1117.86 | |
SO57259_2 | 100 | 25338 | 480 | 1 | 2024-02-24 | 0.06 | 2024-02-12 | 2.29 | 2 | SO57259 | 2024-02-19 | 0.18 | 0.86 | |
SO63682_1 | 100 | 26487 | 576 | 1 | 2024-05-30 | 59.60 | 2024-05-18 | 2384.07 | 1 | SO63682 | 2024-05-25 | 190.73 | 1481.94 | |
SO70218_2 | 100 | 12418 | 485 | 1 | 2024-08-31 | 0.55 | 2024-08-19 | 21.98 | 2 | SO70218 | 2024-08-26 | 1.76 | 8.22 | |
SO48927_1 | 100 | 26703 | 362 | 2 | 1 | 2023-05-10 | 51.23 | 2023-04-28 | 2049.10 | 1 | SO48927 | 2023-05-05 | 163.93 | 1105.81 |
SO57262_1 | 100 | 23282 | 536 | 1 | 2024-02-24 | 0.75 | 2024-02-12 | 29.99 | 1 | SO57262 | 2024-02-19 | 2.40 | 11.22 | |
SO63682_2 | 100 | 26487 | 479 | 1 | 2024-05-30 | 0.22 | 2024-05-18 | 8.99 | 2 | SO63682 | 2024-05-25 | 0.72 | 3.36 | |
SO70218_3 | 100 | 12418 | 463 | 1 | 2024-08-31 | 0.61 | 2024-08-19 | 24.49 | 3 | SO70218 | 2024-08-26 | 1.96 | 9.16 | |
SO48928_1 | 100 | 15502 | 333 | 1 | 2023-05-10 | 19.57 | 2023-04-28 | 782.99 | 1 | SO48928 | 2023-05-05 | 62.64 | 486.71 | |
SO57262_2 | 100 | 23282 | 528 | 1 | 2024-02-24 | 0.12 | 2024-02-12 | 4.99 | 2 | SO57262 | 2024-02-19 | 0.40 | 1.87 | |
SO63682_3 | 100 | 26487 | 477 | 1 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 3 | SO63682 | 2024-05-25 | 0.40 | 1.87 | |
SO70218_4 | 100 | 12418 | 234 | 1 | 2024-08-31 | 1.25 | 2024-08-19 | 49.99 | 4 | SO70218 | 2024-08-26 | 4.00 | 38.49 | |
SO48933_1 | 100 | 26694 | 362 | 2 | 1 | 2023-05-11 | 51.23 | 2023-04-29 | 2049.10 | 1 | SO48933 | 2023-05-06 | 163.93 | 1105.81 |
SO57262_3 | 100 | 23282 | 480 | 1 | 2024-02-24 | 0.06 | 2024-02-12 | 2.29 | 3 | SO57262 | 2024-02-19 | 0.18 | 0.86 | |
SO63682_4 | 100 | 26487 | 225 | 1 | 2024-05-30 | 0.22 | 2024-05-18 | 8.99 | 4 | SO63682 | 2024-05-25 | 0.72 | 6.92 | |
SO70220_1 | 100 | 17136 | 359 | 1 | 2024-08-31 | 57.37 | 2024-08-19 | 2294.99 | 1 | SO70220 | 2024-08-26 | 183.60 | 1251.98 | |
SO48946_1 | 100 | 26725 | 358 | 1 | 2023-05-13 | 51.23 | 2023-05-01 | 2049.10 | 1 | SO48946 | 2023-05-08 | 163.93 | 1105.81 | |
SO57264_1 | 100 | 24530 | 540 | 1 | 2024-02-24 | 0.82 | 2024-02-12 | 32.60 | 1 | SO57264 | 2024-02-19 | 2.61 | 12.19 | |
SO63683_1 | 100 | 26292 | 561 | 1 | 2024-05-30 | 59.60 | 2024-05-18 | 2384.07 | 1 | SO63683 | 2024-05-25 | 190.73 | 1481.94 | |
SO70220_2 | 100 | 17136 | 480 | 1 | 2024-08-31 | 0.06 | 2024-08-19 | 2.29 | 2 | SO70220 | 2024-08-26 | 0.18 | 0.86 | |
SO48954_1 | 100 | 26724 | 362 | 2 | 1 | 2023-05-14 | 51.23 | 2023-05-02 | 2049.10 | 1 | SO48954 | 2023-05-09 | 163.93 | 1105.81 |
SO57264_2 | 100 | 24530 | 529 | 1 | 2024-02-24 | 0.10 | 2024-02-12 | 3.99 | 2 | SO57264 | 2024-02-19 | 0.32 | 1.49 | |
SO63683_2 | 100 | 26292 | 477 | 1 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 2 | SO63683 | 2024-05-25 | 0.40 | 1.87 | |
SO70232_1 | 100 | 27568 | 561 | 1 | 2024-08-31 | 59.60 | 2024-08-19 | 2384.07 | 1 | SO70232 | 2024-08-26 | 190.73 | 1481.94 | |
SO48960_1 | 100 | 26726 | 354 | 1 | 2023-05-15 | 51.79 | 2023-05-03 | 2071.42 | 1 | SO48960 | 2023-05-10 | 165.71 | 1117.86 | |
SO57265_1 | 100 | 23588 | 528 | 1 | 2024-02-24 | 0.12 | 2024-02-12 | 4.99 | 1 | SO57265 | 2024-02-19 | 0.40 | 1.87 | |
SO63683_3 | 100 | 26292 | 225 | 1 | 2024-05-30 | 0.22 | 2024-05-18 | 8.99 | 3 | SO63683 | 2024-05-25 | 0.72 | 6.92 | |
SO70232_2 | 100 | 27568 | 214 | 1 | 2024-08-31 | 0.87 | 2024-08-19 | 34.99 | 2 | SO70232 | 2024-08-26 | 2.80 | 13.09 | |
SO48968_1 | 100 | 13742 | 371 | 1 | 2023-05-16 | 54.54 | 2023-05-04 | 2181.56 | 1 | SO48968 | 2023-05-11 | 174.53 | 1320.68 | |
SO57265_2 | 100 | 23588 | 536 | 1 | 2024-02-24 | 0.75 | 2024-02-12 | 29.99 | 2 | SO57265 | 2024-02-19 | 2.40 | 11.22 | |
SO63683_4 | 100 | 26292 | 479 | 1 | 2024-05-30 | 0.22 | 2024-05-18 | 8.99 | 4 | SO63683 | 2024-05-25 | 0.72 | 3.36 | |
SO70233_1 | 100 | 28064 | 563 | 1 | 2024-08-31 | 59.60 | 2024-08-19 | 2384.07 | 1 | SO70233 | 2024-08-26 | 190.73 | 1481.94 | |
SO48978_1 | 100 | 14290 | 387 | 1 | 2023-05-17 | 25.01 | 2023-05-05 | 1000.44 | 1 | SO48978 | 2023-05-12 | 80.04 | 605.65 | |
SO57265_3 | 100 | 23588 | 480 | 1 | 2024-02-24 | 0.06 | 2024-02-12 | 2.29 | 3 | SO57265 | 2024-02-19 | 0.18 | 0.86 |
Generated 2024-11-10 21:21:51.007 UTC