[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2278 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63677_2 | 6 | 25272 | 488 | 9 | 2024-04-10 | 1.35 | 2024-03-29 | 53.99 | 2 | SO63677 | 2024-04-05 | 4.32 | 41.57 | |
SO63678_1 | 6 | 20628 | 372 | 9 | 2024-04-10 | 61.08 | 2024-03-29 | 2443.35 | 1 | SO63678 | 2024-04-05 | 195.47 | 1554.95 | |
SO63678_2 | 6 | 20628 | 214 | 9 | 2024-04-10 | 0.87 | 2024-03-29 | 34.99 | 2 | SO63678 | 2024-04-05 | 2.80 | 13.09 | |
SO63679_1 | 6 | 14211 | 357 | 9 | 2024-04-10 | 58.00 | 2024-03-29 | 2319.99 | 1 | SO63679 | 2024-04-05 | 185.60 | 1265.62 | |
SO63679_2 | 6 | 14211 | 477 | 9 | 2024-04-10 | 0.12 | 2024-03-29 | 4.99 | 2 | SO63679 | 2024-04-05 | 0.40 | 1.87 | |
SO63679_3 | 6 | 14211 | 478 | 9 | 2024-04-10 | 0.25 | 2024-03-29 | 9.99 | 3 | SO63679 | 2024-04-05 | 0.80 | 3.74 | |
SO63679_4 | 6 | 14211 | 487 | 9 | 2024-04-10 | 1.37 | 2024-03-29 | 54.99 | 4 | SO63679 | 2024-04-05 | 4.40 | 20.57 | |
SO63690_1 | 6 | 21177 | 537 | 9 | 2024-04-11 | 0.88 | 2024-03-30 | 35.00 | 1 | SO63690 | 2024-04-06 | 2.80 | 13.09 | |
SO63690_2 | 6 | 21177 | 528 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 2 | SO63690 | 2024-04-06 | 0.40 | 1.87 | |
SO63691_1 | 6 | 15241 | 478 | 9 | 2024-04-11 | 0.25 | 2024-03-30 | 9.99 | 1 | SO63691 | 2024-04-06 | 0.80 | 3.74 | |
SO63691_2 | 6 | 15241 | 477 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 2 | SO63691 | 2024-04-06 | 0.40 | 1.87 | |
SO63691_3 | 6 | 15241 | 484 | 9 | 2024-04-11 | 0.20 | 2024-03-30 | 7.95 | 3 | SO63691 | 2024-04-06 | 0.64 | 2.97 | |
SO63692_1 | 6 | 15147 | 217 | 9 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 1 | SO63692 | 2024-04-06 | 2.80 | 13.09 | |
SO63692_2 | 6 | 15147 | 467 | 9 | 2024-04-11 | 0.61 | 2024-03-30 | 24.49 | 2 | SO63692 | 2024-04-06 | 1.96 | 9.16 | |
SO63693_1 | 6 | 16733 | 529 | 9 | 2024-04-11 | 0.10 | 2024-03-30 | 3.99 | 1 | SO63693 | 2024-04-06 | 0.32 | 1.49 | |
SO63694_1 | 6 | 13004 | 486 | 9 | 2024-04-11 | 3.98 | 2024-03-30 | 159.00 | 1 | SO63694 | 2024-04-06 | 12.72 | 59.47 | |
SO63732_1 | 6 | 15041 | 583 | 9 | 2024-04-11 | 42.52 | 2024-03-30 | 1700.99 | 1 | SO63732 | 2024-04-06 | 136.08 | 1082.51 | |
SO63732_2 | 6 | 15041 | 491 | 9 | 2024-04-11 | 1.35 | 2024-03-30 | 53.99 | 2 | SO63732 | 2024-04-06 | 4.32 | 41.57 | |
SO63733_1 | 6 | 17909 | 384 | 2 | 9 | 2024-04-11 | 28.01 | 2024-03-30 | 1120.49 | 1 | SO63733 | 2024-04-06 | 89.64 | 713.08 |
SO63733_2 | 6 | 17909 | 489 | 9 | 2024-04-11 | 1.35 | 2024-03-30 | 53.99 | 2 | SO63733 | 2024-04-06 | 4.32 | 41.57 | |
SO63733_3 | 6 | 17909 | 225 | 9 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 3 | SO63733 | 2024-04-06 | 0.72 | 6.92 | |
SO63734_1 | 6 | 24162 | 605 | 9 | 2024-04-11 | 13.50 | 2024-03-30 | 539.99 | 1 | SO63734 | 2024-04-06 | 43.20 | 343.65 | |
SO63734_2 | 6 | 24162 | 538 | 9 | 2024-04-11 | 0.54 | 2024-03-30 | 21.49 | 2 | SO63734 | 2024-04-06 | 1.72 | 8.04 | |
SO63735_1 | 6 | 25108 | 382 | 9 | 2024-04-11 | 28.01 | 2024-03-30 | 1120.49 | 1 | SO63735 | 2024-04-06 | 89.64 | 713.08 | |
SO63735_2 | 6 | 25108 | 491 | 9 | 2024-04-11 | 1.35 | 2024-03-30 | 53.99 | 2 | SO63735 | 2024-04-06 | 4.32 | 41.57 | |
SO63735_3 | 6 | 25108 | 463 | 9 | 2024-04-11 | 0.61 | 2024-03-30 | 24.49 | 3 | SO63735 | 2024-04-06 | 1.96 | 9.16 | |
SO70166_2 | 6 | 12666 | 480 | 9 | 2024-07-12 | 0.06 | 2024-06-30 | 2.29 | 2 | SO70166 | 2024-07-07 | 0.18 | 0.86 | |
SO70167_1 | 6 | 14229 | 539 | 9 | 2024-07-12 | 0.62 | 2024-06-30 | 24.99 | 1 | SO70167 | 2024-07-07 | 2.00 | 9.35 | |
SO70168_1 | 6 | 13048 | 475 | 9 | 2024-07-12 | 1.75 | 2024-06-30 | 69.99 | 1 | SO70168 | 2024-07-07 | 5.60 | 26.18 | |
SO70168_2 | 6 | 13048 | 225 | 9 | 2024-07-12 | 0.22 | 2024-06-30 | 8.99 | 2 | SO70168 | 2024-07-07 | 0.72 | 6.92 | |
SO70169_1 | 6 | 13640 | 529 | 9 | 2024-07-12 | 0.10 | 2024-06-30 | 3.99 | 1 | SO70169 | 2024-07-07 | 0.32 | 1.49 | |
SO70169_2 | 6 | 13640 | 217 | 9 | 2024-07-12 | 0.87 | 2024-06-30 | 34.99 | 2 | SO70169 | 2024-07-07 | 2.80 | 13.09 | |
SO70170_1 | 6 | 19575 | 530 | 9 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 1 | SO70170 | 2024-07-07 | 0.40 | 1.87 | |
SO70170_2 | 6 | 19575 | 541 | 9 | 2024-07-12 | 0.72 | 2024-06-30 | 28.99 | 2 | SO70170 | 2024-07-07 | 2.32 | 10.84 | |
SO70170_3 | 6 | 19575 | 480 | 2 | 9 | 2024-07-12 | 0.06 | 2024-06-30 | 2.29 | 3 | SO70170 | 2024-07-07 | 0.18 | 0.86 |
SO70224_1 | 6 | 26438 | 388 | 9 | 2024-07-12 | 28.01 | 2024-06-30 | 1120.49 | 1 | SO70224 | 2024-07-07 | 89.64 | 713.08 | |
SO70224_2 | 6 | 26438 | 222 | 9 | 2024-07-12 | 0.87 | 2024-06-30 | 34.99 | 2 | SO70224 | 2024-07-07 | 2.80 | 13.09 | |
SO70225_1 | 6 | 25937 | 606 | 2 | 9 | 2024-07-12 | 13.50 | 2024-06-30 | 539.99 | 1 | SO70225 | 2024-07-07 | 43.20 | 343.65 |
SO70225_2 | 6 | 25937 | 538 | 9 | 2024-07-12 | 0.54 | 2024-06-30 | 21.49 | 2 | SO70225 | 2024-07-07 | 1.72 | 8.04 | |
SO70225_3 | 6 | 25937 | 529 | 9 | 2024-07-12 | 0.10 | 2024-06-30 | 3.99 | 3 | SO70225 | 2024-07-07 | 0.32 | 1.49 | |
SO70225_4 | 6 | 25937 | 214 | 9 | 2024-07-12 | 0.87 | 2024-06-30 | 34.99 | 4 | SO70225 | 2024-07-07 | 2.80 | 13.09 | |
SO70226_1 | 6 | 12585 | 594 | 9 | 2024-07-12 | 14.12 | 2024-06-30 | 564.99 | 1 | SO70226 | 2024-07-07 | 45.20 | 308.22 | |
SO70226_2 | 6 | 12585 | 478 | 9 | 2024-07-12 | 0.25 | 2024-06-30 | 9.99 | 2 | SO70226 | 2024-07-07 | 0.80 | 3.74 | |
SO70226_3 | 6 | 12585 | 477 | 9 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 3 | SO70226 | 2024-07-07 | 0.40 | 1.87 | |
SO70227_1 | 6 | 15756 | 361 | 9 | 2024-07-12 | 57.37 | 2024-06-30 | 2294.99 | 1 | SO70227 | 2024-07-07 | 183.60 | 1251.98 | |
SO70227_2 | 6 | 15756 | 537 | 9 | 2024-07-12 | 0.88 | 2024-06-30 | 35.00 | 2 | SO70227 | 2024-07-07 | 2.80 | 13.09 | |
SO70227_3 | 6 | 15756 | 528 | 9 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 3 | SO70227 | 2024-07-07 | 0.40 | 1.87 | |
SO70227_4 | 6 | 15756 | 214 | 9 | 2024-07-12 | 0.87 | 2024-06-30 | 34.99 | 4 | SO70227 | 2024-07-07 | 2.80 | 13.09 | |
SO70228_1 | 6 | 13050 | 361 | 9 | 2024-07-12 | 57.37 | 2024-06-30 | 2294.99 | 1 | SO70228 | 2024-07-07 | 183.60 | 1251.98 | |
SO70228_2 | 6 | 13050 | 537 | 9 | 2024-07-12 | 0.88 | 2024-06-30 | 35.00 | 2 | SO70228 | 2024-07-07 | 2.80 | 13.09 | |
SO70246_1 | 6 | 15120 | 586 | 9 | 2024-07-12 | 18.56 | 2024-06-30 | 742.35 | 1 | SO70246 | 2024-07-07 | 59.39 | 461.44 | |
SO70246_2 | 6 | 15120 | 541 | 9 | 2024-07-12 | 0.72 | 2024-06-30 | 28.99 | 2 | SO70246 | 2024-07-07 | 2.32 | 10.84 | |
SO70246_3 | 6 | 15120 | 530 | 9 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 3 | SO70246 | 2024-07-07 | 0.40 | 1.87 | |
SO70246_4 | 6 | 15120 | 217 | 9 | 2024-07-12 | 0.87 | 2024-06-30 | 34.99 | 4 | SO70246 | 2024-07-07 | 2.80 | 13.09 | |
SO70247_1 | 6 | 29299 | 584 | 9 | 2024-07-12 | 13.50 | 2024-06-30 | 539.99 | 1 | SO70247 | 2024-07-07 | 43.20 | 343.65 | |
SO70247_2 | 6 | 29299 | 479 | 9 | 2024-07-12 | 0.22 | 2024-06-30 | 8.99 | 2 | SO70247 | 2024-07-07 | 0.72 | 3.36 | |
SO70251_1 | 6 | 11148 | 528 | 9 | 2024-07-13 | 0.12 | 2024-07-01 | 4.99 | 1 | SO70251 | 2024-07-08 | 0.40 | 1.87 | |
SO70251_2 | 6 | 11148 | 535 | 9 | 2024-07-13 | 0.62 | 2024-07-01 | 24.99 | 2 | SO70251 | 2024-07-08 | 2.00 | 9.35 | |
SO70251_3 | 6 | 11148 | 480 | 2 | 9 | 2024-07-13 | 0.06 | 2024-07-01 | 2.29 | 3 | SO70251 | 2024-07-08 | 0.18 | 0.86 |
SO70252_1 | 6 | 18763 | 490 | 9 | 2024-07-13 | 1.35 | 2024-07-01 | 53.99 | 1 | SO70252 | 2024-07-08 | 4.32 | 41.57 | |
SO70253_1 | 6 | 28310 | 530 | 9 | 2024-07-13 | 0.12 | 2024-07-01 | 4.99 | 1 | SO70253 | 2024-07-08 | 0.40 | 1.87 | |
SO70254_1 | 6 | 11371 | 237 | 9 | 2024-07-13 | 1.25 | 2024-07-01 | 49.99 | 1 | SO70254 | 2024-07-08 | 4.00 | 38.49 | |
SO70298_1 | 6 | 26152 | 384 | 9 | 2024-07-13 | 28.01 | 2024-07-01 | 1120.49 | 1 | SO70298 | 2024-07-08 | 89.64 | 713.08 | |
SO70298_2 | 6 | 26152 | 214 | 9 | 2024-07-13 | 0.87 | 2024-07-01 | 34.99 | 2 | SO70298 | 2024-07-08 | 2.80 | 13.09 | |
SO70309_1 | 6 | 13616 | 564 | 9 | 2024-07-13 | 59.60 | 2024-07-01 | 2384.07 | 1 | SO70309 | 2024-07-08 | 190.73 | 1481.94 | |
SO70309_2 | 6 | 13616 | 530 | 9 | 2024-07-13 | 0.12 | 2024-07-01 | 4.99 | 2 | SO70309 | 2024-07-08 | 0.40 | 1.87 | |
SO70309_3 | 6 | 13616 | 541 | 9 | 2024-07-13 | 0.72 | 2024-07-01 | 28.99 | 3 | SO70309 | 2024-07-08 | 2.32 | 10.84 | |
SO70309_4 | 6 | 13616 | 487 | 9 | 2024-07-13 | 1.37 | 2024-07-01 | 54.99 | 4 | SO70309 | 2024-07-08 | 4.40 | 20.57 | |
SO70310_1 | 6 | 25939 | 606 | 9 | 2024-07-13 | 13.50 | 2024-07-01 | 539.99 | 1 | SO70310 | 2024-07-08 | 43.20 | 343.65 | |
SO70310_2 | 6 | 25939 | 529 | 9 | 2024-07-13 | 0.10 | 2024-07-01 | 3.99 | 2 | SO70310 | 2024-07-08 | 0.32 | 1.49 | |
SO70310_3 | 6 | 25939 | 538 | 9 | 2024-07-13 | 0.54 | 2024-07-01 | 21.49 | 3 | SO70310 | 2024-07-08 | 1.72 | 8.04 | |
SO70311_1 | 6 | 29313 | 604 | 9 | 2024-07-13 | 13.50 | 2024-07-01 | 539.99 | 1 | SO70311 | 2024-07-08 | 43.20 | 343.65 | |
SO70313_1 | 6 | 12997 | 535 | 9 | 2024-07-14 | 0.62 | 2024-07-02 | 24.99 | 1 | SO70313 | 2024-07-09 | 2.00 | 9.35 | |
SO70313_2 | 6 | 12997 | 480 | 9 | 2024-07-14 | 0.06 | 2024-07-02 | 2.29 | 2 | SO70313 | 2024-07-09 | 0.18 | 0.86 | |
SO70313_3 | 6 | 12997 | 484 | 9 | 2024-07-14 | 0.20 | 2024-07-02 | 7.95 | 3 | SO70313 | 2024-07-09 | 0.64 | 2.97 | |
SO70314_1 | 6 | 14317 | 539 | 9 | 2024-07-14 | 0.62 | 2024-07-02 | 24.99 | 1 | SO70314 | 2024-07-09 | 2.00 | 9.35 | |
SO70314_2 | 6 | 14317 | 529 | 9 | 2024-07-14 | 0.10 | 2024-07-02 | 3.99 | 2 | SO70314 | 2024-07-09 | 0.32 | 1.49 | |
SO70314_3 | 6 | 14317 | 480 | 9 | 2024-07-14 | 0.06 | 2024-07-02 | 2.29 | 3 | SO70314 | 2024-07-09 | 0.18 | 0.86 | |
SO70315_1 | 6 | 18191 | 473 | 9 | 2024-07-14 | 1.59 | 2024-07-02 | 63.50 | 1 | SO70315 | 2024-07-09 | 5.08 | 23.75 | |
SO70315_2 | 6 | 18191 | 485 | 9 | 2024-07-14 | 0.55 | 2024-07-02 | 21.98 | 2 | SO70315 | 2024-07-09 | 1.76 | 8.22 | |
SO70316_1 | 6 | 12997 | 541 | 9 | 2024-07-14 | 0.72 | 2024-07-02 | 28.99 | 1 | SO70316 | 2024-07-09 | 2.32 | 10.84 | |
SO70316_2 | 6 | 12997 | 530 | 9 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 2 | SO70316 | 2024-07-09 | 0.40 | 1.87 | |
SO70316_3 | 6 | 12997 | 225 | 9 | 2024-07-14 | 0.22 | 2024-07-02 | 8.99 | 3 | SO70316 | 2024-07-09 | 0.72 | 6.92 | |
SO70356_1 | 6 | 21987 | 372 | 9 | 2024-07-14 | 61.08 | 2024-07-02 | 2443.35 | 1 | SO70356 | 2024-07-09 | 195.47 | 1554.95 | |
SO70356_2 | 6 | 21987 | 479 | 9 | 2024-07-14 | 0.22 | 2024-07-02 | 8.99 | 2 | SO70356 | 2024-07-09 | 0.72 | 3.36 | |
SO70356_3 | 6 | 21987 | 477 | 9 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 3 | SO70356 | 2024-07-09 | 0.40 | 1.87 | |
SO70357_1 | 6 | 22181 | 374 | 9 | 2024-07-14 | 61.08 | 2024-07-02 | 2443.35 | 1 | SO70357 | 2024-07-09 | 195.47 | 1554.95 | |
SO70357_2 | 6 | 22181 | 479 | 9 | 2024-07-14 | 0.22 | 2024-07-02 | 8.99 | 2 | SO70357 | 2024-07-09 | 0.72 | 3.36 | |
SO70357_3 | 6 | 22181 | 477 | 9 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 3 | SO70357 | 2024-07-09 | 0.40 | 1.87 | |
SO70357_4 | 6 | 22181 | 214 | 9 | 2024-07-14 | 0.87 | 2024-07-02 | 34.99 | 4 | SO70357 | 2024-07-09 | 2.80 | 13.09 | |
SO56111_1 | 6 | 19594 | 372 | 9 | 2023-12-17 | 61.08 | 2023-12-05 | 2443.35 | 1 | SO56111 | 2023-12-12 | 195.47 | 1554.95 | |
SO63736_1 | 6 | 11995 | 353 | 9 | 2024-04-11 | 58.00 | 2024-03-30 | 2319.99 | 1 | SO63736 | 2024-04-06 | 185.60 | 1265.62 | |
SO56112_1 | 6 | 19595 | 378 | 9 | 2023-12-17 | 61.08 | 2023-12-05 | 2443.35 | 1 | SO56112 | 2023-12-12 | 195.47 | 1554.95 | |
SO63736_2 | 6 | 11995 | 485 | 9 | 2024-04-11 | 0.55 | 2024-03-30 | 21.98 | 2 | SO63736 | 2024-04-06 | 1.76 | 8.22 | |
SO56112_2 | 6 | 19595 | 479 | 9 | 2023-12-17 | 0.22 | 2023-12-05 | 8.99 | 2 | SO56112 | 2023-12-12 | 0.72 | 3.36 | |
SO63736_3 | 6 | 11995 | 472 | 9 | 2024-04-11 | 1.59 | 2024-03-30 | 63.50 | 3 | SO63736 | 2024-04-06 | 5.08 | 23.75 | |
SO56112_3 | 6 | 19595 | 477 | 9 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 3 | SO56112 | 2023-12-12 | 0.40 | 1.87 | |
SO63737_1 | 6 | 11034 | 361 | 9 | 2024-04-11 | 57.37 | 2024-03-30 | 2294.99 | 1 | SO63737 | 2024-04-06 | 183.60 | 1251.98 | |
SO56112_4 | 6 | 19595 | 217 | 9 | 2023-12-17 | 0.87 | 2023-12-05 | 34.99 | 4 | SO56112 | 2023-12-12 | 2.80 | 13.09 | |
SO63738_1 | 6 | 14030 | 361 | 9 | 2024-04-11 | 57.37 | 2024-03-30 | 2294.99 | 1 | SO63738 | 2024-04-06 | 183.60 | 1251.98 | |
SO56112_5 | 6 | 19595 | 467 | 9 | 2023-12-17 | 0.61 | 2023-12-05 | 24.49 | 5 | SO56112 | 2023-12-12 | 1.96 | 9.16 | |
SO63738_2 | 6 | 14030 | 483 | 9 | 2024-04-11 | 3.00 | 2024-03-30 | 120.00 | 2 | SO63738 | 2024-04-06 | 9.60 | 44.88 | |
SO56113_1 | 6 | 12348 | 353 | 9 | 2023-12-17 | 58.00 | 2023-12-05 | 2319.99 | 1 | SO56113 | 2023-12-12 | 185.60 | 1265.62 | |
SO63750_1 | 6 | 11988 | 563 | 9 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63750 | 2024-04-06 | 190.73 | 1481.94 | |
SO56113_2 | 6 | 12348 | 478 | 9 | 2023-12-17 | 0.25 | 2023-12-05 | 9.99 | 2 | SO56113 | 2023-12-12 | 0.80 | 3.74 | |
SO63750_2 | 6 | 11988 | 225 | 9 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 2 | SO63750 | 2024-04-06 | 0.72 | 6.92 | |
SO56113_3 | 6 | 12348 | 477 | 9 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 3 | SO56113 | 2023-12-12 | 0.40 | 1.87 | |
SO63751_1 | 6 | 11989 | 575 | 9 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63751 | 2024-04-06 | 190.73 | 1481.94 | |
SO56113_4 | 6 | 12348 | 222 | 9 | 2023-12-17 | 0.87 | 2023-12-05 | 34.99 | 4 | SO56113 | 2023-12-12 | 2.80 | 13.09 | |
SO63752_1 | 6 | 29088 | 567 | 9 | 2024-04-11 | 18.56 | 2024-03-30 | 742.35 | 1 | SO63752 | 2024-04-06 | 59.39 | 461.44 | |
SO56113_5 | 6 | 12348 | 489 | 9 | 2023-12-17 | 1.35 | 2023-12-05 | 53.99 | 5 | SO56113 | 2023-12-12 | 4.32 | 41.57 | |
SO63752_2 | 6 | 29088 | 477 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 2 | SO63752 | 2024-04-06 | 0.40 | 1.87 |
Generated 2024-09-21 13:58:27.918 UTC