[ROOT] dt FactInternetSale < WHERE OrderDate EQ Today >
96 items
| FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO75084_1 | 100 | 11078 | 483 | 6 | 2023-04-01 | 3.00 | 2023-03-20 | 120.00 | 1 | SO75084 | 2023-03-27 | 9.60 | 44.88 |
| SO75085_1 | 100 | 11927 | 225 | 1 | 2023-04-01 | 0.22 | 2023-03-20 | 8.99 | 1 | SO75085 | 2023-03-27 | 0.72 | 6.92 |
| SO75085_2 | 100 | 11927 | 484 | 1 | 2023-04-01 | 0.20 | 2023-03-20 | 7.95 | 2 | SO75085 | 2023-03-27 | 0.64 | 2.97 |
| SO75086_1 | 100 | 28789 | 484 | 4 | 2023-04-01 | 0.20 | 2023-03-20 | 7.95 | 1 | SO75086 | 2023-03-27 | 0.64 | 2.97 |
| SO75087_1 | 100 | 11794 | 214 | 4 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 1 | SO75087 | 2023-03-27 | 2.80 | 13.09 |
| SO75088_1 | 100 | 14680 | 529 | 9 | 2023-04-01 | 0.10 | 2023-03-20 | 3.99 | 1 | SO75088 | 2023-03-27 | 0.32 | 1.49 |
| SO75088_2 | 100 | 14680 | 539 | 9 | 2023-04-01 | 0.62 | 2023-03-20 | 24.99 | 2 | SO75088 | 2023-03-27 | 2.00 | 9.35 |
| SO75088_3 | 100 | 14680 | 222 | 9 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 3 | SO75088 | 2023-03-27 | 2.80 | 13.09 |
| SO75088_4 | 100 | 14680 | 228 | 9 | 2023-04-01 | 1.25 | 2023-03-20 | 49.99 | 4 | SO75088 | 2023-03-27 | 4.00 | 38.49 |
| SO75089_1 | 100 | 19585 | 538 | 9 | 2023-04-01 | 0.54 | 2023-03-20 | 21.49 | 1 | SO75089 | 2023-03-27 | 1.72 | 8.04 |
| SO75089_2 | 100 | 19585 | 529 | 9 | 2023-04-01 | 0.10 | 2023-03-20 | 3.99 | 2 | SO75089 | 2023-03-27 | 0.32 | 1.49 |
| SO75089_3 | 100 | 19585 | 222 | 9 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 3 | SO75089 | 2023-03-27 | 2.80 | 13.09 |
| SO75090_1 | 100 | 27686 | 528 | 9 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75090 | 2023-03-27 | 0.40 | 1.87 |
| SO75090_2 | 100 | 27686 | 537 | 9 | 2023-04-01 | 0.88 | 2023-03-20 | 35.00 | 2 | SO75090 | 2023-03-27 | 2.80 | 13.09 |
| SO75090_3 | 100 | 27686 | 217 | 9 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 3 | SO75090 | 2023-03-27 | 2.80 | 13.09 |
| SO75091_1 | 100 | 20601 | 538 | 9 | 2023-04-01 | 0.54 | 2023-03-20 | 21.49 | 1 | SO75091 | 2023-03-27 | 1.72 | 8.04 |
| SO75091_2 | 100 | 20601 | 529 | 9 | 2023-04-01 | 0.10 | 2023-03-20 | 3.99 | 2 | SO75091 | 2023-03-27 | 0.32 | 1.49 |
| SO75091_3 | 100 | 20601 | 487 | 9 | 2023-04-01 | 1.37 | 2023-03-20 | 54.99 | 3 | SO75091 | 2023-03-27 | 4.40 | 20.57 |
| SO75092_1 | 100 | 26564 | 538 | 9 | 2023-04-01 | 0.54 | 2023-03-20 | 21.49 | 1 | SO75092 | 2023-03-27 | 1.72 | 8.04 |
| SO75092_2 | 100 | 26564 | 465 | 9 | 2023-04-01 | 0.61 | 2023-03-20 | 24.49 | 2 | SO75092 | 2023-03-27 | 1.96 | 9.16 |
| SO75092_3 | 100 | 26564 | 529 | 9 | 2023-04-01 | 0.10 | 2023-03-20 | 3.99 | 3 | SO75092 | 2023-03-27 | 0.32 | 1.49 |
| SO75093_1 | 100 | 16170 | 529 | 9 | 2023-04-01 | 0.10 | 2023-03-20 | 3.99 | 1 | SO75093 | 2023-03-27 | 0.32 | 1.49 |
| SO75093_2 | 100 | 16170 | 540 | 9 | 2023-04-01 | 0.82 | 2023-03-20 | 32.60 | 2 | SO75093 | 2023-03-27 | 2.61 | 12.19 |
| SO75093_3 | 100 | 16170 | 483 | 9 | 2023-04-01 | 3.00 | 2023-03-20 | 120.00 | 3 | SO75093 | 2023-03-27 | 9.60 | 44.88 |
| SO75094_1 | 100 | 16927 | 484 | 9 | 2023-04-01 | 0.20 | 2023-03-20 | 7.95 | 1 | SO75094 | 2023-03-27 | 0.64 | 2.97 |
| SO75095_1 | 100 | 11657 | 488 | 4 | 2023-04-01 | 1.35 | 2023-03-20 | 53.99 | 1 | SO75095 | 2023-03-27 | 4.32 | 41.57 |
| SO75096_1 | 100 | 11287 | 529 | 6 | 2023-04-01 | 0.10 | 2023-03-20 | 3.99 | 1 | SO75096 | 2023-03-27 | 0.32 | 1.49 |
| SO75096_2 | 100 | 11287 | 222 | 6 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 2 | SO75096 | 2023-03-27 | 2.80 | 13.09 |
| SO75096_3 | 100 | 11287 | 237 | 6 | 2023-04-01 | 1.25 | 2023-03-20 | 49.99 | 3 | SO75096 | 2023-03-27 | 4.00 | 38.49 |
| SO75097_1 | 100 | 21717 | 478 | 4 | 2023-04-01 | 0.25 | 2023-03-20 | 9.99 | 1 | SO75097 | 2023-03-27 | 0.80 | 3.74 |
| SO75097_2 | 100 | 21717 | 217 | 4 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 2 | SO75097 | 2023-03-27 | 2.80 | 13.09 |
| SO75098_1 | 100 | 23381 | 528 | 1 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75098 | 2023-03-27 | 0.40 | 1.87 |
| SO75098_2 | 100 | 23381 | 536 | 1 | 2023-04-01 | 0.75 | 2023-03-20 | 29.99 | 2 | SO75098 | 2023-03-27 | 2.40 | 11.22 |
| SO75098_3 | 100 | 23381 | 480 | 1 | 2023-04-01 | 0.06 | 2023-03-20 | 2.29 | 3 | SO75098 | 2023-03-27 | 0.18 | 0.86 |
| SO75099_1 | 100 | 21163 | 478 | 4 | 2023-04-01 | 0.25 | 2023-03-20 | 9.99 | 1 | SO75099 | 2023-03-27 | 0.80 | 3.74 |
| SO75099_2 | 100 | 21163 | 487 | 4 | 2023-04-01 | 1.37 | 2023-03-20 | 54.99 | 2 | SO75099 | 2023-03-27 | 4.40 | 20.57 |
| SO75099_3 | 100 | 21163 | 484 | 4 | 2023-04-01 | 0.20 | 2023-03-20 | 7.95 | 3 | SO75099 | 2023-03-27 | 0.64 | 2.97 |
| SO75100_1 | 100 | 13350 | 478 | 6 | 2023-04-01 | 0.25 | 2023-03-20 | 9.99 | 1 | SO75100 | 2023-03-27 | 0.80 | 3.74 |
| SO75100_2 | 100 | 13350 | 477 | 6 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 2 | SO75100 | 2023-03-27 | 0.40 | 1.87 |
| SO75100_3 | 100 | 13350 | 473 | 6 | 2023-04-01 | 1.59 | 2023-03-20 | 63.50 | 3 | SO75100 | 2023-03-27 | 5.08 | 23.75 |
| SO75101_1 | 100 | 20201 | 474 | 4 | 2023-04-01 | 1.75 | 2023-03-20 | 69.99 | 1 | SO75101 | 2023-03-27 | 5.60 | 26.18 |
| SO75101_2 | 100 | 20201 | 473 | 4 | 2023-04-01 | 1.59 | 2023-03-20 | 63.50 | 2 | SO75101 | 2023-03-27 | 5.08 | 23.75 |
| SO75102_1 | 100 | 19893 | 476 | 1 | 2023-04-01 | 1.75 | 2023-03-20 | 69.99 | 1 | SO75102 | 2023-03-27 | 5.60 | 26.18 |
| SO75102_2 | 100 | 19893 | 234 | 1 | 2023-04-01 | 1.25 | 2023-03-20 | 49.99 | 2 | SO75102 | 2023-03-27 | 4.00 | 38.49 |
| SO75103_1 | 100 | 18529 | 477 | 5 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75103 | 2023-03-27 | 0.40 | 1.87 |
| SO75103_2 | 100 | 18529 | 217 | 5 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 2 | SO75103 | 2023-03-27 | 2.80 | 13.09 |
| SO75104_1 | 100 | 17151 | 477 | 1 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75104 | 2023-03-27 | 0.40 | 1.87 |
| SO75104_2 | 100 | 17151 | 484 | 1 | 2023-04-01 | 0.20 | 2023-03-20 | 7.95 | 2 | SO75104 | 2023-03-27 | 0.64 | 2.97 |
| SO75105_1 | 100 | 15160 | 528 | 4 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75105 | 2023-03-27 | 0.40 | 1.87 |
| SO75105_2 | 100 | 15160 | 214 | 4 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 2 | SO75105 | 2023-03-27 | 2.80 | 13.09 |
| SO75105_3 | 100 | 15160 | 225 | 4 | 2023-04-01 | 0.22 | 2023-03-20 | 8.99 | 3 | SO75105 | 2023-03-27 | 0.72 | 6.92 |
| SO75105_4 | 100 | 15160 | 234 | 4 | 2023-04-01 | 1.25 | 2023-03-20 | 49.99 | 4 | SO75105 | 2023-03-27 | 4.00 | 38.49 |
| SO75106_1 | 100 | 14474 | 528 | 4 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75106 | 2023-03-27 | 0.40 | 1.87 |
| SO75106_2 | 100 | 14474 | 480 | 4 | 2023-04-01 | 0.06 | 2023-03-20 | 2.29 | 2 | SO75106 | 2023-03-27 | 0.18 | 0.86 |
| SO75107_1 | 100 | 14029 | 485 | 1 | 2023-04-01 | 0.55 | 2023-03-20 | 21.98 | 1 | SO75107 | 2023-03-27 | 1.76 | 8.22 |
| SO75107_2 | 100 | 14029 | 217 | 1 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 2 | SO75107 | 2023-03-27 | 2.80 | 13.09 |
| SO75108_1 | 100 | 21347 | 528 | 6 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75108 | 2023-03-27 | 0.40 | 1.87 |
| SO75109_1 | 100 | 14114 | 485 | 4 | 2023-04-01 | 0.55 | 2023-03-20 | 21.98 | 1 | SO75109 | 2023-03-27 | 1.76 | 8.22 |
| SO75109_2 | 100 | 14114 | 471 | 4 | 2023-04-01 | 1.59 | 2023-03-20 | 63.50 | 2 | SO75109 | 2023-03-27 | 5.08 | 23.75 |
| SO75110_1 | 100 | 13753 | 485 | 4 | 2023-04-01 | 0.55 | 2023-03-20 | 21.98 | 1 | SO75110 | 2023-03-27 | 1.76 | 8.22 |
| SO75110_2 | 100 | 13753 | 487 | 4 | 2023-04-01 | 1.37 | 2023-03-20 | 54.99 | 2 | SO75110 | 2023-03-27 | 4.40 | 20.57 |
| SO75110_3 | 100 | 13753 | 484 | 4 | 2023-04-01 | 0.20 | 2023-03-20 | 7.95 | 3 | SO75110 | 2023-03-27 | 0.64 | 2.97 |
| SO75111_1 | 100 | 19072 | 528 | 10 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75111 | 2023-03-27 | 0.40 | 1.87 |
| SO75111_2 | 100 | 19072 | 217 | 10 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 2 | SO75111 | 2023-03-27 | 2.80 | 13.09 |
| SO75111_3 | 100 | 19072 | 225 | 10 | 2023-04-01 | 0.22 | 2023-03-20 | 8.99 | 3 | SO75111 | 2023-03-27 | 0.72 | 6.92 |
| SO75112_1 | 100 | 21523 | 536 | 8 | 2023-04-01 | 0.75 | 2023-03-20 | 29.99 | 1 | SO75112 | 2023-03-27 | 2.40 | 11.22 |
| SO75112_2 | 100 | 21523 | 481 | 8 | 2023-04-01 | 0.22 | 2023-03-20 | 8.99 | 2 | SO75112 | 2023-03-27 | 0.72 | 3.36 |
| SO75113_1 | 100 | 21524 | 535 | 10 | 2023-04-01 | 0.62 | 2023-03-20 | 24.99 | 1 | SO75113 | 2023-03-27 | 2.00 | 9.35 |
| SO75113_2 | 100 | 21524 | 528 | 10 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 2 | SO75113 | 2023-03-27 | 0.40 | 1.87 |
| SO75113_3 | 100 | 21524 | 222 | 10 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 3 | SO75113 | 2023-03-27 | 2.80 | 13.09 |
| SO75113_4 | 100 | 21524 | 231 | 10 | 2023-04-01 | 1.25 | 2023-03-20 | 49.99 | 4 | SO75113 | 2023-03-27 | 4.00 | 38.49 |
| SO75114_1 | 100 | 24704 | 538 | 8 | 2023-04-01 | 0.54 | 2023-03-20 | 21.49 | 1 | SO75114 | 2023-03-27 | 1.72 | 8.04 |
| SO75115_1 | 100 | 26832 | 538 | 8 | 2023-04-01 | 0.54 | 2023-03-20 | 21.49 | 1 | SO75115 | 2023-03-27 | 1.72 | 8.04 |
| SO75115_2 | 100 | 26832 | 529 | 8 | 2023-04-01 | 0.10 | 2023-03-20 | 3.99 | 2 | SO75115 | 2023-03-27 | 0.32 | 1.49 |
| SO75115_3 | 100 | 26832 | 487 | 8 | 2023-04-01 | 1.37 | 2023-03-20 | 54.99 | 3 | SO75115 | 2023-03-27 | 4.40 | 20.57 |
| SO75116_1 | 100 | 16402 | 530 | 10 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75116 | 2023-03-27 | 0.40 | 1.87 |
| SO75117_1 | 100 | 18178 | 530 | 10 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75117 | 2023-03-27 | 0.40 | 1.87 |
| SO75117_2 | 100 | 18178 | 467 | 10 | 2023-04-01 | 0.61 | 2023-03-20 | 24.49 | 2 | SO75117 | 2023-03-27 | 1.96 | 9.16 |
| SO75118_1 | 100 | 13671 | 530 | 8 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75118 | 2023-03-27 | 0.40 | 1.87 |
| SO75118_2 | 100 | 13671 | 480 | 8 | 2023-04-01 | 0.06 | 2023-03-20 | 2.29 | 2 | SO75118 | 2023-03-27 | 0.18 | 0.86 |
| SO75118_3 | 100 | 13671 | 484 | 8 | 2023-04-01 | 0.20 | 2023-03-20 | 7.95 | 3 | SO75118 | 2023-03-27 | 0.64 | 2.97 |
| SO75118_4 | 100 | 13671 | 483 | 8 | 2023-04-01 | 3.00 | 2023-03-20 | 120.00 | 4 | SO75118 | 2023-03-27 | 9.60 | 44.88 |
| SO75119_1 | 100 | 11981 | 528 | 1 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75119 | 2023-03-27 | 0.40 | 1.87 |
| SO75119_2 | 100 | 11981 | 537 | 1 | 2023-04-01 | 0.88 | 2023-03-20 | 35.00 | 2 | SO75119 | 2023-03-27 | 2.80 | 13.09 |
| SO75119_3 | 100 | 11981 | 480 | 1 | 2023-04-01 | 0.06 | 2023-03-20 | 2.29 | 3 | SO75119 | 2023-03-27 | 0.18 | 0.86 |
| SO75120_1 | 100 | 18749 | 485 | 6 | 2023-04-01 | 0.55 | 2023-03-20 | 21.98 | 1 | SO75120 | 2023-03-27 | 1.76 | 8.22 |
| SO75120_2 | 100 | 18749 | 491 | 6 | 2023-04-01 | 1.35 | 2023-03-20 | 53.99 | 2 | SO75120 | 2023-03-27 | 4.32 | 41.57 |
| SO75120_3 | 100 | 18749 | 225 | 6 | 2023-04-01 | 0.22 | 2023-03-20 | 8.99 | 3 | SO75120 | 2023-03-27 | 0.72 | 6.92 |
| SO75121_1 | 100 | 15251 | 528 | 6 | 2023-04-01 | 0.12 | 2023-03-20 | 4.99 | 1 | SO75121 | 2023-03-27 | 0.40 | 1.87 |
| SO75121_2 | 100 | 15251 | 537 | 6 | 2023-04-01 | 0.88 | 2023-03-20 | 35.00 | 2 | SO75121 | 2023-03-27 | 2.80 | 13.09 |
| SO75121_3 | 100 | 15251 | 214 | 6 | 2023-04-01 | 0.87 | 2023-03-20 | 34.99 | 3 | SO75121 | 2023-03-27 | 2.80 | 13.09 |
| SO75122_1 | 100 | 15868 | 485 | 6 | 2023-04-01 | 0.55 | 2023-03-20 | 21.98 | 1 | SO75122 | 2023-03-27 | 1.76 | 8.22 |
| SO75122_2 | 100 | 15868 | 225 | 6 | 2023-04-01 | 0.22 | 2023-03-20 | 8.99 | 2 | SO75122 | 2023-03-27 | 0.72 | 6.92 |
| SO75123_1 | 100 | 18759 | 485 | 6 | 2023-04-01 | 0.55 | 2023-03-20 | 21.98 | 1 | SO75123 | 2023-03-27 | 1.76 | 8.22 |
| SO75123_2 | 100 | 18759 | 486 | 6 | 2023-04-01 | 3.98 | 2023-03-20 | 159.00 | 2 | SO75123 | 2023-03-27 | 12.72 | 59.47 |
| SO75123_3 | 100 | 18759 | 225 | 6 | 2023-04-01 | 0.22 | 2023-03-20 | 8.99 | 3 | SO75123 | 2023-03-27 | 0.72 | 6.92 |
Generated 2023-03-20 10:31:36.417 UTC