[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 1267 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50343_1 | 19 | 26310 | 377 | 6 | 2023-07-05 | 54.54 | 2023-06-23 | 2181.56 | 1 | SO50343 | 2023-06-30 | 174.53 | 1320.68 | |
SO56088_2 | 19 | 25062 | 225 | 6 | 2023-12-17 | 0.22 | 2023-12-05 | 8.99 | 2 | SO56088 | 2023-12-12 | 0.72 | 6.92 | |
SO63379_2 | 19 | 16009 | 474 | 6 | 2024-04-06 | 1.75 | 2024-03-25 | 69.99 | 2 | SO63379 | 2024-04-01 | 5.60 | 26.18 | |
SO70078_2 | 19 | 21659 | 538 | 6 | 2024-07-10 | 0.54 | 2024-06-28 | 21.49 | 2 | SO70078 | 2024-07-05 | 1.72 | 8.04 | |
SO50366_1 | 19 | 26294 | 369 | 2 | 6 | 2023-07-07 | 61.08 | 2023-06-25 | 2443.35 | 1 | SO50366 | 2023-07-02 | 195.47 | 1518.79 |
SO56099_1 | 19 | 11784 | 537 | 6 | 2023-12-17 | 0.88 | 2023-12-05 | 35.00 | 1 | SO56099 | 2023-12-12 | 2.80 | 13.09 | |
SO63380_1 | 19 | 28986 | 474 | 6 | 2024-04-06 | 1.75 | 2024-03-25 | 69.99 | 1 | SO63380 | 2024-04-01 | 5.60 | 26.18 | |
SO70078_3 | 19 | 21659 | 529 | 6 | 2024-07-10 | 0.10 | 2024-06-28 | 3.99 | 3 | SO70078 | 2024-07-05 | 0.32 | 1.49 | |
SO50367_1 | 19 | 26572 | 381 | 6 | 2023-07-07 | 25.01 | 2023-06-25 | 1000.44 | 1 | SO50367 | 2023-07-02 | 80.04 | 605.65 | |
SO56099_2 | 19 | 11784 | 528 | 6 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 2 | SO56099 | 2023-12-12 | 0.40 | 1.87 | |
SO63380_2 | 19 | 28986 | 225 | 6 | 2024-04-06 | 0.22 | 2024-03-25 | 8.99 | 2 | SO63380 | 2024-04-01 | 0.72 | 6.92 | |
SO70103_1 | 19 | 11223 | 480 | 6 | 2024-07-11 | 0.06 | 2024-06-29 | 2.29 | 1 | SO70103 | 2024-07-06 | 0.18 | 0.86 | |
SO50394_1 | 19 | 27557 | 333 | 6 | 2023-07-09 | 19.57 | 2023-06-27 | 782.99 | 1 | SO50394 | 2023-07-04 | 62.64 | 486.71 | |
SO70104_1 | 19 | 11331 | 530 | 6 | 2024-07-11 | 0.12 | 2024-06-29 | 4.99 | 1 | SO70104 | 2024-07-06 | 0.40 | 1.87 | |
SO70104_2 | 19 | 11331 | 480 | 2 | 6 | 2024-07-11 | 0.06 | 2024-06-29 | 2.29 | 2 | SO70104 | 2024-07-06 | 0.18 | 0.86 |
SO70105_1 | 19 | 15761 | 541 | 6 | 2024-07-11 | 0.72 | 2024-06-29 | 28.99 | 1 | SO70105 | 2024-07-06 | 2.32 | 10.84 | |
SO70105_2 | 19 | 15761 | 530 | 6 | 2024-07-11 | 0.12 | 2024-06-29 | 4.99 | 2 | SO70105 | 2024-07-06 | 0.40 | 1.87 | |
SO70105_3 | 19 | 15761 | 222 | 6 | 2024-07-11 | 0.87 | 2024-06-29 | 34.99 | 3 | SO70105 | 2024-07-06 | 2.80 | 13.09 | |
SO70111_1 | 19 | 12972 | 536 | 6 | 2024-07-11 | 0.75 | 2024-06-29 | 29.99 | 1 | SO70111 | 2024-07-06 | 2.40 | 11.22 | |
SO70111_2 | 19 | 12972 | 528 | 6 | 2024-07-11 | 0.12 | 2024-06-29 | 4.99 | 2 | SO70111 | 2024-07-06 | 0.40 | 1.87 | |
SO70111_3 | 19 | 12972 | 480 | 6 | 2024-07-11 | 0.06 | 2024-06-29 | 2.29 | 3 | SO70111 | 2024-07-06 | 0.18 | 0.86 | |
SO70112_1 | 19 | 19200 | 528 | 6 | 2024-07-11 | 0.12 | 2024-06-29 | 4.99 | 1 | SO70112 | 2024-07-06 | 0.40 | 1.87 | |
SO70112_2 | 19 | 19200 | 536 | 6 | 2024-07-11 | 0.75 | 2024-06-29 | 29.99 | 2 | SO70112 | 2024-07-06 | 2.40 | 11.22 | |
SO70112_3 | 19 | 19200 | 480 | 6 | 2024-07-11 | 0.06 | 2024-06-29 | 2.29 | 3 | SO70112 | 2024-07-06 | 0.18 | 0.86 | |
SO70113_1 | 19 | 14658 | 478 | 6 | 2024-07-11 | 0.25 | 2024-06-29 | 9.99 | 1 | SO70113 | 2024-07-06 | 0.80 | 3.74 | |
SO70113_2 | 19 | 14658 | 477 | 6 | 2024-07-11 | 0.12 | 2024-06-29 | 4.99 | 2 | SO70113 | 2024-07-06 | 0.40 | 1.87 | |
SO70113_3 | 19 | 14658 | 484 | 6 | 2024-07-11 | 0.20 | 2024-06-29 | 7.95 | 3 | SO70113 | 2024-07-06 | 0.64 | 2.97 | |
SO70132_1 | 19 | 16123 | 592 | 6 | 2024-07-11 | 14.12 | 2024-06-29 | 564.99 | 1 | SO70132 | 2024-07-06 | 45.20 | 308.22 | |
SO70132_2 | 19 | 16123 | 478 | 6 | 2024-07-11 | 0.25 | 2024-06-29 | 9.99 | 2 | SO70132 | 2024-07-06 | 0.80 | 3.74 | |
SO70132_3 | 19 | 16123 | 487 | 6 | 2024-07-11 | 1.37 | 2024-06-29 | 54.99 | 3 | SO70132 | 2024-07-06 | 4.40 | 20.57 | |
SO70133_1 | 19 | 20182 | 355 | 6 | 2024-07-11 | 58.00 | 2024-06-29 | 2319.99 | 1 | SO70133 | 2024-07-06 | 185.60 | 1265.62 | |
SO70133_2 | 19 | 20182 | 487 | 6 | 2024-07-11 | 1.37 | 2024-06-29 | 54.99 | 2 | SO70133 | 2024-07-06 | 4.40 | 20.57 | |
SO70142_1 | 19 | 20375 | 361 | 6 | 2024-07-11 | 57.37 | 2024-06-29 | 2294.99 | 1 | SO70142 | 2024-07-06 | 183.60 | 1251.98 | |
SO70142_2 | 19 | 20375 | 485 | 6 | 2024-07-11 | 0.55 | 2024-06-29 | 21.98 | 2 | SO70142 | 2024-07-06 | 1.76 | 8.22 | |
SO70142_3 | 19 | 20375 | 228 | 6 | 2024-07-11 | 1.25 | 2024-06-29 | 49.99 | 3 | SO70142 | 2024-07-06 | 4.00 | 38.49 | |
SO70143_1 | 19 | 19705 | 353 | 2 | 6 | 2024-07-11 | 58.00 | 2024-06-29 | 2319.99 | 1 | SO70143 | 2024-07-06 | 185.60 | 1265.62 |
SO70143_2 | 19 | 19705 | 485 | 6 | 2024-07-11 | 0.55 | 2024-06-29 | 21.98 | 2 | SO70143 | 2024-07-06 | 1.76 | 8.22 | |
SO70175_1 | 19 | 11619 | 530 | 6 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 1 | SO70175 | 2024-07-07 | 0.40 | 1.87 | |
SO70175_2 | 19 | 11619 | 487 | 6 | 2024-07-12 | 1.37 | 2024-06-30 | 54.99 | 2 | SO70175 | 2024-07-07 | 4.40 | 20.57 | |
SO70175_3 | 19 | 11619 | 484 | 6 | 2024-07-12 | 0.20 | 2024-06-30 | 7.95 | 3 | SO70175 | 2024-07-07 | 0.64 | 2.97 | |
SO70176_1 | 19 | 11277 | 540 | 6 | 2024-07-12 | 0.82 | 2024-06-30 | 32.60 | 1 | SO70176 | 2024-07-07 | 2.61 | 12.19 | |
SO70176_2 | 19 | 11277 | 228 | 6 | 2024-07-12 | 1.25 | 2024-06-30 | 49.99 | 2 | SO70176 | 2024-07-07 | 4.00 | 38.49 | |
SO70178_1 | 19 | 19000 | 536 | 6 | 2024-07-12 | 0.75 | 2024-06-30 | 29.99 | 1 | SO70178 | 2024-07-07 | 2.40 | 11.22 | |
SO70182_1 | 19 | 18821 | 475 | 6 | 2024-07-12 | 1.75 | 2024-06-30 | 69.99 | 1 | SO70182 | 2024-07-07 | 5.60 | 26.18 | |
SO70183_1 | 19 | 28121 | 476 | 6 | 2024-07-12 | 1.75 | 2024-06-30 | 69.99 | 1 | SO70183 | 2024-07-07 | 5.60 | 26.18 | |
SO70183_2 | 19 | 28121 | 234 | 6 | 2024-07-12 | 1.25 | 2024-06-30 | 49.99 | 2 | SO70183 | 2024-07-07 | 4.00 | 38.49 | |
SO70185_1 | 19 | 29104 | 476 | 6 | 2024-07-12 | 1.75 | 2024-06-30 | 69.99 | 1 | SO70185 | 2024-07-07 | 5.60 | 26.18 | |
SO70185_2 | 19 | 29104 | 225 | 6 | 2024-07-12 | 0.22 | 2024-06-30 | 8.99 | 2 | SO70185 | 2024-07-07 | 0.72 | 6.92 | |
SO70188_1 | 19 | 25196 | 477 | 6 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 1 | SO70188 | 2024-07-07 | 0.40 | 1.87 | |
SO70188_2 | 19 | 25196 | 231 | 6 | 2024-07-12 | 1.25 | 2024-06-30 | 49.99 | 2 | SO70188 | 2024-07-07 | 4.00 | 38.49 | |
SO70190_1 | 19 | 29231 | 477 | 6 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 1 | SO70190 | 2024-07-07 | 0.40 | 1.87 | |
SO70190_2 | 19 | 29231 | 222 | 6 | 2024-07-12 | 0.87 | 2024-06-30 | 34.99 | 2 | SO70190 | 2024-07-07 | 2.80 | 13.09 | |
SO70191_1 | 19 | 23488 | 528 | 6 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 1 | SO70191 | 2024-07-07 | 0.40 | 1.87 | |
SO70203_1 | 19 | 11091 | 537 | 6 | 2024-07-12 | 0.88 | 2024-06-30 | 35.00 | 1 | SO70203 | 2024-07-07 | 2.80 | 13.09 | |
SO70206_1 | 19 | 11841 | 528 | 6 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 1 | SO70206 | 2024-07-07 | 0.40 | 1.87 | |
SO70206_2 | 19 | 11841 | 537 | 6 | 2024-07-12 | 0.88 | 2024-06-30 | 35.00 | 2 | SO70206 | 2024-07-07 | 2.80 | 13.09 |
Generated 2024-09-21 06:40:30.133 UTC