[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2421 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO64425_5 | 100 | 19749 | 483 | 4 | 2024-04-22 | 3.00 | 2024-04-10 | 120.00 | 5 | SO64425 | 2024-04-17 | 9.60 | 44.88 | |
SO64426_1 | 100 | 15501 | 359 | 4 | 2024-04-22 | 57.37 | 2024-04-10 | 2294.99 | 1 | SO64426 | 2024-04-17 | 183.60 | 1251.98 | |
SO64426_2 | 100 | 15501 | 483 | 4 | 2024-04-22 | 3.00 | 2024-04-10 | 120.00 | 2 | SO64426 | 2024-04-17 | 9.60 | 44.88 | |
SO64427_1 | 100 | 15481 | 361 | 4 | 2024-04-22 | 57.37 | 2024-04-10 | 2294.99 | 1 | SO64427 | 2024-04-17 | 183.60 | 1251.98 | |
SO64427_2 | 100 | 15481 | 537 | 4 | 2024-04-22 | 0.88 | 2024-04-10 | 35.00 | 2 | SO64427 | 2024-04-17 | 2.80 | 13.09 | |
SO64427_3 | 100 | 15481 | 528 | 4 | 2024-04-22 | 0.12 | 2024-04-10 | 4.99 | 3 | SO64427 | 2024-04-17 | 0.40 | 1.87 | |
SO64427_4 | 100 | 15481 | 217 | 4 | 2024-04-22 | 0.87 | 2024-04-10 | 34.99 | 4 | SO64427 | 2024-04-17 | 2.80 | 13.09 | |
SO64428_1 | 100 | 12770 | 357 | 4 | 2024-04-22 | 58.00 | 2024-04-10 | 2319.99 | 1 | SO64428 | 2024-04-17 | 185.60 | 1265.62 | |
SO64428_2 | 100 | 12770 | 537 | 4 | 2024-04-22 | 0.88 | 2024-04-10 | 35.00 | 2 | SO64428 | 2024-04-17 | 2.80 | 13.09 | |
SO64428_3 | 100 | 12770 | 480 | 4 | 2024-04-22 | 0.06 | 2024-04-10 | 2.29 | 3 | SO64428 | 2024-04-17 | 0.18 | 0.86 | |
SO64428_4 | 100 | 12770 | 484 | 4 | 2024-04-22 | 0.20 | 2024-04-10 | 7.95 | 4 | SO64428 | 2024-04-17 | 0.64 | 2.97 | |
SO47923_1 | 100 | 26486 | 358 | 4 | 2022-12-29 | 51.23 | 2022-12-17 | 2049.10 | 1 | SO47923 | 2022-12-24 | 163.93 | 1105.81 | |
SO56848_2 | 100 | 19984 | 488 | 4 | 2023-12-31 | 1.35 | 2023-12-19 | 53.99 | 2 | SO56848 | 2023-12-26 | 4.32 | 41.57 | |
SO47934_1 | 100 | 14106 | 385 | 4 | 2022-12-31 | 25.01 | 2022-12-19 | 1000.44 | 1 | SO47934 | 2022-12-26 | 80.04 | 605.65 | |
SO56848_3 | 100 | 19984 | 225 | 4 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 3 | SO56848 | 2023-12-26 | 0.72 | 6.92 | |
SO47947_1 | 100 | 14109 | 387 | 4 | 2023-01-02 | 25.01 | 2022-12-21 | 1000.44 | 1 | SO47947 | 2022-12-28 | 80.04 | 605.65 | |
SO56861_1 | 100 | 11164 | 529 | 4 | 2024-01-01 | 0.10 | 2023-12-20 | 3.99 | 1 | SO56861 | 2023-12-27 | 0.32 | 1.49 | |
SO47949_1 | 100 | 13477 | 377 | 4 | 2023-01-02 | 54.54 | 2022-12-21 | 2181.56 | 1 | SO47949 | 2022-12-28 | 174.53 | 1320.68 | |
SO56861_2 | 100 | 11164 | 480 | 4 | 2024-01-01 | 0.06 | 2023-12-20 | 2.29 | 2 | SO56861 | 2023-12-27 | 0.18 | 0.86 | |
SO47950_1 | 100 | 26484 | 356 | 4 | 2023-01-02 | 51.79 | 2022-12-21 | 2071.42 | 1 | SO47950 | 2022-12-28 | 165.71 | 1117.86 | |
SO56864_1 | 100 | 28281 | 530 | 4 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 1 | SO56864 | 2023-12-27 | 0.40 | 1.87 | |
SO47957_1 | 100 | 14095 | 389 | 4 | 2023-01-03 | 25.01 | 2022-12-22 | 1000.44 | 1 | SO47957 | 2022-12-29 | 80.04 | 605.65 | |
SO56864_2 | 100 | 28281 | 480 | 2 | 4 | 2024-01-01 | 0.06 | 2023-12-20 | 2.29 | 2 | SO56864 | 2023-12-27 | 0.18 | 0.86 |
SO47958_1 | 100 | 15349 | 329 | 4 | 2023-01-03 | 19.57 | 2022-12-22 | 782.99 | 1 | SO47958 | 2022-12-29 | 62.64 | 486.71 | |
SO56867_1 | 100 | 27443 | 538 | 4 | 2024-01-01 | 0.54 | 2023-12-20 | 21.49 | 1 | SO56867 | 2023-12-27 | 1.72 | 8.04 | |
SO48096_1 | 100 | 15398 | 329 | 4 | 2023-01-04 | 19.57 | 2022-12-23 | 782.99 | 1 | SO48096 | 2022-12-30 | 62.64 | 486.71 | |
SO56867_2 | 100 | 27443 | 480 | 4 | 2024-01-01 | 0.06 | 2023-12-20 | 2.29 | 2 | SO56867 | 2023-12-27 | 0.18 | 0.86 | |
SO48100_1 | 100 | 26546 | 356 | 4 | 2023-01-05 | 51.79 | 2022-12-24 | 2071.42 | 1 | SO48100 | 2022-12-31 | 165.71 | 1117.86 | |
SO56870_1 | 100 | 24419 | 529 | 4 | 2024-01-01 | 0.10 | 2023-12-20 | 3.99 | 1 | SO56870 | 2023-12-27 | 0.32 | 1.49 | |
SO48111_1 | 100 | 14112 | 383 | 4 | 2023-01-08 | 25.01 | 2022-12-27 | 1000.44 | 1 | SO48111 | 2023-01-03 | 80.04 | 605.65 | |
SO56870_2 | 100 | 24419 | 540 | 4 | 2024-01-01 | 0.82 | 2023-12-20 | 32.60 | 2 | SO56870 | 2023-12-27 | 2.61 | 12.19 | |
SO48120_1 | 100 | 15388 | 325 | 4 | 2023-01-09 | 19.57 | 2022-12-28 | 782.99 | 1 | SO48120 | 2023-01-04 | 62.64 | 486.71 | |
SO56870_3 | 100 | 24419 | 222 | 4 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 3 | SO56870 | 2023-12-27 | 2.80 | 13.09 | |
SO48125_1 | 100 | 14239 | 389 | 4 | 2023-01-10 | 25.01 | 2022-12-29 | 1000.44 | 1 | SO48125 | 2023-01-05 | 80.04 | 605.65 | |
SO56872_1 | 100 | 21288 | 477 | 4 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 1 | SO56872 | 2023-12-27 | 0.40 | 1.87 | |
SO48128_1 | 100 | 26534 | 352 | 4 | 2023-01-10 | 51.79 | 2022-12-29 | 2071.42 | 1 | SO48128 | 2023-01-05 | 165.71 | 1117.86 | |
SO56872_2 | 100 | 21288 | 478 | 4 | 2024-01-01 | 0.25 | 2023-12-20 | 9.99 | 2 | SO56872 | 2023-12-27 | 0.80 | 3.74 | |
SO48140_1 | 100 | 15374 | 331 | 4 | 2023-01-12 | 19.57 | 2022-12-31 | 782.99 | 1 | SO48140 | 2023-01-07 | 62.64 | 486.71 | |
SO56888_1 | 100 | 12927 | 528 | 4 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 1 | SO56888 | 2023-12-27 | 0.40 | 1.87 | |
SO48152_1 | 100 | 26536 | 352 | 4 | 2023-01-14 | 51.79 | 2023-01-02 | 2071.42 | 1 | SO48152 | 2023-01-09 | 165.71 | 1117.86 | |
SO56888_2 | 100 | 12927 | 537 | 4 | 2024-01-01 | 0.88 | 2023-12-20 | 35.00 | 2 | SO56888 | 2023-12-27 | 2.80 | 13.09 | |
SO48153_1 | 100 | 26575 | 362 | 2 | 4 | 2023-01-14 | 51.23 | 2023-01-02 | 2049.10 | 1 | SO48153 | 2023-01-09 | 163.93 | 1105.81 |
SO56888_3 | 100 | 12927 | 217 | 4 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 3 | SO56888 | 2023-12-27 | 2.80 | 13.09 | |
SO48166_1 | 100 | 13484 | 368 | 4 | 2023-01-16 | 61.08 | 2023-01-04 | 2443.35 | 1 | SO48166 | 2023-01-11 | 195.47 | 1518.79 | |
SO56888_4 | 100 | 12927 | 465 | 4 | 2024-01-01 | 0.61 | 2023-12-20 | 24.49 | 4 | SO56888 | 2023-12-27 | 1.96 | 9.16 | |
SO48167_1 | 100 | 26539 | 362 | 2 | 4 | 2023-01-16 | 51.23 | 2023-01-04 | 2049.10 | 1 | SO48167 | 2023-01-11 | 163.93 | 1105.81 |
SO56889_1 | 100 | 11855 | 528 | 4 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 1 | SO56889 | 2023-12-27 | 0.40 | 1.87 | |
SO48175_1 | 100 | 26545 | 354 | 4 | 2023-01-18 | 51.79 | 2023-01-06 | 2071.42 | 1 | SO48175 | 2023-01-13 | 165.71 | 1117.86 | |
SO56889_2 | 100 | 11855 | 537 | 4 | 2024-01-01 | 0.88 | 2023-12-20 | 35.00 | 2 | SO56889 | 2023-12-27 | 2.80 | 13.09 | |
SO48176_1 | 100 | 15379 | 337 | 4 | 2023-01-18 | 19.57 | 2023-01-06 | 782.99 | 1 | SO48176 | 2023-01-13 | 62.64 | 486.71 | |
SO56890_1 | 100 | 13421 | 485 | 4 | 2024-01-01 | 0.55 | 2023-12-20 | 21.98 | 1 | SO56890 | 2023-12-27 | 1.76 | 8.22 | |
SO48182_1 | 100 | 26600 | 360 | 4 | 2023-01-19 | 51.23 | 2023-01-07 | 2049.10 | 1 | SO48182 | 2023-01-14 | 163.93 | 1105.81 | |
SO56890_2 | 100 | 13421 | 480 | 4 | 2024-01-01 | 0.06 | 2023-12-20 | 2.29 | 2 | SO56890 | 2023-12-27 | 0.18 | 0.86 | |
SO48192_1 | 100 | 13702 | 377 | 4 | 2023-01-21 | 54.54 | 2023-01-09 | 2181.56 | 1 | SO48192 | 2023-01-16 | 174.53 | 1320.68 | |
SO56891_1 | 100 | 11866 | 537 | 4 | 2024-01-01 | 0.88 | 2023-12-20 | 35.00 | 1 | SO56891 | 2023-12-27 | 2.80 | 13.09 | |
SO48193_1 | 100 | 26499 | 352 | 4 | 2023-01-21 | 51.79 | 2023-01-09 | 2071.42 | 1 | SO48193 | 2023-01-16 | 165.71 | 1117.86 | |
SO56893_1 | 100 | 20668 | 581 | 4 | 2024-01-01 | 42.52 | 2023-12-20 | 1700.99 | 1 | SO56893 | 2023-12-27 | 136.08 | 1082.51 | |
SO48201_1 | 100 | 26601 | 356 | 4 | 2023-01-22 | 51.79 | 2023-01-10 | 2071.42 | 1 | SO48201 | 2023-01-17 | 165.71 | 1117.86 | |
SO56893_2 | 100 | 20668 | 231 | 4 | 2024-01-01 | 1.25 | 2023-12-20 | 49.99 | 2 | SO56893 | 2023-12-27 | 4.00 | 38.49 | |
SO48206_1 | 100 | 26538 | 352 | 4 | 2023-01-23 | 51.79 | 2023-01-11 | 2071.42 | 1 | SO48206 | 2023-01-18 | 165.71 | 1117.86 | |
SO56905_1 | 100 | 22887 | 604 | 4 | 2024-01-01 | 13.50 | 2023-12-20 | 539.99 | 1 | SO56905 | 2023-12-27 | 43.20 | 343.65 | |
SO48219_1 | 100 | 26511 | 354 | 4 | 2023-01-25 | 51.79 | 2023-01-13 | 2071.42 | 1 | SO48219 | 2023-01-20 | 165.71 | 1117.86 |
Generated 2024-09-21 11:40:20.979 UTC