[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2469 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71881_29 | 8EDF-4F9F-97 | PO6757112103 | 100 | 281 | 512 | 21 | 4 | 2024-09-22 | 436.91 | 10.92 | 2024-09-10 | 2 | 199.38 | 1 | 436.91 | 29 | SO71881 | 2024-09-17 | 34.95 | 398.75 | 218.45 | |||
SO71924_1 | 1C32-4971-8C | PO725177386 | 100 | 281 | 527 | 291 | 4 | 2024-09-22 | 158.43 | 3.96 | 2024-09-10 | 1 | 144.59 | 1 | 158.43 | 1 | SO71924 | 2024-09-17 | 12.67 | 144.59 | 158.43 | |||
SO47350_1 | D334-4827-9B | PO174170909 | 100 | 282 | 343 | 277 | 4 | 2022-12-23 | 2348.97 | 58.72 | 2022-12-11 | 5 | 486.71 | 1 | 2348.97 | 1 | SO47350 | 2022-12-18 | 187.92 | 2433.53 | 469.79 | |||
SO53550_10 | C0B3-4A54-9F | PO16124171850 | 100 | 282 | 481 | 649 | 4 | 2023-12-23 | 10.79 | 0.27 | 2023-12-11 | 2 | 3.36 | 1 | 10.79 | 10 | SO53550 | 2023-12-18 | 0.86 | 6.72 | 5.39 | |||
SO48356_9 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 420 | 187 | 4 | 2023-03-24 | 849.69 | 21.24 | 2023-03-12 | 6 | 104.80 | 1 | 849.69 | 9 | SO48356 | 2023-03-19 | 67.98 | 628.77 | 141.62 | |||
SO51745_20 | C261-441D-A5 | PO11745132954 | 100 | 282 | 386 | 97 | 4 | 2023-11-22 | 2016.88 | 50.42 | 2023-11-10 | 3 | 713.08 | 1 | 2016.88 | 20 | SO51745 | 2023-11-17 | 161.35 | 2139.24 | 672.29 | |||
SO48016_16 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 325 | 97 | 4 | 2023-02-22 | 1879.18 | 46.98 | 2023-02-10 | 4 | 486.71 | 1 | 1879.18 | 16 | SO48016 | 2023-02-17 | 150.33 | 1946.83 | 469.79 | |||
SO59023_5 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 542 | 61 | 4 | 2024-03-23 | 97.18 | 2.43 | 2024-03-11 | 4 | 17.98 | 1 | 97.18 | 5 | SO59023 | 2024-03-18 | 7.77 | 71.91 | 24.29 | |||
SO48740_2 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 341 | 4 | 4 | 2023-04-24 | 1409.38 | 35.23 | 2023-04-12 | 3 | 486.71 | 1 | 1409.38 | 2 | SO48740 | 2023-04-19 | 112.75 | 1460.12 | 469.79 | |||
SO47676_9 | 5DD7-4A1E-9B | PO13659142296 | 100 | 272 | 308 | 437 | 4 | 2023-01-22 | 744.27 | 18.61 | 2023-01-10 | 1 | 660.91 | 1 | 744.27 | 9 | SO47676 | 2023-01-17 | 59.54 | 660.91 | 744.27 | |||
SO53459_49 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 562 | 14 | 582 | 4 | 190.73 | 2023-12-23 | 953.63 | 19.07 | 2023-12-11 | 1 | 1481.94 | 1 | 762.90 | 49 | SO53459 | 2023-12-18 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO49489_4 | 7419-48A5-B8 | PO16182158783 | 100 | 287 | 468 | 23 | 4 | 2023-06-22 | 113.97 | 2.85 | 2023-06-10 | 5 | 15.67 | 1 | 113.97 | 4 | SO49489 | 2023-06-17 | 9.12 | 78.35 | 22.79 | |||
SO61227_25 | 9006-4208-8F | PO10730172247 | 100 | 287 | 490 | 491 | 4 | 2024-04-23 | 97.18 | 2.43 | 2024-04-11 | 3 | 41.57 | 1 | 97.18 | 25 | SO61227 | 2024-04-18 | 7.77 | 124.72 | 32.39 | |||
SO49099_16 | D567-4CCE-A4 | PO15689170019 | 100 | 281 | 339 | 328 | 4 | 2023-05-25 | 3288.56 | 82.21 | 2023-05-13 | 7 | 486.71 | 1 | 3288.56 | 16 | SO49099 | 2023-05-20 | 263.08 | 3406.95 | 469.79 | |||
SO71796_1 | 9A29-45DE-BF | PO17052159664 | 100 | 282 | 498 | 420 | 4 | 2024-09-22 | 602.35 | 15.06 | 2024-09-10 | 1 | 601.74 | 1 | 602.35 | 1 | SO71796 | 2024-09-17 | 48.19 | 601.74 | 602.35 | |||
SO59013_12 | C224-4535-BA | PO5597199820 | 100 | 281 | 542 | 75 | 4 | 2024-03-23 | 48.59 | 1.21 | 2024-03-11 | 2 | 17.98 | 1 | 48.59 | 12 | SO59013 | 2024-03-18 | 3.89 | 35.96 | 24.29 | |||
SO51855_22 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 471 | 2 | 436 | 4 | 10.31 | 2023-11-22 | 515.62 | 12.63 | 2023-11-10 | 14 | 23.75 | 1 | 505.31 | 22 | SO51855 | 2023-11-17 | 40.42 | 332.49 | 36.83 | 0.02 |
SO59029_19 | E358-40C0-B2 | PO4640116818 | 100 | 287 | 589 | 648 | 4 | 2024-03-23 | 2308.47 | 57.71 | 2024-03-11 | 5 | 419.78 | 1 | 2308.47 | 19 | SO59029 | 2024-03-18 | 184.68 | 2098.89 | 461.69 | |||
SO61184_21 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 573 | 599 | 4 | 2024-04-23 | 11443.54 | 286.09 | 2024-04-11 | 8 | 1481.94 | 1 | 11443.54 | 21 | SO61184 | 2024-04-18 | 915.48 | 11855.50 | 1430.44 | |||
SO49851_36 | 14FB-4B97-95 | PO2494142030 | 100 | 281 | 460 | 184 | 4 | 2023-07-23 | 431.95 | 10.80 | 2023-07-11 | 8 | 37.12 | 1 | 431.95 | 36 | SO49851 | 2023-07-18 | 34.56 | 296.97 | 53.99 | |||
SO48363_5 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 383 | 130 | 4 | 2023-03-24 | 600.26 | 15.01 | 2023-03-12 | 1 | 605.65 | 1 | 600.26 | 5 | SO48363 | 2023-03-19 | 48.02 | 605.65 | 600.26 | |||
SO48049_31 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 221 | 312 | 4 | 2023-02-22 | 40.37 | 1.01 | 2023-02-10 | 2 | 13.88 | 1 | 40.37 | 31 | SO48049 | 2023-02-17 | 3.23 | 27.76 | 20.19 | |||
SO65279_1 | 17C0-4DFE-B8 | PO4582197027 | 100 | 282 | 217 | 25 | 4 | 2024-06-22 | 83.98 | 2.10 | 2024-06-10 | 4 | 13.09 | 1 | 83.98 | 1 | SO65279 | 2024-06-17 | 6.72 | 52.35 | 20.99 | |||
SO71952_41 | 9490-4552-81 | PO9715163911 | 100 | 281 | 592 | 16 | 490 | 4 | 135.60 | 2024-09-22 | 338.99 | 5.08 | 2024-09-10 | 3 | 308.22 | 1 | 203.40 | 41 | SO71952 | 2024-09-17 | 16.27 | 924.65 | 113.00 | 0.40 |
SO49831_17 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 356 | 475 | 4 | 2023-07-23 | 3728.56 | 93.21 | 2023-07-11 | 3 | 1117.86 | 1 | 3728.56 | 17 | SO49831 | 2023-07-18 | 298.28 | 3353.57 | 1242.85 | |||
SO46970_10 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 341 | 258 | 4 | 2022-11-22 | 469.79 | 11.74 | 2022-11-10 | 1 | 486.71 | 1 | 469.79 | 10 | SO46970 | 2022-11-17 | 37.58 | 486.71 | 469.79 | |||
SO48027_2 | C18E-4513-83 | PO609157091 | 100 | 282 | 469 | 492 | 4 | 2023-02-22 | 91.18 | 2.28 | 2023-02-10 | 4 | 15.67 | 1 | 91.18 | 2 | SO48027 | 2023-02-17 | 7.29 | 62.68 | 22.79 | |||
SO53460_23 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 384 | 24 | 4 | 2023-12-23 | 6050.65 | 151.27 | 2023-12-11 | 9 | 713.08 | 1 | 6050.65 | 23 | SO53460 | 2023-12-18 | 484.05 | 6417.72 | 672.29 | |||
SO57145_42 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 551 | 435 | 4 | 2024-02-22 | 316.86 | 7.92 | 2024-02-10 | 2 | 144.59 | 1 | 316.86 | 42 | SO57145 | 2024-02-17 | 25.35 | 289.19 | 158.43 | |||
SO49831_16 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 224 | 475 | 4 | 2023-07-23 | 41.49 | 1.04 | 2023-07-11 | 8 | 5.23 | 1 | 41.49 | 16 | SO49831 | 2023-07-18 | 3.32 | 41.84 | 5.19 | |||
SO48295_51 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 286 | 24 | 4 | 2023-03-24 | 551.81 | 13.80 | 2023-03-12 | 3 | 170.14 | 1 | 551.81 | 51 | SO48295 | 2023-03-19 | 44.15 | 510.43 | 183.94 | |||
SO65303_6 | 93EA-4158-A9 | PO5539133147 | 100 | 282 | 595 | 61 | 4 | 2024-06-22 | 677.99 | 16.95 | 2024-06-10 | 2 | 308.22 | 1 | 677.99 | 6 | SO65303 | 2024-06-17 | 54.24 | 616.44 | 338.99 | |||
SO53583_14 | 582E-4A53-9A | PO5597118655 | 100 | 281 | 525 | 75 | 4 | 2023-12-23 | 475.29 | 11.88 | 2023-12-11 | 3 | 144.59 | 1 | 475.29 | 14 | SO53583 | 2023-12-18 | 38.02 | 433.78 | 158.43 | |||
SO49890_45 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 327 | 3 | 221 | 4 | 366.05 | 2023-07-23 | 7320.96 | 173.87 | 2023-07-11 | 17 | 486.71 | 1 | 6954.91 | 45 | SO49890 | 2023-07-18 | 556.39 | 8274.01 | 430.64 | 0.05 |
SO46049_18 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 326 | 328 | 4 | 2022-08-22 | 838.92 | 20.97 | 2022-08-10 | 2 | 413.15 | 1 | 838.92 | 18 | SO46049 | 2022-08-17 | 67.11 | 826.29 | 419.46 | |||
SO51106_33 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 548 | 331 | 4 | 2023-10-22 | 97.19 | 2.43 | 2023-10-10 | 2 | 35.96 | 1 | 97.19 | 33 | SO51106 | 2023-10-17 | 7.78 | 71.92 | 48.59 | |||
SO57145_24 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 398 | 435 | 4 | 2024-02-22 | 26.72 | 0.67 | 2024-02-10 | 1 | 19.78 | 1 | 26.72 | 24 | SO57145 | 2024-02-17 | 2.14 | 19.78 | 26.72 | |||
SO63252_14 | 4233-41A9-B7 | PO6438150148 | 100 | 281 | 472 | 309 | 4 | 2024-05-24 | 38.10 | 0.95 | 2024-05-12 | 1 | 23.75 | 1 | 38.10 | 14 | SO63252 | 2024-05-19 | 3.05 | 23.75 | 38.10 | |||
SO47028_31 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 448 | 312 | 4 | 2022-11-22 | 47.98 | 1.20 | 2022-11-10 | 4 | 8.25 | 1 | 47.98 | 31 | SO47028 | 2022-11-17 | 3.84 | 32.98 | 11.99 | |||
SO51808_1 | 92BB-45C4-89 | PO7540152834 | 100 | 281 | 579 | 607 | 4 | 2023-11-22 | 728.91 | 18.22 | 2023-11-10 | 1 | 755.15 | 1 | 728.91 | 1 | SO51808 | 2023-11-17 | 58.31 | 755.15 | 728.91 | |||
SO47039_14 | B548-493E-AE | PO5684166879 | 100 | 282 | 428 | 385 | 4 | 2022-11-22 | 1255.54 | 31.39 | 2022-11-10 | 6 | 185.82 | 1 | 1255.54 | 14 | SO47039 | 2022-11-17 | 100.44 | 1114.92 | 209.26 | |||
SO50294_35 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 409 | 312 | 4 | 2023-08-22 | 209.26 | 5.23 | 2023-08-10 | 1 | 185.82 | 1 | 209.26 | 35 | SO50294 | 2023-08-17 | 16.74 | 185.82 | 209.26 | |||
SO53459_1 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 567 | 13 | 582 | 4 | 100.22 | 2023-12-23 | 668.12 | 14.20 | 2023-12-11 | 2 | 461.44 | 1 | 567.90 | 1 | SO53459 | 2023-12-18 | 45.43 | 922.89 | 334.06 | 0.15 |
SO45339_16 | 1F94-40D0-86 | PO7656113434 | 100 | 282 | 232 | 403 | 4 | 2022-05-25 | 57.68 | 1.44 | 2022-05-13 | 2 | 31.72 | 1 | 57.68 | 16 | SO45339 | 2022-05-20 | 4.61 | 63.45 | 28.84 | |||
SO45533_2 | 120C-4720-9A | PO15718114961 | 100 | 283 | 326 | 580 | 4 | 2022-06-22 | 419.46 | 10.49 | 2022-06-10 | 1 | 413.15 | 1 | 419.46 | 2 | SO45533 | 2022-06-17 | 33.56 | 413.15 | 419.46 | |||
SO43897_4 | 128F-4FD9-A4 | PO3799116239 | 100 | 282 | 350 | 312 | 4 | 2021-11-22 | 8099.98 | 202.50 | 2021-11-10 | 4 | 1898.09 | 1 | 8099.98 | 4 | SO43897 | 2021-11-17 | 648.00 | 7592.38 | 2024.99 | |||
SO44124_21 | 2927-45C2-BE | PO6786110112 | 100 | 283 | 223 | 3 | 4 | 2021-12-23 | 20.75 | 0.52 | 2021-12-11 | 4 | 5.71 | 1 | 20.75 | 21 | SO44124 | 2021-12-18 | 1.66 | 22.82 | 5.19 | |||
SO47687_27 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 379 | 203 | 4 | 2023-01-22 | 2617.88 | 65.45 | 2023-01-10 | 2 | 1320.68 | 1 | 2617.88 | 27 | SO47687 | 2023-01-17 | 209.43 | 2641.37 | 1308.94 | |||
SO71848_9 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 579 | 59 | 4 | 2024-09-22 | 728.91 | 18.22 | 2024-09-10 | 1 | 755.15 | 1 | 728.91 | 9 | SO71848 | 2024-09-17 | 58.31 | 755.15 | 728.91 | |||
SO47355_23 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 462 | 24 | 4 | 2022-12-23 | 98.90 | 2.47 | 2022-12-11 | 7 | 9.71 | 1 | 98.90 | 23 | SO47355 | 2022-12-18 | 7.91 | 68.00 | 14.13 | |||
SO51131_13 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 553 | 599 | 4 | 2023-10-22 | 55.31 | 1.38 | 2023-10-10 | 2 | 20.46 | 1 | 55.31 | 13 | SO51131 | 2023-10-17 | 4.42 | 40.93 | 27.65 | |||
SO47435_29 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 421 | 75 | 4 | 2022-12-23 | 392.66 | 9.82 | 2022-12-11 | 2 | 145.28 | 1 | 392.66 | 29 | SO47435 | 2022-12-18 | 31.41 | 290.57 | 196.33 | |||
SO51121_14 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 388 | 491 | 4 | 2023-10-22 | 3361.47 | 84.04 | 2023-10-10 | 5 | 713.08 | 1 | 3361.47 | 14 | SO51121 | 2023-10-17 | 268.92 | 3565.40 | 672.29 | |||
SO67273_24 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 477 | 2 | 475 | 4 | 0.69 | 2024-07-23 | 34.73 | 0.85 | 2024-07-11 | 12 | 1.87 | 1 | 34.04 | 24 | SO67273 | 2024-07-18 | 2.72 | 22.40 | 2.89 | 0.02 |
SO45325_3 | 5C87-4ACC-B0 | PO4553175399 | 100 | 282 | 319 | 313 | 4 | 2022-05-25 | 1749.59 | 43.74 | 2022-05-13 | 2 | 884.71 | 1 | 1749.59 | 3 | SO45325 | 2022-05-20 | 139.97 | 1769.42 | 874.79 | |||
SO53606_35 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 598 | 61 | 4 | 2023-12-23 | 647.99 | 16.20 | 2023-12-11 | 2 | 294.58 | 1 | 647.99 | 35 | SO53606 | 2023-12-18 | 51.84 | 589.16 | 323.99 | |||
SO51126_20 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 566 | 13 | 205 | 4 | 250.54 | 2023-10-22 | 1670.29 | 35.49 | 2023-10-10 | 5 | 461.44 | 1 | 1419.74 | 20 | SO51126 | 2023-10-17 | 113.58 | 2307.22 | 334.06 | 0.15 |
SO48056_25 | 5868-43E3-AD | PO4843164827 | 100 | 287 | 417 | 257 | 4 | 2023-02-22 | 648.91 | 16.22 | 2023-02-10 | 2 | 300.12 | 1 | 648.91 | 25 | SO48056 | 2023-02-17 | 51.91 | 600.24 | 324.45 | |||
SO61264_13 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 374 | 166 | 4 | 2024-04-23 | 1466.01 | 36.65 | 2024-04-11 | 1 | 1554.95 | 1 | 1466.01 | 13 | SO61264 | 2024-04-18 | 117.28 | 1554.95 | 1466.01 | |||
SO46366_4 | 45E2-4301-82 | PO4002112610 | 100 | 282 | 326 | 674 | 4 | 2022-09-22 | 838.92 | 20.97 | 2022-09-10 | 2 | 413.15 | 1 | 838.92 | 4 | SO46366 | 2022-09-17 | 67.11 | 826.29 | 419.46 | |||
SO65315_22 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 524 | 21 | 4 | 2024-06-22 | 633.72 | 15.84 | 2024-06-10 | 4 | 144.59 | 1 | 633.72 | 22 | SO65315 | 2024-06-17 | 50.70 | 578.38 | 158.43 | |||
SO51159_3 | 4AAC-432F-8B | PO5394186744 | 100 | 281 | 589 | 94 | 4 | 2023-10-22 | 461.69 | 11.54 | 2023-10-10 | 1 | 419.78 | 1 | 461.69 | 3 | SO51159 | 2023-10-17 | 36.94 | 419.78 | 461.69 |
Generated 2024-11-10 02:20:48.993 UTC