[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 1700 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56541_1 | 6 | 14071 | 577 | 2 | 9 | 2023-12-25 | 30.37 | 2023-12-13 | 1214.85 | 1 | SO56541 | 2023-12-20 | 97.19 | 755.15 |
SO48490_1 | 6 | 24913 | 381 | 9 | 2023-02-10 | 25.01 | 2023-01-29 | 1000.44 | 1 | SO48490 | 2023-02-05 | 80.04 | 605.65 | |
SO56541_2 | 6 | 14071 | 541 | 9 | 2023-12-25 | 0.72 | 2023-12-13 | 28.99 | 2 | SO56541 | 2023-12-20 | 2.32 | 10.84 | |
SO48491_1 | 6 | 13126 | 358 | 9 | 2023-02-10 | 51.23 | 2023-01-29 | 2049.10 | 1 | SO48491 | 2023-02-05 | 163.93 | 1105.81 | |
SO56541_3 | 6 | 14071 | 530 | 9 | 2023-12-25 | 0.12 | 2023-12-13 | 4.99 | 3 | SO56541 | 2023-12-20 | 0.40 | 1.87 | |
SO48492_1 | 6 | 26567 | 331 | 9 | 2023-02-10 | 19.57 | 2023-01-29 | 782.99 | 1 | SO48492 | 2023-02-05 | 62.64 | 486.71 | |
SO56544_1 | 6 | 18295 | 485 | 9 | 2023-12-25 | 0.55 | 2023-12-13 | 21.98 | 1 | SO56544 | 2023-12-20 | 1.76 | 8.22 | |
SO48498_1 | 6 | 24920 | 387 | 9 | 2023-02-11 | 25.01 | 2023-01-30 | 1000.44 | 1 | SO48498 | 2023-02-06 | 80.04 | 605.65 | |
SO56544_2 | 6 | 18295 | 483 | 9 | 2023-12-25 | 3.00 | 2023-12-13 | 120.00 | 2 | SO56544 | 2023-12-20 | 9.60 | 44.88 | |
SO48499_1 | 6 | 13132 | 358 | 9 | 2023-02-11 | 51.23 | 2023-01-30 | 2049.10 | 1 | SO48499 | 2023-02-06 | 163.93 | 1105.81 | |
SO56545_1 | 6 | 21953 | 537 | 9 | 2023-12-25 | 0.88 | 2023-12-13 | 35.00 | 1 | SO56545 | 2023-12-20 | 2.80 | 13.09 | |
SO48500_1 | 6 | 13135 | 358 | 9 | 2023-02-11 | 51.23 | 2023-01-30 | 2049.10 | 1 | SO48500 | 2023-02-06 | 163.93 | 1105.81 | |
SO56546_1 | 6 | 17244 | 491 | 9 | 2023-12-25 | 1.35 | 2023-12-13 | 53.99 | 1 | SO56546 | 2023-12-20 | 4.32 | 41.57 | |
SO48502_1 | 6 | 26566 | 335 | 9 | 2023-02-11 | 19.57 | 2023-01-30 | 782.99 | 1 | SO48502 | 2023-02-06 | 62.64 | 486.71 | |
SO56547_1 | 6 | 11113 | 484 | 9 | 2023-12-25 | 0.20 | 2023-12-13 | 7.95 | 1 | SO56547 | 2023-12-20 | 0.64 | 2.97 | |
SO48515_1 | 6 | 22959 | 375 | 9 | 2023-02-12 | 54.54 | 2023-01-31 | 2181.56 | 1 | SO48515 | 2023-02-07 | 174.53 | 1320.68 | |
SO56548_1 | 6 | 18195 | 225 | 9 | 2023-12-25 | 0.22 | 2023-12-13 | 8.99 | 1 | SO56548 | 2023-12-20 | 0.72 | 6.92 | |
SO48516_1 | 6 | 13139 | 354 | 9 | 2023-02-12 | 51.79 | 2023-01-31 | 2071.42 | 1 | SO48516 | 2023-02-07 | 165.71 | 1117.86 | |
SO56549_1 | 6 | 18304 | 480 | 9 | 2023-12-25 | 0.06 | 2023-12-13 | 2.29 | 1 | SO56549 | 2023-12-20 | 0.18 | 0.86 | |
SO48528_1 | 6 | 22908 | 379 | 9 | 2023-02-13 | 54.54 | 2023-02-01 | 2181.56 | 1 | SO48528 | 2023-02-08 | 174.53 | 1320.68 | |
SO56550_1 | 6 | 17484 | 487 | 9 | 2023-12-25 | 1.37 | 2023-12-13 | 54.99 | 1 | SO56550 | 2023-12-20 | 4.40 | 20.57 | |
SO48530_1 | 6 | 13104 | 352 | 9 | 2023-02-13 | 51.79 | 2023-02-01 | 2071.42 | 1 | SO48530 | 2023-02-08 | 165.71 | 1117.86 | |
SO56550_2 | 6 | 17484 | 234 | 9 | 2023-12-25 | 1.25 | 2023-12-13 | 49.99 | 2 | SO56550 | 2023-12-20 | 4.00 | 38.49 | |
SO48531_1 | 6 | 13105 | 360 | 9 | 2023-02-13 | 51.23 | 2023-02-01 | 2049.10 | 1 | SO48531 | 2023-02-08 | 163.93 | 1105.81 | |
SO56551_1 | 6 | 16625 | 540 | 9 | 2023-12-25 | 0.82 | 2023-12-13 | 32.60 | 1 | SO56551 | 2023-12-20 | 2.61 | 12.19 | |
SO48532_1 | 6 | 13112 | 362 | 2 | 9 | 2023-02-13 | 51.23 | 2023-02-01 | 2049.10 | 1 | SO48532 | 2023-02-08 | 163.93 | 1105.81 |
SO56551_2 | 6 | 16625 | 529 | 9 | 2023-12-25 | 0.10 | 2023-12-13 | 3.99 | 2 | SO56551 | 2023-12-20 | 0.32 | 1.49 | |
SO48533_1 | 6 | 26560 | 329 | 9 | 2023-02-13 | 19.57 | 2023-02-01 | 782.99 | 1 | SO48533 | 2023-02-08 | 62.64 | 486.71 | |
SO56588_1 | 6 | 28963 | 576 | 9 | 2023-12-25 | 59.60 | 2023-12-13 | 2384.07 | 1 | SO56588 | 2023-12-20 | 190.73 | 1481.94 | |
SO48538_1 | 6 | 22905 | 379 | 9 | 2023-02-14 | 54.54 | 2023-02-02 | 2181.56 | 1 | SO48538 | 2023-02-09 | 174.53 | 1320.68 | |
SO56588_2 | 6 | 28963 | 477 | 9 | 2023-12-25 | 0.12 | 2023-12-13 | 4.99 | 2 | SO56588 | 2023-12-20 | 0.40 | 1.87 | |
SO48539_1 | 6 | 22921 | 377 | 9 | 2023-02-14 | 54.54 | 2023-02-02 | 2181.56 | 1 | SO48539 | 2023-02-09 | 174.53 | 1320.68 | |
SO56588_3 | 6 | 28963 | 479 | 9 | 2023-12-25 | 0.22 | 2023-12-13 | 8.99 | 3 | SO56588 | 2023-12-20 | 0.72 | 3.36 | |
SO48540_1 | 6 | 22931 | 377 | 9 | 2023-02-14 | 54.54 | 2023-02-02 | 2181.56 | 1 | SO48540 | 2023-02-09 | 174.53 | 1320.68 | |
SO56598_1 | 6 | 28479 | 566 | 9 | 2023-12-25 | 18.56 | 2023-12-13 | 742.35 | 1 | SO56598 | 2023-12-20 | 59.39 | 461.44 | |
SO48541_1 | 6 | 22943 | 368 | 9 | 2023-02-14 | 61.08 | 2023-02-02 | 2443.35 | 1 | SO48541 | 2023-02-09 | 195.47 | 1518.79 | |
SO56598_2 | 6 | 28479 | 217 | 9 | 2023-12-25 | 0.87 | 2023-12-13 | 34.99 | 2 | SO56598 | 2023-12-20 | 2.80 | 13.09 | |
SO48543_1 | 6 | 24918 | 387 | 9 | 2023-02-14 | 25.01 | 2023-02-02 | 1000.44 | 1 | SO48543 | 2023-02-09 | 80.04 | 605.65 | |
SO56598_3 | 6 | 28479 | 489 | 9 | 2023-12-25 | 1.35 | 2023-12-13 | 53.99 | 3 | SO56598 | 2023-12-20 | 4.32 | 41.57 | |
SO48544_1 | 6 | 13119 | 354 | 9 | 2023-02-14 | 51.79 | 2023-02-02 | 2071.42 | 1 | SO48544 | 2023-02-09 | 165.71 | 1117.86 | |
SO56600_1 | 6 | 15641 | 536 | 9 | 2023-12-26 | 0.75 | 2023-12-14 | 29.99 | 1 | SO56600 | 2023-12-21 | 2.40 | 11.22 | |
SO48556_1 | 6 | 22936 | 377 | 9 | 2023-02-15 | 54.54 | 2023-02-03 | 2181.56 | 1 | SO48556 | 2023-02-10 | 174.53 | 1320.68 | |
SO56600_2 | 6 | 15641 | 528 | 9 | 2023-12-26 | 0.12 | 2023-12-14 | 4.99 | 2 | SO56600 | 2023-12-21 | 0.40 | 1.87 | |
SO48557_1 | 6 | 22958 | 370 | 9 | 2023-02-15 | 61.08 | 2023-02-03 | 2443.35 | 1 | SO48557 | 2023-02-10 | 195.47 | 1518.79 | |
SO56600_3 | 6 | 15641 | 222 | 9 | 2023-12-26 | 0.87 | 2023-12-14 | 34.99 | 3 | SO56600 | 2023-12-21 | 2.80 | 13.09 | |
SO48559_1 | 6 | 13122 | 354 | 9 | 2023-02-15 | 51.79 | 2023-02-03 | 2071.42 | 1 | SO48559 | 2023-02-10 | 165.71 | 1117.86 | |
SO56600_4 | 6 | 15641 | 467 | 2 | 9 | 2023-12-26 | 0.61 | 2023-12-14 | 24.49 | 4 | SO56600 | 2023-12-21 | 1.96 | 9.16 |
SO48560_1 | 6 | 26561 | 327 | 9 | 2023-02-15 | 19.57 | 2023-02-03 | 782.99 | 1 | SO48560 | 2023-02-10 | 62.64 | 486.71 | |
SO56601_1 | 6 | 20251 | 536 | 9 | 2023-12-26 | 0.75 | 2023-12-14 | 29.99 | 1 | SO56601 | 2023-12-21 | 2.40 | 11.22 | |
SO48561_1 | 6 | 26562 | 341 | 9 | 2023-02-15 | 19.57 | 2023-02-03 | 782.99 | 1 | SO48561 | 2023-02-10 | 62.64 | 486.71 | |
SO56601_2 | 6 | 20251 | 477 | 9 | 2023-12-26 | 0.12 | 2023-12-14 | 4.99 | 2 | SO56601 | 2023-12-21 | 0.40 | 1.87 | |
SO48566_1 | 6 | 22906 | 375 | 9 | 2023-02-16 | 54.54 | 2023-02-04 | 2181.56 | 1 | SO48566 | 2023-02-11 | 174.53 | 1320.68 | |
SO56601_3 | 6 | 20251 | 465 | 9 | 2023-12-26 | 0.61 | 2023-12-14 | 24.49 | 3 | SO56601 | 2023-12-21 | 1.96 | 9.16 | |
SO48575_1 | 6 | 13123 | 360 | 9 | 2023-02-17 | 51.23 | 2023-02-05 | 2049.10 | 1 | SO48575 | 2023-02-12 | 163.93 | 1105.81 | |
SO56602_1 | 6 | 17495 | 485 | 9 | 2023-12-26 | 0.55 | 2023-12-14 | 21.98 | 1 | SO56602 | 2023-12-21 | 1.76 | 8.22 | |
SO48576_1 | 6 | 13133 | 362 | 2 | 9 | 2023-02-17 | 51.23 | 2023-02-05 | 2049.10 | 1 | SO48576 | 2023-02-12 | 163.93 | 1105.81 |
SO56602_2 | 6 | 17495 | 214 | 9 | 2023-12-26 | 0.87 | 2023-12-14 | 34.99 | 2 | SO56602 | 2023-12-21 | 2.80 | 13.09 | |
SO48577_1 | 6 | 26571 | 335 | 9 | 2023-02-17 | 19.57 | 2023-02-05 | 782.99 | 1 | SO48577 | 2023-02-12 | 62.64 | 486.71 | |
SO56603_1 | 6 | 18206 | 485 | 9 | 2023-12-26 | 0.55 | 2023-12-14 | 21.98 | 1 | SO56603 | 2023-12-21 | 1.76 | 8.22 | |
SO48583_1 | 6 | 23106 | 377 | 9 | 2023-02-18 | 54.54 | 2023-02-06 | 2181.56 | 1 | SO48583 | 2023-02-13 | 174.53 | 1320.68 | |
SO56603_2 | 6 | 18206 | 222 | 9 | 2023-12-26 | 0.87 | 2023-12-14 | 34.99 | 2 | SO56603 | 2023-12-21 | 2.80 | 13.09 | |
SO48584_1 | 6 | 22935 | 379 | 9 | 2023-02-18 | 54.54 | 2023-02-06 | 2181.56 | 1 | SO48584 | 2023-02-13 | 174.53 | 1320.68 | |
SO56604_1 | 6 | 21978 | 537 | 9 | 2023-12-26 | 0.88 | 2023-12-14 | 35.00 | 1 | SO56604 | 2023-12-21 | 2.80 | 13.09 | |
SO48585_1 | 6 | 24919 | 389 | 9 | 2023-02-18 | 25.01 | 2023-02-06 | 1000.44 | 1 | SO48585 | 2023-02-13 | 80.04 | 605.65 | |
SO56604_2 | 6 | 21978 | 480 | 9 | 2023-12-26 | 0.06 | 2023-12-14 | 2.29 | 2 | SO56604 | 2023-12-21 | 0.18 | 0.86 | |
SO48586_1 | 6 | 13113 | 354 | 9 | 2023-02-18 | 51.79 | 2023-02-06 | 2071.42 | 1 | SO48586 | 2023-02-13 | 165.71 | 1117.86 | |
SO56605_1 | 6 | 20603 | 538 | 9 | 2023-12-26 | 0.54 | 2023-12-14 | 21.49 | 1 | SO56605 | 2023-12-21 | 1.72 | 8.04 | |
SO48587_1 | 6 | 26568 | 323 | 9 | 2023-02-18 | 19.57 | 2023-02-06 | 782.99 | 1 | SO48587 | 2023-02-13 | 62.64 | 486.71 | |
SO56605_2 | 6 | 20603 | 480 | 9 | 2023-12-26 | 0.06 | 2023-12-14 | 2.29 | 2 | SO56605 | 2023-12-21 | 0.18 | 0.86 | |
SO48588_1 | 6 | 26569 | 339 | 9 | 2023-02-18 | 19.57 | 2023-02-06 | 782.99 | 1 | SO48588 | 2023-02-13 | 62.64 | 486.71 | |
SO56606_1 | 6 | 14315 | 237 | 9 | 2023-12-26 | 1.25 | 2023-12-14 | 49.99 | 1 | SO56606 | 2023-12-21 | 4.00 | 38.49 | |
SO48595_1 | 6 | 23097 | 375 | 9 | 2023-02-19 | 54.54 | 2023-02-07 | 2181.56 | 1 | SO48595 | 2023-02-14 | 174.53 | 1320.68 | |
SO56606_2 | 6 | 14315 | 463 | 9 | 2023-12-26 | 0.61 | 2023-12-14 | 24.49 | 2 | SO56606 | 2023-12-21 | 1.96 | 9.16 | |
SO48596_1 | 6 | 23101 | 373 | 9 | 2023-02-19 | 54.54 | 2023-02-07 | 2181.56 | 1 | SO48596 | 2023-02-14 | 174.53 | 1320.68 | |
SO56608_1 | 6 | 19962 | 479 | 9 | 2023-12-26 | 0.22 | 2023-12-14 | 8.99 | 1 | SO56608 | 2023-12-21 | 0.72 | 3.36 | |
SO48598_1 | 6 | 13106 | 352 | 9 | 2023-02-19 | 51.79 | 2023-02-07 | 2071.42 | 1 | SO48598 | 2023-02-14 | 165.71 | 1117.86 | |
SO56608_2 | 6 | 19962 | 477 | 9 | 2023-12-26 | 0.12 | 2023-12-14 | 4.99 | 2 | SO56608 | 2023-12-21 | 0.40 | 1.87 | |
SO48606_1 | 6 | 22988 | 368 | 9 | 2023-02-20 | 61.08 | 2023-02-08 | 2443.35 | 1 | SO48606 | 2023-02-15 | 195.47 | 1518.79 | |
SO56608_3 | 6 | 19962 | 480 | 9 | 2023-12-26 | 0.06 | 2023-12-14 | 2.29 | 3 | SO56608 | 2023-12-21 | 0.18 | 0.86 | |
SO48607_1 | 6 | 22946 | 377 | 9 | 2023-02-20 | 54.54 | 2023-02-08 | 2181.56 | 1 | SO48607 | 2023-02-15 | 174.53 | 1320.68 | |
SO56639_1 | 6 | 29184 | 561 | 9 | 2023-12-26 | 59.60 | 2023-12-14 | 2384.07 | 1 | SO56639 | 2023-12-21 | 190.73 | 1481.94 | |
SO48610_1 | 6 | 13134 | 358 | 9 | 2023-02-20 | 51.23 | 2023-02-08 | 2049.10 | 1 | SO48610 | 2023-02-15 | 163.93 | 1105.81 | |
SO56639_2 | 6 | 29184 | 530 | 9 | 2023-12-26 | 0.12 | 2023-12-14 | 4.99 | 2 | SO56639 | 2023-12-21 | 0.40 | 1.87 | |
SO48611_1 | 6 | 13518 | 360 | 9 | 2023-02-20 | 51.23 | 2023-02-08 | 2049.10 | 1 | SO48611 | 2023-02-15 | 163.93 | 1105.81 | |
SO56639_3 | 6 | 29184 | 541 | 9 | 2023-12-26 | 0.72 | 2023-12-14 | 28.99 | 3 | SO56639 | 2023-12-21 | 2.32 | 10.84 | |
SO48612_1 | 6 | 13520 | 352 | 9 | 2023-02-20 | 51.79 | 2023-02-08 | 2071.42 | 1 | SO48612 | 2023-02-15 | 165.71 | 1117.86 | |
SO56639_4 | 6 | 29184 | 480 | 9 | 2023-12-26 | 0.06 | 2023-12-14 | 2.29 | 4 | SO56639 | 2023-12-21 | 0.18 | 0.86 | |
SO48619_1 | 6 | 22934 | 369 | 2 | 9 | 2023-02-21 | 61.08 | 2023-02-09 | 2443.35 | 1 | SO48619 | 2023-02-16 | 195.47 | 1518.79 |
SO56640_1 | 6 | 18930 | 372 | 9 | 2023-12-26 | 61.08 | 2023-12-14 | 2443.35 | 1 | SO56640 | 2023-12-21 | 195.47 | 1554.95 | |
SO48621_1 | 6 | 13129 | 360 | 9 | 2023-02-21 | 51.23 | 2023-02-09 | 2049.10 | 1 | SO48621 | 2023-02-16 | 163.93 | 1105.81 | |
SO56640_2 | 6 | 18930 | 479 | 9 | 2023-12-26 | 0.22 | 2023-12-14 | 8.99 | 2 | SO56640 | 2023-12-21 | 0.72 | 3.36 | |
SO48622_1 | 6 | 13156 | 356 | 9 | 2023-02-21 | 51.79 | 2023-02-09 | 2071.42 | 1 | SO48622 | 2023-02-16 | 165.71 | 1117.86 | |
SO56640_3 | 6 | 18930 | 477 | 9 | 2023-12-26 | 0.12 | 2023-12-14 | 4.99 | 3 | SO56640 | 2023-12-21 | 0.40 | 1.87 | |
SO48623_1 | 6 | 13108 | 356 | 9 | 2023-02-21 | 51.79 | 2023-02-09 | 2071.42 | 1 | SO48623 | 2023-02-16 | 165.71 | 1117.86 | |
SO56644_1 | 6 | 23546 | 384 | 9 | 2023-12-27 | 28.01 | 2023-12-15 | 1120.49 | 1 | SO56644 | 2023-12-22 | 89.64 | 713.08 | |
SO48624_1 | 6 | 13109 | 362 | 2 | 9 | 2023-02-21 | 51.23 | 2023-02-09 | 2049.10 | 1 | SO48624 | 2023-02-16 | 163.93 | 1105.81 |
SO56644_2 | 6 | 23546 | 222 | 9 | 2023-12-27 | 0.87 | 2023-12-15 | 34.99 | 2 | SO56644 | 2023-12-22 | 2.80 | 13.09 | |
SO48625_1 | 6 | 26547 | 337 | 9 | 2023-02-21 | 19.57 | 2023-02-09 | 782.99 | 1 | SO48625 | 2023-02-16 | 62.64 | 486.71 | |
SO56645_1 | 6 | 25818 | 528 | 9 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 1 | SO56645 | 2023-12-22 | 0.40 | 1.87 | |
SO48626_1 | 6 | 26570 | 335 | 9 | 2023-02-21 | 19.57 | 2023-02-09 | 782.99 | 1 | SO48626 | 2023-02-16 | 62.64 | 486.71 | |
SO56645_2 | 6 | 25818 | 225 | 9 | 2023-12-27 | 0.22 | 2023-12-15 | 8.99 | 2 | SO56645 | 2023-12-22 | 0.72 | 6.92 | |
SO48629_1 | 6 | 24916 | 389 | 9 | 2023-02-22 | 25.01 | 2023-02-10 | 1000.44 | 1 | SO48629 | 2023-02-17 | 80.04 | 605.65 | |
SO56645_3 | 6 | 25818 | 485 | 9 | 2023-12-27 | 0.55 | 2023-12-15 | 21.98 | 3 | SO56645 | 2023-12-22 | 1.76 | 8.22 | |
SO48641_1 | 6 | 13524 | 354 | 9 | 2023-02-23 | 51.79 | 2023-02-11 | 2071.42 | 1 | SO48641 | 2023-02-18 | 165.71 | 1117.86 | |
SO56646_1 | 6 | 28959 | 478 | 9 | 2023-12-27 | 0.25 | 2023-12-15 | 9.99 | 1 | SO56646 | 2023-12-22 | 0.80 | 3.74 | |
SO48650_1 | 6 | 22986 | 373 | 9 | 2023-02-24 | 54.54 | 2023-02-12 | 2181.56 | 1 | SO48650 | 2023-02-19 | 174.53 | 1320.68 | |
SO56646_2 | 6 | 28959 | 477 | 9 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 2 | SO56646 | 2023-12-22 | 0.40 | 1.87 | |
SO48651_1 | 6 | 22926 | 377 | 9 | 2023-02-24 | 54.54 | 2023-02-12 | 2181.56 | 1 | SO48651 | 2023-02-19 | 174.53 | 1320.68 | |
SO56647_1 | 6 | 16032 | 541 | 9 | 2023-12-27 | 0.72 | 2023-12-15 | 28.99 | 1 | SO56647 | 2023-12-22 | 2.32 | 10.84 | |
SO48652_1 | 6 | 22951 | 368 | 9 | 2023-02-24 | 61.08 | 2023-02-12 | 2443.35 | 1 | SO48652 | 2023-02-19 | 195.47 | 1518.79 | |
SO56647_2 | 6 | 16032 | 530 | 9 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 2 | SO56647 | 2023-12-22 | 0.40 | 1.87 | |
SO48662_1 | 6 | 22938 | 369 | 2 | 9 | 2023-02-25 | 61.08 | 2023-02-13 | 2443.35 | 1 | SO48662 | 2023-02-20 | 195.47 | 1518.79 |
Generated 2024-09-20 13:18:29.105 UTC