[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2512 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56757_1 | 6 | 24909 | 388 | 9 | 2024-02-18 | 28.01 | 2024-02-06 | 1120.49 | 1 | SO56757 | 2024-02-13 | 89.64 | 713.08 | |
SO47823_1 | 6 | 26160 | 337 | 9 | 2023-02-04 | 19.57 | 2023-01-23 | 782.99 | 1 | SO47823 | 2023-01-30 | 62.64 | 486.71 | |
SO56757_2 | 6 | 24909 | 539 | 9 | 2024-02-18 | 0.62 | 2024-02-06 | 24.99 | 2 | SO56757 | 2024-02-13 | 2.00 | 9.35 | |
SO47826_1 | 6 | 22168 | 370 | 9 | 2023-02-05 | 61.08 | 2023-01-24 | 2443.35 | 1 | SO47826 | 2023-01-31 | 195.47 | 1518.79 | |
SO56757_3 | 6 | 24909 | 529 | 9 | 2024-02-18 | 0.10 | 2024-02-06 | 3.99 | 3 | SO56757 | 2024-02-13 | 0.32 | 1.49 | |
SO47827_1 | 6 | 22175 | 370 | 9 | 2023-02-05 | 61.08 | 2023-01-24 | 2443.35 | 1 | SO47827 | 2023-01-31 | 195.47 | 1518.79 | |
SO56760_1 | 6 | 20605 | 529 | 9 | 2024-02-18 | 0.10 | 2024-02-06 | 3.99 | 1 | SO56760 | 2024-02-13 | 0.32 | 1.49 | |
SO47828_1 | 6 | 21984 | 368 | 9 | 2023-02-05 | 61.08 | 2023-01-24 | 2443.35 | 1 | SO47828 | 2023-01-31 | 195.47 | 1518.79 | |
SO56760_2 | 6 | 20605 | 538 | 9 | 2024-02-18 | 0.54 | 2024-02-06 | 21.49 | 2 | SO56760 | 2024-02-13 | 1.72 | 8.04 | |
SO47829_1 | 6 | 12706 | 352 | 9 | 2023-02-05 | 51.79 | 2023-01-24 | 2071.42 | 1 | SO47829 | 2023-01-31 | 165.71 | 1117.86 | |
SO56760_3 | 6 | 20605 | 217 | 9 | 2024-02-18 | 0.87 | 2024-02-06 | 34.99 | 3 | SO56760 | 2024-02-13 | 2.80 | 13.09 | |
SO47833_1 | 6 | 22031 | 373 | 9 | 2023-02-06 | 54.54 | 2023-01-25 | 2181.56 | 1 | SO47833 | 2023-02-01 | 174.53 | 1320.68 | |
SO56760_4 | 6 | 20605 | 463 | 9 | 2024-02-18 | 0.61 | 2024-02-06 | 24.49 | 4 | SO56760 | 2024-02-13 | 1.96 | 9.16 | |
SO47834_1 | 6 | 22196 | 375 | 9 | 2023-02-06 | 54.54 | 2023-01-25 | 2181.56 | 1 | SO47834 | 2023-02-01 | 174.53 | 1320.68 | |
SO56761_1 | 6 | 25217 | 528 | 9 | 2024-02-18 | 0.12 | 2024-02-06 | 4.99 | 1 | SO56761 | 2024-02-13 | 0.40 | 1.87 | |
SO47835_1 | 6 | 24904 | 383 | 9 | 2023-02-06 | 25.01 | 2023-01-25 | 1000.44 | 1 | SO47835 | 2023-02-01 | 80.04 | 605.65 | |
SO56761_2 | 6 | 25217 | 222 | 9 | 2024-02-18 | 0.87 | 2024-02-06 | 34.99 | 2 | SO56761 | 2024-02-13 | 2.80 | 13.09 | |
SO47844_1 | 6 | 21996 | 371 | 9 | 2023-02-07 | 54.54 | 2023-01-26 | 2181.56 | 1 | SO47844 | 2023-02-02 | 174.53 | 1320.68 | |
SO56762_1 | 6 | 29301 | 478 | 9 | 2024-02-18 | 0.25 | 2024-02-06 | 9.99 | 1 | SO56762 | 2024-02-13 | 0.80 | 3.74 | |
SO47855_1 | 6 | 12987 | 354 | 9 | 2023-02-09 | 51.79 | 2023-01-28 | 2071.42 | 1 | SO47855 | 2023-02-04 | 165.71 | 1117.86 | |
SO56762_2 | 6 | 29301 | 477 | 9 | 2024-02-18 | 0.12 | 2024-02-06 | 4.99 | 2 | SO56762 | 2024-02-13 | 0.40 | 1.87 | |
SO47856_1 | 6 | 12995 | 362 | 2 | 9 | 2023-02-09 | 51.23 | 2023-01-28 | 2049.10 | 1 | SO47856 | 2023-02-04 | 163.93 | 1105.81 |
SO56762_3 | 6 | 29301 | 483 | 9 | 2024-02-18 | 3.00 | 2024-02-06 | 120.00 | 3 | SO56762 | 2024-02-13 | 9.60 | 44.88 | |
SO47857_1 | 6 | 13024 | 360 | 9 | 2023-02-09 | 51.23 | 2023-01-28 | 2049.10 | 1 | SO47857 | 2023-02-04 | 163.93 | 1105.81 | |
SO56785_1 | 6 | 16708 | 587 | 9 | 2024-02-18 | 19.24 | 2024-02-06 | 769.49 | 1 | SO56785 | 2024-02-13 | 61.56 | 419.78 | |
SO47862_1 | 6 | 22199 | 379 | 9 | 2023-02-10 | 54.54 | 2023-01-29 | 2181.56 | 1 | SO47862 | 2023-02-05 | 174.53 | 1320.68 | |
SO56785_2 | 6 | 16708 | 477 | 9 | 2024-02-18 | 0.12 | 2024-02-06 | 4.99 | 2 | SO56785 | 2024-02-13 | 0.40 | 1.87 | |
SO47864_1 | 6 | 21966 | 373 | 9 | 2023-02-10 | 54.54 | 2023-01-29 | 2181.56 | 1 | SO47864 | 2023-02-05 | 174.53 | 1320.68 | |
SO56785_3 | 6 | 16708 | 489 | 9 | 2024-02-18 | 1.35 | 2024-02-06 | 53.99 | 3 | SO56785 | 2024-02-13 | 4.32 | 41.57 | |
SO47865_1 | 6 | 12701 | 352 | 9 | 2023-02-10 | 51.79 | 2023-01-29 | 2071.42 | 1 | SO47865 | 2023-02-05 | 165.71 | 1117.86 | |
SO56786_1 | 6 | 19596 | 374 | 9 | 2024-02-18 | 61.08 | 2024-02-06 | 2443.35 | 1 | SO56786 | 2024-02-13 | 195.47 | 1554.95 | |
SO47866_1 | 6 | 12990 | 352 | 9 | 2023-02-10 | 51.79 | 2023-01-29 | 2071.42 | 1 | SO47866 | 2023-02-05 | 165.71 | 1117.86 | |
SO56786_2 | 6 | 19596 | 217 | 9 | 2024-02-18 | 0.87 | 2024-02-06 | 34.99 | 2 | SO56786 | 2024-02-13 | 2.80 | 13.09 | |
SO47867_1 | 6 | 12991 | 360 | 9 | 2023-02-10 | 51.23 | 2023-01-29 | 2049.10 | 1 | SO47867 | 2023-02-05 | 163.93 | 1105.81 | |
SO56787_1 | 6 | 19096 | 378 | 9 | 2024-02-18 | 61.08 | 2024-02-06 | 2443.35 | 1 | SO56787 | 2024-02-13 | 195.47 | 1554.95 | |
SO47868_1 | 6 | 13021 | 354 | 9 | 2023-02-10 | 51.79 | 2023-01-29 | 2071.42 | 1 | SO47868 | 2023-02-05 | 165.71 | 1117.86 | |
SO56787_2 | 6 | 19096 | 479 | 9 | 2024-02-18 | 0.22 | 2024-02-06 | 8.99 | 2 | SO56787 | 2024-02-13 | 0.72 | 3.36 | |
SO47869_1 | 6 | 26190 | 327 | 9 | 2023-02-10 | 19.57 | 2023-01-29 | 782.99 | 1 | SO47869 | 2023-02-05 | 62.64 | 486.71 | |
SO56787_3 | 6 | 19096 | 477 | 9 | 2024-02-18 | 0.12 | 2024-02-06 | 4.99 | 3 | SO56787 | 2024-02-13 | 0.40 | 1.87 | |
SO47878_1 | 6 | 12702 | 358 | 9 | 2023-02-11 | 51.23 | 2023-01-30 | 2049.10 | 1 | SO47878 | 2023-02-06 | 163.93 | 1105.81 | |
SO56787_4 | 6 | 19096 | 487 | 9 | 2024-02-18 | 1.37 | 2024-02-06 | 54.99 | 4 | SO56787 | 2024-02-13 | 4.40 | 20.57 | |
SO47884_1 | 6 | 22030 | 370 | 9 | 2023-02-12 | 61.08 | 2023-01-31 | 2443.35 | 1 | SO47884 | 2023-02-07 | 195.47 | 1518.79 | |
SO56788_1 | 6 | 12009 | 363 | 9 | 2024-02-18 | 57.37 | 2024-02-06 | 2294.99 | 1 | SO56788 | 2024-02-13 | 183.60 | 1251.98 | |
SO47885_1 | 6 | 24901 | 385 | 9 | 2023-02-12 | 25.01 | 2023-01-31 | 1000.44 | 1 | SO47885 | 2023-02-07 | 80.04 | 605.65 | |
SO56788_2 | 6 | 12009 | 485 | 9 | 2024-02-18 | 0.55 | 2024-02-06 | 21.98 | 2 | SO56788 | 2024-02-13 | 1.76 | 8.22 | |
SO47886_1 | 6 | 13011 | 358 | 9 | 2023-02-12 | 51.23 | 2023-01-31 | 2049.10 | 1 | SO47886 | 2023-02-07 | 163.93 | 1105.81 | |
SO56788_3 | 6 | 12009 | 217 | 9 | 2024-02-18 | 0.87 | 2024-02-06 | 34.99 | 3 | SO56788 | 2024-02-13 | 2.80 | 13.09 | |
SO47887_1 | 6 | 13012 | 356 | 9 | 2023-02-12 | 51.79 | 2023-01-31 | 2071.42 | 1 | SO47887 | 2023-02-07 | 165.71 | 1117.86 | |
SO56788_4 | 6 | 12009 | 463 | 9 | 2024-02-18 | 0.61 | 2024-02-06 | 24.49 | 4 | SO56788 | 2024-02-13 | 1.96 | 9.16 | |
SO47888_1 | 6 | 13050 | 354 | 9 | 2023-02-12 | 51.79 | 2023-01-31 | 2071.42 | 1 | SO47888 | 2023-02-07 | 165.71 | 1117.86 | |
SO56789_1 | 6 | 12338 | 363 | 9 | 2024-02-18 | 57.37 | 2024-02-06 | 2294.99 | 1 | SO56789 | 2024-02-13 | 183.60 | 1251.98 | |
SO47899_1 | 6 | 12996 | 358 | 9 | 2023-02-14 | 51.23 | 2023-02-02 | 2049.10 | 1 | SO47899 | 2023-02-09 | 163.93 | 1105.81 | |
SO56789_2 | 6 | 12338 | 485 | 9 | 2024-02-18 | 0.55 | 2024-02-06 | 21.98 | 2 | SO56789 | 2024-02-13 | 1.76 | 8.22 | |
SO47900_1 | 6 | 13035 | 362 | 2 | 9 | 2023-02-14 | 51.23 | 2023-02-02 | 2049.10 | 1 | SO47900 | 2023-02-09 | 163.93 | 1105.81 |
SO56789_3 | 6 | 12338 | 483 | 9 | 2024-02-18 | 3.00 | 2024-02-06 | 120.00 | 3 | SO56789 | 2024-02-13 | 9.60 | 44.88 | |
SO47901_1 | 6 | 13075 | 354 | 9 | 2023-02-14 | 51.79 | 2023-02-02 | 2071.42 | 1 | SO47901 | 2023-02-09 | 165.71 | 1117.86 | |
SO56796_1 | 6 | 23541 | 382 | 9 | 2024-02-19 | 28.01 | 2024-02-07 | 1120.49 | 1 | SO56796 | 2024-02-14 | 89.64 | 713.08 | |
SO47902_1 | 6 | 13076 | 360 | 9 | 2023-02-14 | 51.23 | 2023-02-02 | 2049.10 | 1 | SO47902 | 2023-02-09 | 163.93 | 1105.81 | |
SO56796_2 | 6 | 23541 | 222 | 9 | 2024-02-19 | 0.87 | 2024-02-07 | 34.99 | 2 | SO56796 | 2024-02-14 | 2.80 | 13.09 | |
SO47907_1 | 6 | 21999 | 369 | 2 | 9 | 2023-02-15 | 61.08 | 2023-02-03 | 2443.35 | 1 | SO47907 | 2023-02-10 | 195.47 | 1518.79 |
Generated 2024-11-10 16:11:18.553 UTC