[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1231 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46538_1 | 100 | 12774 | 310 | 4 | 2022-10-14 | 89.46 | 2022-10-02 | 3578.27 | 1 | SO46538 | 2022-10-09 | 286.26 | 2171.29 | |
SO46539_1 | 100 | 12200 | 314 | 4 | 2022-10-14 | 89.46 | 2022-10-02 | 3578.27 | 1 | SO46539 | 2022-10-09 | 286.26 | 2171.29 | |
SO46550_1 | 100 | 26097 | 350 | 4 | 2022-10-15 | 84.37 | 2022-10-03 | 3374.99 | 1 | SO46550 | 2022-10-10 | 270.00 | 1898.09 | |
SO46551_1 | 100 | 14914 | 330 | 4 | 2022-10-15 | 17.48 | 2022-10-03 | 699.10 | 1 | SO46551 | 2022-10-10 | 55.93 | 413.15 | |
SO46552_1 | 100 | 15017 | 328 | 4 | 2022-10-15 | 17.48 | 2022-10-03 | 699.10 | 1 | SO46552 | 2022-10-10 | 55.93 | 413.15 | |
SO46557_1 | 100 | 12904 | 310 | 4 | 2022-10-16 | 89.46 | 2022-10-04 | 3578.27 | 1 | SO46557 | 2022-10-11 | 286.26 | 2171.29 | |
SO46559_1 | 100 | 12762 | 310 | 4 | 2022-10-16 | 89.46 | 2022-10-04 | 3578.27 | 1 | SO46559 | 2022-10-11 | 286.26 | 2171.29 | |
SO46560_1 | 100 | 26096 | 344 | 4 | 2022-10-16 | 85.00 | 2022-10-04 | 3399.99 | 1 | SO46560 | 2022-10-11 | 272.00 | 1912.15 | |
SO46566_1 | 100 | 12789 | 311 | 4 | 2022-10-17 | 89.46 | 2022-10-05 | 3578.27 | 1 | SO46566 | 2022-10-12 | 286.26 | 2171.29 | |
SO46569_1 | 100 | 12450 | 312 | 4 | 2022-10-18 | 89.46 | 2022-10-06 | 3578.27 | 1 | SO46569 | 2022-10-13 | 286.26 | 2171.29 | |
SO46579_1 | 100 | 12186 | 311 | 4 | 2022-10-19 | 89.46 | 2022-10-07 | 3578.27 | 1 | SO46579 | 2022-10-14 | 286.26 | 2171.29 | |
SO46580_1 | 100 | 12187 | 310 | 4 | 2022-10-19 | 89.46 | 2022-10-07 | 3578.27 | 1 | SO46580 | 2022-10-14 | 286.26 | 2171.29 | |
SO46581_1 | 100 | 12188 | 314 | 4 | 2022-10-19 | 89.46 | 2022-10-07 | 3578.27 | 1 | SO46581 | 2022-10-14 | 286.26 | 2171.29 | |
SO46599_1 | 100 | 12206 | 310 | 4 | 2022-10-22 | 89.46 | 2022-10-10 | 3578.27 | 1 | SO46599 | 2022-10-17 | 286.26 | 2171.29 | |
SO46601_1 | 100 | 26098 | 345 | 4 | 2022-10-22 | 85.00 | 2022-10-10 | 3399.99 | 1 | SO46601 | 2022-10-17 | 272.00 | 1912.15 | |
SO46685_1 | 100 | 12947 | 377 | 4 | 2022-10-24 | 54.54 | 2022-10-12 | 2181.56 | 1 | SO46685 | 2022-10-19 | 174.53 | 1320.68 | |
SO46689_1 | 100 | 13032 | 369 | 2 | 4 | 2022-10-25 | 61.08 | 2022-10-13 | 2443.35 | 1 | SO46689 | 2022-10-20 | 195.47 | 1518.79 |
SO46690_1 | 100 | 13039 | 368 | 4 | 2022-10-25 | 61.08 | 2022-10-13 | 2443.35 | 1 | SO46690 | 2022-10-20 | 195.47 | 1518.79 | |
SO46691_1 | 100 | 13142 | 368 | 4 | 2022-10-25 | 61.08 | 2022-10-13 | 2443.35 | 1 | SO46691 | 2022-10-20 | 195.47 | 1518.79 | |
SO46692_1 | 100 | 13208 | 369 | 2 | 4 | 2022-10-25 | 61.08 | 2022-10-13 | 2443.35 | 1 | SO46692 | 2022-10-20 | 195.47 | 1518.79 |
SO46693_1 | 100 | 13210 | 373 | 4 | 2022-10-25 | 54.54 | 2022-10-13 | 2181.56 | 1 | SO46693 | 2022-10-20 | 174.53 | 1320.68 | |
SO46694_1 | 100 | 13220 | 373 | 4 | 2022-10-25 | 54.54 | 2022-10-13 | 2181.56 | 1 | SO46694 | 2022-10-20 | 174.53 | 1320.68 | |
SO46704_1 | 100 | 13059 | 370 | 4 | 2022-10-26 | 61.08 | 2022-10-14 | 2443.35 | 1 | SO46704 | 2022-10-21 | 195.47 | 1518.79 | |
SO46707_1 | 100 | 15199 | 337 | 4 | 2022-10-26 | 19.57 | 2022-10-14 | 782.99 | 1 | SO46707 | 2022-10-21 | 62.64 | 486.71 | |
SO46723_1 | 100 | 12918 | 368 | 4 | 2022-10-28 | 61.08 | 2022-10-16 | 2443.35 | 1 | SO46723 | 2022-10-23 | 195.47 | 1518.79 | |
SO46732_1 | 100 | 13992 | 385 | 4 | 2022-10-29 | 25.01 | 2022-10-17 | 1000.44 | 1 | SO46732 | 2022-10-24 | 80.04 | 605.65 | |
SO46734_1 | 100 | 13060 | 375 | 4 | 2022-10-29 | 54.54 | 2022-10-17 | 2181.56 | 1 | SO46734 | 2022-10-24 | 174.53 | 1320.68 | |
SO46746_1 | 100 | 13057 | 368 | 4 | 2022-10-31 | 61.08 | 2022-10-19 | 2443.35 | 1 | SO46746 | 2022-10-26 | 195.47 | 1518.79 | |
SO46748_1 | 100 | 26252 | 360 | 4 | 2022-10-31 | 51.23 | 2022-10-19 | 2049.10 | 1 | SO46748 | 2022-10-26 | 163.93 | 1105.81 | |
SO46751_1 | 100 | 12934 | 377 | 4 | 2022-11-01 | 54.54 | 2022-10-20 | 2181.56 | 1 | SO46751 | 2022-10-27 | 174.53 | 1320.68 | |
SO46756_1 | 100 | 13993 | 383 | 4 | 2022-11-01 | 25.01 | 2022-10-20 | 1000.44 | 1 | SO46756 | 2022-10-27 | 80.04 | 605.65 | |
SO46760_1 | 100 | 13986 | 387 | 4 | 2022-11-02 | 25.01 | 2022-10-21 | 1000.44 | 1 | SO46760 | 2022-10-28 | 80.04 | 605.65 | |
SO46763_1 | 100 | 13202 | 375 | 4 | 2022-11-02 | 54.54 | 2022-10-21 | 2181.56 | 1 | SO46763 | 2022-10-28 | 174.53 | 1320.68 | |
SO46764_1 | 100 | 26238 | 360 | 4 | 2022-11-02 | 51.23 | 2022-10-21 | 2049.10 | 1 | SO46764 | 2022-10-28 | 163.93 | 1105.81 | |
SO46765_1 | 100 | 15191 | 333 | 4 | 2022-11-02 | 19.57 | 2022-10-21 | 782.99 | 1 | SO46765 | 2022-10-28 | 62.64 | 486.71 | |
SO46771_1 | 100 | 13068 | 377 | 4 | 2022-11-03 | 54.54 | 2022-10-22 | 2181.56 | 1 | SO46771 | 2022-10-29 | 174.53 | 1320.68 | |
SO46774_1 | 100 | 13225 | 375 | 4 | 2022-11-03 | 54.54 | 2022-10-22 | 2181.56 | 1 | SO46774 | 2022-10-29 | 174.53 | 1320.68 | |
SO46780_1 | 100 | 12942 | 379 | 4 | 2022-11-04 | 54.54 | 2022-10-23 | 2181.56 | 1 | SO46780 | 2022-10-30 | 174.53 | 1320.68 | |
SO46782_1 | 100 | 12975 | 371 | 4 | 2022-11-04 | 54.54 | 2022-10-23 | 2181.56 | 1 | SO46782 | 2022-10-30 | 174.53 | 1320.68 | |
SO46785_1 | 100 | 13190 | 373 | 4 | 2022-11-04 | 54.54 | 2022-10-23 | 2181.56 | 1 | SO46785 | 2022-10-30 | 174.53 | 1320.68 | |
SO46786_1 | 100 | 26201 | 354 | 4 | 2022-11-04 | 51.79 | 2022-10-23 | 2071.42 | 1 | SO46786 | 2022-10-30 | 165.71 | 1117.86 | |
SO46787_1 | 100 | 15195 | 333 | 4 | 2022-11-04 | 19.57 | 2022-10-23 | 782.99 | 1 | SO46787 | 2022-10-30 | 62.64 | 486.71 | |
SO46795_1 | 100 | 26234 | 362 | 2 | 4 | 2022-11-05 | 51.23 | 2022-10-24 | 2049.10 | 1 | SO46795 | 2022-10-31 | 163.93 | 1105.81 |
SO46796_1 | 100 | 26247 | 360 | 4 | 2022-11-05 | 51.23 | 2022-10-24 | 2049.10 | 1 | SO46796 | 2022-10-31 | 163.93 | 1105.81 | |
SO46800_1 | 100 | 13019 | 370 | 4 | 2022-11-06 | 61.08 | 2022-10-25 | 2443.35 | 1 | SO46800 | 2022-11-01 | 195.47 | 1518.79 | |
SO46813_1 | 100 | 13152 | 379 | 4 | 2022-11-08 | 54.54 | 2022-10-27 | 2181.56 | 1 | SO46813 | 2022-11-03 | 174.53 | 1320.68 | |
SO46814_1 | 100 | 13165 | 371 | 4 | 2022-11-08 | 54.54 | 2022-10-27 | 2181.56 | 1 | SO46814 | 2022-11-03 | 174.53 | 1320.68 | |
SO46817_1 | 100 | 26121 | 356 | 4 | 2022-11-08 | 51.79 | 2022-10-27 | 2071.42 | 1 | SO46817 | 2022-11-03 | 165.71 | 1117.86 | |
SO46822_1 | 100 | 15155 | 325 | 4 | 2022-11-09 | 19.57 | 2022-10-28 | 782.99 | 1 | SO46822 | 2022-11-04 | 62.64 | 486.71 | |
SO56976_3 | 100 | 20458 | 217 | 4 | 2024-02-22 | 0.87 | 2024-02-10 | 34.99 | 3 | SO56976 | 2024-02-17 | 2.80 | 13.09 | |
SO56978_1 | 100 | 19216 | 477 | 4 | 2024-02-22 | 0.12 | 2024-02-10 | 4.99 | 1 | SO56978 | 2024-02-17 | 0.40 | 1.87 | |
SO56978_2 | 100 | 19216 | 237 | 4 | 2024-02-22 | 1.25 | 2024-02-10 | 49.99 | 2 | SO56978 | 2024-02-17 | 4.00 | 38.49 | |
SO56981_1 | 100 | 16249 | 528 | 4 | 2024-02-22 | 0.12 | 2024-02-10 | 4.99 | 1 | SO56981 | 2024-02-17 | 0.40 | 1.87 | |
SO56981_2 | 100 | 16249 | 481 | 4 | 2024-02-22 | 0.22 | 2024-02-10 | 8.99 | 2 | SO56981 | 2024-02-17 | 0.72 | 3.36 | |
SO56983_1 | 100 | 15405 | 528 | 4 | 2024-02-22 | 0.12 | 2024-02-10 | 4.99 | 1 | SO56983 | 2024-02-17 | 0.40 | 1.87 | |
SO56983_2 | 100 | 15405 | 480 | 4 | 2024-02-22 | 0.06 | 2024-02-10 | 2.29 | 2 | SO56983 | 2024-02-17 | 0.18 | 0.86 | |
SO56983_3 | 100 | 15405 | 484 | 4 | 2024-02-22 | 0.20 | 2024-02-10 | 7.95 | 3 | SO56983 | 2024-02-17 | 0.64 | 2.97 | |
SO56985_1 | 100 | 15838 | 485 | 4 | 2024-02-22 | 0.55 | 2024-02-10 | 21.98 | 1 | SO56985 | 2024-02-17 | 1.76 | 8.22 | |
SO56985_2 | 100 | 15838 | 222 | 4 | 2024-02-22 | 0.87 | 2024-02-10 | 34.99 | 2 | SO56985 | 2024-02-17 | 2.80 | 13.09 | |
SO56993_1 | 100 | 11932 | 537 | 4 | 2024-02-22 | 0.88 | 2024-02-10 | 35.00 | 1 | SO56993 | 2024-02-17 | 2.80 | 13.09 | |
SO56993_2 | 100 | 11932 | 528 | 4 | 2024-02-22 | 0.12 | 2024-02-10 | 4.99 | 2 | SO56993 | 2024-02-17 | 0.40 | 1.87 | |
SO56993_3 | 100 | 11932 | 480 | 4 | 2024-02-22 | 0.06 | 2024-02-10 | 2.29 | 3 | SO56993 | 2024-02-17 | 0.18 | 0.86 | |
SO56998_1 | 100 | 13190 | 355 | 4 | 2024-02-22 | 58.00 | 2024-02-10 | 2319.99 | 1 | SO56998 | 2024-02-17 | 185.60 | 1265.62 | |
SO57006_1 | 100 | 25049 | 225 | 4 | 2024-02-22 | 0.22 | 2024-02-10 | 8.99 | 1 | SO57006 | 2024-02-17 | 0.72 | 6.92 | |
SO57006_2 | 100 | 25049 | 561 | 4 | 2024-02-22 | 59.60 | 2024-02-10 | 2384.07 | 2 | SO57006 | 2024-02-17 | 190.73 | 1481.94 | |
SO57007_1 | 100 | 19744 | 390 | 4 | 2024-02-22 | 28.01 | 2024-02-10 | 1120.49 | 1 | SO57007 | 2024-02-17 | 89.64 | 713.08 | |
SO57007_2 | 100 | 19744 | 228 | 4 | 2024-02-22 | 1.25 | 2024-02-10 | 49.99 | 2 | SO57007 | 2024-02-17 | 4.00 | 38.49 | |
SO57007_3 | 100 | 19744 | 225 | 4 | 2024-02-22 | 0.22 | 2024-02-10 | 8.99 | 3 | SO57007 | 2024-02-17 | 0.72 | 6.92 | |
SO57008_1 | 100 | 19867 | 384 | 4 | 2024-02-22 | 28.01 | 2024-02-10 | 1120.49 | 1 | SO57008 | 2024-02-17 | 89.64 | 713.08 | |
SO57008_2 | 100 | 19867 | 222 | 4 | 2024-02-22 | 0.87 | 2024-02-10 | 34.99 | 2 | SO57008 | 2024-02-17 | 2.80 | 13.09 | |
SO57192_1 | 100 | 11183 | 529 | 4 | 2024-02-23 | 0.10 | 2024-02-11 | 3.99 | 1 | SO57192 | 2024-02-18 | 0.32 | 1.49 | |
SO57192_2 | 100 | 11183 | 480 | 4 | 2024-02-23 | 0.06 | 2024-02-11 | 2.29 | 2 | SO57192 | 2024-02-18 | 0.18 | 0.86 | |
SO57201_1 | 100 | 11840 | 234 | 4 | 2024-02-23 | 1.25 | 2024-02-11 | 49.99 | 1 | SO57201 | 2024-02-18 | 4.00 | 38.49 | |
SO57215_1 | 100 | 14919 | 528 | 4 | 2024-02-23 | 0.12 | 2024-02-11 | 4.99 | 1 | SO57215 | 2024-02-18 | 0.40 | 1.87 | |
SO57215_2 | 100 | 14919 | 480 | 2 | 4 | 2024-02-23 | 0.06 | 2024-02-11 | 2.29 | 2 | SO57215 | 2024-02-18 | 0.18 | 0.86 |
SO57223_1 | 100 | 14090 | 485 | 4 | 2024-02-23 | 0.55 | 2024-02-11 | 21.98 | 1 | SO57223 | 2024-02-18 | 1.76 | 8.22 | |
SO57223_2 | 100 | 14090 | 471 | 4 | 2024-02-23 | 1.59 | 2024-02-11 | 63.50 | 2 | SO57223 | 2024-02-18 | 5.08 | 23.75 | |
SO57224_1 | 100 | 13187 | 485 | 4 | 2024-02-23 | 0.55 | 2024-02-11 | 21.98 | 1 | SO57224 | 2024-02-18 | 1.76 | 8.22 | |
SO57224_2 | 100 | 13187 | 484 | 4 | 2024-02-23 | 0.20 | 2024-02-11 | 7.95 | 2 | SO57224 | 2024-02-18 | 0.64 | 2.97 | |
SO57225_1 | 100 | 20382 | 372 | 4 | 2024-02-23 | 61.08 | 2024-02-11 | 2443.35 | 1 | SO57225 | 2024-02-18 | 195.47 | 1554.95 | |
SO57225_2 | 100 | 20382 | 540 | 4 | 2024-02-23 | 0.82 | 2024-02-11 | 32.60 | 2 | SO57225 | 2024-02-18 | 2.61 | 12.19 | |
SO57225_3 | 100 | 20382 | 529 | 4 | 2024-02-23 | 0.10 | 2024-02-11 | 3.99 | 3 | SO57225 | 2024-02-18 | 0.32 | 1.49 | |
SO57225_4 | 100 | 20382 | 480 | 4 | 2024-02-23 | 0.06 | 2024-02-11 | 2.29 | 4 | SO57225 | 2024-02-18 | 0.18 | 0.86 | |
SO57226_1 | 100 | 19162 | 598 | 4 | 2024-02-23 | 13.50 | 2024-02-11 | 539.99 | 1 | SO57226 | 2024-02-18 | 43.20 | 294.58 | |
SO57226_2 | 100 | 19162 | 477 | 4 | 2024-02-23 | 0.12 | 2024-02-11 | 4.99 | 2 | SO57226 | 2024-02-18 | 0.40 | 1.87 | |
SO57226_3 | 100 | 19162 | 225 | 4 | 2024-02-23 | 0.22 | 2024-02-11 | 8.99 | 3 | SO57226 | 2024-02-18 | 0.72 | 6.92 | |
SO57226_4 | 100 | 19162 | 478 | 4 | 2024-02-23 | 0.25 | 2024-02-11 | 9.99 | 4 | SO57226 | 2024-02-18 | 0.80 | 3.74 | |
SO57228_1 | 100 | 11773 | 355 | 4 | 2024-02-23 | 58.00 | 2024-02-11 | 2319.99 | 1 | SO57228 | 2024-02-18 | 185.60 | 1265.62 | |
SO57228_2 | 100 | 11773 | 485 | 4 | 2024-02-23 | 0.55 | 2024-02-11 | 21.98 | 2 | SO57228 | 2024-02-18 | 1.76 | 8.22 | |
SO57228_3 | 100 | 11773 | 472 | 4 | 2024-02-23 | 1.59 | 2024-02-11 | 63.50 | 3 | SO57228 | 2024-02-18 | 5.08 | 23.75 | |
SO57236_1 | 100 | 24354 | 563 | 4 | 2024-02-23 | 59.60 | 2024-02-11 | 2384.07 | 1 | SO57236 | 2024-02-18 | 190.73 | 1481.94 | |
SO57236_2 | 100 | 24354 | 541 | 4 | 2024-02-23 | 0.72 | 2024-02-11 | 28.99 | 2 | SO57236 | 2024-02-18 | 2.32 | 10.84 | |
SO57236_3 | 100 | 24354 | 530 | 4 | 2024-02-23 | 0.12 | 2024-02-11 | 4.99 | 3 | SO57236 | 2024-02-18 | 0.40 | 1.87 | |
SO57237_1 | 100 | 22899 | 606 | 2 | 4 | 2024-02-23 | 13.50 | 2024-02-11 | 539.99 | 1 | SO57237 | 2024-02-18 | 43.20 | 343.65 |
SO57237_2 | 100 | 22899 | 538 | 4 | 2024-02-23 | 0.54 | 2024-02-11 | 21.49 | 2 | SO57237 | 2024-02-18 | 1.72 | 8.04 | |
SO57237_3 | 100 | 22899 | 529 | 4 | 2024-02-23 | 0.10 | 2024-02-11 | 3.99 | 3 | SO57237 | 2024-02-18 | 0.32 | 1.49 |
Generated 2024-11-10 23:00:10.708 UTC