[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 1869 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50351_1 | 100 | 15885 | 337 | 1 | 2023-07-05 | 19.57 | 2023-06-23 | 782.99 | 1 | SO50351 | 2023-06-30 | 62.64 | 486.71 | |
SO50354_1 | 100 | 14456 | 381 | 1 | 2023-07-05 | 25.01 | 2023-06-23 | 1000.44 | 1 | SO50354 | 2023-06-30 | 80.04 | 605.65 | |
SO50362_1 | 100 | 27292 | 362 | 2 | 1 | 2023-07-06 | 51.23 | 2023-06-24 | 2049.10 | 1 | SO50362 | 2023-07-01 | 163.93 | 1105.81 |
SO50372_1 | 100 | 27440 | 358 | 1 | 2023-07-07 | 51.23 | 2023-06-25 | 2049.10 | 1 | SO50372 | 2023-07-02 | 163.93 | 1105.81 | |
SO50387_1 | 100 | 27407 | 354 | 1 | 2023-07-08 | 51.79 | 2023-06-26 | 2071.42 | 1 | SO50387 | 2023-07-03 | 165.71 | 1117.86 | |
SO50391_1 | 100 | 15901 | 337 | 1 | 2023-07-08 | 19.57 | 2023-06-26 | 782.99 | 1 | SO50391 | 2023-07-03 | 62.64 | 486.71 | |
SO50392_1 | 100 | 15902 | 329 | 1 | 2023-07-08 | 19.57 | 2023-06-26 | 782.99 | 1 | SO50392 | 2023-07-03 | 62.64 | 486.71 | |
SO50393_1 | 100 | 15918 | 335 | 1 | 2023-07-08 | 19.57 | 2023-06-26 | 782.99 | 1 | SO50393 | 2023-07-03 | 62.64 | 486.71 | |
SO50395_1 | 100 | 14439 | 383 | 1 | 2023-07-08 | 25.01 | 2023-06-26 | 1000.44 | 1 | SO50395 | 2023-07-03 | 80.04 | 605.65 | |
SO50419_1 | 100 | 14453 | 387 | 1 | 2023-07-10 | 25.01 | 2023-06-28 | 1000.44 | 1 | SO50419 | 2023-07-05 | 80.04 | 605.65 | |
SO50427_1 | 100 | 15944 | 335 | 1 | 2023-07-11 | 19.57 | 2023-06-29 | 782.99 | 1 | SO50427 | 2023-07-06 | 62.64 | 486.71 | |
SO50428_1 | 100 | 14421 | 381 | 1 | 2023-07-11 | 25.01 | 2023-06-29 | 1000.44 | 1 | SO50428 | 2023-07-06 | 80.04 | 605.65 | |
SO50444_1 | 100 | 14438 | 389 | 1 | 2023-07-13 | 25.01 | 2023-07-01 | 1000.44 | 1 | SO50444 | 2023-07-08 | 80.04 | 605.65 | |
SO50451_1 | 100 | 27272 | 360 | 1 | 2023-07-14 | 51.23 | 2023-07-02 | 2049.10 | 1 | SO50451 | 2023-07-09 | 163.93 | 1105.81 | |
SO50474_1 | 100 | 27269 | 362 | 2 | 1 | 2023-07-16 | 51.23 | 2023-07-04 | 2049.10 | 1 | SO50474 | 2023-07-11 | 163.93 | 1105.81 |
SO50478_1 | 100 | 15893 | 339 | 1 | 2023-07-16 | 19.57 | 2023-07-04 | 782.99 | 1 | SO50478 | 2023-07-11 | 62.64 | 486.71 | |
SO50479_1 | 100 | 14449 | 385 | 1 | 2023-07-16 | 25.01 | 2023-07-04 | 1000.44 | 1 | SO50479 | 2023-07-11 | 80.04 | 605.65 | |
SO50486_1 | 100 | 14448 | 381 | 1 | 2023-07-17 | 25.01 | 2023-07-05 | 1000.44 | 1 | SO50486 | 2023-07-12 | 80.04 | 605.65 | |
SO50496_1 | 100 | 14452 | 381 | 1 | 2023-07-18 | 25.01 | 2023-07-06 | 1000.44 | 1 | SO50496 | 2023-07-13 | 80.04 | 605.65 | |
SO50497_1 | 100 | 14419 | 389 | 1 | 2023-07-18 | 25.01 | 2023-07-06 | 1000.44 | 1 | SO50497 | 2023-07-13 | 80.04 | 605.65 | |
SO50520_1 | 100 | 27264 | 356 | 1 | 2023-07-22 | 51.79 | 2023-07-10 | 2071.42 | 1 | SO50520 | 2023-07-17 | 165.71 | 1117.86 | |
SO50521_1 | 100 | 27279 | 356 | 1 | 2023-07-22 | 51.79 | 2023-07-10 | 2071.42 | 1 | SO50521 | 2023-07-17 | 165.71 | 1117.86 | |
SO50524_1 | 100 | 15914 | 321 | 1 | 2023-07-22 | 19.57 | 2023-07-10 | 782.99 | 1 | SO50524 | 2023-07-17 | 62.64 | 486.71 | |
SO50525_1 | 100 | 14447 | 387 | 1 | 2023-07-22 | 25.01 | 2023-07-10 | 1000.44 | 1 | SO50525 | 2023-07-17 | 80.04 | 605.65 | |
SO50529_1 | 100 | 27295 | 358 | 1 | 2023-07-23 | 51.23 | 2023-07-11 | 2049.10 | 1 | SO50529 | 2023-07-18 | 163.93 | 1105.81 | |
SO50539_1 | 100 | 27261 | 358 | 1 | 2023-07-24 | 51.23 | 2023-07-12 | 2049.10 | 1 | SO50539 | 2023-07-19 | 163.93 | 1105.81 | |
SO50573_1 | 100 | 15934 | 329 | 1 | 2023-07-26 | 19.57 | 2023-07-14 | 782.99 | 1 | SO50573 | 2023-07-21 | 62.64 | 486.71 | |
SO50587_1 | 100 | 27262 | 360 | 1 | 2023-07-28 | 51.23 | 2023-07-16 | 2049.10 | 1 | SO50587 | 2023-07-23 | 163.93 | 1105.81 | |
SO50596_1 | 100 | 27416 | 362 | 2 | 1 | 2023-07-29 | 51.23 | 2023-07-17 | 2049.10 | 1 | SO50596 | 2023-07-24 | 163.93 | 1105.81 |
SO50598_1 | 100 | 27271 | 354 | 1 | 2023-07-29 | 51.79 | 2023-07-17 | 2071.42 | 1 | SO50598 | 2023-07-24 | 165.71 | 1117.86 | |
SO50605_1 | 100 | 27450 | 354 | 1 | 2023-07-30 | 51.79 | 2023-07-18 | 2071.42 | 1 | SO50605 | 2023-07-25 | 165.71 | 1117.86 | |
SO50618_1 | 100 | 27431 | 360 | 1 | 2023-07-31 | 51.23 | 2023-07-19 | 2049.10 | 1 | SO50618 | 2023-07-26 | 163.93 | 1105.81 | |
SO50633_1 | 100 | 14420 | 387 | 1 | 2023-08-01 | 25.01 | 2023-07-20 | 1000.44 | 1 | SO50633 | 2023-07-27 | 80.04 | 605.65 | |
SO50641_1 | 100 | 27455 | 354 | 1 | 2023-08-02 | 51.79 | 2023-07-21 | 2071.42 | 1 | SO50641 | 2023-07-28 | 165.71 | 1117.86 | |
SO50651_1 | 100 | 15888 | 335 | 1 | 2023-08-02 | 19.57 | 2023-07-21 | 782.99 | 1 | SO50651 | 2023-07-28 | 62.64 | 486.71 | |
SO50760_1 | 100 | 27549 | 354 | 1 | 2023-08-03 | 51.79 | 2023-07-22 | 2071.42 | 1 | SO50760 | 2023-07-29 | 165.71 | 1117.86 | |
SO50766_1 | 100 | 13977 | 369 | 2 | 1 | 2023-08-03 | 61.08 | 2023-07-22 | 2443.35 | 1 | SO50766 | 2023-07-29 | 195.47 | 1518.79 |
SO50791_1 | 100 | 15969 | 341 | 1 | 2023-08-05 | 19.57 | 2023-07-24 | 782.99 | 1 | SO50791 | 2023-07-31 | 62.64 | 486.71 | |
SO50802_1 | 100 | 14494 | 385 | 1 | 2023-08-06 | 25.01 | 2023-07-25 | 1000.44 | 1 | SO50802 | 2023-08-01 | 80.04 | 605.65 | |
SO50825_1 | 100 | 27570 | 352 | 1 | 2023-08-09 | 51.79 | 2023-07-28 | 2071.42 | 1 | SO50825 | 2023-08-04 | 165.71 | 1117.86 | |
SO50845_1 | 100 | 13947 | 375 | 1 | 2023-08-10 | 54.54 | 2023-07-29 | 2181.56 | 1 | SO50845 | 2023-08-05 | 174.53 | 1320.68 | |
SO50846_1 | 100 | 13979 | 368 | 1 | 2023-08-10 | 61.08 | 2023-07-29 | 2443.35 | 1 | SO50846 | 2023-08-05 | 195.47 | 1518.79 | |
SO50853_1 | 100 | 27542 | 356 | 1 | 2023-08-11 | 51.79 | 2023-07-30 | 2071.42 | 1 | SO50853 | 2023-08-06 | 165.71 | 1117.86 | |
SO50854_1 | 100 | 27551 | 358 | 1 | 2023-08-11 | 51.23 | 2023-07-30 | 2049.10 | 1 | SO50854 | 2023-08-06 | 163.93 | 1105.81 | |
SO50855_1 | 100 | 27558 | 358 | 1 | 2023-08-11 | 51.23 | 2023-07-30 | 2049.10 | 1 | SO50855 | 2023-08-06 | 163.93 | 1105.81 | |
SO50860_1 | 100 | 27504 | 352 | 1 | 2023-08-12 | 51.79 | 2023-07-31 | 2071.42 | 1 | SO50860 | 2023-08-07 | 165.71 | 1117.86 | |
SO50866_1 | 100 | 15991 | 333 | 1 | 2023-08-12 | 19.57 | 2023-07-31 | 782.99 | 1 | SO50866 | 2023-08-07 | 62.64 | 486.71 | |
SO50891_1 | 100 | 15976 | 339 | 1 | 2023-08-14 | 19.57 | 2023-08-02 | 782.99 | 1 | SO50891 | 2023-08-09 | 62.64 | 486.71 | |
SO50905_1 | 100 | 27576 | 352 | 1 | 2023-08-16 | 51.79 | 2023-08-04 | 2071.42 | 1 | SO50905 | 2023-08-11 | 165.71 | 1117.86 | |
SO50916_1 | 100 | 27531 | 354 | 1 | 2023-08-17 | 51.79 | 2023-08-05 | 2071.42 | 1 | SO50916 | 2023-08-12 | 165.71 | 1117.86 | |
SO50935_1 | 100 | 15980 | 321 | 1 | 2023-08-18 | 19.57 | 2023-08-06 | 782.99 | 1 | SO50935 | 2023-08-13 | 62.64 | 486.71 | |
SO59357_1 | 100 | 22160 | 536 | 1 | 2024-02-06 | 0.75 | 2024-01-25 | 29.99 | 1 | SO59357 | 2024-02-01 | 2.40 | 11.22 | |
SO59357_2 | 100 | 22160 | 528 | 1 | 2024-02-06 | 0.12 | 2024-01-25 | 4.99 | 2 | SO59357 | 2024-02-01 | 0.40 | 1.87 | |
SO59357_3 | 100 | 22160 | 480 | 1 | 2024-02-06 | 0.06 | 2024-01-25 | 2.29 | 3 | SO59357 | 2024-02-01 | 0.18 | 0.86 | |
SO59360_1 | 100 | 21579 | 478 | 1 | 2024-02-06 | 0.25 | 2024-01-25 | 9.99 | 1 | SO59360 | 2024-02-01 | 0.80 | 3.74 | |
SO59360_2 | 100 | 21579 | 477 | 1 | 2024-02-06 | 0.12 | 2024-01-25 | 4.99 | 2 | SO59360 | 2024-02-01 | 0.40 | 1.87 | |
SO59361_1 | 100 | 18365 | 477 | 1 | 2024-02-06 | 0.12 | 2024-01-25 | 4.99 | 1 | SO59361 | 2024-02-01 | 0.40 | 1.87 | |
SO59361_2 | 100 | 18365 | 214 | 1 | 2024-02-06 | 0.87 | 2024-01-25 | 34.99 | 2 | SO59361 | 2024-02-01 | 2.80 | 13.09 | |
SO59370_1 | 100 | 12092 | 537 | 1 | 2024-02-06 | 0.88 | 2024-01-25 | 35.00 | 1 | SO59370 | 2024-02-01 | 2.80 | 13.09 | |
SO59370_2 | 100 | 12092 | 528 | 1 | 2024-02-06 | 0.12 | 2024-01-25 | 4.99 | 2 | SO59370 | 2024-02-01 | 0.40 | 1.87 | |
SO59370_3 | 100 | 12092 | 480 | 1 | 2024-02-06 | 0.06 | 2024-01-25 | 2.29 | 3 | SO59370 | 2024-02-01 | 0.18 | 0.86 | |
SO59379_1 | 100 | 13907 | 363 | 1 | 2024-02-06 | 57.37 | 2024-01-25 | 2294.99 | 1 | SO59379 | 2024-02-01 | 183.60 | 1251.98 |
Generated 2024-09-20 12:23:58.669 UTC