[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '8' > < SKIP 1308 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69095_2 | 100 | 14797 | 237 | 8 | 2024-08-19 | 1.25 | 2024-08-07 | 49.99 | 2 | SO69095 | 2024-08-14 | 4.00 | 38.49 | |
SO51361_1 | 100 | 25795 | 376 | 8 | 2023-11-03 | 61.08 | 2023-10-22 | 2443.35 | 1 | SO51361 | 2023-10-29 | 195.47 | 1554.95 | |
SO58357_3 | 100 | 17761 | 231 | 8 | 2024-03-15 | 1.25 | 2024-03-03 | 49.99 | 3 | SO58357 | 2024-03-10 | 4.00 | 38.49 | |
SO62428_1 | 100 | 15001 | 485 | 8 | 2024-05-13 | 0.55 | 2024-05-01 | 21.98 | 1 | SO62428 | 2024-05-08 | 1.76 | 8.22 | |
SO69099_1 | 100 | 12713 | 355 | 8 | 2024-08-19 | 58.00 | 2024-08-07 | 2319.99 | 1 | SO69099 | 2024-08-14 | 185.60 | 1265.62 | |
SO51361_2 | 100 | 25795 | 540 | 8 | 2023-11-03 | 0.82 | 2023-10-22 | 32.60 | 2 | SO51361 | 2023-10-29 | 2.61 | 12.19 | |
SO58384_1 | 100 | 15633 | 472 | 8 | 2024-03-15 | 1.59 | 2024-03-03 | 63.50 | 1 | SO58384 | 2024-03-10 | 5.08 | 23.75 | |
SO62428_2 | 100 | 15001 | 481 | 8 | 2024-05-13 | 0.22 | 2024-05-01 | 8.99 | 2 | SO62428 | 2024-05-08 | 0.72 | 3.36 | |
SO69099_2 | 100 | 12713 | 478 | 8 | 2024-08-19 | 0.25 | 2024-08-07 | 9.99 | 2 | SO69099 | 2024-08-14 | 0.80 | 3.74 | |
SO51361_3 | 100 | 25795 | 529 | 8 | 2023-11-03 | 0.10 | 2023-10-22 | 3.99 | 3 | SO51361 | 2023-10-29 | 0.32 | 1.49 | |
SO58384_2 | 100 | 15633 | 528 | 8 | 2024-03-15 | 0.12 | 2024-03-03 | 4.99 | 2 | SO58384 | 2024-03-10 | 0.40 | 1.87 | |
SO62429_1 | 100 | 17718 | 535 | 8 | 2024-05-13 | 0.62 | 2024-05-01 | 24.99 | 1 | SO62429 | 2024-05-08 | 2.00 | 9.35 | |
SO69099_3 | 100 | 12713 | 477 | 8 | 2024-08-19 | 0.12 | 2024-08-07 | 4.99 | 3 | SO69099 | 2024-08-14 | 0.40 | 1.87 | |
SO51361_4 | 100 | 25795 | 480 | 8 | 2023-11-03 | 0.06 | 2023-10-22 | 2.29 | 4 | SO51361 | 2023-10-29 | 0.18 | 0.86 | |
SO58385_1 | 100 | 18034 | 539 | 8 | 2024-03-15 | 0.62 | 2024-03-03 | 24.99 | 1 | SO58385 | 2024-03-10 | 2.00 | 9.35 | |
SO62429_2 | 100 | 17718 | 528 | 8 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 2 | SO62429 | 2024-05-08 | 0.40 | 1.87 | |
SO69099_4 | 100 | 12713 | 214 | 8 | 2024-08-19 | 0.87 | 2024-08-07 | 34.99 | 4 | SO69099 | 2024-08-14 | 2.80 | 13.09 | |
SO51373_1 | 100 | 22414 | 584 | 8 | 2023-11-03 | 13.50 | 2023-10-22 | 539.99 | 1 | SO51373 | 2023-10-29 | 43.20 | 343.65 | |
SO58385_2 | 100 | 18034 | 529 | 8 | 2024-03-15 | 0.10 | 2024-03-03 | 3.99 | 2 | SO58385 | 2024-03-10 | 0.32 | 1.49 | |
SO62429_3 | 100 | 17718 | 480 | 2 | 8 | 2024-05-13 | 0.06 | 2024-05-01 | 2.29 | 3 | SO62429 | 2024-05-08 | 0.18 | 0.86 |
SO69101_1 | 100 | 18045 | 581 | 8 | 2024-08-19 | 42.52 | 2024-08-07 | 1700.99 | 1 | SO69101 | 2024-08-14 | 136.08 | 1082.51 | |
SO51373_2 | 100 | 22414 | 222 | 8 | 2023-11-03 | 0.87 | 2023-10-22 | 34.99 | 2 | SO51373 | 2023-10-29 | 2.80 | 13.09 | |
SO58385_3 | 100 | 18034 | 222 | 8 | 2024-03-15 | 0.87 | 2024-03-03 | 34.99 | 3 | SO58385 | 2024-03-10 | 2.80 | 13.09 | |
SO62431_1 | 100 | 24531 | 472 | 8 | 2024-05-13 | 1.59 | 2024-05-01 | 63.50 | 1 | SO62431 | 2024-05-08 | 5.08 | 23.75 | |
SO69101_2 | 100 | 18045 | 237 | 8 | 2024-08-19 | 1.25 | 2024-08-07 | 49.99 | 2 | SO69101 | 2024-08-14 | 4.00 | 38.49 | |
SO51389_1 | 100 | 19428 | 384 | 8 | 2023-11-04 | 28.01 | 2023-10-23 | 1120.49 | 1 | SO51389 | 2023-10-30 | 89.64 | 713.08 | |
SO58411_1 | 100 | 20719 | 386 | 8 | 2024-03-15 | 28.01 | 2024-03-03 | 1120.49 | 1 | SO58411 | 2024-03-10 | 89.64 | 713.08 | |
SO62431_2 | 100 | 24531 | 529 | 8 | 2024-05-13 | 0.10 | 2024-05-01 | 3.99 | 2 | SO62431 | 2024-05-08 | 0.32 | 1.49 | |
SO69101_3 | 100 | 18045 | 481 | 8 | 2024-08-19 | 0.22 | 2024-08-07 | 8.99 | 3 | SO69101 | 2024-08-14 | 0.72 | 3.36 | |
SO51389_2 | 100 | 19428 | 225 | 8 | 2023-11-04 | 0.22 | 2023-10-23 | 8.99 | 2 | SO51389 | 2023-10-30 | 0.72 | 6.92 | |
SO58411_2 | 100 | 20719 | 225 | 8 | 2024-03-15 | 0.22 | 2024-03-03 | 8.99 | 2 | SO58411 | 2024-03-10 | 0.72 | 6.92 | |
SO62432_1 | 100 | 25317 | 529 | 8 | 2024-05-13 | 0.10 | 2024-05-01 | 3.99 | 1 | SO62432 | 2024-05-08 | 0.32 | 1.49 | |
SO69102_1 | 100 | 17952 | 583 | 8 | 2024-08-19 | 42.52 | 2024-08-07 | 1700.99 | 1 | SO69102 | 2024-08-14 | 136.08 | 1082.51 | |
SO51389_3 | 100 | 19428 | 234 | 8 | 2023-11-04 | 1.25 | 2023-10-23 | 49.99 | 3 | SO51389 | 2023-10-30 | 4.00 | 38.49 | |
SO58411_3 | 100 | 20719 | 214 | 8 | 2024-03-15 | 0.87 | 2024-03-03 | 34.99 | 3 | SO58411 | 2024-03-10 | 2.80 | 13.09 | |
SO62432_2 | 100 | 25317 | 538 | 8 | 2024-05-13 | 0.54 | 2024-05-01 | 21.49 | 2 | SO62432 | 2024-05-08 | 1.72 | 8.04 | |
SO69102_2 | 100 | 17952 | 234 | 8 | 2024-08-19 | 1.25 | 2024-08-07 | 49.99 | 2 | SO69102 | 2024-08-14 | 4.00 | 38.49 | |
SO51410_1 | 100 | 14945 | 600 | 8 | 2023-11-06 | 13.50 | 2023-10-25 | 539.99 | 1 | SO51410 | 2023-11-01 | 43.20 | 294.58 | |
SO58413_1 | 100 | 12461 | 605 | 8 | 2024-03-15 | 13.50 | 2024-03-03 | 539.99 | 1 | SO58413 | 2024-03-10 | 43.20 | 343.65 | |
SO62432_3 | 100 | 25317 | 471 | 8 | 2024-05-13 | 1.59 | 2024-05-01 | 63.50 | 3 | SO62432 | 2024-05-08 | 5.08 | 23.75 | |
SO69102_3 | 100 | 17952 | 482 | 8 | 2024-08-19 | 0.22 | 2024-08-07 | 8.99 | 3 | SO69102 | 2024-08-14 | 0.72 | 3.36 | |
SO51410_2 | 100 | 14945 | 485 | 8 | 2023-11-06 | 0.55 | 2023-10-25 | 21.98 | 2 | SO51410 | 2023-11-01 | 1.76 | 8.22 | |
SO58413_2 | 100 | 12461 | 479 | 8 | 2024-03-15 | 0.22 | 2024-03-03 | 8.99 | 2 | SO58413 | 2024-03-10 | 0.72 | 3.36 | |
SO62434_1 | 100 | 24864 | 538 | 8 | 2024-05-13 | 0.54 | 2024-05-01 | 21.49 | 1 | SO62434 | 2024-05-08 | 1.72 | 8.04 | |
SO69118_1 | 100 | 16604 | 485 | 8 | 2024-08-19 | 0.55 | 2024-08-07 | 21.98 | 1 | SO69118 | 2024-08-14 | 1.76 | 8.22 | |
SO51410_3 | 100 | 14945 | 483 | 8 | 2023-11-06 | 3.00 | 2023-10-25 | 120.00 | 3 | SO51410 | 2023-11-01 | 9.60 | 44.88 | |
SO58413_3 | 100 | 12461 | 477 | 8 | 2024-03-15 | 0.12 | 2024-03-03 | 4.99 | 3 | SO58413 | 2024-03-10 | 0.40 | 1.87 | |
SO62434_2 | 100 | 24864 | 529 | 8 | 2024-05-13 | 0.10 | 2024-05-01 | 3.99 | 2 | SO62434 | 2024-05-08 | 0.32 | 1.49 | |
SO69118_2 | 100 | 16604 | 217 | 8 | 2024-08-19 | 0.87 | 2024-08-07 | 34.99 | 2 | SO69118 | 2024-08-14 | 2.80 | 13.09 | |
SO51454_1 | 100 | 14198 | 574 | 8 | 2023-11-08 | 59.60 | 2023-10-27 | 2384.07 | 1 | SO51454 | 2023-11-03 | 190.73 | 1481.94 | |
SO58413_4 | 100 | 12461 | 217 | 8 | 2024-03-15 | 0.87 | 2024-03-03 | 34.99 | 4 | SO58413 | 2024-03-10 | 2.80 | 13.09 | |
SO62434_3 | 100 | 24864 | 480 | 2 | 8 | 2024-05-13 | 0.06 | 2024-05-01 | 2.29 | 3 | SO62434 | 2024-05-08 | 0.18 | 0.86 |
SO69122_1 | 100 | 12811 | 530 | 8 | 2024-08-19 | 0.12 | 2024-08-07 | 4.99 | 1 | SO69122 | 2024-08-14 | 0.40 | 1.87 | |
SO51454_2 | 100 | 14198 | 479 | 8 | 2023-11-08 | 0.22 | 2023-10-27 | 8.99 | 2 | SO51454 | 2023-11-03 | 0.72 | 3.36 | |
SO58445_1 | 100 | 12845 | 485 | 8 | 2024-03-16 | 0.55 | 2024-03-04 | 21.98 | 1 | SO58445 | 2024-03-11 | 1.76 | 8.22 | |
SO62434_4 | 100 | 24864 | 484 | 8 | 2024-05-13 | 0.20 | 2024-05-01 | 7.95 | 4 | SO62434 | 2024-05-08 | 0.64 | 2.97 |
Generated 2024-11-10 14:24:49.484 UTC