[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 656 > < TAKE 62 >
62 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43860_5 | E57D-4B4B-BF | PO16646146654 | 100 | 286 | 275 | 1 | 1 | 2021-10-02 | 356.90 | 8.92 | 2021-09-20 | 1 | 352.14 | 1 | 356.90 | 5 | SO43860 | 2021-09-27 | 28.55 | 352.14 | 356.90 |
SO44796_2 | 15BA-4644-82 | PO7946119769 | 100 | 282 | 315 | 438 | 1 | 2022-02-01 | 4373.97 | 109.35 | 2022-01-20 | 5 | 884.71 | 1 | 4373.97 | 2 | SO44796 | 2022-01-27 | 349.92 | 4423.54 | 874.79 |
SO47999_17 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 391 | 650 | 1 | 2023-01-02 | 177.86 | 4.45 | 2022-12-21 | 2 | 65.81 | 1 | 177.86 | 17 | SO47999 | 2022-12-28 | 14.23 | 131.62 | 88.93 |
SO69521_2 | EAFC-4D00-94 | PO6148143676 | 100 | 289 | 566 | 693 | 1 | 2024-07-02 | 445.41 | 11.14 | 2024-06-20 | 1 | 461.44 | 1 | 445.41 | 2 | SO69521 | 2024-06-27 | 35.63 | 461.44 | 445.41 |
SO59010_34 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 222 | 109 | 1 | 2024-02-01 | 62.98 | 1.57 | 2024-01-20 | 3 | 13.09 | 1 | 62.98 | 34 | SO59010 | 2024-01-27 | 5.04 | 39.26 | 20.99 |
SO67294_13 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 255 | 290 | 1 | 2024-06-02 | 607.00 | 15.17 | 2024-05-21 | 3 | 204.63 | 1 | 607.00 | 13 | SO67294 | 2024-05-28 | 48.56 | 613.88 | 202.33 |
SO47694_12 | 8253-4E13-9D | PO899122764 | 100 | 289 | 381 | 290 | 1 | 2022-12-02 | 3601.58 | 90.04 | 2022-11-20 | 6 | 605.65 | 1 | 3601.58 | 12 | SO47694 | 2022-11-27 | 288.13 | 3633.90 | 600.26 |
SO69525_3 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 388 | 343 | 1 | 2024-07-02 | 3361.47 | 84.04 | 2024-06-20 | 5 | 713.08 | 1 | 3361.47 | 3 | SO69525 | 2024-06-27 | 268.92 | 3565.40 | 672.29 |
SO59066_4 | 9FAA-410F-AB | PO9309141643 | 100 | 293 | 569 | 55 | 1 | 2024-02-01 | 445.41 | 11.14 | 2024-01-20 | 1 | 461.44 | 1 | 445.41 | 4 | SO59066 | 2024-01-27 | 35.63 | 461.44 | 445.41 |
SO61244_18 | 22F5-4A88-BE | PO6612122199 | 100 | 286 | 578 | 110 | 1 | 2024-03-03 | 1457.82 | 36.45 | 2024-02-20 | 2 | 755.15 | 1 | 1457.82 | 18 | SO61244 | 2024-02-27 | 116.63 | 1510.30 | 728.91 |
SO53452_32 | B555-4FD7-8B | PO870113712 | 100 | 286 | 496 | 621 | 1 | 2023-11-02 | 3011.73 | 75.29 | 2023-10-21 | 5 | 601.74 | 1 | 3011.73 | 32 | SO53452 | 2023-10-28 | 240.94 | 3008.72 | 602.35 |
SO47033_19 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 371 | 343 | 1 | 2022-10-02 | 6544.69 | 163.62 | 2022-09-20 | 5 | 1320.68 | 1 | 6544.69 | 19 | SO47033 | 2022-09-27 | 523.58 | 6603.42 | 1308.94 |
SO50217_10 | 6AE5-491F-B6 | PO14500116814 | 100 | 282 | 427 | 650 | 1 | 2023-07-02 | 627.77 | 15.69 | 2023-06-20 | 3 | 185.82 | 1 | 627.77 | 10 | SO50217 | 2023-06-27 | 50.22 | 557.46 | 209.26 |
SO49136_24 | 3492-4F41-97 | PO4727180151 | 100 | 293 | 224 | 343 | 1 | 2023-04-04 | 15.56 | 0.39 | 2023-03-23 | 3 | 5.23 | 1 | 15.56 | 24 | SO49136 | 2023-03-30 | 1.24 | 15.69 | 5.19 |
SO49112_1 | 6ADE-4BB3-8A | PO14529148314 | 100 | 293 | 360 | 289 | 1 | 2023-04-04 | 3688.38 | 92.21 | 2023-03-23 | 3 | 1105.81 | 1 | 3688.38 | 1 | SO49112 | 2023-03-30 | 295.07 | 3317.43 | 1229.46 |
SO58946_6 | F9DD-426F-9A | PO12470155874 | 100 | 287 | 496 | 672 | 1 | 2024-02-01 | 1204.69 | 30.12 | 2024-01-20 | 2 | 601.74 | 1 | 1204.69 | 6 | SO58946 | 2024-01-27 | 96.38 | 1203.49 | 602.35 |
SO45295_1 | 113A-4330-B0 | PO14529163242 | 100 | 286 | 348 | 289 | 1 | 2022-04-04 | 2024.99 | 50.62 | 2022-03-23 | 1 | 1898.09 | 1 | 2024.99 | 1 | SO45295 | 2022-03-30 | 162.00 | 1898.09 | 2024.99 |
SO48387_1 | C0BE-45D3-9D | PO8294167884 | 100 | 289 | 362 | 488 | 1 | 2023-02-01 | 1229.46 | 30.74 | 2023-01-20 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO48387 | 2023-01-27 | 98.36 | 1105.81 | 1229.46 |
SO47066_9 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 271 | 218 | 1 | 2022-10-02 | 202.33 | 5.06 | 2022-09-20 | 1 | 187.16 | 1 | 202.33 | 9 | SO47066 | 2022-09-27 | 16.19 | 187.16 | 202.33 |
SO49464_20 | C383-45FE-83 | PO841195010 | 100 | 286 | 396 | 254 | 1 | 2023-05-02 | 224.51 | 5.61 | 2023-04-20 | 3 | 55.38 | 1 | 224.51 | 20 | SO49464 | 2023-04-27 | 17.96 | 166.14 | 74.84 |
SO50218_20 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 459 | 127 | 1 | 2023-07-02 | 161.98 | 4.05 | 2023-06-20 | 3 | 37.12 | 1 | 161.98 | 20 | SO50218 | 2023-06-27 | 12.96 | 111.36 | 53.99 |
SO71785_23 | 28F9-4101-A1 | PO19169115427 | 100 | 289 | 544 | 272 | 1 | 2024-08-02 | 291.56 | 7.29 | 2024-07-21 | 6 | 35.96 | 1 | 291.56 | 23 | SO71785 | 2024-07-28 | 23.33 | 215.76 | 48.59 |
SO47694_22 | 8253-4E13-9D | PO899122764 | 100 | 289 | 368 | 290 | 1 | 2022-12-02 | 7330.05 | 183.25 | 2022-11-20 | 5 | 1518.79 | 1 | 7330.05 | 22 | SO47694 | 2022-11-27 | 586.40 | 7593.93 | 1466.01 |
SO53493_20 | F767-491F-84 | PO13543118174 | 100 | 287 | 532 | 293 | 1 | 2023-11-02 | 899.24 | 22.48 | 2023-10-21 | 6 | 136.79 | 1 | 899.24 | 20 | SO53493 | 2023-10-28 | 71.94 | 820.71 | 149.87 |
SO69525_16 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 605 | 343 | 1 | 2024-07-02 | 971.98 | 24.30 | 2024-06-20 | 3 | 343.65 | 1 | 971.98 | 16 | SO69525 | 2024-06-27 | 77.76 | 1030.95 | 323.99 |
SO48328_20 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 305 | 293 | 1 | 2023-02-01 | 736.15 | 18.40 | 2023-01-20 | 1 | 653.70 | 1 | 736.15 | 20 | SO48328 | 2023-01-27 | 58.89 | 653.70 | 736.15 |
SO53457_14 | B3F3-4A07-9B | PO19169151555 | 100 | 289 | 524 | 272 | 1 | 2023-11-02 | 633.72 | 15.84 | 2023-10-21 | 4 | 144.59 | 1 | 633.72 | 14 | SO53457 | 2023-10-28 | 50.70 | 578.38 | 158.43 |
SO49544_2 | 9647-4E6D-B8 | PO8294194867 | 100 | 289 | 421 | 488 | 1 | 2023-05-02 | 196.33 | 4.91 | 2023-04-20 | 1 | 145.28 | 1 | 196.33 | 2 | SO49544 | 2023-04-27 | 15.71 | 145.28 | 196.33 |
SO45068_1 | 6E46-440A-B5 | PO5075140071 | 100 | 289 | 332 | 344 | 1 | 2022-03-04 | 838.92 | 20.97 | 2022-02-20 | 2 | 413.15 | 1 | 838.92 | 1 | SO45068 | 2022-02-27 | 67.11 | 826.29 | 419.46 |
SO48058_1 | F8DA-47F1-8F | PO5046143527 | 100 | 289 | 394 | 596 | 1 | 2023-01-02 | 20.52 | 0.51 | 2022-12-21 | 1 | 15.18 | 1 | 20.52 | 1 | SO48058 | 2022-12-28 | 1.64 | 15.18 | 20.52 |
SO47667_1 | 5C8F-41D1-9C | PO15602134650 | 100 | 282 | 412 | 7 | 1 | 2022-12-02 | 180.13 | 4.50 | 2022-11-20 | 1 | 133.30 | 1 | 180.13 | 1 | SO47667 | 2022-11-27 | 14.41 | 133.30 | 180.13 |
SO49852_4 | 5DD7-447A-8D | PO2581189096 | 100 | 282 | 327 | 698 | 1 | 2023-06-02 | 1879.18 | 46.98 | 2023-05-21 | 4 | 486.71 | 1 | 1879.18 | 4 | SO49852 | 2023-05-28 | 150.33 | 1946.83 | 469.79 |
SO63148_24 | 00FA-42B1-88 | PO16675153915 | 100 | 293 | 471 | 361 | 1 | 2024-04-03 | 114.30 | 2.86 | 2024-03-22 | 3 | 23.75 | 1 | 114.30 | 24 | SO63148 | 2024-03-29 | 9.14 | 71.25 | 38.10 |
SO47368_9 | 7A90-4975-A2 | PO17487188099 | 100 | 286 | 329 | 692 | 1 | 2022-11-02 | 469.79 | 11.74 | 2022-10-21 | 1 | 486.71 | 1 | 469.79 | 9 | SO47368 | 2022-10-28 | 37.58 | 486.71 | 469.79 |
SO71904_8 | DBF0-4665-A7 | PO5017189568 | 100 | 289 | 562 | 308 | 1 | 2024-08-02 | 7152.21 | 178.81 | 2024-07-21 | 5 | 1481.94 | 1 | 7152.21 | 8 | SO71904 | 2024-07-28 | 572.18 | 7409.69 | 1430.44 |
SO43867_10 | 061F-4449-BE | PO14471123403 | 100 | 286 | 212 | 145 | 1 | 2021-10-02 | 20.19 | 0.50 | 2021-09-20 | 1 | 12.03 | 1 | 20.19 | 10 | SO43867 | 2021-09-27 | 1.61 | 12.03 | 20.19 |
SO57030_21 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 603 | 236 | 1 | 2024-01-02 | 218.68 | 5.47 | 2023-12-21 | 3 | 53.94 | 1 | 218.68 | 21 | SO57030 | 2023-12-28 | 17.49 | 161.82 | 72.89 |
SO65258_7 | 6CDC-4EA0-B2 | PO13543123789 | 100 | 287 | 527 | 293 | 1 | 2024-05-02 | 316.86 | 7.92 | 2024-04-20 | 2 | 144.59 | 1 | 316.86 | 7 | SO65258 | 2024-04-27 | 25.35 | 289.19 | 158.43 |
SO57136_23 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 545 | 433 | 1 | 2024-01-02 | 145.76 | 3.64 | 2023-12-21 | 6 | 17.98 | 1 | 145.76 | 23 | SO57136 | 2023-12-28 | 11.66 | 107.87 | 24.29 |
SO65258_13 | 6CDC-4EA0-B2 | PO13543123789 | 100 | 287 | 222 | 293 | 1 | 2024-05-02 | 20.99 | 0.52 | 2024-04-20 | 1 | 13.09 | 1 | 20.99 | 13 | SO65258 | 2024-04-27 | 1.68 | 13.09 | 20.99 |
SO43867_2 | 061F-4449-BE | PO14471123403 | 100 | 286 | 347 | 145 | 1 | 2021-10-02 | 2039.99 | 51.00 | 2021-09-20 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO43867 | 2021-09-27 | 163.20 | 1912.15 | 2039.99 |
SO46972_25 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 393 | 650 | 1 | 2022-10-02 | 550.78 | 13.77 | 2022-09-20 | 4 | 101.89 | 1 | 550.78 | 25 | SO46972 | 2022-09-27 | 44.06 | 407.57 | 137.69 |
SO45344_16 | 166F-4C74-85 | PO8816179390 | 100 | 289 | 328 | 218 | 1 | 2022-04-04 | 838.92 | 20.97 | 2022-03-23 | 2 | 413.15 | 1 | 838.92 | 16 | SO45344 | 2022-03-30 | 67.11 | 826.29 | 419.46 |
SO51721_35 | 9429-430D-89 | PO14500124798 | 100 | 282 | 513 | 650 | 1 | 2023-10-02 | 655.36 | 16.38 | 2023-09-20 | 3 | 199.38 | 1 | 655.36 | 35 | SO51721 | 2023-09-27 | 52.43 | 598.13 | 218.45 |
SO50693_10 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 395 | 254 | 1 | 2023-08-02 | 245.50 | 6.14 | 2023-07-21 | 4 | 45.42 | 1 | 245.50 | 10 | SO50693 | 2023-07-28 | 19.64 | 181.67 | 61.37 |
SO49548_6 | 0BD9-4A6D-8E | PO8903146134 | 100 | 293 | 343 | 235 | 1 | 2023-05-02 | 469.79 | 11.74 | 2023-04-20 | 1 | 486.71 | 1 | 469.79 | 6 | SO49548 | 2023-04-27 | 37.58 | 486.71 | 469.79 |
SO50693_20 | 0DA5-4EE4-93 | PO841149385 | 100 | 286 | 466 | 254 | 1 | 2023-08-02 | 98.90 | 2.47 | 2023-07-21 | 7 | 9.71 | 1 | 98.90 | 20 | SO50693 | 2023-07-28 | 7.91 | 68.00 | 14.13 |
SO48347_39 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 457 | 254 | 1 | 2023-02-01 | 89.99 | 2.25 | 2023-01-20 | 2 | 30.93 | 1 | 89.99 | 39 | SO48347 | 2023-01-27 | 7.20 | 61.87 | 44.99 |
SO50297_10 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 230 | 343 | 1 | 2023-07-02 | 86.52 | 2.16 | 2023-06-20 | 3 | 29.08 | 1 | 86.52 | 10 | SO50297 | 2023-06-27 | 6.92 | 87.24 | 28.84 |
SO57130_14 | 2182-4ADD-88 | PO6148161629 | 100 | 289 | 554 | 693 | 1 | 2024-01-02 | 109.88 | 2.75 | 2023-12-21 | 2 | 40.66 | 1 | 109.88 | 14 | SO57130 | 2023-12-28 | 8.79 | 81.31 | 54.94 |
SO50314_7 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 341 | 433 | 1 | 2023-07-02 | 939.59 | 23.49 | 2023-06-20 | 2 | 486.71 | 1 | 939.59 | 7 | SO50314 | 2023-06-27 | 75.17 | 973.41 | 469.79 |
SO49889_8 | 8783-45FC-96 | PO7105112550 | 100 | 293 | 329 | 668 | 1 | 2023-06-02 | 939.59 | 23.49 | 2023-05-21 | 2 | 486.71 | 1 | 939.59 | 8 | SO49889 | 2023-05-28 | 75.17 | 973.41 | 469.79 |
SO46025_1 | ADCD-4F7A-A7 | PO19981184028 | 100 | 286 | 232 | 271 | 1 | 2022-07-02 | 57.68 | 1.44 | 2022-06-20 | 2 | 31.72 | 1 | 57.68 | 1 | SO46025 | 2022-06-27 | 4.61 | 63.45 | 28.84 |
SO46967_38 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 396 | 487 | 1 | 2022-10-02 | 149.68 | 3.74 | 2022-09-20 | 2 | 55.38 | 1 | 149.68 | 38 | SO46967 | 2022-09-27 | 11.97 | 110.76 | 74.84 |
SO69406_29 | E101-486C-A5 | PO16675181672 | 100 | 293 | 477 | 361 | 1 | 2024-07-02 | 23.95 | 0.60 | 2024-06-20 | 8 | 1.87 | 1 | 23.95 | 29 | SO69406 | 2024-06-27 | 1.92 | 14.93 | 2.99 |
SO58963_19 | 6ADC-4485-8C | PO841129336 | 100 | 286 | 484 | 254 | 1 | 2024-02-01 | 38.16 | 0.95 | 2024-01-20 | 8 | 2.97 | 1 | 38.16 | 19 | SO58963 | 2024-01-27 | 3.05 | 23.79 | 4.77 |
SO44762_11 | 553E-437E-92 | PO13543176259 | 100 | 287 | 235 | 293 | 1 | 2022-02-01 | 57.68 | 1.44 | 2022-01-20 | 2 | 31.72 | 1 | 57.68 | 11 | SO44762 | 2022-01-27 | 4.61 | 63.45 | 28.84 |
SO47367_2 | 7C51-451A-B4 | PO17139175308 | 100 | 286 | 337 | 644 | 1 | 2022-11-02 | 469.79 | 11.74 | 2022-10-21 | 1 | 486.71 | 1 | 469.79 | 2 | SO47367 | 2022-10-28 | 37.58 | 486.71 | 469.79 |
SO71861_1 | 21C6-4FE7-96 | PO14152156429 | 100 | 293 | 376 | 37 | 1 | 2024-08-02 | 1466.01 | 36.65 | 2024-07-21 | 1 | 1554.95 | 1 | 1466.01 | 1 | SO71861 | 2024-07-28 | 117.28 | 1554.95 | 1466.01 |
SO48347_45 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 213 | 254 | 1 | 2023-02-01 | 100.93 | 2.52 | 2023-01-20 | 5 | 13.88 | 1 | 100.93 | 45 | SO48347 | 2023-01-27 | 8.07 | 69.39 | 20.19 |
SO69521_15 | EAFC-4D00-94 | PO6148143676 | 100 | 289 | 502 | 693 | 1 | 2024-07-02 | 600.16 | 15.00 | 2024-06-20 | 3 | 199.85 | 1 | 600.16 | 15 | SO69521 | 2024-06-27 | 48.01 | 599.56 | 200.05 |
SO69406_2 | E101-486C-A5 | PO16675181672 | 100 | 293 | 562 | 361 | 1 | 2024-07-02 | 2860.88 | 71.52 | 2024-06-20 | 2 | 1481.94 | 1 | 2860.88 | 2 | SO69406 | 2024-06-27 | 228.87 | 2963.88 | 1430.44 |
Generated 2024-09-20 02:37:02.902 UTC