[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 2531 < SKIP 1875 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69134_1 | 19 | 18122 | 353 | 2 | 6 | 2024-08-19 | 58.00 | 2024-08-07 | 2319.99 | 1 | SO69134 | 2024-08-14 | 185.60 | 1265.62 |
SO69134_2 | 19 | 18122 | 483 | 6 | 2024-08-19 | 3.00 | 2024-08-07 | 120.00 | 2 | SO69134 | 2024-08-14 | 9.60 | 44.88 | |
SO69148_1 | 19 | 15175 | 575 | 6 | 2024-08-19 | 59.60 | 2024-08-07 | 2384.07 | 1 | SO69148 | 2024-08-14 | 190.73 | 1481.94 | |
SO69177_1 | 19 | 11019 | 214 | 6 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 1 | SO69177 | 2024-08-15 | 2.80 | 13.09 | |
SO69178_1 | 19 | 14282 | 489 | 6 | 2024-08-20 | 1.35 | 2024-08-08 | 53.99 | 1 | SO69178 | 2024-08-15 | 4.32 | 41.57 | |
SO69181_1 | 19 | 11711 | 530 | 6 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 1 | SO69181 | 2024-08-15 | 0.40 | 1.87 | |
SO69182_1 | 19 | 11300 | 530 | 6 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 1 | SO69182 | 2024-08-15 | 0.40 | 1.87 | |
SO69182_2 | 19 | 11300 | 480 | 2 | 6 | 2024-08-20 | 0.06 | 2024-08-08 | 2.29 | 2 | SO69182 | 2024-08-15 | 0.18 | 0.86 |
SO69182_3 | 19 | 11300 | 486 | 6 | 2024-08-20 | 3.98 | 2024-08-08 | 159.00 | 3 | SO69182 | 2024-08-15 | 12.72 | 59.47 | |
SO69184_1 | 19 | 15008 | 529 | 6 | 2024-08-20 | 0.10 | 2024-08-08 | 3.99 | 1 | SO69184 | 2024-08-15 | 0.32 | 1.49 | |
SO69184_2 | 19 | 15008 | 540 | 6 | 2024-08-20 | 0.82 | 2024-08-08 | 32.60 | 2 | SO69184 | 2024-08-15 | 2.61 | 12.19 | |
SO69184_3 | 19 | 15008 | 217 | 6 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 3 | SO69184 | 2024-08-15 | 2.80 | 13.09 | |
SO69185_1 | 19 | 18637 | 536 | 6 | 2024-08-20 | 0.75 | 2024-08-08 | 29.99 | 1 | SO69185 | 2024-08-15 | 2.40 | 11.22 | |
SO69186_1 | 19 | 15866 | 478 | 6 | 2024-08-20 | 0.25 | 2024-08-08 | 9.99 | 1 | SO69186 | 2024-08-15 | 0.80 | 3.74 | |
SO69186_2 | 19 | 15866 | 477 | 6 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 2 | SO69186 | 2024-08-15 | 0.40 | 1.87 | |
SO69186_3 | 19 | 15866 | 214 | 6 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 3 | SO69186 | 2024-08-15 | 2.80 | 13.09 | |
SO69187_1 | 19 | 13285 | 478 | 6 | 2024-08-20 | 0.25 | 2024-08-08 | 9.99 | 1 | SO69187 | 2024-08-15 | 0.80 | 3.74 | |
SO69187_2 | 19 | 13285 | 477 | 6 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 2 | SO69187 | 2024-08-15 | 0.40 | 1.87 | |
SO69187_3 | 19 | 13285 | 487 | 6 | 2024-08-20 | 1.37 | 2024-08-08 | 54.99 | 3 | SO69187 | 2024-08-15 | 4.40 | 20.57 | |
SO69187_4 | 19 | 13285 | 465 | 6 | 2024-08-20 | 0.61 | 2024-08-08 | 24.49 | 4 | SO69187 | 2024-08-15 | 1.96 | 9.16 | |
SO69195_1 | 19 | 21803 | 528 | 6 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 1 | SO69195 | 2024-08-15 | 0.40 | 1.87 | |
SO69195_2 | 19 | 21803 | 214 | 6 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 2 | SO69195 | 2024-08-15 | 2.80 | 13.09 | |
SO69209_1 | 19 | 12074 | 528 | 6 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 1 | SO69209 | 2024-08-15 | 0.40 | 1.87 | |
SO69209_2 | 19 | 12074 | 537 | 6 | 2024-08-20 | 0.88 | 2024-08-08 | 35.00 | 2 | SO69209 | 2024-08-15 | 2.80 | 13.09 | |
SO69209_3 | 19 | 12074 | 222 | 6 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 3 | SO69209 | 2024-08-15 | 2.80 | 13.09 | |
SO69209_4 | 19 | 12074 | 467 | 6 | 2024-08-20 | 0.61 | 2024-08-08 | 24.49 | 4 | SO69209 | 2024-08-15 | 1.96 | 9.16 | |
SO69214_1 | 19 | 18595 | 359 | 6 | 2024-08-20 | 57.37 | 2024-08-08 | 2294.99 | 1 | SO69214 | 2024-08-15 | 183.60 | 1251.98 | |
SO69214_2 | 19 | 18595 | 537 | 6 | 2024-08-20 | 0.88 | 2024-08-08 | 35.00 | 2 | SO69214 | 2024-08-15 | 2.80 | 13.09 | |
SO69229_1 | 19 | 15187 | 561 | 6 | 2024-08-20 | 59.60 | 2024-08-08 | 2384.07 | 1 | SO69229 | 2024-08-15 | 190.73 | 1481.94 | |
SO69229_2 | 19 | 15187 | 541 | 6 | 2024-08-20 | 0.72 | 2024-08-08 | 28.99 | 2 | SO69229 | 2024-08-15 | 2.32 | 10.84 | |
SO69229_3 | 19 | 15187 | 530 | 6 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 3 | SO69229 | 2024-08-15 | 0.40 | 1.87 | |
SO69229_4 | 19 | 15187 | 480 | 6 | 2024-08-20 | 0.06 | 2024-08-08 | 2.29 | 4 | SO69229 | 2024-08-15 | 0.18 | 0.86 | |
SO69233_1 | 19 | 27075 | 584 | 6 | 2024-08-20 | 13.50 | 2024-08-08 | 539.99 | 1 | SO69233 | 2024-08-15 | 43.20 | 343.65 | |
SO69233_2 | 19 | 27075 | 479 | 6 | 2024-08-20 | 0.22 | 2024-08-08 | 8.99 | 2 | SO69233 | 2024-08-15 | 0.72 | 3.36 | |
SO69233_3 | 19 | 27075 | 477 | 6 | 2024-08-20 | 0.12 | 2024-08-08 | 4.99 | 3 | SO69233 | 2024-08-15 | 0.40 | 1.87 | |
SO69233_4 | 19 | 27075 | 222 | 6 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 4 | SO69233 | 2024-08-15 | 2.80 | 13.09 | |
SO69235_1 | 19 | 20188 | 384 | 6 | 2024-08-20 | 28.01 | 2024-08-08 | 1120.49 | 1 | SO69235 | 2024-08-15 | 89.64 | 713.08 | |
SO69235_2 | 19 | 20188 | 222 | 6 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 2 | SO69235 | 2024-08-15 | 2.80 | 13.09 | |
SO69259_1 | 19 | 11519 | 529 | 6 | 2024-08-21 | 0.10 | 2024-08-09 | 3.99 | 1 | SO69259 | 2024-08-16 | 0.32 | 1.49 | |
SO69259_2 | 19 | 11519 | 539 | 6 | 2024-08-21 | 0.62 | 2024-08-09 | 24.99 | 2 | SO69259 | 2024-08-16 | 2.00 | 9.35 | |
SO69259_3 | 19 | 11519 | 217 | 6 | 2024-08-21 | 0.87 | 2024-08-09 | 34.99 | 3 | SO69259 | 2024-08-16 | 2.80 | 13.09 | |
SO69262_1 | 19 | 11176 | 535 | 6 | 2024-08-21 | 0.62 | 2024-08-09 | 24.99 | 1 | SO69262 | 2024-08-16 | 2.00 | 9.35 | |
SO69262_2 | 19 | 11176 | 528 | 6 | 2024-08-21 | 0.12 | 2024-08-09 | 4.99 | 2 | SO69262 | 2024-08-16 | 0.40 | 1.87 | |
SO69262_3 | 19 | 11176 | 217 | 6 | 2024-08-21 | 0.87 | 2024-08-09 | 34.99 | 3 | SO69262 | 2024-08-16 | 2.80 | 13.09 | |
SO69262_4 | 19 | 11176 | 228 | 6 | 2024-08-21 | 1.25 | 2024-08-09 | 49.99 | 4 | SO69262 | 2024-08-16 | 4.00 | 38.49 | |
SO59998_1 | 19 | 11632 | 536 | 6 | 2024-04-06 | 0.75 | 2024-03-25 | 29.99 | 1 | SO59998 | 2024-04-01 | 2.40 | 11.22 | |
SO59998_2 | 19 | 11632 | 528 | 6 | 2024-04-06 | 0.12 | 2024-03-25 | 4.99 | 2 | SO59998 | 2024-04-01 | 0.40 | 1.87 | |
SO59998_3 | 19 | 11632 | 217 | 6 | 2024-04-06 | 0.87 | 2024-03-25 | 34.99 | 3 | SO59998 | 2024-04-01 | 2.80 | 13.09 | |
SO60000_1 | 19 | 15377 | 478 | 6 | 2024-04-06 | 0.25 | 2024-03-25 | 9.99 | 1 | SO60000 | 2024-04-01 | 0.80 | 3.74 | |
SO60000_2 | 19 | 15377 | 477 | 6 | 2024-04-06 | 0.12 | 2024-03-25 | 4.99 | 2 | SO60000 | 2024-04-01 | 0.40 | 1.87 | |
SO60000_3 | 19 | 15377 | 484 | 6 | 2024-04-06 | 0.20 | 2024-03-25 | 7.95 | 3 | SO60000 | 2024-04-01 | 0.64 | 2.97 | |
SO60005_1 | 19 | 11833 | 477 | 6 | 2024-04-06 | 0.12 | 2024-03-25 | 4.99 | 1 | SO60005 | 2024-04-01 | 0.40 | 1.87 | |
SO60005_2 | 19 | 11833 | 225 | 6 | 2024-04-06 | 0.22 | 2024-03-25 | 8.99 | 2 | SO60005 | 2024-04-01 | 0.72 | 6.92 | |
SO60007_1 | 19 | 22107 | 485 | 6 | 2024-04-06 | 0.55 | 2024-03-25 | 21.98 | 1 | SO60007 | 2024-04-01 | 1.76 | 8.22 | |
SO60007_2 | 19 | 22107 | 228 | 6 | 2024-04-06 | 1.25 | 2024-03-25 | 49.99 | 2 | SO60007 | 2024-04-01 | 4.00 | 38.49 | |
SO60030_1 | 19 | 25992 | 584 | 6 | 2024-04-06 | 13.50 | 2024-03-25 | 539.99 | 1 | SO60030 | 2024-04-01 | 43.20 | 343.65 | |
SO60032_1 | 19 | 19394 | 382 | 6 | 2024-04-06 | 28.01 | 2024-03-25 | 1120.49 | 1 | SO60032 | 2024-04-01 | 89.64 | 713.08 | |
SO60032_2 | 19 | 19394 | 222 | 6 | 2024-04-06 | 0.87 | 2024-03-25 | 34.99 | 2 | SO60032 | 2024-04-01 | 2.80 | 13.09 | |
SO60036_1 | 19 | 17023 | 582 | 6 | 2024-04-06 | 42.52 | 2024-03-25 | 1700.99 | 1 | SO60036 | 2024-04-01 | 136.08 | 1082.51 | |
SO60036_2 | 19 | 17023 | 214 | 6 | 2024-04-06 | 0.87 | 2024-03-25 | 34.99 | 2 | SO60036 | 2024-04-01 | 2.80 | 13.09 | |
SO60065_1 | 19 | 11176 | 540 | 6 | 2024-04-07 | 0.82 | 2024-03-26 | 32.60 | 1 | SO60065 | 2024-04-02 | 2.61 | 12.19 | |
SO60065_2 | 19 | 11176 | 529 | 6 | 2024-04-07 | 0.10 | 2024-03-26 | 3.99 | 2 | SO60065 | 2024-04-02 | 0.32 | 1.49 |
Generated 2024-11-10 16:57:36.526 UTC