[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 531 > < TAKE 48 >
48 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44185_1 | 6 | 17280 | 310 | 9 | 2022-01-02 | 89.46 | 2021-12-21 | 3578.27 | 1 | SO44185 | 2021-12-28 | 286.26 | 2171.29 | |
SO55596_4 | 100 | 19122 | 477 | 4 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 4 | SO55596 | 2024-01-22 | 0.40 | 1.87 | |
SO62139_2 | 6 | 17354 | 484 | 9 | 2024-05-08 | 0.20 | 2024-04-26 | 7.95 | 2 | SO62139 | 2024-05-03 | 0.64 | 2.97 | |
SO44186_1 | 100 | 25889 | 347 | 4 | 2022-01-04 | 85.00 | 2021-12-23 | 3399.99 | 1 | SO44186 | 2021-12-30 | 272.00 | 1912.15 | |
SO55597_1 | 19 | 13284 | 363 | 2 | 6 | 2024-01-27 | 57.37 | 2024-01-15 | 2294.99 | 1 | SO55597 | 2024-01-22 | 183.60 | 1251.98 |
SO62140_1 | 6 | 17351 | 374 | 9 | 2024-05-08 | 61.08 | 2024-04-26 | 2443.35 | 1 | SO62140 | 2024-05-03 | 195.47 | 1554.95 | |
SO44187_1 | 6 | 17069 | 313 | 9 | 2022-01-04 | 89.46 | 2021-12-23 | 3578.27 | 1 | SO44187 | 2021-12-30 | 286.26 | 2171.29 | |
SO55597_2 | 19 | 13284 | 487 | 6 | 2024-01-27 | 1.37 | 2024-01-15 | 54.99 | 2 | SO55597 | 2024-01-22 | 4.40 | 20.57 | |
SO62140_2 | 6 | 17351 | 540 | 9 | 2024-05-08 | 0.82 | 2024-04-26 | 32.60 | 2 | SO62140 | 2024-05-03 | 2.61 | 12.19 | |
SO44188_1 | 98 | 20052 | 334 | 10 | 2022-01-05 | 17.48 | 2021-12-24 | 699.10 | 1 | SO44188 | 2021-12-31 | 55.93 | 413.15 | |
SO55597_3 | 19 | 13284 | 463 | 6 | 2024-01-27 | 0.61 | 2024-01-15 | 24.49 | 3 | SO55597 | 2024-01-22 | 1.96 | 9.16 | |
SO62140_3 | 6 | 17351 | 529 | 9 | 2024-05-08 | 0.10 | 2024-04-26 | 3.99 | 3 | SO62140 | 2024-05-03 | 0.32 | 1.49 | |
SO44189_1 | 98 | 20054 | 322 | 10 | 2022-01-05 | 17.48 | 2021-12-24 | 699.10 | 1 | SO44189 | 2021-12-31 | 55.93 | 413.15 | |
SO55598_1 | 100 | 12941 | 353 | 2 | 1 | 2024-01-27 | 58.00 | 2024-01-15 | 2319.99 | 1 | SO55598 | 2024-01-22 | 185.60 | 1265.62 |
SO62140_4 | 6 | 17351 | 214 | 9 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 4 | SO62140 | 2024-05-03 | 2.80 | 13.09 | |
SO44190_1 | 6 | 11061 | 348 | 9 | 2022-01-05 | 84.37 | 2021-12-24 | 3374.99 | 1 | SO44190 | 2021-12-31 | 270.00 | 1898.09 | |
SO55598_2 | 100 | 12941 | 487 | 1 | 2024-01-27 | 1.37 | 2024-01-15 | 54.99 | 2 | SO55598 | 2024-01-22 | 4.40 | 20.57 | |
SO62140_5 | 6 | 17351 | 465 | 9 | 2024-05-08 | 0.61 | 2024-04-26 | 24.49 | 5 | SO62140 | 2024-05-03 | 1.96 | 9.16 | |
SO44191_1 | 6 | 17248 | 310 | 9 | 2022-01-05 | 89.46 | 2021-12-24 | 3578.27 | 1 | SO44191 | 2021-12-31 | 286.26 | 2171.29 | |
SO55599_1 | 100 | 11040 | 353 | 1 | 2024-01-27 | 58.00 | 2024-01-15 | 2319.99 | 1 | SO55599 | 2024-01-22 | 185.60 | 1265.62 | |
SO62141_1 | 6 | 24485 | 386 | 9 | 2024-05-08 | 28.01 | 2024-04-26 | 1120.49 | 1 | SO62141 | 2024-05-03 | 89.64 | 713.08 | |
SO44192_1 | 29 | 13570 | 312 | 8 | 2022-01-06 | 89.46 | 2021-12-25 | 3578.27 | 1 | SO44192 | 2022-01-01 | 286.26 | 2171.29 | |
SO55599_2 | 100 | 11040 | 485 | 1 | 2024-01-27 | 0.55 | 2024-01-15 | 21.98 | 2 | SO55599 | 2024-01-22 | 1.76 | 8.22 | |
SO62141_2 | 6 | 24485 | 489 | 9 | 2024-05-08 | 1.35 | 2024-04-26 | 53.99 | 2 | SO62141 | 2024-05-03 | 4.32 | 41.57 | |
SO44193_1 | 100 | 28164 | 312 | 4 | 2022-01-06 | 89.46 | 2021-12-25 | 3578.27 | 1 | SO44193 | 2022-01-01 | 286.26 | 2171.29 | |
SO55599_3 | 100 | 11040 | 481 | 1 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 3 | SO55599 | 2024-01-22 | 0.72 | 3.36 | |
SO62142_1 | 6 | 13128 | 359 | 9 | 2024-05-08 | 57.37 | 2024-04-26 | 2294.99 | 1 | SO62142 | 2024-05-03 | 183.60 | 1251.98 | |
SO44194_1 | 6 | 17064 | 310 | 9 | 2022-01-06 | 89.46 | 2021-12-25 | 3578.27 | 1 | SO44194 | 2022-01-01 | 286.26 | 2171.29 | |
SO55600_1 | 19 | 13101 | 361 | 6 | 2024-01-27 | 57.37 | 2024-01-15 | 2294.99 | 1 | SO55600 | 2024-01-22 | 183.60 | 1251.98 | |
SO62142_2 | 6 | 13128 | 214 | 9 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 2 | SO62142 | 2024-05-03 | 2.80 | 13.09 | |
SO44195_1 | 6 | 17249 | 313 | 9 | 2022-01-06 | 89.46 | 2021-12-25 | 3578.27 | 1 | SO44195 | 2022-01-01 | 286.26 | 2171.29 | |
SO55600_2 | 19 | 13101 | 485 | 6 | 2024-01-27 | 0.55 | 2024-01-15 | 21.98 | 2 | SO55600 | 2024-01-22 | 1.76 | 8.22 | |
SO62143_1 | 6 | 13632 | 353 | 2 | 9 | 2024-05-08 | 58.00 | 2024-04-26 | 2319.99 | 1 | SO62143 | 2024-05-03 | 185.60 | 1265.62 |
SO44196_1 | 6 | 17295 | 314 | 9 | 2022-01-06 | 89.46 | 2021-12-25 | 3578.27 | 1 | SO44196 | 2022-01-01 | 286.26 | 2171.29 | |
SO55600_3 | 19 | 13101 | 217 | 6 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 3 | SO55600 | 2024-01-22 | 2.80 | 13.09 | |
SO62144_1 | 6 | 13953 | 357 | 9 | 2024-05-08 | 58.00 | 2024-04-26 | 2319.99 | 1 | SO62144 | 2024-05-03 | 185.60 | 1265.62 | |
SO44197_1 | 100 | 28096 | 312 | 4 | 2022-01-07 | 89.46 | 2021-12-26 | 3578.27 | 1 | SO44197 | 2022-01-02 | 286.26 | 2171.29 | |
SO55601_1 | 98 | 14771 | 585 | 10 | 2024-01-27 | 18.56 | 2024-01-15 | 742.35 | 1 | SO55601 | 2024-01-22 | 59.39 | 461.44 | |
SO62144_2 | 6 | 13953 | 480 | 9 | 2024-05-08 | 0.06 | 2024-04-26 | 2.29 | 2 | SO62144 | 2024-05-03 | 0.18 | 0.86 | |
SO44198_1 | 100 | 28150 | 310 | 4 | 2022-01-07 | 89.46 | 2021-12-26 | 3578.27 | 1 | SO44198 | 2022-01-02 | 286.26 | 2171.29 | |
SO55601_2 | 98 | 14771 | 479 | 10 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55601 | 2024-01-22 | 0.72 | 3.36 | |
SO62145_1 | 6 | 13637 | 361 | 9 | 2024-05-08 | 57.37 | 2024-04-26 | 2294.99 | 1 | SO62145 | 2024-05-03 | 183.60 | 1251.98 | |
SO44199_1 | 6 | 17259 | 313 | 9 | 2022-01-07 | 89.46 | 2021-12-26 | 3578.27 | 1 | SO44199 | 2022-01-02 | 286.26 | 2171.29 | |
SO55601_3 | 98 | 14771 | 477 | 10 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 3 | SO55601 | 2024-01-22 | 0.40 | 1.87 | |
SO62146_1 | 100 | 25840 | 577 | 4 | 2024-05-08 | 30.37 | 2024-04-26 | 1214.85 | 1 | SO62146 | 2024-05-03 | 97.19 | 755.15 | |
SO44200_1 | 6 | 17312 | 311 | 9 | 2022-01-07 | 89.46 | 2021-12-26 | 3578.27 | 1 | SO44200 | 2022-01-02 | 286.26 | 2171.29 | |
SO55602_1 | 98 | 12385 | 585 | 10 | 2024-01-27 | 18.56 | 2024-01-15 | 742.35 | 1 | SO55602 | 2024-01-22 | 59.39 | 461.44 | |
SO62146_2 | 100 | 25840 | 214 | 4 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 2 | SO62146 | 2024-05-03 | 2.80 | 13.09 |
Generated 2024-11-10 14:41:14.085 UTC