[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 2018 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO70535_2 | 19 | 11223 | 480 | 6 | 2024-09-08 | 0.06 | 2024-08-27 | 2.29 | 2 | SO70535 | 2024-09-03 | 0.18 | 0.86 | |
SO57550_1 | 19 | 13944 | 529 | 6 | 2024-03-03 | 0.10 | 2024-02-20 | 3.99 | 1 | SO57550 | 2024-02-27 | 0.32 | 1.49 | |
SO64083_1 | 19 | 14480 | 478 | 6 | 2024-06-09 | 0.25 | 2024-05-28 | 9.99 | 1 | SO64083 | 2024-06-04 | 0.80 | 3.74 | |
SO70536_1 | 19 | 14561 | 540 | 6 | 2024-09-08 | 0.82 | 2024-08-27 | 32.60 | 1 | SO70536 | 2024-09-03 | 2.61 | 12.19 | |
SO57550_2 | 19 | 13944 | 540 | 6 | 2024-03-03 | 0.82 | 2024-02-20 | 32.60 | 2 | SO57550 | 2024-02-27 | 2.61 | 12.19 | |
SO64083_2 | 19 | 14480 | 477 | 6 | 2024-06-09 | 0.12 | 2024-05-28 | 4.99 | 2 | SO64083 | 2024-06-04 | 0.40 | 1.87 | |
SO70536_2 | 19 | 14561 | 529 | 6 | 2024-09-08 | 0.10 | 2024-08-27 | 3.99 | 2 | SO70536 | 2024-09-03 | 0.32 | 1.49 | |
SO57550_3 | 19 | 13944 | 222 | 6 | 2024-03-03 | 0.87 | 2024-02-20 | 34.99 | 3 | SO57550 | 2024-02-27 | 2.80 | 13.09 | |
SO64083_3 | 19 | 14480 | 217 | 6 | 2024-06-09 | 0.87 | 2024-05-28 | 34.99 | 3 | SO64083 | 2024-06-04 | 2.80 | 13.09 | |
SO70536_3 | 19 | 14561 | 217 | 6 | 2024-09-08 | 0.87 | 2024-08-27 | 34.99 | 3 | SO70536 | 2024-09-03 | 2.80 | 13.09 | |
SO57554_1 | 19 | 11287 | 477 | 6 | 2024-03-03 | 0.12 | 2024-02-20 | 4.99 | 1 | SO57554 | 2024-02-27 | 0.40 | 1.87 | |
SO64085_1 | 19 | 13231 | 477 | 6 | 2024-06-09 | 0.12 | 2024-05-28 | 4.99 | 1 | SO64085 | 2024-06-04 | 0.40 | 1.87 | |
SO70538_1 | 19 | 11869 | 540 | 6 | 2024-09-08 | 0.82 | 2024-08-27 | 32.60 | 1 | SO70538 | 2024-09-03 | 2.61 | 12.19 | |
SO57554_2 | 19 | 11287 | 478 | 6 | 2024-03-03 | 0.25 | 2024-02-20 | 9.99 | 2 | SO57554 | 2024-02-27 | 0.80 | 3.74 | |
SO64085_2 | 19 | 13231 | 478 | 6 | 2024-06-09 | 0.25 | 2024-05-28 | 9.99 | 2 | SO64085 | 2024-06-04 | 0.80 | 3.74 | |
SO70538_2 | 19 | 11869 | 529 | 6 | 2024-09-08 | 0.10 | 2024-08-27 | 3.99 | 2 | SO70538 | 2024-09-03 | 0.32 | 1.49 | |
SO57554_3 | 19 | 11287 | 225 | 6 | 2024-03-03 | 0.22 | 2024-02-20 | 8.99 | 3 | SO57554 | 2024-02-27 | 0.72 | 6.92 | |
SO64087_1 | 19 | 12140 | 477 | 6 | 2024-06-09 | 0.12 | 2024-05-28 | 4.99 | 1 | SO64087 | 2024-06-04 | 0.40 | 1.87 | |
SO70538_3 | 19 | 11869 | 214 | 6 | 2024-09-08 | 0.87 | 2024-08-27 | 34.99 | 3 | SO70538 | 2024-09-03 | 2.80 | 13.09 | |
SO57556_1 | 19 | 20312 | 528 | 6 | 2024-03-03 | 0.12 | 2024-02-20 | 4.99 | 1 | SO57556 | 2024-02-27 | 0.40 | 1.87 | |
SO64087_2 | 19 | 12140 | 225 | 6 | 2024-06-09 | 0.22 | 2024-05-28 | 8.99 | 2 | SO64087 | 2024-06-04 | 0.72 | 6.92 | |
SO70538_4 | 19 | 11869 | 463 | 6 | 2024-09-08 | 0.61 | 2024-08-27 | 24.49 | 4 | SO70538 | 2024-09-03 | 1.96 | 9.16 | |
SO57567_1 | 19 | 11502 | 528 | 6 | 2024-03-03 | 0.12 | 2024-02-20 | 4.99 | 1 | SO57567 | 2024-02-27 | 0.40 | 1.87 | |
SO64089_1 | 19 | 26095 | 528 | 6 | 2024-06-09 | 0.12 | 2024-05-28 | 4.99 | 1 | SO64089 | 2024-06-04 | 0.40 | 1.87 | |
SO70540_1 | 19 | 19541 | 536 | 6 | 2024-09-08 | 0.75 | 2024-08-27 | 29.99 | 1 | SO70540 | 2024-09-03 | 2.40 | 11.22 | |
SO57567_2 | 19 | 11502 | 537 | 6 | 2024-03-03 | 0.88 | 2024-02-20 | 35.00 | 2 | SO57567 | 2024-02-27 | 2.80 | 13.09 | |
SO64089_2 | 19 | 26095 | 480 | 6 | 2024-06-09 | 0.06 | 2024-05-28 | 2.29 | 2 | SO64089 | 2024-06-04 | 0.18 | 0.86 | |
SO70540_2 | 19 | 19541 | 480 | 2 | 6 | 2024-09-08 | 0.06 | 2024-08-27 | 2.29 | 2 | SO70540 | 2024-09-03 | 0.18 | 0.86 |
SO57567_3 | 19 | 11502 | 485 | 6 | 2024-03-03 | 0.55 | 2024-02-20 | 21.98 | 3 | SO57567 | 2024-02-27 | 1.76 | 8.22 | |
SO64089_3 | 19 | 26095 | 484 | 6 | 2024-06-09 | 0.20 | 2024-05-28 | 7.95 | 3 | SO64089 | 2024-06-04 | 0.64 | 2.97 | |
SO70545_1 | 19 | 12166 | 477 | 6 | 2024-09-08 | 0.12 | 2024-08-27 | 4.99 | 1 | SO70545 | 2024-09-03 | 0.40 | 1.87 | |
SO57567_4 | 19 | 11502 | 225 | 6 | 2024-03-03 | 0.22 | 2024-02-20 | 8.99 | 4 | SO57567 | 2024-02-27 | 0.72 | 6.92 | |
SO64131_1 | 19 | 11619 | 228 | 6 | 2024-06-10 | 1.25 | 2024-05-29 | 49.99 | 1 | SO64131 | 2024-06-05 | 4.00 | 38.49 | |
SO70545_2 | 19 | 12166 | 222 | 6 | 2024-09-08 | 0.87 | 2024-08-27 | 34.99 | 2 | SO70545 | 2024-09-03 | 2.80 | 13.09 | |
SO57568_1 | 19 | 13285 | 537 | 6 | 2024-03-03 | 0.88 | 2024-02-20 | 35.00 | 1 | SO57568 | 2024-02-27 | 2.80 | 13.09 | |
SO64134_1 | 19 | 11711 | 535 | 6 | 2024-06-10 | 0.62 | 2024-05-29 | 24.99 | 1 | SO64134 | 2024-06-05 | 2.00 | 9.35 | |
SO70549_1 | 19 | 23487 | 528 | 6 | 2024-09-08 | 0.12 | 2024-08-27 | 4.99 | 1 | SO70549 | 2024-09-03 | 0.40 | 1.87 | |
SO57568_2 | 19 | 13285 | 485 | 6 | 2024-03-03 | 0.55 | 2024-02-20 | 21.98 | 2 | SO57568 | 2024-02-27 | 1.76 | 8.22 | |
SO64134_2 | 19 | 11711 | 528 | 6 | 2024-06-10 | 0.12 | 2024-05-29 | 4.99 | 2 | SO64134 | 2024-06-05 | 0.40 | 1.87 | |
SO70549_2 | 19 | 23487 | 217 | 6 | 2024-09-08 | 0.87 | 2024-08-27 | 34.99 | 2 | SO70549 | 2024-09-03 | 2.80 | 13.09 | |
SO57568_3 | 19 | 13285 | 477 | 6 | 2024-03-03 | 0.12 | 2024-02-20 | 4.99 | 3 | SO57568 | 2024-02-27 | 0.40 | 1.87 | |
SO64134_3 | 19 | 11711 | 480 | 2 | 6 | 2024-06-10 | 0.06 | 2024-05-29 | 2.29 | 3 | SO64134 | 2024-06-05 | 0.18 | 0.86 |
SO70549_3 | 19 | 23487 | 231 | 6 | 2024-09-08 | 1.25 | 2024-08-27 | 49.99 | 3 | SO70549 | 2024-09-03 | 4.00 | 38.49 | |
SO57568_4 | 19 | 13285 | 478 | 6 | 2024-03-03 | 0.25 | 2024-02-20 | 9.99 | 4 | SO57568 | 2024-02-27 | 0.80 | 3.74 | |
SO64138_1 | 19 | 29323 | 225 | 6 | 2024-06-10 | 0.22 | 2024-05-29 | 8.99 | 1 | SO64138 | 2024-06-05 | 0.72 | 6.92 | |
SO70559_1 | 19 | 11498 | 528 | 6 | 2024-09-08 | 0.12 | 2024-08-27 | 4.99 | 1 | SO70559 | 2024-09-03 | 0.40 | 1.87 | |
SO57568_5 | 19 | 13285 | 222 | 6 | 2024-03-03 | 0.87 | 2024-02-20 | 34.99 | 5 | SO57568 | 2024-02-27 | 2.80 | 13.09 | |
SO64138_2 | 19 | 29323 | 476 | 6 | 2024-06-10 | 1.75 | 2024-05-29 | 69.99 | 2 | SO64138 | 2024-06-05 | 5.60 | 26.18 | |
SO70559_2 | 19 | 11498 | 537 | 6 | 2024-09-08 | 0.88 | 2024-08-27 | 35.00 | 2 | SO70559 | 2024-09-03 | 2.80 | 13.09 | |
SO57572_1 | 19 | 15498 | 537 | 6 | 2024-03-03 | 0.88 | 2024-02-20 | 35.00 | 1 | SO57572 | 2024-02-27 | 2.80 | 13.09 | |
SO64156_1 | 19 | 16987 | 363 | 6 | 2024-06-10 | 57.37 | 2024-05-29 | 2294.99 | 1 | SO64156 | 2024-06-05 | 183.60 | 1251.98 | |
SO70559_3 | 19 | 11498 | 214 | 6 | 2024-09-08 | 0.87 | 2024-08-27 | 34.99 | 3 | SO70559 | 2024-09-03 | 2.80 | 13.09 | |
SO57572_2 | 19 | 15498 | 528 | 6 | 2024-03-03 | 0.12 | 2024-02-20 | 4.99 | 2 | SO57572 | 2024-02-27 | 0.40 | 1.87 | |
SO64156_2 | 19 | 16987 | 483 | 6 | 2024-06-10 | 3.00 | 2024-05-29 | 120.00 | 2 | SO64156 | 2024-06-05 | 9.60 | 44.88 | |
SO70561_1 | 19 | 13175 | 537 | 6 | 2024-09-08 | 0.88 | 2024-08-27 | 35.00 | 1 | SO70561 | 2024-09-03 | 2.80 | 13.09 | |
SO57572_3 | 19 | 15498 | 214 | 6 | 2024-03-03 | 0.87 | 2024-02-20 | 34.99 | 3 | SO57572 | 2024-02-27 | 2.80 | 13.09 | |
SO64178_1 | 19 | 11501 | 477 | 6 | 2024-06-11 | 0.12 | 2024-05-30 | 4.99 | 1 | SO64178 | 2024-06-06 | 0.40 | 1.87 | |
SO70561_2 | 19 | 13175 | 528 | 6 | 2024-09-08 | 0.12 | 2024-08-27 | 4.99 | 2 | SO70561 | 2024-09-03 | 0.40 | 1.87 | |
SO57572_4 | 19 | 15498 | 234 | 6 | 2024-03-03 | 1.25 | 2024-02-20 | 49.99 | 4 | SO57572 | 2024-02-27 | 4.00 | 38.49 | |
SO64178_2 | 19 | 11501 | 479 | 6 | 2024-06-11 | 0.22 | 2024-05-30 | 8.99 | 2 | SO64178 | 2024-06-06 | 0.72 | 3.36 | |
SO70561_3 | 19 | 13175 | 485 | 6 | 2024-09-08 | 0.55 | 2024-08-27 | 21.98 | 3 | SO70561 | 2024-09-03 | 1.76 | 8.22 | |
SO57572_5 | 19 | 15498 | 463 | 6 | 2024-03-03 | 0.61 | 2024-02-20 | 24.49 | 5 | SO57572 | 2024-02-27 | 1.96 | 9.16 | |
SO64178_3 | 19 | 11501 | 222 | 6 | 2024-06-11 | 0.87 | 2024-05-30 | 34.99 | 3 | SO64178 | 2024-06-06 | 2.80 | 13.09 | |
SO70567_1 | 19 | 16366 | 380 | 6 | 2024-09-08 | 61.08 | 2024-08-27 | 2443.35 | 1 | SO70567 | 2024-09-03 | 195.47 | 1554.95 | |
SO57577_1 | 19 | 16020 | 593 | 6 | 2024-03-03 | 14.12 | 2024-02-20 | 564.99 | 1 | SO57577 | 2024-02-27 | 45.20 | 308.22 | |
SO64188_1 | 19 | 11498 | 480 | 6 | 2024-06-11 | 0.06 | 2024-05-30 | 2.29 | 1 | SO64188 | 2024-06-06 | 0.18 | 0.86 | |
SO70567_2 | 19 | 16366 | 483 | 6 | 2024-09-08 | 3.00 | 2024-08-27 | 120.00 | 2 | SO70567 | 2024-09-03 | 9.60 | 44.88 | |
SO57577_2 | 19 | 16020 | 485 | 6 | 2024-03-03 | 0.55 | 2024-02-20 | 21.98 | 2 | SO57577 | 2024-02-27 | 1.76 | 8.22 | |
SO64191_1 | 19 | 14084 | 539 | 6 | 2024-06-11 | 0.62 | 2024-05-30 | 24.99 | 1 | SO64191 | 2024-06-06 | 2.00 | 9.35 | |
SO70568_1 | 19 | 13851 | 361 | 6 | 2024-09-08 | 57.37 | 2024-08-27 | 2294.99 | 1 | SO70568 | 2024-09-03 | 183.60 | 1251.98 | |
SO57577_3 | 19 | 16020 | 225 | 6 | 2024-03-03 | 0.22 | 2024-02-20 | 8.99 | 3 | SO57577 | 2024-02-27 | 0.72 | 6.92 | |
SO64191_2 | 19 | 14084 | 529 | 6 | 2024-06-11 | 0.10 | 2024-05-30 | 3.99 | 2 | SO64191 | 2024-06-06 | 0.32 | 1.49 | |
SO70568_2 | 19 | 13851 | 485 | 6 | 2024-09-08 | 0.55 | 2024-08-27 | 21.98 | 2 | SO70568 | 2024-09-03 | 1.76 | 8.22 | |
SO57579_1 | 19 | 13343 | 363 | 6 | 2024-03-03 | 57.37 | 2024-02-20 | 2294.99 | 1 | SO57579 | 2024-02-27 | 183.60 | 1251.98 | |
SO64191_3 | 19 | 14084 | 463 | 6 | 2024-06-11 | 0.61 | 2024-05-30 | 24.49 | 3 | SO64191 | 2024-06-06 | 1.96 | 9.16 | |
SO70568_3 | 19 | 13851 | 478 | 6 | 2024-09-08 | 0.25 | 2024-08-27 | 9.99 | 3 | SO70568 | 2024-09-03 | 0.80 | 3.74 | |
SO57579_2 | 19 | 13343 | 485 | 6 | 2024-03-03 | 0.55 | 2024-02-20 | 21.98 | 2 | SO57579 | 2024-02-27 | 1.76 | 8.22 | |
SO64195_1 | 19 | 11300 | 538 | 6 | 2024-06-11 | 0.54 | 2024-05-30 | 21.49 | 1 | SO64195 | 2024-06-06 | 1.72 | 8.04 | |
SO70568_4 | 19 | 13851 | 477 | 6 | 2024-09-08 | 0.12 | 2024-08-27 | 4.99 | 4 | SO70568 | 2024-09-03 | 0.40 | 1.87 | |
SO57579_3 | 19 | 13343 | 480 | 6 | 2024-03-03 | 0.06 | 2024-02-20 | 2.29 | 3 | SO57579 | 2024-02-27 | 0.18 | 0.86 | |
SO64196_1 | 19 | 13701 | 541 | 6 | 2024-06-11 | 0.72 | 2024-05-30 | 28.99 | 1 | SO64196 | 2024-06-06 | 2.32 | 10.84 | |
SO70570_1 | 19 | 19661 | 357 | 6 | 2024-09-08 | 58.00 | 2024-08-27 | 2319.99 | 1 | SO70570 | 2024-09-03 | 185.60 | 1265.62 | |
SO57587_1 | 19 | 11984 | 574 | 6 | 2024-03-03 | 59.60 | 2024-02-20 | 2384.07 | 1 | SO57587 | 2024-02-27 | 190.73 | 1481.94 | |
SO64196_2 | 19 | 13701 | 530 | 6 | 2024-06-11 | 0.12 | 2024-05-30 | 4.99 | 2 | SO64196 | 2024-06-06 | 0.40 | 1.87 | |
SO70570_2 | 19 | 19661 | 528 | 6 | 2024-09-08 | 0.12 | 2024-08-27 | 4.99 | 2 | SO70570 | 2024-09-03 | 0.40 | 1.87 | |
SO57587_2 | 19 | 11984 | 479 | 6 | 2024-03-03 | 0.22 | 2024-02-20 | 8.99 | 2 | SO57587 | 2024-02-27 | 0.72 | 3.36 | |
SO64196_3 | 19 | 13701 | 479 | 6 | 2024-06-11 | 0.22 | 2024-05-30 | 8.99 | 3 | SO64196 | 2024-06-06 | 0.72 | 3.36 | |
SO70570_3 | 19 | 19661 | 537 | 6 | 2024-09-08 | 0.88 | 2024-08-27 | 35.00 | 3 | SO70570 | 2024-09-03 | 2.80 | 13.09 | |
SO57587_3 | 19 | 11984 | 477 | 6 | 2024-03-03 | 0.12 | 2024-02-20 | 4.99 | 3 | SO57587 | 2024-02-27 | 0.40 | 1.87 | |
SO64201_1 | 19 | 13758 | 478 | 6 | 2024-06-11 | 0.25 | 2024-05-30 | 9.99 | 1 | SO64201 | 2024-06-06 | 0.80 | 3.74 | |
SO70570_4 | 19 | 19661 | 480 | 6 | 2024-09-08 | 0.06 | 2024-08-27 | 2.29 | 4 | SO70570 | 2024-09-03 | 0.18 | 0.86 | |
SO57587_4 | 19 | 11984 | 480 | 2 | 6 | 2024-03-03 | 0.06 | 2024-02-20 | 2.29 | 4 | SO57587 | 2024-02-27 | 0.18 | 0.86 |
SO64201_2 | 19 | 13758 | 477 | 6 | 2024-06-11 | 0.12 | 2024-05-30 | 4.99 | 2 | SO64201 | 2024-06-06 | 0.40 | 1.87 | |
SO70570_5 | 19 | 19661 | 486 | 6 | 2024-09-08 | 3.98 | 2024-08-27 | 159.00 | 5 | SO70570 | 2024-09-03 | 12.72 | 59.47 | |
SO57601_1 | 19 | 13474 | 530 | 6 | 2024-03-04 | 0.12 | 2024-02-21 | 4.99 | 1 | SO57601 | 2024-02-28 | 0.40 | 1.87 | |
SO64201_3 | 19 | 13758 | 480 | 6 | 2024-06-11 | 0.06 | 2024-05-30 | 2.29 | 3 | SO64201 | 2024-06-06 | 0.18 | 0.86 |
Generated 2024-11-13 06:43:03.319 UTC