[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 314 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46080_3 | B0FC-4A4A-91 | PO2958185372 | 100 | 286 | 232 | 559 | 1 | 2022-08-23 | 28.84 | 0.72 | 2022-08-11 | 1 | 31.72 | 1 | 28.84 | 3 | SO46080 | 2022-08-18 | 2.31 | 31.72 | 28.84 |
SO71833_20 | 8525-4645-AB | PO10411123072 | 100 | 289 | 579 | 182 | 1 | 2024-09-23 | 728.91 | 18.22 | 2024-09-11 | 1 | 755.15 | 1 | 728.91 | 20 | SO71833 | 2024-09-18 | 58.31 | 755.15 | 728.91 |
SO53547_1 | C80F-4007-AC | PO14065128727 | 100 | 293 | 240 | 379 | 1 | 2023-12-24 | 1717.80 | 42.95 | 2023-12-12 | 2 | 868.63 | 1 | 1717.80 | 1 | SO53547 | 2023-12-19 | 137.42 | 1737.27 | 858.90 |
SO53452_30 | B555-4FD7-8B | PO870113712 | 100 | 286 | 503 | 621 | 1 | 2023-12-24 | 800.21 | 20.01 | 2023-12-12 | 4 | 199.85 | 1 | 800.21 | 30 | SO53452 | 2023-12-19 | 64.02 | 799.41 | 200.05 |
SO59059_8 | FD9E-44C4-97 | PO7482187440 | 100 | 293 | 503 | 163 | 1 | 2024-03-24 | 200.05 | 5.00 | 2024-03-12 | 1 | 199.85 | 1 | 200.05 | 8 | SO59059 | 2024-03-19 | 16.00 | 199.85 | 200.05 |
SO67321_21 | 7F43-4E4F-8E | PO7076150186 | 100 | 293 | 562 | 505 | 1 | 2024-07-24 | 7152.21 | 178.81 | 2024-07-12 | 5 | 1481.94 | 1 | 7152.21 | 21 | SO67321 | 2024-07-19 | 572.18 | 7409.69 | 1430.44 |
SO57105_32 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 593 | 697 | 1 | 2024-02-23 | 1016.98 | 25.42 | 2024-02-11 | 3 | 308.22 | 1 | 1016.98 | 32 | SO57105 | 2024-02-18 | 81.36 | 924.65 | 338.99 |
SO48057_23 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 333 | 343 | 1 | 2023-02-23 | 1879.18 | 46.98 | 2023-02-11 | 4 | 486.71 | 1 | 1879.18 | 23 | SO48057 | 2023-02-18 | 150.33 | 1946.83 | 469.79 |
SO69408_36 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 517 | 236 | 1 | 2024-08-23 | 63.17 | 1.58 | 2024-08-11 | 2 | 23.37 | 1 | 63.17 | 36 | SO69408 | 2024-08-18 | 5.05 | 46.74 | 31.58 |
SO51711_53 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 298 | 236 | 1 | 2023-11-23 | 3239.04 | 80.98 | 2023-11-11 | 4 | 739.04 | 1 | 3239.04 | 53 | SO51711 | 2023-11-18 | 259.12 | 2956.16 | 809.76 |
SO46972_20 | 1A21-419F-8D | PO14500164221 | 100 | 282 | 420 | 650 | 1 | 2022-11-23 | 566.46 | 14.16 | 2022-11-11 | 4 | 104.80 | 1 | 566.46 | 20 | SO46972 | 2022-11-18 | 45.32 | 419.18 | 141.62 |
SO51123_44 | E412-45DF-AE | PO899150137 | 100 | 289 | 606 | 290 | 1 | 2023-10-23 | 1295.98 | 32.40 | 2023-10-11 | 4 | 343.65 | 1 | 1295.98 | 44 | SO51123 | 2023-10-18 | 103.68 | 1374.60 | 323.99 |
SO49053_41 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 364 | 236 | 1 | 2023-05-26 | 1295.99 | 32.40 | 2023-05-14 | 2 | 598.44 | 1 | 1295.99 | 41 | SO49053 | 2023-05-21 | 103.68 | 1196.87 | 647.99 |
SO49503_11 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 421 | 293 | 1 | 2023-06-23 | 392.66 | 9.82 | 2023-06-11 | 2 | 145.28 | 1 | 392.66 | 11 | SO49503 | 2023-06-18 | 31.41 | 290.57 | 196.33 |
SO44762_7 | 553E-437E-92 | PO13543176259 | 100 | 287 | 223 | 293 | 1 | 2022-03-25 | 41.49 | 1.04 | 2022-03-13 | 8 | 5.71 | 1 | 41.49 | 7 | SO44762 | 2022-03-20 | 3.32 | 45.64 | 5.19 |
SO53569_20 | 113E-43AD-94 | PO9309141312 | 100 | 293 | 576 | 55 | 1 | 2023-12-24 | 5721.77 | 143.04 | 2023-12-12 | 4 | 1481.94 | 1 | 5721.77 | 20 | SO53569 | 2023-12-19 | 457.74 | 5927.75 | 1430.44 |
SO58910_18 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 474 | 272 | 1 | 2024-03-24 | 167.98 | 4.20 | 2024-03-12 | 4 | 26.18 | 1 | 167.98 | 18 | SO58910 | 2024-03-19 | 13.44 | 104.71 | 41.99 |
SO63133_24 | C3D9-4B73-83 | PO18618146912 | 100 | 286 | 523 | 605 | 1 | 2024-05-25 | 31.58 | 0.79 | 2024-05-13 | 1 | 23.37 | 1 | 31.58 | 24 | SO63133 | 2024-05-20 | 2.53 | 23.37 | 31.58 |
SO53613_1 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 544 | 109 | 1 | 2023-12-24 | 145.78 | 3.64 | 2023-12-12 | 3 | 35.96 | 1 | 145.78 | 1 | SO53613 | 2023-12-19 | 11.66 | 107.88 | 48.59 |
SO47385_3 | 0FBF-482E-BB | PO14065116820 | 100 | 286 | 239 | 379 | 1 | 2022-12-24 | 780.82 | 19.52 | 2022-12-12 | 1 | 722.26 | 1 | 780.82 | 3 | SO47385 | 2022-12-19 | 62.47 | 722.26 | 780.82 |
SO67315_9 | 02BE-4BB0-BD | PO7105133864 | 100 | 293 | 225 | 668 | 1 | 2024-07-24 | 16.18 | 0.40 | 2024-07-12 | 3 | 6.92 | 1 | 16.18 | 9 | SO67315 | 2024-07-19 | 1.29 | 20.77 | 5.39 |
SO69475_40 | F74A-4967-BA | PO18618162557 | 100 | 286 | 523 | 605 | 1 | 2024-08-23 | 63.17 | 1.58 | 2024-08-11 | 2 | 23.37 | 1 | 63.17 | 40 | SO69475 | 2024-08-18 | 5.05 | 46.74 | 31.58 |
SO51838_4 | 8AB1-478C-86 | PO4727199391 | 100 | 293 | 372 | 343 | 1 | 2023-11-23 | 4398.03 | 109.95 | 2023-11-11 | 3 | 1554.95 | 1 | 4398.03 | 4 | SO51838 | 2023-11-18 | 351.84 | 4664.84 | 1466.01 |
SO69413_29 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 599 | 43 | 1 | 2024-08-23 | 323.99 | 8.10 | 2024-08-11 | 1 | 294.58 | 1 | 323.99 | 29 | SO69413 | 2024-08-18 | 25.92 | 294.58 | 323.99 |
SO47057_9 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 360 | 401 | 1 | 2022-11-23 | 2458.92 | 61.47 | 2022-11-11 | 2 | 1105.81 | 1 | 2458.92 | 9 | SO47057 | 2022-11-18 | 196.71 | 2211.62 | 1229.46 |
SO69525_22 | 9DCD-4F42-9E | PO4727119266 | 100 | 293 | 604 | 343 | 1 | 2024-08-23 | 323.99 | 8.10 | 2024-08-11 | 1 | 343.65 | 1 | 323.99 | 22 | SO69525 | 2024-08-18 | 25.92 | 343.65 | 323.99 |
SO58961_46 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 565 | 182 | 1 | 2024-03-24 | 445.41 | 11.14 | 2024-03-12 | 1 | 461.44 | 1 | 445.41 | 46 | SO58961 | 2024-03-19 | 35.63 | 461.44 | 445.41 |
SO67266_17 | 3CFE-46C9-88 | PO16588161069 | 100 | 289 | 544 | 146 | 1 | 2024-07-24 | 97.19 | 2.43 | 2024-07-12 | 2 | 35.96 | 1 | 97.19 | 17 | SO67266 | 2024-07-19 | 7.78 | 71.92 | 48.59 |
SO48387_6 | C0BE-45D3-9D | PO8294167884 | 100 | 289 | 297 | 488 | 1 | 2023-03-25 | 736.15 | 18.40 | 2023-03-13 | 1 | 653.70 | 1 | 736.15 | 6 | SO48387 | 2023-03-20 | 58.89 | 653.70 | 736.15 |
SO69508_33 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 583 | 433 | 1 | 2024-08-23 | 9185.35 | 229.63 | 2024-08-11 | 9 | 1082.51 | 1 | 9185.35 | 33 | SO69508 | 2024-08-18 | 734.83 | 9742.59 | 1020.59 |
SO51830_45 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 477 | 433 | 1 | 2023-11-23 | 11.98 | 0.30 | 2023-11-11 | 4 | 1.87 | 1 | 11.98 | 45 | SO51830 | 2023-11-18 | 0.96 | 7.47 | 2.99 |
Generated 2024-11-10 04:58:41.080 UTC