[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > SKIP 1000 < SKIP 2048 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO52947_1 | 98 | 24064 | 477 | 10 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 1 | SO52947 | 2023-12-09 | 0.40 | 1.87 | |
SO52949_1 | 98 | 14799 | 541 | 10 | 2023-12-14 | 0.72 | 2023-12-02 | 28.99 | 1 | SO52949 | 2023-12-09 | 2.32 | 10.84 | |
SO52949_2 | 98 | 14799 | 530 | 10 | 2023-12-14 | 0.12 | 2023-12-02 | 4.99 | 2 | SO52949 | 2023-12-09 | 0.40 | 1.87 | |
SO52949_3 | 98 | 14799 | 225 | 10 | 2023-12-14 | 0.22 | 2023-12-02 | 8.99 | 3 | SO52949 | 2023-12-09 | 0.72 | 6.92 | |
SO52949_4 | 98 | 14799 | 234 | 10 | 2023-12-14 | 1.25 | 2023-12-02 | 49.99 | 4 | SO52949 | 2023-12-09 | 4.00 | 38.49 | |
SO52953_1 | 98 | 12593 | 225 | 10 | 2023-12-14 | 0.22 | 2023-12-02 | 8.99 | 1 | SO52953 | 2023-12-09 | 0.72 | 6.92 | |
SO52966_1 | 98 | 11351 | 363 | 2 | 10 | 2023-12-15 | 57.37 | 2023-12-03 | 2294.99 | 1 | SO52966 | 2023-12-10 | 183.60 | 1251.98 |
SO52967_1 | 98 | 11353 | 363 | 10 | 2023-12-15 | 57.37 | 2023-12-03 | 2294.99 | 1 | SO52967 | 2023-12-10 | 183.60 | 1251.98 | |
SO52967_2 | 98 | 11353 | 477 | 10 | 2023-12-15 | 0.12 | 2023-12-03 | 4.99 | 2 | SO52967 | 2023-12-10 | 0.40 | 1.87 | |
SO52967_3 | 98 | 11353 | 478 | 10 | 2023-12-15 | 0.25 | 2023-12-03 | 9.99 | 3 | SO52967 | 2023-12-10 | 0.80 | 3.74 | |
SO52986_1 | 98 | 17705 | 528 | 10 | 2023-12-15 | 0.12 | 2023-12-03 | 4.99 | 1 | SO52986 | 2023-12-10 | 0.40 | 1.87 | |
SO52986_2 | 98 | 17705 | 535 | 10 | 2023-12-15 | 0.62 | 2023-12-03 | 24.99 | 2 | SO52986 | 2023-12-10 | 2.00 | 9.35 | |
SO52990_1 | 98 | 20588 | 535 | 10 | 2023-12-15 | 0.62 | 2023-12-03 | 24.99 | 1 | SO52990 | 2023-12-10 | 2.00 | 9.35 | |
SO52990_2 | 98 | 20588 | 480 | 10 | 2023-12-15 | 0.06 | 2023-12-03 | 2.29 | 2 | SO52990 | 2023-12-10 | 0.18 | 0.86 | |
SO52992_1 | 98 | 27806 | 529 | 10 | 2023-12-15 | 0.10 | 2023-12-03 | 3.99 | 1 | SO52992 | 2023-12-10 | 0.32 | 1.49 | |
SO52993_1 | 98 | 26865 | 529 | 10 | 2023-12-15 | 0.10 | 2023-12-03 | 3.99 | 1 | SO52993 | 2023-12-10 | 0.32 | 1.49 | |
SO52993_2 | 98 | 26865 | 483 | 10 | 2023-12-15 | 3.00 | 2023-12-03 | 120.00 | 2 | SO52993 | 2023-12-10 | 9.60 | 44.88 | |
SO52994_1 | 98 | 16193 | 530 | 10 | 2023-12-15 | 0.12 | 2023-12-03 | 4.99 | 1 | SO52994 | 2023-12-10 | 0.40 | 1.87 | |
SO53005_1 | 98 | 11493 | 363 | 10 | 2023-12-16 | 57.37 | 2023-12-04 | 2294.99 | 1 | SO53005 | 2023-12-11 | 183.60 | 1251.98 | |
SO53005_2 | 98 | 11493 | 222 | 10 | 2023-12-16 | 0.87 | 2023-12-04 | 34.99 | 2 | SO53005 | 2023-12-11 | 2.80 | 13.09 | |
SO53037_1 | 98 | 18632 | 528 | 10 | 2023-12-16 | 0.12 | 2023-12-04 | 4.99 | 1 | SO53037 | 2023-12-11 | 0.40 | 1.87 | |
SO53037_2 | 98 | 18632 | 535 | 10 | 2023-12-16 | 0.62 | 2023-12-04 | 24.99 | 2 | SO53037 | 2023-12-11 | 2.00 | 9.35 | |
SO53037_3 | 98 | 18632 | 480 | 2 | 10 | 2023-12-16 | 0.06 | 2023-12-04 | 2.29 | 3 | SO53037 | 2023-12-11 | 0.18 | 0.86 |
SO53040_1 | 98 | 28410 | 538 | 10 | 2023-12-16 | 0.54 | 2023-12-04 | 21.49 | 1 | SO53040 | 2023-12-11 | 1.72 | 8.04 | |
SO70319_5 | 98 | 16452 | 228 | 10 | 2024-09-02 | 1.25 | 2024-08-21 | 49.99 | 5 | SO70319 | 2024-08-28 | 4.00 | 38.49 | |
SO70321_1 | 98 | 19917 | 353 | 10 | 2024-09-02 | 58.00 | 2024-08-21 | 2319.99 | 1 | SO70321 | 2024-08-28 | 185.60 | 1265.62 | |
SO70321_2 | 98 | 19917 | 537 | 10 | 2024-09-02 | 0.88 | 2024-08-21 | 35.00 | 2 | SO70321 | 2024-08-28 | 2.80 | 13.09 | |
SO70321_3 | 98 | 19917 | 528 | 10 | 2024-09-02 | 0.12 | 2024-08-21 | 4.99 | 3 | SO70321 | 2024-08-28 | 0.40 | 1.87 | |
SO70321_4 | 98 | 19917 | 482 | 10 | 2024-09-02 | 0.22 | 2024-08-21 | 8.99 | 4 | SO70321 | 2024-08-28 | 0.72 | 3.36 | |
SO70323_1 | 98 | 14833 | 361 | 10 | 2024-09-02 | 57.37 | 2024-08-21 | 2294.99 | 1 | SO70323 | 2024-08-28 | 183.60 | 1251.98 | |
SO70323_2 | 98 | 14833 | 537 | 10 | 2024-09-02 | 0.88 | 2024-08-21 | 35.00 | 2 | SO70323 | 2024-08-28 | 2.80 | 13.09 | |
SO70324_1 | 98 | 19258 | 225 | 10 | 2024-09-02 | 0.22 | 2024-08-21 | 8.99 | 1 | SO70324 | 2024-08-28 | 0.72 | 6.92 | |
SO70324_2 | 98 | 19258 | 595 | 10 | 2024-09-02 | 14.12 | 2024-08-21 | 564.99 | 2 | SO70324 | 2024-08-28 | 45.20 | 308.22 | |
SO70341_1 | 98 | 15713 | 540 | 10 | 2024-09-02 | 0.82 | 2024-08-21 | 32.60 | 1 | SO70341 | 2024-08-28 | 2.61 | 12.19 | |
SO70343_1 | 98 | 26397 | 477 | 10 | 2024-09-02 | 0.12 | 2024-08-21 | 4.99 | 1 | SO70343 | 2024-08-28 | 0.40 | 1.87 | |
SO70343_2 | 98 | 26397 | 214 | 10 | 2024-09-02 | 0.87 | 2024-08-21 | 34.99 | 2 | SO70343 | 2024-08-28 | 2.80 | 13.09 | |
SO70344_1 | 98 | 12626 | 541 | 10 | 2024-09-02 | 0.72 | 2024-08-21 | 28.99 | 1 | SO70344 | 2024-08-28 | 2.32 | 10.84 | |
SO70344_2 | 98 | 12626 | 530 | 10 | 2024-09-02 | 0.12 | 2024-08-21 | 4.99 | 2 | SO70344 | 2024-08-28 | 0.40 | 1.87 | |
SO70344_3 | 98 | 12626 | 222 | 10 | 2024-09-02 | 0.87 | 2024-08-21 | 34.99 | 3 | SO70344 | 2024-08-28 | 2.80 | 13.09 | |
SO70346_1 | 98 | 13675 | 541 | 10 | 2024-09-02 | 0.72 | 2024-08-21 | 28.99 | 1 | SO70346 | 2024-08-28 | 2.32 | 10.84 | |
SO70346_2 | 98 | 13675 | 530 | 10 | 2024-09-02 | 0.12 | 2024-08-21 | 4.99 | 2 | SO70346 | 2024-08-28 | 0.40 | 1.87 | |
SO70346_3 | 98 | 13675 | 480 | 10 | 2024-09-02 | 0.06 | 2024-08-21 | 2.29 | 3 | SO70346 | 2024-08-28 | 0.18 | 0.86 | |
SO70346_4 | 98 | 13675 | 483 | 10 | 2024-09-02 | 3.00 | 2024-08-21 | 120.00 | 4 | SO70346 | 2024-08-28 | 9.60 | 44.88 | |
SO70346_5 | 98 | 13675 | 225 | 10 | 2024-09-02 | 0.22 | 2024-08-21 | 8.99 | 5 | SO70346 | 2024-08-28 | 0.72 | 6.92 | |
SO70347_1 | 98 | 16401 | 530 | 10 | 2024-09-02 | 0.12 | 2024-08-21 | 4.99 | 1 | SO70347 | 2024-08-28 | 0.40 | 1.87 | |
SO70347_2 | 98 | 16401 | 480 | 2 | 10 | 2024-09-02 | 0.06 | 2024-08-21 | 2.29 | 2 | SO70347 | 2024-08-28 | 0.18 | 0.86 |
SO70372_1 | 98 | 27185 | 605 | 10 | 2024-09-02 | 13.50 | 2024-08-21 | 539.99 | 1 | SO70372 | 2024-08-28 | 43.20 | 343.65 | |
SO70372_2 | 98 | 27185 | 479 | 10 | 2024-09-02 | 0.22 | 2024-08-21 | 8.99 | 2 | SO70372 | 2024-08-28 | 0.72 | 3.36 | |
SO70372_3 | 98 | 27185 | 477 | 10 | 2024-09-02 | 0.12 | 2024-08-21 | 4.99 | 3 | SO70372 | 2024-08-28 | 0.40 | 1.87 | |
SO70372_4 | 98 | 27185 | 222 | 10 | 2024-09-02 | 0.87 | 2024-08-21 | 34.99 | 4 | SO70372 | 2024-08-28 | 2.80 | 13.09 | |
SO70386_1 | 98 | 14937 | 361 | 10 | 2024-09-03 | 57.37 | 2024-08-22 | 2294.99 | 1 | SO70386 | 2024-08-29 | 183.60 | 1251.98 | |
SO70386_2 | 98 | 14937 | 480 | 10 | 2024-09-03 | 0.06 | 2024-08-22 | 2.29 | 2 | SO70386 | 2024-08-29 | 0.18 | 0.86 | |
SO70406_1 | 98 | 17205 | 537 | 10 | 2024-09-03 | 0.88 | 2024-08-22 | 35.00 | 1 | SO70406 | 2024-08-29 | 2.80 | 13.09 | |
SO70407_1 | 98 | 17204 | 528 | 10 | 2024-09-03 | 0.12 | 2024-08-22 | 4.99 | 1 | SO70407 | 2024-08-29 | 0.40 | 1.87 | |
SO70407_2 | 98 | 17204 | 537 | 10 | 2024-09-03 | 0.88 | 2024-08-22 | 35.00 | 2 | SO70407 | 2024-08-29 | 2.80 | 13.09 | |
SO70407_3 | 98 | 17204 | 222 | 10 | 2024-09-03 | 0.87 | 2024-08-22 | 34.99 | 3 | SO70407 | 2024-08-29 | 2.80 | 13.09 | |
SO70408_1 | 98 | 14963 | 477 | 10 | 2024-09-03 | 0.12 | 2024-08-22 | 4.99 | 1 | SO70408 | 2024-08-29 | 0.40 | 1.87 | |
SO70408_2 | 98 | 14963 | 214 | 10 | 2024-09-03 | 0.87 | 2024-08-22 | 34.99 | 2 | SO70408 | 2024-08-29 | 2.80 | 13.09 | |
SO70409_1 | 98 | 17650 | 529 | 10 | 2024-09-03 | 0.10 | 2024-08-22 | 3.99 | 1 | SO70409 | 2024-08-29 | 0.32 | 1.49 | |
SO70409_2 | 98 | 17650 | 222 | 10 | 2024-09-03 | 0.87 | 2024-08-22 | 34.99 | 2 | SO70409 | 2024-08-29 | 2.80 | 13.09 |
Generated 2024-11-10 15:51:36.266 UTC