[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2350 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58000_2 | 100 | 13273 | 485 | 4 | 2024-03-08 | 0.55 | 2024-02-25 | 21.98 | 2 | SO58000 | 2024-03-03 | 1.76 | 8.22 | |
SO58000_3 | 100 | 13273 | 486 | 4 | 2024-03-08 | 3.98 | 2024-02-25 | 159.00 | 3 | SO58000 | 2024-03-03 | 12.72 | 59.47 | |
SO58010_1 | 100 | 25386 | 560 | 4 | 2024-03-08 | 30.37 | 2024-02-25 | 1214.85 | 1 | SO58010 | 2024-03-03 | 97.19 | 755.15 | |
SO58010_2 | 100 | 25386 | 222 | 4 | 2024-03-08 | 0.87 | 2024-02-25 | 34.99 | 2 | SO58010 | 2024-03-03 | 2.80 | 13.09 | |
SO58011_1 | 100 | 25162 | 564 | 4 | 2024-03-08 | 59.60 | 2024-02-25 | 2384.07 | 1 | SO58011 | 2024-03-03 | 190.73 | 1481.94 | |
SO58013_1 | 100 | 25185 | 563 | 4 | 2024-03-08 | 59.60 | 2024-02-25 | 2384.07 | 1 | SO58013 | 2024-03-03 | 190.73 | 1481.94 | |
SO58013_2 | 100 | 25185 | 541 | 4 | 2024-03-08 | 0.72 | 2024-02-25 | 28.99 | 2 | SO58013 | 2024-03-03 | 2.32 | 10.84 | |
SO58013_3 | 100 | 25185 | 530 | 4 | 2024-03-08 | 0.12 | 2024-02-25 | 4.99 | 3 | SO58013 | 2024-03-03 | 0.40 | 1.87 | |
SO58013_4 | 100 | 25185 | 217 | 4 | 2024-03-08 | 0.87 | 2024-02-25 | 34.99 | 4 | SO58013 | 2024-03-03 | 2.80 | 13.09 | |
SO58016_1 | 100 | 20030 | 390 | 4 | 2024-03-08 | 28.01 | 2024-02-25 | 1120.49 | 1 | SO58016 | 2024-03-03 | 89.64 | 713.08 | |
SO58016_2 | 100 | 20030 | 222 | 4 | 2024-03-08 | 0.87 | 2024-02-25 | 34.99 | 2 | SO58016 | 2024-03-03 | 2.80 | 13.09 | |
SO58037_1 | 100 | 28860 | 539 | 4 | 2024-03-09 | 0.62 | 2024-02-26 | 24.99 | 1 | SO58037 | 2024-03-04 | 2.00 | 9.35 | |
SO58037_2 | 100 | 28860 | 529 | 4 | 2024-03-09 | 0.10 | 2024-02-26 | 3.99 | 2 | SO58037 | 2024-03-04 | 0.32 | 1.49 | |
SO58040_1 | 100 | 26314 | 529 | 4 | 2024-03-09 | 0.10 | 2024-02-26 | 3.99 | 1 | SO58040 | 2024-03-04 | 0.32 | 1.49 | |
SO58040_2 | 100 | 26314 | 538 | 4 | 2024-03-09 | 0.54 | 2024-02-26 | 21.49 | 2 | SO58040 | 2024-03-04 | 1.72 | 8.04 | |
SO58040_3 | 100 | 26314 | 473 | 4 | 2024-03-09 | 1.59 | 2024-02-26 | 63.50 | 3 | SO58040 | 2024-03-04 | 5.08 | 23.75 | |
SO58041_1 | 100 | 24355 | 540 | 4 | 2024-03-09 | 0.82 | 2024-02-26 | 32.60 | 1 | SO58041 | 2024-03-04 | 2.61 | 12.19 | |
SO58041_2 | 100 | 24355 | 529 | 4 | 2024-03-09 | 0.10 | 2024-02-26 | 3.99 | 2 | SO58041 | 2024-03-04 | 0.32 | 1.49 | |
SO68757_2 | 100 | 20536 | 477 | 4 | 2024-08-14 | 0.12 | 2024-08-02 | 4.99 | 2 | SO68757 | 2024-08-09 | 0.40 | 1.87 | |
SO68757_3 | 100 | 20536 | 225 | 4 | 2024-08-14 | 0.22 | 2024-08-02 | 8.99 | 3 | SO68757 | 2024-08-09 | 0.72 | 6.92 | |
SO68759_1 | 100 | 20112 | 225 | 4 | 2024-08-14 | 0.22 | 2024-08-02 | 8.99 | 1 | SO68759 | 2024-08-09 | 0.72 | 6.92 | |
SO68759_2 | 100 | 20112 | 475 | 4 | 2024-08-14 | 1.75 | 2024-08-02 | 69.99 | 2 | SO68759 | 2024-08-09 | 5.60 | 26.18 | |
SO68764_1 | 100 | 16152 | 528 | 4 | 2024-08-14 | 0.12 | 2024-08-02 | 4.99 | 1 | SO68764 | 2024-08-09 | 0.40 | 1.87 | |
SO68764_2 | 100 | 16152 | 217 | 4 | 2024-08-14 | 0.87 | 2024-08-02 | 34.99 | 2 | SO68764 | 2024-08-09 | 2.80 | 13.09 | |
SO68764_3 | 100 | 16152 | 463 | 4 | 2024-08-14 | 0.61 | 2024-08-02 | 24.49 | 3 | SO68764 | 2024-08-09 | 1.96 | 9.16 | |
SO68765_1 | 100 | 14513 | 528 | 4 | 2024-08-14 | 0.12 | 2024-08-02 | 4.99 | 1 | SO68765 | 2024-08-09 | 0.40 | 1.87 | |
SO68766_1 | 100 | 15741 | 528 | 4 | 2024-08-14 | 0.12 | 2024-08-02 | 4.99 | 1 | SO68766 | 2024-08-09 | 0.40 | 1.87 | |
SO68766_2 | 100 | 15741 | 214 | 4 | 2024-08-14 | 0.87 | 2024-08-02 | 34.99 | 2 | SO68766 | 2024-08-09 | 2.80 | 13.09 | |
SO68766_3 | 100 | 15741 | 234 | 4 | 2024-08-14 | 1.25 | 2024-08-02 | 49.99 | 3 | SO68766 | 2024-08-09 | 4.00 | 38.49 | |
SO68779_1 | 100 | 13236 | 485 | 4 | 2024-08-14 | 0.55 | 2024-08-02 | 21.98 | 1 | SO68779 | 2024-08-09 | 1.76 | 8.22 | |
SO68780_1 | 100 | 12887 | 485 | 4 | 2024-08-14 | 0.55 | 2024-08-02 | 21.98 | 1 | SO68780 | 2024-08-09 | 1.76 | 8.22 | |
SO68781_1 | 100 | 12921 | 355 | 4 | 2024-08-14 | 58.00 | 2024-08-02 | 2319.99 | 1 | SO68781 | 2024-08-09 | 185.60 | 1265.62 | |
SO68781_2 | 100 | 12921 | 537 | 4 | 2024-08-14 | 0.88 | 2024-08-02 | 35.00 | 2 | SO68781 | 2024-08-09 | 2.80 | 13.09 | |
SO68781_3 | 100 | 12921 | 528 | 4 | 2024-08-14 | 0.12 | 2024-08-02 | 4.99 | 3 | SO68781 | 2024-08-09 | 0.40 | 1.87 | |
SO68794_1 | 100 | 25362 | 567 | 4 | 2024-08-14 | 18.56 | 2024-08-02 | 742.35 | 1 | SO68794 | 2024-08-09 | 59.39 | 461.44 | |
SO68794_2 | 100 | 25362 | 479 | 4 | 2024-08-14 | 0.22 | 2024-08-02 | 8.99 | 2 | SO68794 | 2024-08-09 | 0.72 | 3.36 | |
SO68795_1 | 100 | 27527 | 562 | 4 | 2024-08-14 | 59.60 | 2024-08-02 | 2384.07 | 1 | SO68795 | 2024-08-09 | 190.73 | 1481.94 | |
SO68795_2 | 100 | 27527 | 214 | 4 | 2024-08-14 | 0.87 | 2024-08-02 | 34.99 | 2 | SO68795 | 2024-08-09 | 2.80 | 13.09 | |
SO68795_3 | 100 | 27527 | 467 | 2 | 4 | 2024-08-14 | 0.61 | 2024-08-02 | 24.49 | 3 | SO68795 | 2024-08-09 | 1.96 | 9.16 |
SO68796_1 | 100 | 27273 | 563 | 4 | 2024-08-14 | 59.60 | 2024-08-02 | 2384.07 | 1 | SO68796 | 2024-08-09 | 190.73 | 1481.94 | |
SO68796_2 | 100 | 27273 | 214 | 4 | 2024-08-14 | 0.87 | 2024-08-02 | 34.99 | 2 | SO68796 | 2024-08-09 | 2.80 | 13.09 | |
SO68800_1 | 100 | 18350 | 580 | 4 | 2024-08-14 | 42.52 | 2024-08-02 | 1700.99 | 1 | SO68800 | 2024-08-09 | 136.08 | 1082.51 | |
SO68800_2 | 100 | 18350 | 222 | 4 | 2024-08-14 | 0.87 | 2024-08-02 | 34.99 | 2 | SO68800 | 2024-08-09 | 2.80 | 13.09 | |
SO68801_1 | 100 | 18431 | 583 | 4 | 2024-08-14 | 42.52 | 2024-08-02 | 1700.99 | 1 | SO68801 | 2024-08-09 | 136.08 | 1082.51 | |
SO68801_2 | 100 | 18431 | 488 | 4 | 2024-08-14 | 1.35 | 2024-08-02 | 53.99 | 2 | SO68801 | 2024-08-09 | 4.32 | 41.57 | |
SO68828_1 | 100 | 26790 | 538 | 4 | 2024-08-15 | 0.54 | 2024-08-03 | 21.49 | 1 | SO68828 | 2024-08-10 | 1.72 | 8.04 | |
SO68828_2 | 100 | 26790 | 529 | 4 | 2024-08-15 | 0.10 | 2024-08-03 | 3.99 | 2 | SO68828 | 2024-08-10 | 0.32 | 1.49 | |
SO68828_3 | 100 | 26790 | 480 | 4 | 2024-08-15 | 0.06 | 2024-08-03 | 2.29 | 3 | SO68828 | 2024-08-10 | 0.18 | 0.86 | |
SO68831_1 | 100 | 27417 | 538 | 4 | 2024-08-15 | 0.54 | 2024-08-03 | 21.49 | 1 | SO68831 | 2024-08-10 | 1.72 | 8.04 | |
SO68832_1 | 100 | 25201 | 529 | 4 | 2024-08-15 | 0.10 | 2024-08-03 | 3.99 | 1 | SO68832 | 2024-08-10 | 0.32 | 1.49 | |
SO68832_2 | 100 | 25201 | 540 | 4 | 2024-08-15 | 0.82 | 2024-08-03 | 32.60 | 2 | SO68832 | 2024-08-10 | 2.61 | 12.19 | |
SO68832_3 | 100 | 25201 | 465 | 4 | 2024-08-15 | 0.61 | 2024-08-03 | 24.49 | 3 | SO68832 | 2024-08-10 | 1.96 | 9.16 | |
SO68832_4 | 100 | 25201 | 222 | 4 | 2024-08-15 | 0.87 | 2024-08-03 | 34.99 | 4 | SO68832 | 2024-08-10 | 2.80 | 13.09 | |
SO68834_1 | 100 | 26203 | 535 | 4 | 2024-08-15 | 0.62 | 2024-08-03 | 24.99 | 1 | SO68834 | 2024-08-10 | 2.00 | 9.35 | |
SO68834_2 | 100 | 26203 | 528 | 4 | 2024-08-15 | 0.12 | 2024-08-03 | 4.99 | 2 | SO68834 | 2024-08-10 | 0.40 | 1.87 | |
SO68834_3 | 100 | 26203 | 486 | 4 | 2024-08-15 | 3.98 | 2024-08-03 | 159.00 | 3 | SO68834 | 2024-08-10 | 12.72 | 59.47 | |
SO68836_1 | 100 | 24426 | 540 | 4 | 2024-08-15 | 0.82 | 2024-08-03 | 32.60 | 1 | SO68836 | 2024-08-10 | 2.61 | 12.19 | |
SO68836_2 | 100 | 24426 | 529 | 4 | 2024-08-15 | 0.10 | 2024-08-03 | 3.99 | 2 | SO68836 | 2024-08-10 | 0.32 | 1.49 | |
SO68836_3 | 100 | 24426 | 217 | 4 | 2024-08-15 | 0.87 | 2024-08-03 | 34.99 | 3 | SO68836 | 2024-08-10 | 2.80 | 13.09 | |
SO68837_1 | 100 | 21697 | 478 | 4 | 2024-08-15 | 0.25 | 2024-08-03 | 9.99 | 1 | SO68837 | 2024-08-10 | 0.80 | 3.74 |
Generated 2024-11-10 10:51:23.425 UTC