[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > SKIP 4000 < SKIP 872 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO54044_3 | 6 | 21993 | 222 | 9 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 3 | SO54044 | 2023-12-27 | 2.80 | 13.09 | |
SO54045_1 | 6 | 18898 | 537 | 9 | 2024-01-01 | 0.88 | 2023-12-20 | 35.00 | 1 | SO54045 | 2023-12-27 | 2.80 | 13.09 | |
SO54045_2 | 6 | 18898 | 528 | 9 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 2 | SO54045 | 2023-12-27 | 0.40 | 1.87 | |
SO54045_3 | 6 | 18898 | 222 | 9 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 3 | SO54045 | 2023-12-27 | 2.80 | 13.09 | |
SO54046_1 | 6 | 29333 | 477 | 9 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 1 | SO54046 | 2023-12-27 | 0.40 | 1.87 | |
SO54046_2 | 6 | 29333 | 231 | 9 | 2024-01-01 | 1.25 | 2023-12-20 | 49.99 | 2 | SO54046 | 2023-12-27 | 4.00 | 38.49 | |
SO54047_1 | 6 | 24276 | 477 | 9 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 1 | SO54047 | 2023-12-27 | 0.40 | 1.87 | |
SO54047_2 | 6 | 24276 | 478 | 9 | 2024-01-01 | 0.25 | 2023-12-20 | 9.99 | 2 | SO54047 | 2023-12-27 | 0.80 | 3.74 | |
SO54047_3 | 6 | 24276 | 225 | 9 | 2024-01-01 | 0.22 | 2023-12-20 | 8.99 | 3 | SO54047 | 2023-12-27 | 0.72 | 6.92 | |
SO54096_1 | 6 | 16744 | 376 | 9 | 2024-01-01 | 61.08 | 2023-12-20 | 2443.35 | 1 | SO54096 | 2023-12-27 | 195.47 | 1554.95 | |
SO54096_2 | 6 | 16744 | 477 | 9 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 2 | SO54096 | 2023-12-27 | 0.40 | 1.87 | |
SO54096_3 | 6 | 16744 | 479 | 9 | 2024-01-01 | 0.22 | 2023-12-20 | 8.99 | 3 | SO54096 | 2023-12-27 | 0.72 | 3.36 | |
SO54096_4 | 6 | 16744 | 222 | 9 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 4 | SO54096 | 2023-12-27 | 2.80 | 13.09 | |
SO54097_1 | 6 | 11900 | 353 | 2 | 9 | 2024-01-01 | 58.00 | 2023-12-20 | 2319.99 | 1 | SO54097 | 2023-12-27 | 185.60 | 1265.62 |
SO54097_2 | 6 | 11900 | 487 | 9 | 2024-01-01 | 1.37 | 2023-12-20 | 54.99 | 2 | SO54097 | 2023-12-27 | 4.40 | 20.57 | |
SO54103_1 | 6 | 24903 | 386 | 9 | 2024-01-02 | 28.01 | 2023-12-21 | 1120.49 | 1 | SO54103 | 2023-12-28 | 89.64 | 713.08 | |
SO54103_2 | 6 | 24903 | 214 | 9 | 2024-01-02 | 0.87 | 2023-12-21 | 34.99 | 2 | SO54103 | 2023-12-28 | 2.80 | 13.09 | |
SO54103_3 | 6 | 24903 | 481 | 9 | 2024-01-02 | 0.22 | 2023-12-21 | 8.99 | 3 | SO54103 | 2023-12-28 | 0.72 | 3.36 | |
SO54106_1 | 6 | 14217 | 535 | 9 | 2024-01-02 | 0.62 | 2023-12-21 | 24.99 | 1 | SO54106 | 2023-12-28 | 2.00 | 9.35 | |
SO54106_2 | 6 | 14217 | 528 | 9 | 2024-01-02 | 0.12 | 2023-12-21 | 4.99 | 2 | SO54106 | 2023-12-28 | 0.40 | 1.87 | |
SO54106_3 | 6 | 14217 | 214 | 9 | 2024-01-02 | 0.87 | 2023-12-21 | 34.99 | 3 | SO54106 | 2023-12-28 | 2.80 | 13.09 | |
SO54106_4 | 6 | 14217 | 463 | 9 | 2024-01-02 | 0.61 | 2023-12-21 | 24.49 | 4 | SO54106 | 2023-12-28 | 1.96 | 9.16 | |
SO54107_1 | 6 | 27704 | 528 | 9 | 2024-01-02 | 0.12 | 2023-12-21 | 4.99 | 1 | SO54107 | 2023-12-28 | 0.40 | 1.87 | |
SO54107_2 | 6 | 27704 | 537 | 9 | 2024-01-02 | 0.88 | 2023-12-21 | 35.00 | 2 | SO54107 | 2023-12-28 | 2.80 | 13.09 | |
SO54107_3 | 6 | 27704 | 480 | 9 | 2024-01-02 | 0.06 | 2023-12-21 | 2.29 | 3 | SO54107 | 2023-12-28 | 0.18 | 0.86 | |
SO54108_1 | 6 | 16619 | 540 | 9 | 2024-01-02 | 0.82 | 2023-12-21 | 32.60 | 1 | SO54108 | 2023-12-28 | 2.61 | 12.19 | |
SO54108_2 | 6 | 16619 | 217 | 9 | 2024-01-02 | 0.87 | 2023-12-21 | 34.99 | 2 | SO54108 | 2023-12-28 | 2.80 | 13.09 | |
SO54136_1 | 6 | 20822 | 584 | 9 | 2024-01-02 | 13.50 | 2023-12-21 | 539.99 | 1 | SO54136 | 2023-12-28 | 43.20 | 343.65 | |
SO54136_2 | 6 | 20822 | 479 | 9 | 2024-01-02 | 0.22 | 2023-12-21 | 8.99 | 2 | SO54136 | 2023-12-28 | 0.72 | 3.36 | |
SO54136_3 | 6 | 20822 | 477 | 9 | 2024-01-02 | 0.12 | 2023-12-21 | 4.99 | 3 | SO54136 | 2023-12-28 | 0.40 | 1.87 | |
SO54136_4 | 6 | 20822 | 480 | 9 | 2024-01-02 | 0.06 | 2023-12-21 | 2.29 | 4 | SO54136 | 2023-12-28 | 0.18 | 0.86 | |
SO54137_1 | 6 | 20426 | 606 | 2 | 9 | 2024-01-02 | 13.50 | 2023-12-21 | 539.99 | 1 | SO54137 | 2023-12-28 | 43.20 | 343.65 |
SO54137_2 | 6 | 20426 | 538 | 9 | 2024-01-02 | 0.54 | 2023-12-21 | 21.49 | 2 | SO54137 | 2023-12-28 | 1.72 | 8.04 | |
SO54138_1 | 6 | 28115 | 605 | 9 | 2024-01-02 | 13.50 | 2023-12-21 | 539.99 | 1 | SO54138 | 2023-12-28 | 43.20 | 343.65 | |
SO54138_2 | 6 | 28115 | 479 | 9 | 2024-01-02 | 0.22 | 2023-12-21 | 8.99 | 2 | SO54138 | 2023-12-28 | 0.72 | 3.36 | |
SO54138_3 | 6 | 28115 | 477 | 9 | 2024-01-02 | 0.12 | 2023-12-21 | 4.99 | 3 | SO54138 | 2023-12-28 | 0.40 | 1.87 | |
SO54138_4 | 6 | 28115 | 482 | 9 | 2024-01-02 | 0.22 | 2023-12-21 | 8.99 | 4 | SO54138 | 2023-12-28 | 0.72 | 3.36 | |
SO54139_1 | 6 | 18708 | 380 | 9 | 2024-01-02 | 61.08 | 2023-12-21 | 2443.35 | 1 | SO54139 | 2023-12-28 | 195.47 | 1554.95 | |
SO54139_2 | 6 | 18708 | 540 | 9 | 2024-01-02 | 0.82 | 2023-12-21 | 32.60 | 2 | SO54139 | 2023-12-28 | 2.61 | 12.19 | |
SO54139_3 | 6 | 18708 | 480 | 9 | 2024-01-02 | 0.06 | 2023-12-21 | 2.29 | 3 | SO54139 | 2023-12-28 | 0.18 | 0.86 | |
SO54140_1 | 6 | 12013 | 596 | 9 | 2024-01-02 | 13.50 | 2023-12-21 | 539.99 | 1 | SO54140 | 2023-12-28 | 43.20 | 294.58 | |
SO54140_2 | 6 | 12013 | 478 | 9 | 2024-01-02 | 0.25 | 2023-12-21 | 9.99 | 2 | SO54140 | 2023-12-28 | 0.80 | 3.74 | |
SO54148_1 | 6 | 18494 | 372 | 9 | 2024-01-03 | 61.08 | 2023-12-22 | 2443.35 | 1 | SO54148 | 2023-12-29 | 195.47 | 1554.95 | |
SO54148_2 | 6 | 18494 | 479 | 9 | 2024-01-03 | 0.22 | 2023-12-22 | 8.99 | 2 | SO54148 | 2023-12-29 | 0.72 | 3.36 | |
SO54148_3 | 6 | 18494 | 477 | 9 | 2024-01-03 | 0.12 | 2023-12-22 | 4.99 | 3 | SO54148 | 2023-12-29 | 0.40 | 1.87 | |
SO54148_4 | 6 | 18494 | 480 | 9 | 2024-01-03 | 0.06 | 2023-12-22 | 2.29 | 4 | SO54148 | 2023-12-29 | 0.18 | 0.86 | |
SO54150_1 | 6 | 15579 | 539 | 9 | 2024-01-03 | 0.62 | 2023-12-22 | 24.99 | 1 | SO54150 | 2023-12-29 | 2.00 | 9.35 | |
SO54151_1 | 6 | 17062 | 536 | 9 | 2024-01-03 | 0.75 | 2023-12-22 | 29.99 | 1 | SO54151 | 2023-12-29 | 2.40 | 11.22 | |
SO54151_2 | 6 | 17062 | 528 | 9 | 2024-01-03 | 0.12 | 2023-12-22 | 4.99 | 2 | SO54151 | 2023-12-29 | 0.40 | 1.87 | |
SO54151_3 | 6 | 17062 | 480 | 9 | 2024-01-03 | 0.06 | 2023-12-22 | 2.29 | 3 | SO54151 | 2023-12-29 | 0.18 | 0.86 | |
SO54152_1 | 6 | 25220 | 538 | 9 | 2024-01-03 | 0.54 | 2023-12-22 | 21.49 | 1 | SO54152 | 2023-12-29 | 1.72 | 8.04 | |
SO54152_2 | 6 | 25220 | 480 | 9 | 2024-01-03 | 0.06 | 2023-12-22 | 2.29 | 2 | SO54152 | 2023-12-29 | 0.18 | 0.86 | |
SO54176_1 | 6 | 18729 | 582 | 9 | 2024-01-03 | 42.52 | 2023-12-22 | 1700.99 | 1 | SO54176 | 2023-12-29 | 136.08 | 1082.51 | |
SO54176_2 | 6 | 18729 | 490 | 9 | 2024-01-03 | 1.35 | 2023-12-22 | 53.99 | 2 | SO54176 | 2023-12-29 | 4.32 | 41.57 | |
SO54185_1 | 6 | 23524 | 388 | 9 | 2024-01-04 | 28.01 | 2023-12-23 | 1120.49 | 1 | SO54185 | 2023-12-30 | 89.64 | 713.08 | |
SO54185_2 | 6 | 23524 | 222 | 9 | 2024-01-04 | 0.87 | 2023-12-23 | 34.99 | 2 | SO54185 | 2023-12-30 | 2.80 | 13.09 |
Generated 2024-11-10 20:10:22.366 UTC