[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1906 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48464_1 | 100 | 13734 | 375 | 4 | 2023-03-31 | 54.54 | 2023-03-19 | 2181.56 | 1 | SO48464 | 2023-03-26 | 174.53 | 1320.68 | |
SO48465_1 | 100 | 26626 | 356 | 4 | 2023-03-31 | 51.79 | 2023-03-19 | 2071.42 | 1 | SO48465 | 2023-03-26 | 165.71 | 1117.86 | |
SO48466_1 | 100 | 15404 | 333 | 4 | 2023-03-31 | 19.57 | 2023-03-19 | 782.99 | 1 | SO48466 | 2023-03-26 | 62.64 | 486.71 | |
SO48468_1 | 100 | 15433 | 337 | 4 | 2023-03-31 | 19.57 | 2023-03-19 | 782.99 | 1 | SO48468 | 2023-03-26 | 62.64 | 486.71 | |
SO48473_1 | 100 | 26641 | 352 | 4 | 2023-03-31 | 51.79 | 2023-03-19 | 2071.42 | 1 | SO48473 | 2023-03-26 | 165.71 | 1117.86 | |
SO48477_1 | 100 | 26611 | 352 | 4 | 2023-04-01 | 51.79 | 2023-03-20 | 2071.42 | 1 | SO48477 | 2023-03-27 | 165.71 | 1117.86 | |
SO48495_1 | 100 | 26602 | 360 | 4 | 2023-04-03 | 51.23 | 2023-03-22 | 2049.10 | 1 | SO48495 | 2023-03-29 | 163.93 | 1105.81 | |
SO48496_1 | 100 | 26603 | 362 | 2 | 4 | 2023-04-03 | 51.23 | 2023-03-22 | 2049.10 | 1 | SO48496 | 2023-03-29 | 163.93 | 1105.81 |
SO48508_1 | 100 | 13736 | 377 | 4 | 2023-04-04 | 54.54 | 2023-03-23 | 2181.56 | 1 | SO48508 | 2023-03-30 | 174.53 | 1320.68 | |
SO48510_1 | 100 | 26631 | 354 | 4 | 2023-04-04 | 51.79 | 2023-03-23 | 2071.42 | 1 | SO48510 | 2023-03-30 | 165.71 | 1117.86 | |
SO48511_1 | 100 | 26635 | 362 | 2 | 4 | 2023-04-04 | 51.23 | 2023-03-23 | 2049.10 | 1 | SO48511 | 2023-03-30 | 163.93 | 1105.81 |
SO48513_1 | 100 | 15417 | 321 | 4 | 2023-04-04 | 19.57 | 2023-03-23 | 782.99 | 1 | SO48513 | 2023-03-30 | 62.64 | 486.71 | |
SO48514_1 | 100 | 15427 | 339 | 4 | 2023-04-04 | 19.57 | 2023-03-23 | 782.99 | 1 | SO48514 | 2023-03-30 | 62.64 | 486.71 | |
SO48526_1 | 100 | 13724 | 375 | 4 | 2023-04-05 | 54.54 | 2023-03-24 | 2181.56 | 1 | SO48526 | 2023-03-31 | 174.53 | 1320.68 | |
SO70119_2 | 100 | 16131 | 480 | 2 | 4 | 2024-08-30 | 0.06 | 2024-08-18 | 2.29 | 2 | SO70119 | 2024-08-25 | 0.18 | 0.86 |
SO70119_3 | 100 | 16131 | 486 | 4 | 2024-08-30 | 3.98 | 2024-08-18 | 159.00 | 3 | SO70119 | 2024-08-25 | 12.72 | 59.47 | |
SO70126_1 | 100 | 11787 | 537 | 4 | 2024-08-30 | 0.88 | 2024-08-18 | 35.00 | 1 | SO70126 | 2024-08-25 | 2.80 | 13.09 | |
SO70126_2 | 100 | 11787 | 528 | 4 | 2024-08-30 | 0.12 | 2024-08-18 | 4.99 | 2 | SO70126 | 2024-08-25 | 0.40 | 1.87 | |
SO70126_3 | 100 | 11787 | 217 | 4 | 2024-08-30 | 0.87 | 2024-08-18 | 34.99 | 3 | SO70126 | 2024-08-25 | 2.80 | 13.09 | |
SO70127_1 | 100 | 12093 | 537 | 4 | 2024-08-30 | 0.88 | 2024-08-18 | 35.00 | 1 | SO70127 | 2024-08-25 | 2.80 | 13.09 | |
SO70127_2 | 100 | 12093 | 480 | 4 | 2024-08-30 | 0.06 | 2024-08-18 | 2.29 | 2 | SO70127 | 2024-08-25 | 0.18 | 0.86 | |
SO70128_1 | 100 | 12119 | 537 | 4 | 2024-08-30 | 0.88 | 2024-08-18 | 35.00 | 1 | SO70128 | 2024-08-25 | 2.80 | 13.09 | |
SO70128_2 | 100 | 12119 | 528 | 4 | 2024-08-30 | 0.12 | 2024-08-18 | 4.99 | 2 | SO70128 | 2024-08-25 | 0.40 | 1.87 | |
SO70128_3 | 100 | 12119 | 480 | 4 | 2024-08-30 | 0.06 | 2024-08-18 | 2.29 | 3 | SO70128 | 2024-08-25 | 0.18 | 0.86 | |
SO70129_1 | 100 | 12426 | 537 | 4 | 2024-08-30 | 0.88 | 2024-08-18 | 35.00 | 1 | SO70129 | 2024-08-25 | 2.80 | 13.09 | |
SO70129_2 | 100 | 12426 | 528 | 4 | 2024-08-30 | 0.12 | 2024-08-18 | 4.99 | 2 | SO70129 | 2024-08-25 | 0.40 | 1.87 | |
SO70129_3 | 100 | 12426 | 222 | 4 | 2024-08-30 | 0.87 | 2024-08-18 | 34.99 | 3 | SO70129 | 2024-08-25 | 2.80 | 13.09 | |
SO70129_4 | 100 | 12426 | 467 | 4 | 2024-08-30 | 0.61 | 2024-08-18 | 24.49 | 4 | SO70129 | 2024-08-25 | 1.96 | 9.16 | |
SO70131_1 | 100 | 16138 | 591 | 4 | 2024-08-30 | 14.12 | 2024-08-18 | 564.99 | 1 | SO70131 | 2024-08-25 | 45.20 | 308.22 | |
SO70134_1 | 100 | 18075 | 353 | 4 | 2024-08-30 | 58.00 | 2024-08-18 | 2319.99 | 1 | SO70134 | 2024-08-25 | 185.60 | 1265.62 | |
SO70134_2 | 100 | 18075 | 528 | 4 | 2024-08-30 | 0.12 | 2024-08-18 | 4.99 | 2 | SO70134 | 2024-08-25 | 0.40 | 1.87 | |
SO70134_3 | 100 | 18075 | 537 | 4 | 2024-08-30 | 0.88 | 2024-08-18 | 35.00 | 3 | SO70134 | 2024-08-25 | 2.80 | 13.09 | |
SO70134_4 | 100 | 18075 | 214 | 4 | 2024-08-30 | 0.87 | 2024-08-18 | 34.99 | 4 | SO70134 | 2024-08-25 | 2.80 | 13.09 | |
SO70135_1 | 100 | 17623 | 363 | 4 | 2024-08-30 | 57.37 | 2024-08-18 | 2294.99 | 1 | SO70135 | 2024-08-25 | 183.60 | 1251.98 | |
SO70135_2 | 100 | 17623 | 485 | 4 | 2024-08-30 | 0.55 | 2024-08-18 | 21.98 | 2 | SO70135 | 2024-08-25 | 1.76 | 8.22 | |
SO70135_3 | 100 | 17623 | 478 | 4 | 2024-08-30 | 0.25 | 2024-08-18 | 9.99 | 3 | SO70135 | 2024-08-25 | 0.80 | 3.74 | |
SO70136_1 | 100 | 17543 | 359 | 4 | 2024-08-30 | 57.37 | 2024-08-18 | 2294.99 | 1 | SO70136 | 2024-08-25 | 183.60 | 1251.98 | |
SO70136_2 | 100 | 17543 | 483 | 4 | 2024-08-30 | 3.00 | 2024-08-18 | 120.00 | 2 | SO70136 | 2024-08-25 | 9.60 | 44.88 | |
SO70139_1 | 100 | 13057 | 587 | 4 | 2024-08-30 | 19.24 | 2024-08-18 | 769.49 | 1 | SO70139 | 2024-08-25 | 61.56 | 419.78 | |
SO70139_2 | 100 | 13057 | 474 | 4 | 2024-08-30 | 1.75 | 2024-08-18 | 69.99 | 2 | SO70139 | 2024-08-25 | 5.60 | 26.18 | |
SO70139_3 | 100 | 13057 | 225 | 4 | 2024-08-30 | 0.22 | 2024-08-18 | 8.99 | 3 | SO70139 | 2024-08-25 | 0.72 | 6.92 | |
SO70139_4 | 100 | 13057 | 228 | 4 | 2024-08-30 | 1.25 | 2024-08-18 | 49.99 | 4 | SO70139 | 2024-08-25 | 4.00 | 38.49 | |
SO70145_1 | 100 | 17176 | 357 | 4 | 2024-08-30 | 58.00 | 2024-08-18 | 2319.99 | 1 | SO70145 | 2024-08-25 | 185.60 | 1265.62 | |
SO70145_2 | 100 | 17176 | 478 | 4 | 2024-08-30 | 0.25 | 2024-08-18 | 9.99 | 2 | SO70145 | 2024-08-25 | 0.80 | 3.74 | |
SO70145_3 | 100 | 17176 | 477 | 4 | 2024-08-30 | 0.12 | 2024-08-18 | 4.99 | 3 | SO70145 | 2024-08-25 | 0.40 | 1.87 | |
SO70145_4 | 100 | 17176 | 222 | 4 | 2024-08-30 | 0.87 | 2024-08-18 | 34.99 | 4 | SO70145 | 2024-08-25 | 2.80 | 13.09 | |
SO70154_1 | 100 | 26234 | 560 | 4 | 2024-08-30 | 30.37 | 2024-08-18 | 1214.85 | 1 | SO70154 | 2024-08-25 | 97.19 | 755.15 | |
SO70154_2 | 100 | 26234 | 541 | 4 | 2024-08-30 | 0.72 | 2024-08-18 | 28.99 | 2 | SO70154 | 2024-08-25 | 2.32 | 10.84 | |
SO70157_1 | 100 | 23506 | 584 | 4 | 2024-08-30 | 13.50 | 2024-08-18 | 539.99 | 1 | SO70157 | 2024-08-25 | 43.20 | 343.65 | |
SO70158_1 | 100 | 21711 | 388 | 4 | 2024-08-30 | 28.01 | 2024-08-18 | 1120.49 | 1 | SO70158 | 2024-08-25 | 89.64 | 713.08 | |
SO70158_2 | 100 | 21711 | 467 | 2 | 4 | 2024-08-30 | 0.61 | 2024-08-18 | 24.49 | 2 | SO70158 | 2024-08-25 | 1.96 | 9.16 |
SO70158_3 | 100 | 21711 | 214 | 4 | 2024-08-30 | 0.87 | 2024-08-18 | 34.99 | 3 | SO70158 | 2024-08-25 | 2.80 | 13.09 | |
SO70174_1 | 100 | 28975 | 529 | 4 | 2024-08-31 | 0.10 | 2024-08-19 | 3.99 | 1 | SO70174 | 2024-08-26 | 0.32 | 1.49 | |
SO70174_2 | 100 | 28975 | 539 | 4 | 2024-08-31 | 0.62 | 2024-08-19 | 24.99 | 2 | SO70174 | 2024-08-26 | 2.00 | 9.35 | |
SO70174_3 | 100 | 28975 | 225 | 4 | 2024-08-31 | 0.22 | 2024-08-19 | 8.99 | 3 | SO70174 | 2024-08-26 | 0.72 | 6.92 | |
SO70180_1 | 100 | 22979 | 478 | 4 | 2024-08-31 | 0.25 | 2024-08-19 | 9.99 | 1 | SO70180 | 2024-08-26 | 0.80 | 3.74 | |
SO70180_2 | 100 | 22979 | 477 | 4 | 2024-08-31 | 0.12 | 2024-08-19 | 4.99 | 2 | SO70180 | 2024-08-26 | 0.40 | 1.87 | |
SO70180_3 | 100 | 22979 | 487 | 4 | 2024-08-31 | 1.37 | 2024-08-19 | 54.99 | 3 | SO70180 | 2024-08-26 | 4.40 | 20.57 | |
SO70180_4 | 100 | 22979 | 225 | 4 | 2024-08-31 | 0.22 | 2024-08-19 | 8.99 | 4 | SO70180 | 2024-08-26 | 0.72 | 6.92 | |
SO70181_1 | 100 | 23275 | 477 | 4 | 2024-08-31 | 0.12 | 2024-08-19 | 4.99 | 1 | SO70181 | 2024-08-26 | 0.40 | 1.87 |
Generated 2024-11-10 19:56:15.025 UTC