[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1567 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63613_3 | 100 | 20700 | 529 | 4 | 2024-05-29 | 0.10 | 2024-05-17 | 3.99 | 3 | SO63613 | 2024-05-24 | 0.32 | 1.49 | |
SO63613_4 | 100 | 20700 | 217 | 4 | 2024-05-29 | 0.87 | 2024-05-17 | 34.99 | 4 | SO63613 | 2024-05-24 | 2.80 | 13.09 | |
SO63613_5 | 100 | 20700 | 234 | 4 | 2024-05-29 | 1.25 | 2024-05-17 | 49.99 | 5 | SO63613 | 2024-05-24 | 4.00 | 38.49 | |
SO63613_6 | 100 | 20700 | 225 | 4 | 2024-05-29 | 0.22 | 2024-05-17 | 8.99 | 6 | SO63613 | 2024-05-24 | 0.72 | 6.92 | |
SO63616_1 | 100 | 17662 | 582 | 4 | 2024-05-29 | 42.52 | 2024-05-17 | 1700.99 | 1 | SO63616 | 2024-05-24 | 136.08 | 1082.51 | |
SO63616_2 | 100 | 17662 | 488 | 4 | 2024-05-29 | 1.35 | 2024-05-17 | 53.99 | 2 | SO63616 | 2024-05-24 | 4.32 | 41.57 | |
SO63616_3 | 100 | 17662 | 225 | 4 | 2024-05-29 | 0.22 | 2024-05-17 | 8.99 | 3 | SO63616 | 2024-05-24 | 0.72 | 6.92 | |
SO63633_1 | 19 | 28781 | 480 | 4 | 2024-05-30 | 0.06 | 2024-05-18 | 2.29 | 1 | SO63633 | 2024-05-25 | 0.18 | 0.86 | |
SO63635_1 | 100 | 29220 | 539 | 4 | 2024-05-30 | 0.62 | 2024-05-18 | 24.99 | 1 | SO63635 | 2024-05-25 | 2.00 | 9.35 | |
SO63637_1 | 100 | 27379 | 541 | 4 | 2024-05-30 | 0.72 | 2024-05-18 | 28.99 | 1 | SO63637 | 2024-05-25 | 2.32 | 10.84 | |
SO63637_2 | 100 | 27379 | 530 | 4 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 2 | SO63637 | 2024-05-25 | 0.40 | 1.87 | |
SO63637_3 | 100 | 27379 | 487 | 4 | 2024-05-30 | 1.37 | 2024-05-18 | 54.99 | 3 | SO63637 | 2024-05-25 | 4.40 | 20.57 | |
SO63637_4 | 100 | 27379 | 471 | 4 | 2024-05-30 | 1.59 | 2024-05-18 | 63.50 | 4 | SO63637 | 2024-05-25 | 5.08 | 23.75 | |
SO63643_1 | 100 | 26689 | 541 | 4 | 2024-05-30 | 0.72 | 2024-05-18 | 28.99 | 1 | SO63643 | 2024-05-25 | 2.32 | 10.84 | |
SO63643_2 | 100 | 26689 | 530 | 4 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 2 | SO63643 | 2024-05-25 | 0.40 | 1.87 | |
SO63643_3 | 100 | 26689 | 487 | 4 | 2024-05-30 | 1.37 | 2024-05-18 | 54.99 | 3 | SO63643 | 2024-05-25 | 4.40 | 20.57 | |
SO63643_4 | 100 | 26689 | 484 | 4 | 2024-05-30 | 0.20 | 2024-05-18 | 7.95 | 4 | SO63643 | 2024-05-25 | 0.64 | 2.97 | |
SO63644_1 | 100 | 22085 | 528 | 4 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 1 | SO63644 | 2024-05-25 | 0.40 | 1.87 | |
SO63644_2 | 100 | 22085 | 536 | 4 | 2024-05-30 | 0.75 | 2024-05-18 | 29.99 | 2 | SO63644 | 2024-05-25 | 2.40 | 11.22 | |
SO63645_1 | 100 | 21801 | 478 | 4 | 2024-05-30 | 0.25 | 2024-05-18 | 9.99 | 1 | SO63645 | 2024-05-25 | 0.80 | 3.74 | |
SO63645_2 | 100 | 21801 | 222 | 4 | 2024-05-30 | 0.87 | 2024-05-18 | 34.99 | 2 | SO63645 | 2024-05-25 | 2.80 | 13.09 | |
SO63646_1 | 100 | 20379 | 476 | 4 | 2024-05-30 | 1.75 | 2024-05-18 | 69.99 | 1 | SO63646 | 2024-05-25 | 5.60 | 26.18 | |
SO63646_2 | 100 | 20379 | 488 | 4 | 2024-05-30 | 1.35 | 2024-05-18 | 53.99 | 2 | SO63646 | 2024-05-25 | 4.32 | 41.57 | |
SO63648_1 | 100 | 17598 | 477 | 4 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 1 | SO63648 | 2024-05-25 | 0.40 | 1.87 | |
SO63648_2 | 100 | 17598 | 214 | 4 | 2024-05-30 | 0.87 | 2024-05-18 | 34.99 | 2 | SO63648 | 2024-05-25 | 2.80 | 13.09 | |
SO63662_1 | 100 | 11164 | 528 | 4 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 1 | SO63662 | 2024-05-25 | 0.40 | 1.87 | |
SO63662_2 | 100 | 11164 | 537 | 4 | 2024-05-30 | 0.88 | 2024-05-18 | 35.00 | 2 | SO63662 | 2024-05-25 | 2.80 | 13.09 | |
SO63662_3 | 100 | 11164 | 472 | 4 | 2024-05-30 | 1.59 | 2024-05-18 | 63.50 | 3 | SO63662 | 2024-05-25 | 5.08 | 23.75 | |
SO63662_4 | 100 | 11164 | 214 | 4 | 2024-05-30 | 0.87 | 2024-05-18 | 34.99 | 4 | SO63662 | 2024-05-25 | 2.80 | 13.09 | |
SO63663_1 | 100 | 11163 | 528 | 4 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 1 | SO63663 | 2024-05-25 | 0.40 | 1.87 | |
SO63663_2 | 100 | 11163 | 537 | 4 | 2024-05-30 | 0.88 | 2024-05-18 | 35.00 | 2 | SO63663 | 2024-05-25 | 2.80 | 13.09 | |
SO63663_3 | 100 | 11163 | 480 | 4 | 2024-05-30 | 0.06 | 2024-05-18 | 2.29 | 3 | SO63663 | 2024-05-25 | 0.18 | 0.86 | |
SO63666_1 | 100 | 14653 | 590 | 4 | 2024-05-30 | 19.24 | 2024-05-18 | 769.49 | 1 | SO63666 | 2024-05-25 | 61.56 | 419.78 | |
SO47923_1 | 100 | 26486 | 358 | 4 | 2023-02-17 | 51.23 | 2023-02-05 | 2049.10 | 1 | SO47923 | 2023-02-12 | 163.93 | 1105.81 | |
SO47934_1 | 100 | 14106 | 385 | 4 | 2023-02-19 | 25.01 | 2023-02-07 | 1000.44 | 1 | SO47934 | 2023-02-14 | 80.04 | 605.65 | |
SO47947_1 | 100 | 14109 | 387 | 4 | 2023-02-21 | 25.01 | 2023-02-09 | 1000.44 | 1 | SO47947 | 2023-02-16 | 80.04 | 605.65 | |
SO47949_1 | 100 | 13477 | 377 | 4 | 2023-02-21 | 54.54 | 2023-02-09 | 2181.56 | 1 | SO47949 | 2023-02-16 | 174.53 | 1320.68 | |
SO47950_1 | 100 | 26484 | 356 | 4 | 2023-02-21 | 51.79 | 2023-02-09 | 2071.42 | 1 | SO47950 | 2023-02-16 | 165.71 | 1117.86 | |
SO47957_1 | 100 | 14095 | 389 | 4 | 2023-02-22 | 25.01 | 2023-02-10 | 1000.44 | 1 | SO47957 | 2023-02-17 | 80.04 | 605.65 | |
SO47958_1 | 100 | 15349 | 329 | 4 | 2023-02-22 | 19.57 | 2023-02-10 | 782.99 | 1 | SO47958 | 2023-02-17 | 62.64 | 486.71 | |
SO48096_1 | 100 | 15398 | 329 | 4 | 2023-02-23 | 19.57 | 2023-02-11 | 782.99 | 1 | SO48096 | 2023-02-18 | 62.64 | 486.71 | |
SO48100_1 | 100 | 26546 | 356 | 4 | 2023-02-24 | 51.79 | 2023-02-12 | 2071.42 | 1 | SO48100 | 2023-02-19 | 165.71 | 1117.86 | |
SO48111_1 | 100 | 14112 | 383 | 4 | 2023-02-27 | 25.01 | 2023-02-15 | 1000.44 | 1 | SO48111 | 2023-02-22 | 80.04 | 605.65 | |
SO48120_1 | 100 | 15388 | 325 | 4 | 2023-02-28 | 19.57 | 2023-02-16 | 782.99 | 1 | SO48120 | 2023-02-23 | 62.64 | 486.71 | |
SO48125_1 | 100 | 14239 | 389 | 4 | 2023-03-01 | 25.01 | 2023-02-17 | 1000.44 | 1 | SO48125 | 2023-02-24 | 80.04 | 605.65 | |
SO48128_1 | 100 | 26534 | 352 | 4 | 2023-03-01 | 51.79 | 2023-02-17 | 2071.42 | 1 | SO48128 | 2023-02-24 | 165.71 | 1117.86 | |
SO48140_1 | 100 | 15374 | 331 | 4 | 2023-03-03 | 19.57 | 2023-02-19 | 782.99 | 1 | SO48140 | 2023-02-26 | 62.64 | 486.71 | |
SO48152_1 | 100 | 26536 | 352 | 4 | 2023-03-05 | 51.79 | 2023-02-21 | 2071.42 | 1 | SO48152 | 2023-02-28 | 165.71 | 1117.86 | |
SO48153_1 | 100 | 26575 | 362 | 2 | 4 | 2023-03-05 | 51.23 | 2023-02-21 | 2049.10 | 1 | SO48153 | 2023-02-28 | 163.93 | 1105.81 |
SO48166_1 | 100 | 13484 | 368 | 4 | 2023-03-07 | 61.08 | 2023-02-23 | 2443.35 | 1 | SO48166 | 2023-03-02 | 195.47 | 1518.79 | |
SO48167_1 | 100 | 26539 | 362 | 2 | 4 | 2023-03-07 | 51.23 | 2023-02-23 | 2049.10 | 1 | SO48167 | 2023-03-02 | 163.93 | 1105.81 |
SO48175_1 | 100 | 26545 | 354 | 4 | 2023-03-09 | 51.79 | 2023-02-25 | 2071.42 | 1 | SO48175 | 2023-03-04 | 165.71 | 1117.86 | |
SO48176_1 | 100 | 15379 | 337 | 4 | 2023-03-09 | 19.57 | 2023-02-25 | 782.99 | 1 | SO48176 | 2023-03-04 | 62.64 | 486.71 | |
SO48182_1 | 100 | 26600 | 360 | 4 | 2023-03-10 | 51.23 | 2023-02-26 | 2049.10 | 1 | SO48182 | 2023-03-05 | 163.93 | 1105.81 | |
SO48192_1 | 100 | 13702 | 377 | 4 | 2023-03-12 | 54.54 | 2023-02-28 | 2181.56 | 1 | SO48192 | 2023-03-07 | 174.53 | 1320.68 | |
SO48193_1 | 100 | 26499 | 352 | 4 | 2023-03-12 | 51.79 | 2023-02-28 | 2071.42 | 1 | SO48193 | 2023-03-07 | 165.71 | 1117.86 | |
SO48201_1 | 100 | 26601 | 356 | 4 | 2023-03-13 | 51.79 | 2023-03-01 | 2071.42 | 1 | SO48201 | 2023-03-08 | 165.71 | 1117.86 | |
SO48206_1 | 100 | 26538 | 352 | 4 | 2023-03-14 | 51.79 | 2023-03-02 | 2071.42 | 1 | SO48206 | 2023-03-09 | 165.71 | 1117.86 | |
SO48219_1 | 100 | 26511 | 354 | 4 | 2023-03-16 | 51.79 | 2023-03-04 | 2071.42 | 1 | SO48219 | 2023-03-11 | 165.71 | 1117.86 | |
SO48221_1 | 100 | 15365 | 337 | 4 | 2023-03-16 | 19.57 | 2023-03-04 | 782.99 | 1 | SO48221 | 2023-03-11 | 62.64 | 486.71 | |
SO48223_1 | 100 | 14120 | 383 | 4 | 2023-03-17 | 25.01 | 2023-03-05 | 1000.44 | 1 | SO48223 | 2023-03-12 | 80.04 | 605.65 | |
SO48229_1 | 100 | 26510 | 354 | 4 | 2023-03-18 | 51.79 | 2023-03-06 | 2071.42 | 1 | SO48229 | 2023-03-13 | 165.71 | 1117.86 |
Generated 2024-11-11 04:00:02.955 UTC