[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 843 > < TAKE 60 >
60 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49893_4 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 448 | 523 | 3 | 2023-06-03 | 59.97 | 1.50 | 2023-05-22 | 5 | 8.25 | 1 | 59.97 | 4 | SO49893 | 2023-05-29 | 4.80 | 41.23 | 11.99 | |||
SO45536_6 | 260C-4755-B2 | PO15167166424 | 100 | 283 | 318 | 273 | 4 | 2022-05-03 | 1749.59 | 43.74 | 2022-04-21 | 2 | 884.71 | 1 | 1749.59 | 6 | SO45536 | 2022-04-28 | 139.97 | 1769.42 | 874.79 | |||
SO69397_11 | 1339-46CA-AC | PO18879152551 | 19 | 291 | 573 | 64 | 6 | 2024-07-03 | 2860.88 | 71.52 | 2024-06-21 | 2 | 1481.94 | 1 | 2860.88 | 11 | SO69397 | 2024-06-28 | 228.87 | 2963.88 | 1430.44 | |||
SO49828_39 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 417 | 514 | 6 | 2023-06-03 | 1622.26 | 40.56 | 2023-05-22 | 5 | 300.12 | 1 | 1622.26 | 39 | SO49828 | 2023-05-29 | 129.78 | 1500.59 | 324.45 | |||
SO47724_25 | FDA2-4CD7-92 | PO8787160870 | 100 | 282 | 458 | 2 | 523 | 3 | 9.57 | 2022-12-03 | 478.44 | 11.72 | 2022-11-21 | 11 | 30.93 | 1 | 468.87 | 25 | SO47724 | 2022-11-28 | 37.51 | 340.27 | 43.49 | 0.02 |
SO49464_26 | C383-45FE-83 | PO841195010 | 100 | 286 | 421 | 254 | 1 | 2023-05-03 | 196.33 | 4.91 | 2023-04-21 | 1 | 145.28 | 1 | 196.33 | 26 | SO49464 | 2023-04-28 | 15.71 | 145.28 | 196.33 | |||
SO47680_31 | FD44-4F17-A1 | PO13340181659 | 100 | 292 | 356 | 355 | 7 | 2022-12-03 | 1242.85 | 31.07 | 2022-11-21 | 1 | 1117.86 | 1 | 1242.85 | 31 | SO47680 | 2022-11-28 | 99.43 | 1117.86 | 1242.85 | |||
SO69415_4 | 3D39-4844-B5 | PO15080175978 | 100 | 292 | 576 | 283 | 7 | 2024-07-03 | 1430.44 | 35.76 | 2024-06-21 | 1 | 1481.94 | 1 | 1430.44 | 4 | SO69415 | 2024-06-28 | 114.44 | 1481.94 | 1430.44 | |||
SO48023_17 | 18BD-4FA3-9F | PO11020197101 | 19 | 284 | 339 | 336 | 6 | 2023-01-03 | 939.59 | 23.49 | 2022-12-22 | 2 | 486.71 | 1 | 939.59 | 17 | SO48023 | 2022-12-29 | 75.17 | 973.41 | 469.79 | |||
SO57128_20 | 52E0-4277-80 | PO6525176590 | 100 | 281 | 517 | 345 | 4 | 2024-01-03 | 63.17 | 1.58 | 2023-12-22 | 2 | 23.37 | 1 | 63.17 | 20 | SO57128 | 2023-12-29 | 5.05 | 46.74 | 31.58 | |||
SO63245_26 | 1025-4AD1-A1 | PO5800120355 | 100 | 285 | 400 | 63 | 5 | 2024-04-04 | 111.46 | 2.79 | 2024-03-23 | 3 | 27.49 | 1 | 111.46 | 26 | SO63245 | 2024-03-30 | 8.92 | 82.48 | 37.15 | |||
SO69408_11 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 527 | 236 | 1 | 2024-07-03 | 633.72 | 15.84 | 2024-06-21 | 4 | 144.59 | 1 | 633.72 | 11 | SO69408 | 2024-06-28 | 50.70 | 578.38 | 158.43 | |||
SO49100_11 | BD42-4470-A8 | PO17603154869 | 19 | 284 | 224 | 12 | 6 | 2023-04-05 | 36.31 | 0.91 | 2023-03-24 | 7 | 5.23 | 1 | 36.31 | 11 | SO49100 | 2023-03-31 | 2.90 | 36.61 | 5.19 | |||
SO61199_4 | EFA0-4D12-A2 | PO2552199779 | 100 | 286 | 359 | 506 | 1 | 2024-03-04 | 5507.98 | 137.70 | 2024-02-21 | 4 | 1251.98 | 1 | 5507.98 | 4 | SO61199 | 2024-02-28 | 440.64 | 5007.93 | 1376.99 | |||
SO50294_10 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 469 | 3 | 312 | 4 | 18.81 | 2023-07-03 | 376.10 | 8.93 | 2023-06-21 | 18 | 15.67 | 1 | 357.30 | 10 | SO50294 | 2023-06-28 | 28.58 | 282.08 | 20.89 | 0.05 |
SO45532_7 | 1342-4F90-B0 | PO15834119448 | 100 | 283 | 315 | 417 | 4 | 2022-05-03 | 1749.59 | 43.74 | 2022-04-21 | 2 | 884.71 | 1 | 1749.59 | 7 | SO45532 | 2022-04-28 | 139.97 | 1769.42 | 874.79 | |||
SO51853_21 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 516 | 476 | 5 | 2023-10-03 | 23.48 | 0.59 | 2023-09-21 | 1 | 17.38 | 1 | 23.48 | 21 | SO51853 | 2023-09-28 | 1.88 | 17.38 | 23.48 | |||
SO47670_41 | 0CD2-463E-8F | PO14732184884 | 19 | 291 | 329 | 514 | 6 | 2022-12-03 | 1409.38 | 35.23 | 2022-11-21 | 3 | 486.71 | 1 | 1409.38 | 41 | SO47670 | 2022-11-28 | 112.75 | 1460.12 | 469.79 | |||
SO44795_19 | 629B-45A2-8B | PO7569171528 | 100 | 287 | 292 | 608 | 4 | 2022-02-02 | 2456.10 | 61.40 | 2022-01-21 | 3 | 706.81 | 1 | 2456.10 | 19 | SO44795 | 2022-01-28 | 196.49 | 2120.43 | 818.70 | |||
SO49473_19 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 213 | 90 | 5 | 2023-05-03 | 60.56 | 1.51 | 2023-04-21 | 3 | 13.88 | 1 | 60.56 | 19 | SO49473 | 2023-04-28 | 4.84 | 41.63 | 20.19 | |||
SO53505_18 | B522-40FD-B5 | PO11397144048 | 36 | 295 | 237 | 176 | 8 | 2023-11-03 | 209.96 | 5.25 | 2023-10-22 | 7 | 38.49 | 1 | 209.96 | 18 | SO53505 | 2023-10-29 | 16.80 | 269.45 | 29.99 | |||
SO53551_15 | 8593-405C-AB | PO14297167079 | 100 | 285 | 572 | 13 | 627 | 5 | 150.33 | 2023-11-03 | 1002.17 | 21.30 | 2023-10-22 | 3 | 461.44 | 1 | 851.85 | 15 | SO53551 | 2023-10-29 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO47378_16 | E766-4274-A7 | PO15341116216 | 100 | 283 | 459 | 327 | 3 | 2022-11-03 | 161.98 | 4.05 | 2022-10-22 | 3 | 37.12 | 1 | 161.98 | 16 | SO47378 | 2022-10-29 | 12.96 | 111.36 | 53.99 | |||
SO51789_15 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 472 | 2 | 605 | 1 | 8.84 | 2023-10-03 | 441.96 | 10.83 | 2023-09-21 | 12 | 23.75 | 1 | 433.12 | 15 | SO51789 | 2023-09-28 | 34.65 | 284.99 | 36.83 | 0.02 |
SO44566_13 | 482A-4537-98 | PO7830134580 | 100 | 283 | 212 | 40 | 4 | 2022-01-03 | 40.37 | 1.01 | 2021-12-22 | 2 | 12.03 | 1 | 40.37 | 13 | SO44566 | 2021-12-29 | 3.23 | 24.06 | 20.19 | |||
SO43871_4 | 01F1-4AD5-A5 | PO13572145817 | 100 | 287 | 212 | 527 | 3 | 2021-10-03 | 40.37 | 1.01 | 2021-09-21 | 2 | 12.03 | 1 | 40.37 | 4 | SO43871 | 2021-09-28 | 3.23 | 24.06 | 20.19 | |||
SO46639_12 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 329 | 480 | 6 | 2022-09-02 | 1409.38 | 35.23 | 2022-08-21 | 3 | 486.71 | 1 | 1409.38 | 12 | SO46639 | 2022-08-28 | 112.75 | 1460.12 | 469.79 | |||
SO44301_7 | 34BE-4E85-85 | PO10730158868 | 100 | 287 | 320 | 491 | 4 | 2021-12-03 | 419.46 | 10.49 | 2021-11-21 | 1 | 413.15 | 1 | 419.46 | 7 | SO44301 | 2021-11-28 | 33.56 | 413.15 | 419.46 | |||
SO46055_27 | DDC5-498B-87 | PO13572168536 | 100 | 287 | 232 | 527 | 3 | 2022-07-03 | 28.84 | 0.72 | 2022-06-21 | 1 | 31.72 | 1 | 28.84 | 27 | SO46055 | 2022-06-28 | 2.31 | 31.72 | 28.84 | |||
SO65280_1 | FE9D-45E4-AE | PO4814116369 | 36 | 295 | 560 | 464 | 8 | 2024-05-03 | 1457.82 | 36.45 | 2024-04-21 | 2 | 755.15 | 1 | 1457.82 | 1 | SO65280 | 2024-04-28 | 116.63 | 1510.30 | 728.91 | |||
SO71847_6 | 3A74-467E-8B | PO18502143784 | 19 | 291 | 579 | 154 | 6 | 2024-08-03 | 2915.64 | 72.89 | 2024-07-22 | 4 | 755.15 | 1 | 2915.64 | 6 | SO71847 | 2024-07-29 | 233.25 | 3020.60 | 728.91 | |||
SO61243_22 | 0370-4B1B-9D | PO7859152962 | 100 | 287 | 488 | 221 | 4 | 2024-03-04 | 194.36 | 4.86 | 2024-02-21 | 6 | 41.57 | 1 | 194.36 | 22 | SO61243 | 2024-02-28 | 15.55 | 249.43 | 32.39 | |||
SO46647_26 | FA5F-4878-9F | PO2552157860 | 100 | 286 | 224 | 506 | 1 | 2022-09-02 | 31.12 | 0.78 | 2022-08-21 | 6 | 5.23 | 1 | 31.12 | 26 | SO46647 | 2022-08-28 | 2.49 | 31.38 | 5.19 | |||
SO47687_28 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 325 | 203 | 4 | 2022-12-03 | 1409.38 | 35.23 | 2022-11-21 | 3 | 486.71 | 1 | 1409.38 | 28 | SO47687 | 2022-11-28 | 112.75 | 1460.12 | 469.79 | |||
SO49540_8 | FD60-4F29-B7 | PO6757123714 | 100 | 281 | 469 | 21 | 4 | 2023-05-03 | 22.79 | 0.57 | 2023-04-21 | 1 | 15.67 | 1 | 22.79 | 8 | SO49540 | 2023-04-28 | 1.82 | 15.67 | 22.79 | |||
SO50739_4 | 7F49-4009-8C | PO3886138724 | 100 | 281 | 456 | 165 | 4 | 2023-08-03 | 134.98 | 3.37 | 2023-07-22 | 3 | 30.93 | 1 | 134.98 | 4 | SO50739 | 2023-07-29 | 10.80 | 92.80 | 44.99 | |||
SO49894_20 | C75C-4AA6-B6 | PO10092140429 | 100 | 283 | 352 | 252 | 2 | 2023-06-03 | 4971.41 | 124.29 | 2023-05-22 | 4 | 1117.86 | 1 | 4971.41 | 20 | SO49894 | 2023-05-29 | 397.71 | 4471.42 | 1242.85 | |||
SO49467_7 | 9917-4AE9-86 | PO1798127190 | 19 | 291 | 352 | 10 | 6 | 2023-05-03 | 3728.56 | 93.21 | 2023-04-21 | 3 | 1117.86 | 1 | 3728.56 | 7 | SO49467 | 2023-04-28 | 298.28 | 3353.57 | 1242.85 | |||
SO67276_44 | 9FD9-4B05-AA | PO13340158801 | 100 | 292 | 225 | 355 | 7 | 2024-06-03 | 10.79 | 0.27 | 2024-05-22 | 2 | 6.92 | 1 | 10.79 | 44 | SO67276 | 2024-05-29 | 0.86 | 13.84 | 5.39 | |||
SO45042_5 | 081C-4281-8E | PO16617111461 | 100 | 286 | 350 | 397 | 1 | 2022-03-05 | 10124.97 | 253.12 | 2022-02-21 | 5 | 1898.09 | 1 | 10124.97 | 5 | SO45042 | 2022-02-28 | 810.00 | 9490.47 | 2024.99 | |||
SO44529_1 | EF3C-4FE3-85 | PO10556131826 | 19 | 284 | 326 | 534 | 6 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO44529 | 2021-12-29 | 33.56 | 413.15 | 419.46 | |||
SO69528_10 | 2644-4747-86 | PO6438163496 | 100 | 272 | 477 | 309 | 4 | 2024-07-03 | 8.98 | 0.22 | 2024-06-21 | 3 | 1.87 | 1 | 8.98 | 10 | SO69528 | 2024-06-28 | 0.72 | 5.60 | 2.99 | |||
SO69466_26 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 225 | 167 | 4 | 2024-07-03 | 10.79 | 0.27 | 2024-06-21 | 2 | 6.92 | 1 | 10.79 | 26 | SO69466 | 2024-06-28 | 0.86 | 13.84 | 5.39 | |||
SO51826_6 | DBF7-4FCA-86 | PO6148188136 | 100 | 289 | 562 | 14 | 693 | 1 | 1144.35 | 2023-10-03 | 5721.77 | 114.44 | 2023-09-21 | 6 | 1481.94 | 1 | 4577.41 | 6 | SO51826 | 2023-09-28 | 366.19 | 8891.63 | 953.63 | 0.20 |
SO49865_29 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 369 | 81 | 5 | 2023-06-03 | 1466.01 | 36.65 | 2023-05-22 | 1 | 1518.79 | 1 | 1466.01 | 29 | SO49865 | 2023-05-29 | 117.28 | 1518.79 | 1466.01 | |||
SO61186_19 | C662-487E-B0 | PO14732152217 | 19 | 291 | 374 | 514 | 6 | 2024-03-04 | 4398.03 | 109.95 | 2024-02-21 | 3 | 1554.95 | 1 | 4398.03 | 19 | SO61186 | 2024-02-28 | 351.84 | 4664.84 | 1466.01 | |||
SO51822_13 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 597 | 546 | 3 | 2023-10-03 | 1943.96 | 48.60 | 2023-09-21 | 6 | 294.58 | 1 | 1943.96 | 13 | SO51822 | 2023-09-28 | 155.52 | 1767.48 | 323.99 | |||
SO61189_6 | 1A25-4A8C-8B | PO12412183085 | 100 | 281 | 606 | 670 | 3 | 2024-03-04 | 2267.96 | 56.70 | 2024-02-21 | 7 | 343.65 | 1 | 2267.96 | 6 | SO61189 | 2024-02-28 | 181.44 | 2405.55 | 323.99 | |||
SO44781_1 | 32AD-4737-BB | PO4002147144 | 100 | 282 | 223 | 674 | 4 | 2022-02-02 | 5.19 | 0.13 | 2022-01-21 | 1 | 5.71 | 1 | 5.19 | 1 | SO44781 | 2022-01-28 | 0.41 | 5.71 | 5.19 | |||
SO57065_30 | B68A-407E-99 | PO11658151711 | 100 | 283 | 400 | 233 | 2 | 2024-01-03 | 111.46 | 2.79 | 2023-12-22 | 3 | 27.49 | 1 | 111.46 | 30 | SO57065 | 2023-12-29 | 8.92 | 82.48 | 37.15 | |||
SO51140_26 | 0583-4C94-BA | PO6467148715 | 100 | 283 | 490 | 660 | 3 | 2023-09-02 | 291.55 | 7.29 | 2023-08-21 | 9 | 41.57 | 1 | 291.55 | 26 | SO51140 | 2023-08-28 | 23.32 | 374.15 | 32.39 | |||
SO69436_1 | 1BC6-4800-A2 | PO12731116523 | 36 | 292 | 483 | 247 | 7 | 2024-07-03 | 360.00 | 9.00 | 2024-06-21 | 5 | 44.88 | 1 | 360.00 | 1 | SO69436 | 2024-06-28 | 28.80 | 224.40 | 72.00 | |||
SO48751_21 | 1B86-4985-89 | PO13775132235 | 100 | 283 | 385 | 618 | 2 | 2023-03-05 | 600.26 | 15.01 | 2023-02-21 | 1 | 605.65 | 1 | 600.26 | 21 | SO48751 | 2023-02-28 | 48.02 | 605.65 | 600.26 | |||
SO43873_11 | 494C-48D2-BD | PO12499138177 | 100 | 282 | 322 | 78 | 4 | 2021-10-03 | 2097.29 | 52.43 | 2021-09-21 | 5 | 413.15 | 1 | 2097.29 | 11 | SO43873 | 2021-09-28 | 167.78 | 2065.73 | 419.46 | |||
SO44302_1 | 89AB-4ED2-AA | PO9947118701 | 100 | 285 | 313 | 603 | 5 | 2021-12-03 | 2146.96 | 53.67 | 2021-11-21 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO44302 | 2021-11-28 | 171.76 | 2171.29 | 2146.96 | |||
SO51168_33 | 10E0-426C-9D | PO3509110394 | 36 | 292 | 471 | 3 | 139 | 7 | 33.18 | 2023-09-02 | 663.58 | 15.76 | 2023-08-21 | 19 | 23.75 | 1 | 630.40 | 33 | SO51168 | 2023-08-28 | 50.43 | 451.23 | 34.93 | 0.05 |
SO61244_6 | 22F5-4A88-BE | PO6612122199 | 100 | 286 | 566 | 110 | 1 | 2024-03-04 | 2227.05 | 55.68 | 2024-02-21 | 5 | 461.44 | 1 | 2227.05 | 6 | SO61244 | 2024-02-28 | 178.16 | 2307.22 | 445.41 | |||
SO46629_12 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 383 | 670 | 3 | 2022-09-02 | 1200.53 | 30.01 | 2022-08-21 | 2 | 605.65 | 1 | 1200.53 | 12 | SO46629 | 2022-08-28 | 96.04 | 1211.30 | 600.26 | |||
SO47440_11 | 490D-4B3C-84 | PO7018185620 | 100 | 283 | 469 | 695 | 3 | 2022-11-03 | 91.18 | 2.28 | 2022-10-22 | 4 | 15.67 | 1 | 91.18 | 11 | SO47440 | 2022-10-29 | 7.29 | 62.68 | 22.79 | |||
SO47700_10 | 5C46-42DE-AD | PO2494132198 | 100 | 283 | 469 | 184 | 4 | 2022-12-03 | 91.18 | 2.28 | 2022-11-21 | 4 | 15.67 | 1 | 91.18 | 10 | SO47700 | 2022-11-28 | 7.29 | 62.68 | 22.79 |
Generated 2024-09-20 05:57:34.770 UTC