[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 425 > < TAKE 56 >
56 items
| FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO65173_12 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 581 | 155 | 6 | 2024-06-27 | 6123.56 | 153.09 | 2024-06-15 | 6 | 1082.51 | 1 | 6123.56 | 12 | SO65173 | 2024-06-22 | 489.89 | 6495.06 | 1020.59 | |||
| SO45313_17 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 314 | 317 | 6 | 2022-05-30 | 2146.96 | 53.67 | 2022-05-18 | 1 | 2171.29 | 1 | 2146.96 | 17 | SO45313 | 2022-05-25 | 171.76 | 2171.29 | 2146.96 | |||
| SO51751_18 | 257C-4EC8-98 | PO11368156185 | 36 | 295 | 591 | 687 | 8 | 2023-11-27 | 1355.98 | 33.90 | 2023-11-15 | 4 | 308.22 | 1 | 1355.98 | 18 | SO51751 | 2023-11-22 | 108.48 | 1232.87 | 338.99 | |||
| SO45328_7 | 2212-4E8E-82 | PO5684113284 | 100 | 282 | 218 | 385 | 4 | 2022-05-30 | 57.00 | 1.43 | 2022-05-18 | 10 | 3.40 | 1 | 57.00 | 7 | SO45328 | 2022-05-25 | 4.56 | 33.96 | 5.70 | |||
| SO46660_25 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 343 | 3 | 166 | 4 | 452.18 | 2022-10-27 | 9043.53 | 214.78 | 2022-10-15 | 21 | 486.71 | 1 | 8591.36 | 25 | SO46660 | 2022-10-22 | 687.31 | 10220.84 | 430.64 | 0.05 |
| SO47374_6 | C6BE-481A-A0 | PO16182131046 | 100 | 287 | 233 | 23 | 4 | 2022-12-28 | 115.36 | 2.88 | 2022-12-16 | 4 | 29.08 | 1 | 115.36 | 6 | SO47374 | 2022-12-23 | 9.23 | 116.32 | 28.84 | |||
| SO69510_2 | 20D6-41A2-8F | PO5568198481 | 100 | 285 | 477 | 422 | 5 | 2024-08-27 | 2.99 | 0.07 | 2024-08-15 | 1 | 1.87 | 1 | 2.99 | 2 | SO69510 | 2024-08-22 | 0.24 | 1.87 | 2.99 | |||
| SO53534_7 | F0B1-423E-8B | PO20213153510 | 100 | 283 | 545 | 216 | 2 | 2023-12-28 | 72.88 | 1.82 | 2023-12-16 | 3 | 17.98 | 1 | 72.88 | 7 | SO53534 | 2023-12-23 | 5.83 | 53.93 | 24.29 | |||
| SO48001_37 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 305 | 127 | 1 | 2023-02-27 | 736.15 | 18.40 | 2023-02-15 | 1 | 653.70 | 1 | 736.15 | 37 | SO48001 | 2023-02-22 | 58.89 | 653.70 | 736.15 | |||
| SO53506_10 | B5B1-4DF9-82 | PO11455145357 | 100 | 283 | 584 | 72 | 2 | 2023-12-28 | 1295.98 | 32.40 | 2023-12-16 | 4 | 343.65 | 1 | 1295.98 | 10 | SO53506 | 2023-12-23 | 103.68 | 1374.60 | 323.99 | |||
| SO49831_9 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 409 | 475 | 4 | 2023-07-28 | 837.02 | 20.93 | 2023-07-16 | 4 | 185.82 | 1 | 837.02 | 9 | SO49831 | 2023-07-23 | 66.96 | 743.28 | 209.26 | |||
| SO69437_12 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 487 | 175 | 7 | 2024-08-27 | 329.94 | 8.25 | 2024-08-15 | 10 | 20.57 | 1 | 329.94 | 12 | SO69437 | 2024-08-22 | 26.40 | 205.66 | 32.99 | |||
| SO45786_7 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 317 | 514 | 6 | 2022-07-28 | 6123.56 | 153.09 | 2022-07-16 | 7 | 884.71 | 1 | 6123.56 | 7 | SO45786 | 2022-07-23 | 489.88 | 6192.96 | 874.79 | |||
| SO47716_47 | 619E-46D6-98 | PO6467148836 | 100 | 281 | 333 | 660 | 3 | 2023-01-27 | 3288.56 | 82.21 | 2023-01-15 | 7 | 486.71 | 1 | 3288.56 | 47 | SO47716 | 2023-01-22 | 263.08 | 3406.95 | 469.79 | |||
| SO50735_3 | 915C-46CF-8E | PO2001132307 | 19 | 291 | 439 | 701 | 6 | 2023-09-27 | 780.82 | 19.52 | 2023-09-15 | 1 | 722.26 | 1 | 780.82 | 3 | SO50735 | 2023-09-22 | 62.47 | 722.26 | 780.82 | |||
| SO49864_23 | D282-4C24-9B | PO13775121562 | 100 | 283 | 221 | 618 | 2 | 2023-07-28 | 80.75 | 2.02 | 2023-07-16 | 4 | 13.88 | 1 | 80.75 | 23 | SO49864 | 2023-07-23 | 6.46 | 55.51 | 20.19 | |||
| SO58918_65 | C811-4D40-80 | PO17574131484 | 19 | 291 | 525 | 678 | 6 | 2024-03-28 | 633.72 | 15.84 | 2024-03-16 | 4 | 144.59 | 1 | 633.72 | 65 | SO58918 | 2024-03-23 | 50.70 | 578.38 | 158.43 | |||
| SO49848_17 | 31E6-4A3B-9C | PO1711148241 | 19 | 291 | 396 | 245 | 6 | 2023-07-28 | 74.84 | 1.87 | 2023-07-16 | 1 | 55.38 | 1 | 74.84 | 17 | SO49848 | 2023-07-23 | 5.99 | 55.38 | 74.84 | |||
| SO63247_10 | 1EB8-4AE3-AC | PO6148143330 | 100 | 289 | 496 | 693 | 1 | 2024-05-29 | 1807.04 | 45.18 | 2024-05-17 | 3 | 601.74 | 1 | 1807.04 | 10 | SO63247 | 2024-05-24 | 144.56 | 1805.23 | 602.35 | |||
| SO51706_3 | EC0B-4A2D-A1 | PO16762139224 | 100 | 282 | 217 | 259 | 4 | 2023-11-27 | 20.99 | 0.52 | 2023-11-15 | 1 | 13.09 | 1 | 20.99 | 3 | SO51706 | 2023-11-22 | 1.68 | 13.09 | 20.99 | |||
| SO51108_17 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 463 | 530 | 5 | 2023-10-27 | 102.86 | 2.57 | 2023-10-15 | 7 | 9.16 | 1 | 102.86 | 17 | SO51108 | 2023-10-22 | 8.23 | 64.12 | 14.69 | |||
| SO47666_7 | 6551-4B29-BF | PO16588184420 | 100 | 289 | 453 | 146 | 1 | 2023-01-27 | 251.96 | 6.30 | 2023-01-15 | 7 | 24.75 | 1 | 251.96 | 7 | SO47666 | 2023-01-22 | 20.16 | 173.22 | 35.99 | |||
| SO59059_4 | FD9E-44C4-97 | PO7482187440 | 100 | 293 | 496 | 163 | 1 | 2024-03-28 | 2409.38 | 60.23 | 2024-03-16 | 4 | 601.74 | 1 | 2409.38 | 4 | SO59059 | 2024-03-23 | 192.75 | 2406.97 | 602.35 | |||
| SO63177_17 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 225 | 263 | 6 | 2024-05-29 | 21.58 | 0.54 | 2024-05-17 | 4 | 6.92 | 1 | 21.58 | 17 | SO63177 | 2024-05-24 | 1.73 | 27.69 | 5.39 | |||
| SO46651_1 | 68A1-47A8-9A | PO3016181627 | 100 | 283 | 410 | 183 | 3 | 2022-10-27 | 182.24 | 4.56 | 2022-10-15 | 5 | 26.97 | 1 | 182.24 | 1 | SO46651 | 2022-10-22 | 14.58 | 134.85 | 36.45 | |||
| SO50245_18 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 233 | 66 | 6 | 2023-08-27 | 259.56 | 6.49 | 2023-08-15 | 9 | 29.08 | 1 | 259.56 | 18 | SO50245 | 2023-08-22 | 20.77 | 261.73 | 28.84 | |||
| SO43910_11 | 8233-42D0-BD | PO7598186753 | 100 | 285 | 338 | 45 | 5 | 2021-11-27 | 419.46 | 10.49 | 2021-11-15 | 1 | 413.15 | 1 | 419.46 | 11 | SO43910 | 2021-11-22 | 33.56 | 413.15 | 419.46 | |||
| SO46616_34 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 383 | 514 | 6 | 2022-10-27 | 1800.79 | 45.02 | 2022-10-15 | 3 | 605.65 | 1 | 1800.79 | 34 | SO46616 | 2022-10-22 | 144.06 | 1816.95 | 600.26 | |||
| SO46988_5 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 233 | 78 | 4 | 2022-11-27 | 288.40 | 7.21 | 2022-11-15 | 10 | 29.08 | 1 | 288.40 | 5 | SO46988 | 2022-11-22 | 23.07 | 290.81 | 28.84 | |||
| SO57065_31 | B68A-407E-99 | PO11658151711 | 100 | 283 | 501 | 233 | 2 | 2024-02-27 | 218.63 | 5.47 | 2024-02-15 | 3 | 53.93 | 1 | 218.63 | 31 | SO57065 | 2024-02-22 | 17.49 | 161.78 | 72.88 | |||
| SO49069_14 | 251D-4CF2-8D | PO1914132192 | 19 | 284 | 325 | 66 | 6 | 2023-05-30 | 469.79 | 11.74 | 2023-05-18 | 1 | 486.71 | 1 | 469.79 | 14 | SO49069 | 2023-05-25 | 37.58 | 486.71 | 469.79 | |||
| SO49161_7 | 0377-44E6-AA | PO7627157444 | 100 | 293 | 339 | 433 | 1 | 2023-05-30 | 1879.18 | 46.98 | 2023-05-18 | 4 | 486.71 | 1 | 1879.18 | 7 | SO49161 | 2023-05-25 | 150.33 | 1946.83 | 469.79 | |||
| SO51721_13 | 9429-430D-89 | PO14500124798 | 100 | 282 | 484 | 3 | 650 | 1 | 3.50 | 2023-11-27 | 69.96 | 1.66 | 2023-11-15 | 16 | 2.97 | 1 | 66.46 | 13 | SO51721 | 2023-11-22 | 5.32 | 47.57 | 4.37 | 0.05 |
| SO71897_7 | 01B7-40D7-B0 | PO4785152479 | 100 | 282 | 471 | 223 | 3 | 2024-09-27 | 38.10 | 0.95 | 2024-09-15 | 1 | 23.75 | 1 | 38.10 | 7 | SO71897 | 2024-09-22 | 3.05 | 23.75 | 38.10 | |||
| SO53545_20 | 2CC7-4F36-B6 | PO14239178578 | 19 | 291 | 465 | 550 | 6 | 2023-12-28 | 44.08 | 1.10 | 2023-12-16 | 3 | 9.16 | 1 | 44.08 | 20 | SO53545 | 2023-12-23 | 3.53 | 27.48 | 14.69 | |||
| SO43665_6 | 19F0-4638-8E | PO16588191572 | 100 | 289 | 223 | 146 | 1 | 2021-10-27 | 10.37 | 0.26 | 2021-10-15 | 2 | 5.71 | 1 | 10.37 | 6 | SO43665 | 2021-10-22 | 0.83 | 11.41 | 5.19 | |||
| SO50702_21 | 6D0A-413E-BE | PO2697119650 | 100 | 282 | 362 | 187 | 4 | 2023-09-27 | 4917.84 | 122.95 | 2023-09-15 | 4 | 1105.81 | 1 | 4917.84 | 21 | SO50702 | 2023-09-22 | 393.43 | 4423.24 | 1229.46 | |||
| SO46036_7 | DBE7-4B0A-93 | PO18386134137 | 100 | 281 | 212 | 558 | 2 | 2022-08-27 | 80.75 | 2.02 | 2022-08-15 | 4 | 12.03 | 1 | 80.75 | 7 | SO46036 | 2022-08-22 | 6.46 | 48.11 | 20.19 | |||
| SO63148_13 | 00FA-42B1-88 | PO16675153915 | 100 | 293 | 603 | 361 | 1 | 2024-05-29 | 145.79 | 3.64 | 2024-05-17 | 2 | 53.94 | 1 | 145.79 | 13 | SO63148 | 2024-05-24 | 11.66 | 107.88 | 72.89 | |||
| SO71854_23 | AF3C-4FDF-A6 | PO16385143469 | 6 | 296 | 465 | 249 | 9 | 2024-09-27 | 58.78 | 1.47 | 2024-09-15 | 4 | 9.16 | 1 | 58.78 | 23 | SO71854 | 2024-09-22 | 4.70 | 36.64 | 14.69 | |||
| SO58968_9 | 6168-427B-B5 | PO1305182599 | 100 | 290 | 471 | 319 | 7 | 2024-03-28 | 114.30 | 2.86 | 2024-03-16 | 3 | 23.75 | 1 | 114.30 | 9 | SO58968 | 2024-03-23 | 9.14 | 71.25 | 38.10 | |||
| SO48341_38 | A747-471B-97 | PO10701176180 | 100 | 282 | 356 | 133 | 4 | 2023-03-29 | 6214.26 | 155.36 | 2023-03-17 | 5 | 1117.86 | 1 | 6214.26 | 38 | SO48341 | 2023-03-24 | 497.14 | 5589.28 | 1242.85 | |||
| SO50272_27 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 422 | 97 | 4 | 2023-08-27 | 270.16 | 6.75 | 2023-08-15 | 4 | 49.98 | 1 | 270.16 | 27 | SO50272 | 2023-08-22 | 21.61 | 199.92 | 67.54 | |||
| SO53516_1 | B8FA-4D65-AF | PO377190988 | 36 | 295 | 570 | 13 | 633 | 8 | 50.11 | 2023-12-28 | 334.06 | 7.10 | 2023-12-16 | 1 | 461.44 | 1 | 283.95 | 1 | SO53516 | 2023-12-23 | 22.72 | 461.44 | 334.06 | 0.15 |
| SO53475_28 | FFE3-4820-88 | PO15515192405 | 100 | 292 | 467 | 481 | 7 | 2023-12-28 | 88.16 | 2.20 | 2023-12-16 | 6 | 9.16 | 1 | 88.16 | 28 | SO53475 | 2023-12-23 | 7.05 | 54.96 | 14.69 | |||
| SO65311_13 | 8732-477D-BC | PO7047142102 | 100 | 281 | 531 | 544 | 3 | 2024-06-27 | 299.75 | 7.49 | 2024-06-15 | 2 | 136.79 | 1 | 299.75 | 13 | SO65311 | 2024-06-22 | 23.98 | 273.57 | 149.87 | |||
| SO47439_11 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 216 | 3 | 4 | 2022-12-28 | 201.87 | 5.05 | 2022-12-16 | 10 | 13.88 | 1 | 201.87 | 11 | SO47439 | 2022-12-23 | 16.15 | 138.78 | 20.19 | |||
| SO53470_7 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 494 | 420 | 4 | 2023-12-28 | 3011.73 | 75.29 | 2023-12-16 | 5 | 601.74 | 1 | 3011.73 | 7 | SO53470 | 2023-12-23 | 240.94 | 3008.72 | 602.35 | |||
| SO61248_13 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 295 | 496 | 6 | 2024-04-28 | 1637.40 | 40.94 | 2024-04-16 | 2 | 747.20 | 1 | 1637.40 | 13 | SO61248 | 2024-04-23 | 130.99 | 1494.40 | 818.70 | |||
| SO53524_50 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 586 | 13 | 611 | 5 | 450.98 | 2023-12-28 | 3006.52 | 63.89 | 2023-12-16 | 9 | 461.44 | 1 | 2555.54 | 50 | SO53524 | 2023-12-23 | 204.44 | 4153.00 | 334.06 | 0.15 |
| SO63252_33 | 4233-41A9-B7 | PO6438150148 | 100 | 281 | 484 | 309 | 4 | 2024-05-29 | 4.77 | 0.12 | 2024-05-17 | 1 | 2.97 | 1 | 4.77 | 33 | SO63252 | 2024-05-24 | 0.38 | 2.97 | 4.77 | |||
| SO49836_22 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 409 | 530 | 5 | 2023-07-28 | 209.26 | 5.23 | 2023-07-16 | 1 | 185.82 | 1 | 209.26 | 22 | SO49836 | 2023-07-23 | 16.74 | 185.82 | 209.26 | |||
| SO50747_17 | A59F-46DA-BE | PO5597196496 | 100 | 281 | 395 | 75 | 4 | 2023-09-27 | 245.50 | 6.14 | 2023-09-15 | 4 | 45.42 | 1 | 245.50 | 17 | SO50747 | 2023-09-22 | 19.64 | 181.67 | 61.37 | |||
| SO49078_11 | 827E-4512-AD | PO2668184206 | 100 | 290 | 459 | 535 | 7 | 2023-05-30 | 107.99 | 2.70 | 2023-05-18 | 2 | 37.12 | 1 | 107.99 | 11 | SO49078 | 2023-05-25 | 8.64 | 74.24 | 53.99 | |||
| SO71819_38 | DBA3-430C-8B | PO12354153257 | 100 | 283 | 309 | 197 | 3 | 2024-09-27 | 818.70 | 20.47 | 2024-09-15 | 1 | 747.20 | 1 | 818.70 | 38 | SO71819 | 2024-09-22 | 65.50 | 747.20 | 818.70 | |||
| SO65152_1 | 9C5B-4E79-98 | PO20213135029 | 100 | 283 | 390 | 216 | 2 | 2024-06-27 | 1344.59 | 33.61 | 2024-06-15 | 2 | 713.08 | 1 | 1344.59 | 1 | SO65152 | 2024-06-22 | 107.57 | 1426.16 | 672.29 |
Generated 2024-11-14 05:31:49.877 UTC