[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 623 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55611_1 | 100 | 29403 | 604 | 8 | 2024-01-27 | 13.50 | 2024-01-15 | 539.99 | 1 | SO55611 | 2024-01-22 | 43.20 | 343.65 | |
SO62154_2 | 6 | 17229 | 476 | 9 | 2024-05-08 | 1.75 | 2024-04-26 | 69.99 | 2 | SO62154 | 2024-05-03 | 5.60 | 26.18 | |
SO44205_1 | 6 | 17285 | 312 | 9 | 2022-01-08 | 89.46 | 2021-12-27 | 3578.27 | 1 | SO44205 | 2022-01-03 | 286.26 | 2171.29 | |
SO55611_2 | 100 | 29403 | 479 | 8 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55611 | 2024-01-22 | 0.72 | 3.36 | |
SO62154_3 | 6 | 17229 | 488 | 9 | 2024-05-08 | 1.35 | 2024-04-26 | 53.99 | 3 | SO62154 | 2024-05-03 | 4.32 | 41.57 | |
SO44206_1 | 98 | 11250 | 347 | 10 | 2022-01-09 | 85.00 | 2021-12-28 | 3399.99 | 1 | SO44206 | 2022-01-04 | 272.00 | 1912.15 | |
SO55611_3 | 100 | 29403 | 477 | 8 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 3 | SO55611 | 2024-01-22 | 0.40 | 1.87 | |
SO62155_1 | 6 | 14308 | 585 | 9 | 2024-05-08 | 18.56 | 2024-04-26 | 742.35 | 1 | SO62155 | 2024-05-03 | 59.39 | 461.44 | |
SO44207_1 | 100 | 28162 | 313 | 4 | 2022-01-09 | 89.46 | 2021-12-28 | 3578.27 | 1 | SO44207 | 2022-01-04 | 286.26 | 2171.29 | |
SO55611_4 | 100 | 29403 | 488 | 8 | 2024-01-27 | 1.35 | 2024-01-15 | 53.99 | 4 | SO55611 | 2024-01-22 | 4.32 | 41.57 | |
SO62155_2 | 6 | 14308 | 479 | 9 | 2024-05-08 | 0.22 | 2024-04-26 | 8.99 | 2 | SO62155 | 2024-05-03 | 0.72 | 3.36 | |
SO44208_1 | 100 | 25879 | 347 | 4 | 2022-01-09 | 85.00 | 2021-12-28 | 3399.99 | 1 | SO44208 | 2022-01-04 | 272.00 | 1912.15 | |
SO55611_5 | 100 | 29403 | 225 | 8 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 5 | SO55611 | 2024-01-22 | 0.72 | 6.92 | |
SO62155_3 | 6 | 14308 | 477 | 9 | 2024-05-08 | 0.12 | 2024-04-26 | 4.99 | 3 | SO62155 | 2024-05-03 | 0.40 | 1.87 | |
SO44209_1 | 6 | 17257 | 311 | 9 | 2022-01-09 | 89.46 | 2021-12-28 | 3578.27 | 1 | SO44209 | 2022-01-04 | 286.26 | 2171.29 | |
SO55612_1 | 98 | 25760 | 605 | 10 | 2024-01-27 | 13.50 | 2024-01-15 | 539.99 | 1 | SO55612 | 2024-01-22 | 43.20 | 343.65 | |
SO62156_1 | 6 | 11768 | 564 | 9 | 2024-05-08 | 59.60 | 2024-04-26 | 2384.07 | 1 | SO62156 | 2024-05-03 | 190.73 | 1481.94 | |
SO44210_1 | 98 | 13783 | 310 | 10 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44210 | 2022-01-05 | 286.26 | 2171.29 | |
SO55612_2 | 98 | 25760 | 538 | 10 | 2024-01-27 | 0.54 | 2024-01-15 | 21.49 | 2 | SO55612 | 2024-01-22 | 1.72 | 8.04 | |
SO62156_2 | 6 | 11768 | 217 | 9 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 2 | SO62156 | 2024-05-03 | 2.80 | 13.09 | |
SO44211_1 | 100 | 28154 | 313 | 4 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44211 | 2022-01-05 | 286.26 | 2171.29 | |
SO55612_3 | 98 | 25760 | 529 | 10 | 2024-01-27 | 0.10 | 2024-01-15 | 3.99 | 3 | SO55612 | 2024-01-22 | 0.32 | 1.49 | |
SO62157_1 | 6 | 23099 | 584 | 9 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62157 | 2024-05-03 | 43.20 | 343.65 | |
SO44212_1 | 100 | 28170 | 312 | 4 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44212 | 2022-01-05 | 286.26 | 2171.29 | |
SO55612_4 | 98 | 25760 | 480 | 10 | 2024-01-27 | 0.06 | 2024-01-15 | 2.29 | 4 | SO55612 | 2024-01-22 | 0.18 | 0.86 | |
SO62158_1 | 100 | 12894 | 477 | 4 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62158 | 2024-05-04 | 0.40 | 1.87 | |
SO44213_1 | 6 | 17351 | 310 | 9 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44213 | 2022-01-05 | 286.26 | 2171.29 | |
SO55613_1 | 6 | 15577 | 539 | 9 | 2024-01-28 | 0.62 | 2024-01-16 | 24.99 | 1 | SO55613 | 2024-01-23 | 2.00 | 9.35 | |
SO62158_2 | 100 | 12894 | 479 | 4 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 2 | SO62158 | 2024-05-04 | 0.72 | 3.36 | |
SO44214_1 | 6 | 17332 | 311 | 9 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44214 | 2022-01-05 | 286.26 | 2171.29 | |
SO55613_2 | 6 | 15577 | 231 | 9 | 2024-01-28 | 1.25 | 2024-01-16 | 49.99 | 2 | SO55613 | 2024-01-23 | 4.00 | 38.49 | |
SO62159_1 | 19 | 11223 | 237 | 6 | 2024-05-09 | 1.25 | 2024-04-27 | 49.99 | 1 | SO62159 | 2024-05-04 | 4.00 | 38.49 | |
SO44215_1 | 100 | 28180 | 312 | 1 | 2022-01-11 | 89.46 | 2021-12-30 | 3578.27 | 1 | SO44215 | 2022-01-06 | 286.26 | 2171.29 | |
SO55613_3 | 6 | 15577 | 225 | 9 | 2024-01-28 | 0.22 | 2024-01-16 | 8.99 | 3 | SO55613 | 2024-01-23 | 0.72 | 6.92 | |
SO62160_1 | 6 | 14307 | 535 | 9 | 2024-05-09 | 0.62 | 2024-04-27 | 24.99 | 1 | SO62160 | 2024-05-04 | 2.00 | 9.35 | |
SO44216_1 | 29 | 13560 | 314 | 8 | 2022-01-11 | 89.46 | 2021-12-30 | 3578.27 | 1 | SO44216 | 2022-01-06 | 286.26 | 2171.29 | |
SO55614_1 | 6 | 19584 | 538 | 9 | 2024-01-28 | 0.54 | 2024-01-16 | 21.49 | 1 | SO55614 | 2024-01-23 | 1.72 | 8.04 | |
SO62160_2 | 6 | 14307 | 528 | 9 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 2 | SO62160 | 2024-05-04 | 0.40 | 1.87 | |
SO44217_1 | 100 | 28148 | 310 | 1 | 2022-01-11 | 89.46 | 2021-12-30 | 3578.27 | 1 | SO44217 | 2022-01-06 | 286.26 | 2171.29 | |
SO55614_2 | 6 | 19584 | 529 | 9 | 2024-01-28 | 0.10 | 2024-01-16 | 3.99 | 2 | SO55614 | 2024-01-23 | 0.32 | 1.49 | |
SO62160_3 | 6 | 14307 | 480 | 2 | 9 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 3 | SO62160 | 2024-05-04 | 0.18 | 0.86 |
SO44218_1 | 19 | 22109 | 311 | 6 | 2022-01-11 | 89.46 | 2021-12-30 | 3578.27 | 1 | SO44218 | 2022-01-06 | 286.26 | 2171.29 | |
SO55614_3 | 6 | 19584 | 480 | 9 | 2024-01-28 | 0.06 | 2024-01-16 | 2.29 | 3 | SO55614 | 2024-01-23 | 0.18 | 0.86 | |
SO62161_1 | 6 | 17061 | 536 | 9 | 2024-05-09 | 0.75 | 2024-04-27 | 29.99 | 1 | SO62161 | 2024-05-04 | 2.40 | 11.22 | |
SO44219_1 | 100 | 14590 | 338 | 4 | 2022-01-11 | 17.48 | 2021-12-30 | 699.10 | 1 | SO44219 | 2022-01-06 | 55.93 | 413.15 | |
SO55615_1 | 6 | 24906 | 528 | 9 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55615 | 2024-01-23 | 0.40 | 1.87 | |
SO62161_2 | 6 | 17061 | 480 | 2 | 9 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 2 | SO62161 | 2024-05-04 | 0.18 | 0.86 |
SO44220_1 | 6 | 11060 | 345 | 9 | 2022-01-11 | 85.00 | 2021-12-30 | 3399.99 | 1 | SO44220 | 2022-01-06 | 272.00 | 1912.15 | |
SO55615_2 | 6 | 24906 | 485 | 9 | 2024-01-28 | 0.55 | 2024-01-16 | 21.98 | 2 | SO55615 | 2024-01-23 | 1.76 | 8.22 | |
SO62162_1 | 6 | 22204 | 528 | 9 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62162 | 2024-05-04 | 0.40 | 1.87 | |
SO44221_1 | 6 | 17255 | 314 | 9 | 2022-01-11 | 89.46 | 2021-12-30 | 3578.27 | 1 | SO44221 | 2022-01-06 | 286.26 | 2171.29 | |
SO55615_3 | 6 | 24906 | 222 | 9 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 3 | SO55615 | 2024-01-23 | 2.80 | 13.09 | |
SO62162_2 | 6 | 22204 | 537 | 9 | 2024-05-09 | 0.88 | 2024-04-27 | 35.00 | 2 | SO62162 | 2024-05-04 | 2.80 | 13.09 | |
SO44222_1 | 6 | 17258 | 311 | 9 | 2022-01-11 | 89.46 | 2021-12-30 | 3578.27 | 1 | SO44222 | 2022-01-06 | 286.26 | 2171.29 | |
SO55616_1 | 6 | 24595 | 528 | 9 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55616 | 2024-01-23 | 0.40 | 1.87 | |
SO62162_3 | 6 | 22204 | 480 | 9 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 3 | SO62162 | 2024-05-04 | 0.18 | 0.86 | |
SO44223_1 | 98 | 13847 | 310 | 10 | 2022-01-12 | 89.46 | 2021-12-31 | 3578.27 | 1 | SO44223 | 2022-01-07 | 286.26 | 2171.29 | |
SO55616_2 | 6 | 24595 | 485 | 9 | 2024-01-28 | 0.55 | 2024-01-16 | 21.98 | 2 | SO55616 | 2024-01-23 | 1.76 | 8.22 | |
SO62163_1 | 6 | 24897 | 528 | 9 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62163 | 2024-05-04 | 0.40 | 1.87 | |
SO44224_1 | 100 | 28166 | 314 | 4 | 2022-01-12 | 89.46 | 2021-12-31 | 3578.27 | 1 | SO44224 | 2022-01-07 | 286.26 | 2171.29 | |
SO55616_3 | 6 | 24595 | 222 | 9 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 3 | SO55616 | 2024-01-23 | 2.80 | 13.09 | |
SO62164_1 | 6 | 22859 | 477 | 9 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62164 | 2024-05-04 | 0.40 | 1.87 | |
SO44225_1 | 98 | 20060 | 322 | 10 | 2022-01-13 | 17.48 | 2022-01-01 | 699.10 | 1 | SO44225 | 2022-01-08 | 55.93 | 413.15 | |
SO55617_1 | 6 | 22914 | 477 | 9 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55617 | 2024-01-23 | 0.40 | 1.87 | |
SO62165_1 | 6 | 28951 | 478 | 9 | 2024-05-09 | 0.25 | 2024-04-27 | 9.99 | 1 | SO62165 | 2024-05-04 | 0.80 | 3.74 | |
SO44226_1 | 39 | 12255 | 313 | 7 | 2022-01-13 | 89.46 | 2022-01-01 | 3578.27 | 1 | SO44226 | 2022-01-08 | 286.26 | 2171.29 | |
SO55617_2 | 6 | 22914 | 487 | 9 | 2024-01-28 | 1.37 | 2024-01-16 | 54.99 | 2 | SO55617 | 2024-01-23 | 4.40 | 20.57 | |
SO62166_1 | 6 | 15240 | 478 | 9 | 2024-05-09 | 0.25 | 2024-04-27 | 9.99 | 1 | SO62166 | 2024-05-04 | 0.80 | 3.74 | |
SO44227_1 | 39 | 28401 | 349 | 7 | 2022-01-13 | 84.37 | 2022-01-01 | 3374.99 | 1 | SO44227 | 2022-01-08 | 270.00 | 1898.09 | |
SO55618_1 | 6 | 27970 | 530 | 9 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55618 | 2024-01-23 | 0.40 | 1.87 | |
SO62167_1 | 6 | 17283 | 225 | 9 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 1 | SO62167 | 2024-05-04 | 0.72 | 6.92 | |
SO44228_1 | 98 | 11333 | 344 | 10 | 2022-01-13 | 85.00 | 2022-01-01 | 3399.99 | 1 | SO44228 | 2022-01-08 | 272.00 | 1912.15 | |
SO55618_2 | 6 | 27970 | 467 | 9 | 2024-01-28 | 0.61 | 2024-01-16 | 24.49 | 2 | SO55618 | 2024-01-23 | 1.96 | 9.16 | |
SO62167_2 | 6 | 17283 | 231 | 9 | 2024-05-09 | 1.25 | 2024-04-27 | 49.99 | 2 | SO62167 | 2024-05-04 | 4.00 | 38.49 | |
SO44229_1 | 100 | 25886 | 344 | 1 | 2022-01-13 | 85.00 | 2022-01-01 | 3399.99 | 1 | SO44229 | 2022-01-08 | 272.00 | 1912.15 | |
SO55618_3 | 6 | 27970 | 217 | 9 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 3 | SO55618 | 2024-01-23 | 2.80 | 13.09 | |
SO62168_1 | 6 | 13954 | 465 | 9 | 2024-05-09 | 0.61 | 2024-04-27 | 24.49 | 1 | SO62168 | 2024-05-04 | 1.96 | 9.16 | |
SO44230_1 | 6 | 17241 | 312 | 9 | 2022-01-13 | 89.46 | 2022-01-01 | 3578.27 | 1 | SO44230 | 2022-01-08 | 286.26 | 2171.29 | |
SO55619_1 | 6 | 26668 | 476 | 9 | 2024-01-28 | 1.75 | 2024-01-16 | 69.99 | 1 | SO55619 | 2024-01-23 | 5.60 | 26.18 | |
SO62169_1 | 6 | 18247 | 225 | 9 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 1 | SO62169 | 2024-05-04 | 0.72 | 6.92 | |
SO44231_1 | 39 | 17973 | 334 | 7 | 2022-01-13 | 17.48 | 2022-01-01 | 699.10 | 1 | SO44231 | 2022-01-08 | 55.93 | 413.15 | |
SO55619_2 | 6 | 26668 | 228 | 9 | 2024-01-28 | 1.25 | 2024-01-16 | 49.99 | 2 | SO55619 | 2024-01-23 | 4.00 | 38.49 | |
SO62170_1 | 6 | 11150 | 225 | 9 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 1 | SO62170 | 2024-05-04 | 0.72 | 6.92 | |
SO44232_1 | 6 | 17334 | 312 | 9 | 2022-01-13 | 89.46 | 2022-01-01 | 3578.27 | 1 | SO44232 | 2022-01-08 | 286.26 | 2171.29 | |
SO55620_1 | 6 | 28322 | 530 | 9 | 2024-01-28 | 0.12 | 2024-01-16 | 4.99 | 1 | SO55620 | 2024-01-23 | 0.40 | 1.87 | |
SO62171_1 | 6 | 14123 | 540 | 9 | 2024-05-09 | 0.82 | 2024-04-27 | 32.60 | 1 | SO62171 | 2024-05-04 | 2.61 | 12.19 | |
SO44233_1 | 98 | 13841 | 310 | 10 | 2022-01-14 | 89.46 | 2022-01-02 | 3578.27 | 1 | SO44233 | 2022-01-09 | 286.26 | 2171.29 | |
SO55620_2 | 6 | 28322 | 467 | 9 | 2024-01-28 | 0.61 | 2024-01-16 | 24.49 | 2 | SO55620 | 2024-01-23 | 1.96 | 9.16 | |
SO62172_1 | 100 | 17787 | 581 | 7 | 2024-05-09 | 42.52 | 2024-04-27 | 1700.99 | 1 | SO62172 | 2024-05-04 | 136.08 | 1082.51 | |
SO44234_1 | 100 | 28184 | 312 | 4 | 2022-01-14 | 89.46 | 2022-01-02 | 3578.27 | 1 | SO44234 | 2022-01-09 | 286.26 | 2171.29 | |
SO55621_1 | 6 | 13041 | 217 | 9 | 2024-01-28 | 0.87 | 2024-01-16 | 34.99 | 1 | SO55621 | 2024-01-23 | 2.80 | 13.09 | |
SO62172_2 | 100 | 17787 | 539 | 7 | 2024-05-09 | 0.62 | 2024-04-27 | 24.99 | 2 | SO62172 | 2024-05-04 | 2.00 | 9.35 | |
SO44235_1 | 19 | 22117 | 313 | 6 | 2022-01-14 | 89.46 | 2022-01-02 | 3578.27 | 1 | SO44235 | 2022-01-09 | 286.26 | 2171.29 | |
SO55621_2 | 6 | 13041 | 488 | 9 | 2024-01-28 | 1.35 | 2024-01-16 | 53.99 | 2 | SO55621 | 2024-01-23 | 4.32 | 41.57 | |
SO62173_1 | 100 | 11420 | 599 | 7 | 2024-05-09 | 13.50 | 2024-04-27 | 539.99 | 1 | SO62173 | 2024-05-04 | 43.20 | 294.58 | |
SO44236_1 | 100 | 28191 | 312 | 1 | 2022-01-14 | 89.46 | 2022-01-02 | 3578.27 | 1 | SO44236 | 2022-01-09 | 286.26 | 2171.29 |
Generated 2024-11-10 17:02:48.256 UTC