[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > SKIP 4000 < SKIP 249 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO66751_1 | 6 | 12577 | 600 | 9 | 2024-07-15 | 13.50 | 2024-07-03 | 539.99 | 1 | SO66751 | 2024-07-10 | 43.20 | 294.58 | |
SO66751_2 | 6 | 12577 | 535 | 9 | 2024-07-15 | 0.62 | 2024-07-03 | 24.99 | 2 | SO66751 | 2024-07-10 | 2.00 | 9.35 | |
SO66764_1 | 6 | 14303 | 569 | 9 | 2024-07-15 | 18.56 | 2024-07-03 | 742.35 | 1 | SO66764 | 2024-07-10 | 59.39 | 461.44 | |
SO66769_1 | 6 | 13043 | 535 | 9 | 2024-07-16 | 0.62 | 2024-07-04 | 24.99 | 1 | SO66769 | 2024-07-11 | 2.00 | 9.35 | |
SO66769_2 | 6 | 13043 | 528 | 9 | 2024-07-16 | 0.12 | 2024-07-04 | 4.99 | 2 | SO66769 | 2024-07-11 | 0.40 | 1.87 | |
SO66769_3 | 6 | 13043 | 485 | 9 | 2024-07-16 | 0.55 | 2024-07-04 | 21.98 | 3 | SO66769 | 2024-07-11 | 1.76 | 8.22 | |
SO66769_4 | 6 | 13043 | 217 | 9 | 2024-07-16 | 0.87 | 2024-07-04 | 34.99 | 4 | SO66769 | 2024-07-11 | 2.80 | 13.09 | |
SO66770_1 | 6 | 15039 | 536 | 9 | 2024-07-16 | 0.75 | 2024-07-04 | 29.99 | 1 | SO66770 | 2024-07-11 | 2.40 | 11.22 | |
SO66770_2 | 6 | 15039 | 528 | 9 | 2024-07-16 | 0.12 | 2024-07-04 | 4.99 | 2 | SO66770 | 2024-07-11 | 0.40 | 1.87 | |
SO66770_3 | 6 | 15039 | 222 | 9 | 2024-07-16 | 0.87 | 2024-07-04 | 34.99 | 3 | SO66770 | 2024-07-11 | 2.80 | 13.09 | |
SO66771_1 | 6 | 25268 | 529 | 9 | 2024-07-16 | 0.10 | 2024-07-04 | 3.99 | 1 | SO66771 | 2024-07-11 | 0.32 | 1.49 | |
SO66771_2 | 6 | 25268 | 538 | 9 | 2024-07-16 | 0.54 | 2024-07-04 | 21.49 | 2 | SO66771 | 2024-07-11 | 1.72 | 8.04 | |
SO66771_3 | 6 | 25268 | 222 | 9 | 2024-07-16 | 0.87 | 2024-07-04 | 34.99 | 3 | SO66771 | 2024-07-11 | 2.80 | 13.09 | |
SO66772_1 | 6 | 23647 | 477 | 9 | 2024-07-16 | 0.12 | 2024-07-04 | 4.99 | 1 | SO66772 | 2024-07-11 | 0.40 | 1.87 | |
SO66772_2 | 6 | 23647 | 484 | 9 | 2024-07-16 | 0.20 | 2024-07-04 | 7.95 | 2 | SO66772 | 2024-07-11 | 0.64 | 2.97 | |
SO66773_1 | 6 | 22965 | 530 | 9 | 2024-07-16 | 0.12 | 2024-07-04 | 4.99 | 1 | SO66773 | 2024-07-11 | 0.40 | 1.87 | |
SO66773_2 | 6 | 22965 | 480 | 2 | 9 | 2024-07-16 | 0.06 | 2024-07-04 | 2.29 | 2 | SO66773 | 2024-07-11 | 0.18 | 0.86 |
SO66774_1 | 6 | 16165 | 540 | 9 | 2024-07-16 | 0.82 | 2024-07-04 | 32.60 | 1 | SO66774 | 2024-07-11 | 2.61 | 12.19 | |
SO66774_2 | 6 | 16165 | 529 | 9 | 2024-07-16 | 0.10 | 2024-07-04 | 3.99 | 2 | SO66774 | 2024-07-11 | 0.32 | 1.49 | |
SO66775_1 | 6 | 18264 | 222 | 9 | 2024-07-16 | 0.87 | 2024-07-04 | 34.99 | 1 | SO66775 | 2024-07-11 | 2.80 | 13.09 | |
SO66776_1 | 6 | 19097 | 480 | 9 | 2024-07-16 | 0.06 | 2024-07-04 | 2.29 | 1 | SO66776 | 2024-07-11 | 0.18 | 0.86 | |
SO66817_1 | 6 | 21230 | 582 | 9 | 2024-07-16 | 42.52 | 2024-07-04 | 1700.99 | 1 | SO66817 | 2024-07-11 | 136.08 | 1082.51 | |
SO66817_2 | 6 | 21230 | 539 | 9 | 2024-07-16 | 0.62 | 2024-07-04 | 24.99 | 2 | SO66817 | 2024-07-11 | 2.00 | 9.35 | |
SO66817_3 | 6 | 21230 | 480 | 9 | 2024-07-16 | 0.06 | 2024-07-04 | 2.29 | 3 | SO66817 | 2024-07-11 | 0.18 | 0.86 | |
SO66818_1 | 6 | 26154 | 390 | 9 | 2024-07-16 | 28.01 | 2024-07-04 | 1120.49 | 1 | SO66818 | 2024-07-11 | 89.64 | 713.08 | |
SO66818_2 | 6 | 26154 | 222 | 9 | 2024-07-16 | 0.87 | 2024-07-04 | 34.99 | 2 | SO66818 | 2024-07-11 | 2.80 | 13.09 | |
SO66819_1 | 6 | 25830 | 386 | 9 | 2024-07-16 | 28.01 | 2024-07-04 | 1120.49 | 1 | SO66819 | 2024-07-11 | 89.64 | 713.08 | |
SO66819_2 | 6 | 25830 | 477 | 9 | 2024-07-16 | 0.12 | 2024-07-04 | 4.99 | 2 | SO66819 | 2024-07-11 | 0.40 | 1.87 | |
SO66819_3 | 6 | 25830 | 479 | 9 | 2024-07-16 | 0.22 | 2024-07-04 | 8.99 | 3 | SO66819 | 2024-07-11 | 0.72 | 3.36 | |
SO66820_1 | 6 | 14301 | 355 | 9 | 2024-07-16 | 58.00 | 2024-07-04 | 2319.99 | 1 | SO66820 | 2024-07-11 | 185.60 | 1265.62 | |
SO66821_1 | 6 | 12007 | 361 | 9 | 2024-07-16 | 57.37 | 2024-07-04 | 2294.99 | 1 | SO66821 | 2024-07-11 | 183.60 | 1251.98 | |
SO66821_2 | 6 | 12007 | 478 | 9 | 2024-07-16 | 0.25 | 2024-07-04 | 9.99 | 2 | SO66821 | 2024-07-11 | 0.80 | 3.74 | |
SO66821_3 | 6 | 12007 | 217 | 9 | 2024-07-16 | 0.87 | 2024-07-04 | 34.99 | 3 | SO66821 | 2024-07-11 | 2.80 | 13.09 | |
SO66827_1 | 6 | 12677 | 562 | 9 | 2024-07-16 | 59.60 | 2024-07-04 | 2384.07 | 1 | SO66827 | 2024-07-11 | 190.73 | 1481.94 | |
SO66827_2 | 6 | 12677 | 222 | 9 | 2024-07-16 | 0.87 | 2024-07-04 | 34.99 | 2 | SO66827 | 2024-07-11 | 2.80 | 13.09 | |
SO66828_1 | 6 | 12683 | 573 | 9 | 2024-07-16 | 59.60 | 2024-07-04 | 2384.07 | 1 | SO66828 | 2024-07-11 | 190.73 | 1481.94 | |
SO66828_2 | 6 | 12683 | 541 | 9 | 2024-07-16 | 0.72 | 2024-07-04 | 28.99 | 2 | SO66828 | 2024-07-11 | 2.32 | 10.84 | |
SO66830_1 | 6 | 21964 | 537 | 9 | 2024-07-17 | 0.88 | 2024-07-05 | 35.00 | 1 | SO66830 | 2024-07-12 | 2.80 | 13.09 | |
SO66830_2 | 6 | 21964 | 528 | 9 | 2024-07-17 | 0.12 | 2024-07-05 | 4.99 | 2 | SO66830 | 2024-07-12 | 0.40 | 1.87 | |
SO48435_1 | 6 | 22953 | 377 | 9 | 2023-03-27 | 54.54 | 2023-03-15 | 2181.56 | 1 | SO48435 | 2023-03-22 | 174.53 | 1320.68 | |
SO48438_1 | 6 | 13117 | 362 | 2 | 9 | 2023-03-28 | 51.23 | 2023-03-16 | 2049.10 | 1 | SO48438 | 2023-03-23 | 163.93 | 1105.81 |
SO48448_1 | 6 | 22987 | 375 | 9 | 2023-03-29 | 54.54 | 2023-03-17 | 2181.56 | 1 | SO48448 | 2023-03-24 | 174.53 | 1320.68 | |
SO48449_1 | 6 | 22907 | 370 | 9 | 2023-03-29 | 61.08 | 2023-03-17 | 2443.35 | 1 | SO48449 | 2023-03-24 | 195.47 | 1518.79 | |
SO48451_1 | 6 | 13107 | 358 | 9 | 2023-03-29 | 51.23 | 2023-03-17 | 2049.10 | 1 | SO48451 | 2023-03-24 | 163.93 | 1105.81 | |
SO48457_1 | 6 | 13110 | 362 | 2 | 9 | 2023-03-30 | 51.23 | 2023-03-18 | 2049.10 | 1 | SO48457 | 2023-03-25 | 163.93 | 1105.81 |
SO48469_1 | 6 | 22961 | 377 | 9 | 2023-03-31 | 54.54 | 2023-03-19 | 2181.56 | 1 | SO48469 | 2023-03-26 | 174.53 | 1320.68 | |
SO48470_1 | 6 | 23105 | 379 | 9 | 2023-03-31 | 54.54 | 2023-03-19 | 2181.56 | 1 | SO48470 | 2023-03-26 | 174.53 | 1320.68 | |
SO48471_1 | 6 | 22909 | 375 | 9 | 2023-03-31 | 54.54 | 2023-03-19 | 2181.56 | 1 | SO48471 | 2023-03-26 | 174.53 | 1320.68 | |
SO48472_1 | 6 | 22942 | 373 | 9 | 2023-03-31 | 54.54 | 2023-03-19 | 2181.56 | 1 | SO48472 | 2023-03-26 | 174.53 | 1320.68 | |
SO48474_1 | 6 | 26447 | 329 | 9 | 2023-03-31 | 19.57 | 2023-03-19 | 782.99 | 1 | SO48474 | 2023-03-26 | 62.64 | 486.71 | |
SO48478_1 | 6 | 22929 | 371 | 9 | 2023-04-01 | 54.54 | 2023-03-20 | 2181.56 | 1 | SO48478 | 2023-03-27 | 174.53 | 1320.68 | |
SO48479_1 | 6 | 22939 | 373 | 9 | 2023-04-01 | 54.54 | 2023-03-20 | 2181.56 | 1 | SO48479 | 2023-03-27 | 174.53 | 1320.68 | |
SO48482_1 | 6 | 24912 | 387 | 9 | 2023-04-01 | 25.01 | 2023-03-20 | 1000.44 | 1 | SO48482 | 2023-03-27 | 80.04 | 605.65 | |
SO48483_1 | 6 | 24917 | 381 | 9 | 2023-04-01 | 25.01 | 2023-03-20 | 1000.44 | 1 | SO48483 | 2023-03-27 | 80.04 | 605.65 | |
SO48484_1 | 6 | 13525 | 352 | 9 | 2023-04-01 | 51.79 | 2023-03-20 | 2071.42 | 1 | SO48484 | 2023-03-27 | 165.71 | 1117.86 | |
SO48485_1 | 6 | 26587 | 335 | 9 | 2023-04-01 | 19.57 | 2023-03-20 | 782.99 | 1 | SO48485 | 2023-03-27 | 62.64 | 486.71 | |
SO48489_1 | 6 | 22954 | 369 | 2 | 9 | 2023-04-02 | 61.08 | 2023-03-21 | 2443.35 | 1 | SO48489 | 2023-03-28 | 195.47 | 1518.79 |
SO48490_1 | 6 | 24913 | 381 | 9 | 2023-04-02 | 25.01 | 2023-03-21 | 1000.44 | 1 | SO48490 | 2023-03-28 | 80.04 | 605.65 | |
SO48491_1 | 6 | 13126 | 358 | 9 | 2023-04-02 | 51.23 | 2023-03-21 | 2049.10 | 1 | SO48491 | 2023-03-28 | 163.93 | 1105.81 | |
SO48492_1 | 6 | 26567 | 331 | 9 | 2023-04-02 | 19.57 | 2023-03-21 | 782.99 | 1 | SO48492 | 2023-03-28 | 62.64 | 486.71 |
Generated 2024-11-10 11:48:33.988 UTC