[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 436 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49086_4 | DC81-474D-82 | PO15196160156 | 100 | 282 | 337 | 258 | 4 | 2023-05-26 | 2348.97 | 58.72 | 2023-05-14 | 5 | 486.71 | 1 | 2348.97 | 4 | SO49086 | 2023-05-21 | 187.92 | 2433.53 | 469.79 | |||
SO71866_9 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 575 | 627 | 5 | 2024-09-23 | 2860.88 | 71.52 | 2024-09-11 | 2 | 1481.94 | 1 | 2860.88 | 9 | SO71866 | 2024-09-18 | 228.87 | 2963.88 | 1430.44 | |||
SO58907_7 | F365-4683-97 | PO19372175613 | 100 | 282 | 491 | 582 | 4 | 2024-03-24 | 129.58 | 3.24 | 2024-03-12 | 4 | 41.57 | 1 | 129.58 | 7 | SO58907 | 2024-03-19 | 10.37 | 166.29 | 32.39 | |||
SO69440_3 | E124-4B73-BF | PO11629191677 | 100 | 283 | 477 | 396 | 2 | 2024-08-23 | 5.99 | 0.15 | 2024-08-11 | 2 | 1.87 | 1 | 5.99 | 3 | SO69440 | 2024-08-18 | 0.48 | 3.73 | 2.99 | |||
SO47434_23 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 453 | 61 | 4 | 2022-12-24 | 179.97 | 4.50 | 2022-12-12 | 5 | 24.75 | 1 | 179.97 | 23 | SO47434 | 2022-12-19 | 14.40 | 123.73 | 35.99 | |||
SO46076_14 | E898-4203-B0 | PO2523131751 | 100 | 287 | 215 | 167 | 4 | 2022-08-23 | 60.56 | 1.51 | 2022-08-11 | 3 | 12.03 | 1 | 60.56 | 14 | SO46076 | 2022-08-18 | 4.84 | 36.08 | 20.19 | |||
SO49484_5 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 308 | 118 | 6 | 2023-06-23 | 1488.55 | 37.21 | 2023-06-11 | 2 | 660.91 | 1 | 1488.55 | 5 | SO49484 | 2023-06-18 | 119.08 | 1321.83 | 744.27 | |||
SO49101_9 | 0549-4175-A0 | PO15573181395 | 100 | 293 | 297 | 487 | 1 | 2023-05-26 | 736.15 | 18.40 | 2023-05-14 | 1 | 653.70 | 1 | 736.15 | 9 | SO49101 | 2023-05-21 | 58.89 | 653.70 | 736.15 | |||
SO67349_39 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 217 | 81 | 5 | 2024-07-24 | 41.99 | 1.05 | 2024-07-12 | 2 | 13.09 | 1 | 41.99 | 39 | SO67349 | 2024-07-19 | 3.36 | 26.17 | 20.99 | |||
SO55299_2 | 0B56-423B-B7 | PO6612171212 | 100 | 286 | 574 | 110 | 1 | 2024-01-23 | 4291.33 | 107.28 | 2024-01-11 | 3 | 1481.94 | 1 | 4291.33 | 2 | SO55299 | 2024-01-18 | 343.31 | 4445.81 | 1430.44 | |||
SO44494_20 | 8EF7-4B3A-A4 | PO18386158045 | 100 | 281 | 334 | 558 | 2 | 2022-02-23 | 1258.38 | 31.46 | 2022-02-11 | 3 | 413.15 | 1 | 1258.38 | 20 | SO44494 | 2022-02-18 | 100.67 | 1239.44 | 419.46 | |||
SO50737_3 | 1B3A-4961-B0 | PO4002125356 | 100 | 282 | 343 | 674 | 4 | 2023-09-23 | 469.79 | 11.74 | 2023-09-11 | 1 | 486.71 | 1 | 469.79 | 3 | SO50737 | 2023-09-18 | 37.58 | 486.71 | 469.79 | |||
SO44744_10 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 312 | 173 | 6 | 2022-03-25 | 4293.92 | 107.35 | 2022-03-13 | 2 | 2171.29 | 1 | 4293.92 | 10 | SO44744 | 2022-03-20 | 343.51 | 4342.59 | 2146.96 | |||
SO44131_10 | A7D8-4DAE-BC | PO9019194963 | 100 | 281 | 350 | 576 | 2 | 2021-12-24 | 2024.99 | 50.62 | 2021-12-12 | 1 | 1898.09 | 1 | 2024.99 | 10 | SO44131 | 2021-12-19 | 162.00 | 1898.09 | 2024.99 | |||
SO45043_7 | 5114-4658-8F | PO16588117521 | 100 | 289 | 232 | 146 | 1 | 2022-04-25 | 28.84 | 0.72 | 2022-04-13 | 1 | 31.72 | 1 | 28.84 | 7 | SO45043 | 2022-04-20 | 2.31 | 31.72 | 28.84 | |||
SO51760_16 | 2C2D-41C9-8C | PO9918180623 | 100 | 285 | 577 | 260 | 5 | 2023-11-23 | 2186.73 | 54.67 | 2023-11-11 | 3 | 755.15 | 1 | 2186.73 | 16 | SO51760 | 2023-11-18 | 174.94 | 2265.45 | 728.91 | |||
SO69466_9 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 487 | 167 | 4 | 2024-08-23 | 131.98 | 3.30 | 2024-08-11 | 4 | 20.57 | 1 | 131.98 | 9 | SO69466 | 2024-08-18 | 10.56 | 82.27 | 32.99 | |||
SO55283_15 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 475 | 442 | 6 | 2024-01-23 | 83.99 | 2.10 | 2024-01-11 | 2 | 26.18 | 1 | 83.99 | 15 | SO55283 | 2024-01-18 | 6.72 | 52.35 | 41.99 | |||
SO49052_18 | 8769-409E-94 | PO16733182723 | 19 | 291 | 337 | 533 | 6 | 2023-05-26 | 1409.38 | 35.23 | 2023-05-14 | 3 | 486.71 | 1 | 1409.38 | 18 | SO49052 | 2023-05-21 | 112.75 | 1460.12 | 469.79 | |||
SO47714_3 | 884B-4F33-A1 | PO6235113773 | 100 | 281 | 343 | 431 | 3 | 2023-01-23 | 469.79 | 11.74 | 2023-01-11 | 1 | 486.71 | 1 | 469.79 | 3 | SO47714 | 2023-01-18 | 37.58 | 486.71 | 469.79 | |||
SO51157_5 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 217 | 11 | 414 | 2 | 37.79 | 2023-10-23 | 251.93 | 5.35 | 2023-10-11 | 16 | 13.09 | 1 | 214.14 | 5 | SO51157 | 2023-10-18 | 17.13 | 209.38 | 15.75 | 0.15 |
SO48071_25 | E6F7-41F8-92 | PO6525193011 | 100 | 283 | 396 | 345 | 4 | 2023-02-23 | 74.84 | 1.87 | 2023-02-11 | 1 | 55.38 | 1 | 74.84 | 25 | SO48071 | 2023-02-18 | 5.99 | 55.38 | 74.84 | |||
SO51745_10 | C261-441D-A5 | PO11745132954 | 100 | 282 | 255 | 97 | 4 | 2023-11-23 | 607.00 | 15.17 | 2023-11-11 | 3 | 204.63 | 1 | 607.00 | 10 | SO51745 | 2023-11-18 | 48.56 | 613.88 | 202.33 | |||
SO67322_11 | 1881-4634-82 | PO6612121393 | 100 | 286 | 552 | 110 | 1 | 2024-07-24 | 219.58 | 5.49 | 2024-07-12 | 4 | 40.62 | 1 | 219.58 | 11 | SO67322 | 2024-07-19 | 17.57 | 162.49 | 54.89 | |||
SO53582_14 | 9E24-4A2C-8A | PO4785164058 | 100 | 282 | 471 | 223 | 3 | 2023-12-24 | 228.60 | 5.72 | 2023-12-12 | 6 | 23.75 | 1 | 228.60 | 14 | SO53582 | 2023-12-19 | 18.29 | 142.49 | 38.10 | |||
SO65157_15 | 51FF-4A62-89 | PO19372154832 | 100 | 282 | 570 | 582 | 4 | 2024-06-23 | 445.41 | 11.14 | 2024-06-11 | 1 | 461.44 | 1 | 445.41 | 15 | SO65157 | 2024-06-18 | 35.63 | 461.44 | 445.41 | |||
SO67324_13 | E926-43C1-A2 | PO5452147202 | 36 | 295 | 483 | 320 | 8 | 2024-07-24 | 576.00 | 14.40 | 2024-07-12 | 8 | 44.88 | 1 | 576.00 | 13 | SO67324 | 2024-07-19 | 46.08 | 359.04 | 72.00 | |||
SO51823_12 | 2FB1-4AE1-BC | PO8642173409 | 98 | 288 | 504 | 520 | 10 | 2023-11-23 | 200.05 | 5.00 | 2023-11-11 | 1 | 199.85 | 1 | 200.05 | 12 | SO51823 | 2023-11-18 | 16.00 | 199.85 | 200.05 | |||
SO50663_30 | 286E-4915-89 | PO19343130555 | 100 | 282 | 447 | 2 | 24 | 4 | 3.48 | 2023-09-23 | 174.00 | 4.26 | 2023-09-11 | 12 | 10.31 | 1 | 170.52 | 30 | SO50663 | 2023-09-18 | 13.64 | 123.75 | 14.50 | 0.02 |
SO46668_41 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 448 | 221 | 4 | 2022-10-23 | 47.98 | 1.20 | 2022-10-11 | 4 | 8.25 | 1 | 47.98 | 41 | SO46668 | 2022-10-18 | 3.84 | 32.98 | 11.99 | |||
SO55277_19 | E9AB-453F-BA | PO2552111630 | 100 | 286 | 309 | 506 | 1 | 2024-01-23 | 2456.10 | 61.40 | 2024-01-11 | 3 | 747.20 | 1 | 2456.10 | 19 | SO55277 | 2024-01-18 | 196.49 | 2241.60 | 818.70 | |||
SO49844_10 | 84A1-4FF2-A9 | PO899181442 | 100 | 289 | 435 | 290 | 1 | 2023-07-24 | 1946.72 | 48.67 | 2023-07-12 | 6 | 300.12 | 1 | 1946.72 | 10 | SO49844 | 2023-07-19 | 155.74 | 1800.71 | 324.45 | |||
SO57016_10 | 5FA2-418F-AF | PO19227187256 | 19 | 284 | 390 | 210 | 6 | 2024-02-23 | 672.29 | 16.81 | 2024-02-11 | 1 | 713.08 | 1 | 672.29 | 10 | SO57016 | 2024-02-18 | 53.78 | 713.08 | 672.29 | |||
SO47028_7 | 8DA0-456D-8F | PO3799132728 | 100 | 282 | 367 | 312 | 4 | 2022-11-23 | 1943.98 | 48.60 | 2022-11-11 | 3 | 598.44 | 1 | 1943.98 | 7 | SO47028 | 2022-11-18 | 155.52 | 1795.31 | 647.99 | |||
SO50244_35 | 8887-4F96-A3 | PO1508168261 | 98 | 290 | 373 | 430 | 10 | 2023-08-23 | 5235.75 | 130.89 | 2023-08-11 | 4 | 1320.68 | 1 | 5235.75 | 35 | SO50244 | 2023-08-18 | 418.86 | 5282.74 | 1308.94 | |||
SO50295_1 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 365 | 352 | 6 | 2023-08-23 | 1943.98 | 48.60 | 2023-08-11 | 3 | 598.44 | 1 | 1943.98 | 1 | SO50295 | 2023-08-18 | 155.52 | 1795.31 | 647.99 | |||
SO47986_9 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 464 | 236 | 1 | 2023-02-23 | 28.26 | 0.71 | 2023-02-11 | 2 | 9.71 | 1 | 28.26 | 9 | SO47986 | 2023-02-18 | 2.26 | 19.43 | 14.13 | |||
SO57145_28 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 306 | 435 | 4 | 2024-02-23 | 2429.28 | 60.73 | 2024-02-11 | 3 | 739.04 | 1 | 2429.28 | 28 | SO57145 | 2024-02-18 | 194.34 | 2217.12 | 809.76 | |||
SO49831_6 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 362 | 475 | 4 | 2023-07-24 | 4917.84 | 122.95 | 2023-07-12 | 4 | 1105.81 | 1 | 4917.84 | 6 | SO49831 | 2023-07-19 | 393.43 | 4423.24 | 1229.46 | |||
SO61204_10 | E810-4164-82 | PO15312134209 | 19 | 291 | 463 | 299 | 6 | 2024-04-24 | 58.78 | 1.47 | 2024-04-12 | 4 | 9.16 | 1 | 58.78 | 10 | SO61204 | 2024-04-19 | 4.70 | 36.64 | 14.69 | |||
SO51771_36 | F78B-4D68-8E | PO1508157846 | 98 | 288 | 418 | 430 | 10 | 2023-11-23 | 356.90 | 8.92 | 2023-11-11 | 1 | 360.94 | 1 | 356.90 | 36 | SO51771 | 2023-11-18 | 28.55 | 360.94 | 356.90 | |||
SO65156_6 | 3295-4FC6-BC | PO19401176373 | 19 | 291 | 545 | 173 | 6 | 2024-06-23 | 48.59 | 1.21 | 2024-06-11 | 2 | 17.98 | 1 | 48.59 | 6 | SO65156 | 2024-06-18 | 3.89 | 35.96 | 24.29 | |||
SO57024_5 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 465 | 264 | 6 | 2024-02-23 | 73.47 | 1.84 | 2024-02-11 | 5 | 9.16 | 1 | 73.47 | 5 | SO57024 | 2024-02-18 | 5.88 | 45.80 | 14.69 | |||
SO47033_26 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 407 | 343 | 1 | 2022-11-23 | 328.01 | 8.20 | 2022-11-11 | 5 | 48.55 | 1 | 328.01 | 26 | SO47033 | 2022-11-18 | 26.24 | 242.73 | 65.60 | |||
SO48771_10 | E98F-4302-92 | PO8410125811 | 98 | 288 | 381 | 538 | 10 | 2023-04-25 | 3001.31 | 75.03 | 2023-04-13 | 5 | 605.65 | 1 | 3001.31 | 10 | SO48771 | 2023-04-20 | 240.11 | 3028.25 | 600.26 | |||
SO57041_11 | 214B-45FE-BA | PO15283137428 | 100 | 281 | 570 | 363 | 3 | 2024-02-23 | 890.82 | 22.27 | 2024-02-11 | 2 | 461.44 | 1 | 890.82 | 11 | SO57041 | 2024-02-18 | 71.27 | 922.89 | 445.41 | |||
SO47988_32 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 456 | 533 | 6 | 2023-02-23 | 314.96 | 7.87 | 2023-02-11 | 7 | 30.93 | 1 | 314.96 | 32 | SO47988 | 2023-02-18 | 25.20 | 216.53 | 44.99 | |||
SO46343_3 | 2DB3-460D-85 | PO15167181233 | 100 | 283 | 232 | 273 | 4 | 2022-09-23 | 86.52 | 2.16 | 2022-09-11 | 3 | 31.72 | 1 | 86.52 | 3 | SO46343 | 2022-09-18 | 6.92 | 95.17 | 28.84 | |||
SO48034_4 | 995F-4D9D-A9 | PO1769135453 | 100 | 281 | 422 | 540 | 2 | 2023-02-23 | 405.23 | 10.13 | 2023-02-11 | 6 | 49.98 | 1 | 405.23 | 4 | SO48034 | 2023-02-18 | 32.42 | 299.87 | 67.54 | |||
SO47395_36 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 424 | 72 | 2 | 2022-12-24 | 428.47 | 10.71 | 2022-12-12 | 2 | 158.53 | 1 | 428.47 | 36 | SO47395 | 2022-12-19 | 34.28 | 317.07 | 214.24 | |||
SO48287_1 | 7A9E-45FF-8B | PO493197818 | 19 | 291 | 415 | 654 | 6 | 2023-03-25 | 198.04 | 4.95 | 2023-03-13 | 1 | 146.55 | 1 | 198.04 | 1 | SO48287 | 2023-03-20 | 15.84 | 146.55 | 198.04 | |||
SO49499_11 | E899-4E47-A2 | PO15341196181 | 100 | 281 | 362 | 327 | 3 | 2023-06-23 | 3688.38 | 92.21 | 2023-06-11 | 3 | 1105.81 | 1 | 3688.38 | 11 | SO49499 | 2023-06-18 | 295.07 | 3317.43 | 1229.46 | |||
SO48389_24 | 304D-46A7-8E | PO8671159284 | 98 | 288 | 421 | 502 | 10 | 2023-03-25 | 1177.97 | 29.45 | 2023-03-13 | 6 | 145.28 | 1 | 1177.97 | 24 | SO48389 | 2023-03-20 | 94.24 | 871.70 | 196.33 | |||
SO46662_53 | 07F7-472E-AC | PO6467187386 | 100 | 281 | 213 | 8 | 660 | 3 | 16.82 | 2022-10-23 | 168.22 | 3.79 | 2022-10-11 | 10 | 13.88 | 1 | 151.40 | 53 | SO46662 | 2022-10-18 | 12.11 | 138.78 | 16.82 | 0.10 |
SO46368_19 | BF32-47A9-90 | PO4408111909 | 100 | 281 | 336 | 143 | 2 | 2022-09-23 | 838.92 | 20.97 | 2022-09-11 | 2 | 413.15 | 1 | 838.92 | 19 | SO46368 | 2022-09-18 | 67.11 | 826.29 | 419.46 | |||
SO44749_32 | 6F66-42B6-AB | PO17545111622 | 19 | 288 | 232 | 155 | 6 | 2022-03-25 | 86.52 | 2.16 | 2022-03-13 | 3 | 31.72 | 1 | 86.52 | 32 | SO44749 | 2022-03-20 | 6.92 | 95.17 | 28.84 | |||
SO69491_3 | 4EBF-438F-8A | PO12064111829 | 6 | 296 | 564 | 159 | 9 | 2024-08-23 | 2860.88 | 71.52 | 2024-08-11 | 2 | 1481.94 | 1 | 2860.88 | 3 | SO69491 | 2024-08-18 | 228.87 | 2963.88 | 1430.44 | |||
SO51853_16 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 309 | 476 | 5 | 2023-11-23 | 818.70 | 20.47 | 2023-11-11 | 1 | 747.20 | 1 | 818.70 | 16 | SO51853 | 2023-11-18 | 65.50 | 747.20 | 818.70 | |||
SO51150_11 | 5831-4C4F-B1 | PO8004129956 | 6 | 296 | 561 | 14 | 231 | 9 | 762.90 | 2023-10-23 | 3814.51 | 76.29 | 2023-10-11 | 4 | 1481.94 | 1 | 3051.61 | 11 | SO51150 | 2023-10-18 | 244.13 | 5927.75 | 953.63 | 0.20 |
SO53615_24 | FBF4-4FC7-A6 | PO4814189523 | 36 | 295 | 503 | 464 | 8 | 2023-12-24 | 600.16 | 15.00 | 2023-12-12 | 3 | 199.85 | 1 | 600.16 | 24 | SO53615 | 2023-12-19 | 48.01 | 599.56 | 200.05 | |||
SO50665_1 | F21E-4880-9E | PO18589183989 | 100 | 292 | 414 | 67 | 7 | 2023-09-23 | 149.03 | 3.73 | 2023-09-11 | 1 | 110.28 | 1 | 149.03 | 1 | SO50665 | 2023-09-18 | 11.92 | 110.28 | 149.03 | |||
SO48306_14 | EA27-471A-9D | PO17574166075 | 19 | 291 | 396 | 678 | 6 | 2023-03-25 | 149.68 | 3.74 | 2023-03-13 | 2 | 55.38 | 1 | 149.68 | 14 | SO48306 | 2023-03-20 | 11.97 | 110.76 | 74.84 |
Generated 2024-11-10 04:29:40.062 UTC