[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 187 < SKIP 2244 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59157_1 | 100 | 24736 | 529 | 1 | 2024-03-25 | 0.10 | 2024-03-13 | 3.99 | 1 | SO59157 | 2024-03-20 | 0.32 | 1.49 |
SO53031_3 | 100 | 21159 | 222 | 1 | 2023-12-16 | 0.87 | 2023-12-04 | 34.99 | 3 | SO53031 | 2023-12-11 | 2.80 | 13.09 |
SO53031_4 | 100 | 21159 | 465 | 1 | 2023-12-16 | 0.61 | 2023-12-04 | 24.49 | 4 | SO53031 | 2023-12-11 | 1.96 | 9.16 |
SO53046_1 | 100 | 12979 | 485 | 1 | 2023-12-16 | 0.55 | 2023-12-04 | 21.98 | 1 | SO53046 | 2023-12-11 | 1.76 | 8.22 |
SO53046_2 | 100 | 12979 | 486 | 1 | 2023-12-16 | 3.98 | 2023-12-04 | 159.00 | 2 | SO53046 | 2023-12-11 | 12.72 | 59.47 |
SO53049_1 | 100 | 15561 | 591 | 1 | 2023-12-16 | 14.12 | 2023-12-04 | 564.99 | 1 | SO53049 | 2023-12-11 | 45.20 | 308.22 |
SO53049_2 | 100 | 15561 | 535 | 1 | 2023-12-16 | 0.62 | 2023-12-04 | 24.99 | 2 | SO53049 | 2023-12-11 | 2.00 | 9.35 |
SO53049_3 | 100 | 15561 | 480 | 1 | 2023-12-16 | 0.06 | 2023-12-04 | 2.29 | 3 | SO53049 | 2023-12-11 | 0.18 | 0.86 |
SO53051_1 | 100 | 13870 | 589 | 1 | 2023-12-16 | 19.24 | 2023-12-04 | 769.49 | 1 | SO53051 | 2023-12-11 | 61.56 | 419.78 |
SO53051_2 | 100 | 13870 | 476 | 1 | 2023-12-16 | 1.75 | 2023-12-04 | 69.99 | 2 | SO53051 | 2023-12-11 | 5.60 | 26.18 |
SO53084_1 | 100 | 28094 | 480 | 1 | 2023-12-17 | 0.06 | 2023-12-05 | 2.29 | 1 | SO53084 | 2023-12-12 | 0.18 | 0.86 |
SO53086_1 | 100 | 28793 | 539 | 1 | 2023-12-17 | 0.62 | 2023-12-05 | 24.99 | 1 | SO53086 | 2023-12-12 | 2.00 | 9.35 |
SO53088_1 | 100 | 11226 | 480 | 1 | 2023-12-17 | 0.06 | 2023-12-05 | 2.29 | 1 | SO53088 | 2023-12-12 | 0.18 | 0.86 |
SO53091_1 | 100 | 25378 | 529 | 1 | 2023-12-17 | 0.10 | 2023-12-05 | 3.99 | 1 | SO53091 | 2023-12-12 | 0.32 | 1.49 |
SO53091_2 | 100 | 25378 | 540 | 1 | 2023-12-17 | 0.82 | 2023-12-05 | 32.60 | 2 | SO53091 | 2023-12-12 | 2.61 | 12.19 |
SO53091_3 | 100 | 25378 | 480 | 1 | 2023-12-17 | 0.06 | 2023-12-05 | 2.29 | 3 | SO53091 | 2023-12-12 | 0.18 | 0.86 |
SO53095_1 | 100 | 23711 | 528 | 1 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 1 | SO53095 | 2023-12-12 | 0.40 | 1.87 |
SO53095_2 | 100 | 23711 | 536 | 1 | 2023-12-17 | 0.75 | 2023-12-05 | 29.99 | 2 | SO53095 | 2023-12-12 | 2.40 | 11.22 |
SO53100_1 | 100 | 17137 | 477 | 1 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 1 | SO53100 | 2023-12-12 | 0.40 | 1.87 |
SO53116_1 | 100 | 11883 | 537 | 1 | 2023-12-17 | 0.88 | 2023-12-05 | 35.00 | 1 | SO53116 | 2023-12-12 | 2.80 | 13.09 |
SO53116_2 | 100 | 11883 | 528 | 1 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 2 | SO53116 | 2023-12-12 | 0.40 | 1.87 |
SO53116_3 | 100 | 11883 | 480 | 1 | 2023-12-17 | 0.06 | 2023-12-05 | 2.29 | 3 | SO53116 | 2023-12-12 | 0.18 | 0.86 |
SO53145_1 | 100 | 26340 | 535 | 1 | 2023-12-18 | 0.62 | 2023-12-06 | 24.99 | 1 | SO53145 | 2023-12-13 | 2.00 | 9.35 |
SO53145_2 | 100 | 26340 | 528 | 1 | 2023-12-18 | 0.12 | 2023-12-06 | 4.99 | 2 | SO53145 | 2023-12-13 | 0.40 | 1.87 |
SO53145_3 | 100 | 26340 | 217 | 1 | 2023-12-18 | 0.87 | 2023-12-06 | 34.99 | 3 | SO53145 | 2023-12-13 | 2.80 | 13.09 |
SO53147_1 | 100 | 25902 | 535 | 1 | 2023-12-18 | 0.62 | 2023-12-06 | 24.99 | 1 | SO53147 | 2023-12-13 | 2.00 | 9.35 |
SO53147_2 | 100 | 25902 | 528 | 1 | 2023-12-18 | 0.12 | 2023-12-06 | 4.99 | 2 | SO53147 | 2023-12-13 | 0.40 | 1.87 |
SO53147_3 | 100 | 25902 | 222 | 1 | 2023-12-18 | 0.87 | 2023-12-06 | 34.99 | 3 | SO53147 | 2023-12-13 | 2.80 | 13.09 |
SO53150_1 | 100 | 19005 | 476 | 1 | 2023-12-18 | 1.75 | 2023-12-06 | 69.99 | 1 | SO53150 | 2023-12-13 | 5.60 | 26.18 |
SO53150_2 | 100 | 19005 | 465 | 1 | 2023-12-18 | 0.61 | 2023-12-06 | 24.49 | 2 | SO53150 | 2023-12-13 | 1.96 | 9.16 |
SO53155_1 | 100 | 14404 | 528 | 1 | 2023-12-18 | 0.12 | 2023-12-06 | 4.99 | 1 | SO53155 | 2023-12-13 | 0.40 | 1.87 |
SO53169_1 | 100 | 11525 | 355 | 1 | 2023-12-18 | 58.00 | 2023-12-06 | 2319.99 | 1 | SO53169 | 2023-12-13 | 185.60 | 1265.62 |
SO53169_2 | 100 | 11525 | 537 | 1 | 2023-12-18 | 0.88 | 2023-12-06 | 35.00 | 2 | SO53169 | 2023-12-13 | 2.80 | 13.09 |
SO53169_3 | 100 | 11525 | 480 | 1 | 2023-12-18 | 0.06 | 2023-12-06 | 2.29 | 3 | SO53169 | 2023-12-13 | 0.18 | 0.86 |
SO53170_1 | 100 | 12059 | 363 | 1 | 2023-12-18 | 57.37 | 2023-12-06 | 2294.99 | 1 | SO53170 | 2023-12-13 | 183.60 | 1251.98 |
SO53170_2 | 100 | 12059 | 485 | 1 | 2023-12-18 | 0.55 | 2023-12-06 | 21.98 | 2 | SO53170 | 2023-12-13 | 1.76 | 8.22 |
SO53170_3 | 100 | 12059 | 214 | 1 | 2023-12-18 | 0.87 | 2023-12-06 | 34.99 | 3 | SO53170 | 2023-12-13 | 2.80 | 13.09 |
SO53177_1 | 100 | 25098 | 577 | 1 | 2023-12-18 | 30.37 | 2023-12-06 | 1214.85 | 1 | SO53177 | 2023-12-13 | 97.19 | 755.15 |
SO53177_2 | 100 | 25098 | 530 | 1 | 2023-12-18 | 0.12 | 2023-12-06 | 4.99 | 2 | SO53177 | 2023-12-13 | 0.40 | 1.87 |
SO53177_3 | 100 | 25098 | 541 | 1 | 2023-12-18 | 0.72 | 2023-12-06 | 28.99 | 3 | SO53177 | 2023-12-13 | 2.32 | 10.84 |
SO53177_4 | 100 | 25098 | 480 | 1 | 2023-12-18 | 0.06 | 2023-12-06 | 2.29 | 4 | SO53177 | 2023-12-13 | 0.18 | 0.86 |
SO53178_1 | 100 | 22300 | 605 | 1 | 2023-12-18 | 13.50 | 2023-12-06 | 539.99 | 1 | SO53178 | 2023-12-13 | 43.20 | 343.65 |
SO53178_2 | 100 | 22300 | 481 | 1 | 2023-12-18 | 0.22 | 2023-12-06 | 8.99 | 2 | SO53178 | 2023-12-13 | 0.72 | 3.36 |
SO53179_1 | 100 | 21608 | 584 | 1 | 2023-12-18 | 13.50 | 2023-12-06 | 539.99 | 1 | SO53179 | 2023-12-13 | 43.20 | 343.65 |
SO53179_2 | 100 | 21608 | 214 | 1 | 2023-12-18 | 0.87 | 2023-12-06 | 34.99 | 2 | SO53179 | 2023-12-13 | 2.80 | 13.09 |
SO53181_1 | 100 | 19407 | 390 | 1 | 2023-12-18 | 28.01 | 2023-12-06 | 1120.49 | 1 | SO53181 | 2023-12-13 | 89.64 | 713.08 |
SO53181_2 | 100 | 19407 | 217 | 1 | 2023-12-18 | 0.87 | 2023-12-06 | 34.99 | 2 | SO53181 | 2023-12-13 | 2.80 | 13.09 |
SO53185_1 | 100 | 12024 | 225 | 1 | 2023-12-19 | 0.22 | 2023-12-07 | 8.99 | 1 | SO53185 | 2023-12-14 | 0.72 | 6.92 |
SO53197_1 | 100 | 11871 | 222 | 1 | 2023-12-19 | 0.87 | 2023-12-07 | 34.99 | 1 | SO53197 | 2023-12-14 | 2.80 | 13.09 |
SO53198_1 | 100 | 11321 | 480 | 1 | 2023-12-19 | 0.06 | 2023-12-07 | 2.29 | 1 | SO53198 | 2023-12-14 | 0.18 | 0.86 |
SO53204_1 | 100 | 26506 | 535 | 1 | 2023-12-19 | 0.62 | 2023-12-07 | 24.99 | 1 | SO53204 | 2023-12-14 | 2.00 | 9.35 |
SO53204_2 | 100 | 26506 | 528 | 1 | 2023-12-19 | 0.12 | 2023-12-07 | 4.99 | 2 | SO53204 | 2023-12-14 | 0.40 | 1.87 |
SO53204_3 | 100 | 26506 | 217 | 1 | 2023-12-19 | 0.87 | 2023-12-07 | 34.99 | 3 | SO53204 | 2023-12-14 | 2.80 | 13.09 |
SO53228_1 | 100 | 11889 | 528 | 1 | 2023-12-19 | 0.12 | 2023-12-07 | 4.99 | 1 | SO53228 | 2023-12-14 | 0.40 | 1.87 |
SO53228_2 | 100 | 11889 | 537 | 1 | 2023-12-19 | 0.88 | 2023-12-07 | 35.00 | 2 | SO53228 | 2023-12-14 | 2.80 | 13.09 |
SO53228_3 | 100 | 11889 | 480 | 1 | 2023-12-19 | 0.06 | 2023-12-07 | 2.29 | 3 | SO53228 | 2023-12-14 | 0.18 | 0.86 |
SO53229_1 | 100 | 11255 | 528 | 1 | 2023-12-19 | 0.12 | 2023-12-07 | 4.99 | 1 | SO53229 | 2023-12-14 | 0.40 | 1.87 |
SO53229_2 | 100 | 11255 | 537 | 1 | 2023-12-19 | 0.88 | 2023-12-07 | 35.00 | 2 | SO53229 | 2023-12-14 | 2.80 | 13.09 |
SO53229_3 | 100 | 11255 | 222 | 1 | 2023-12-19 | 0.87 | 2023-12-07 | 34.99 | 3 | SO53229 | 2023-12-14 | 2.80 | 13.09 |
SO53233_1 | 100 | 16878 | 580 | 1 | 2023-12-19 | 42.52 | 2023-12-07 | 1700.99 | 1 | SO53233 | 2023-12-14 | 136.08 | 1082.51 |
SO53233_2 | 100 | 16878 | 222 | 1 | 2023-12-19 | 0.87 | 2023-12-07 | 34.99 | 2 | SO53233 | 2023-12-14 | 2.80 | 13.09 |
SO53235_1 | 100 | 11303 | 361 | 1 | 2023-12-19 | 57.37 | 2023-12-07 | 2294.99 | 1 | SO53235 | 2023-12-14 | 183.60 | 1251.98 |
Generated 2024-11-10 17:49:01.189 UTC