[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 2309 > < TAKE 31 >
31 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO65173_17 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 546 | 155 | 6 | 2024-06-23 | 149.02 | 3.73 | 2024-06-11 | 4 | 27.57 | 1 | 149.02 | 17 | SO65173 | 2024-06-18 | 11.92 | 110.27 | 37.25 | |||
| SO45553_6 | 87C3-40D7-80 | PO1885177550 | 19 | 284 | 345 | 588 | 6 | 2022-06-23 | 16319.95 | 408.00 | 2022-06-11 | 8 | 1912.15 | 1 | 16319.95 | 6 | SO45553 | 2022-06-18 | 1305.60 | 15297.24 | 2039.99 | |||
| SO49484_22 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 447 | 118 | 6 | 2023-06-23 | 75.00 | 1.88 | 2023-06-11 | 5 | 10.31 | 1 | 75.00 | 22 | SO49484 | 2023-06-18 | 6.00 | 51.56 | 15.00 | |||
| SO50265_17 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 341 | 479 | 6 | 2023-08-23 | 2348.97 | 58.72 | 2023-08-11 | 5 | 486.71 | 1 | 2348.97 | 17 | SO50265 | 2023-08-18 | 187.92 | 2433.53 | 469.79 | |||
| SO47003_17 | 2C85-4918-94 | PO638185142 | 19 | 291 | 468 | 280 | 6 | 2022-11-23 | 45.59 | 1.14 | 2022-11-11 | 2 | 15.67 | 1 | 45.59 | 17 | SO47003 | 2022-11-18 | 3.65 | 31.34 | 22.79 | |||
| SO44504_8 | CFE2-4C08-B0 | PO16733198490 | 19 | 288 | 275 | 533 | 6 | 2022-02-23 | 356.90 | 8.92 | 2022-02-11 | 1 | 352.14 | 1 | 356.90 | 8 | SO44504 | 2022-02-18 | 28.55 | 352.14 | 356.90 | |||
| SO67272_17 | F467-41BF-8B | PO13862111340 | 19 | 291 | 359 | 119 | 6 | 2024-07-24 | 5507.98 | 137.70 | 2024-07-12 | 4 | 1251.98 | 1 | 5507.98 | 17 | SO67272 | 2024-07-19 | 440.64 | 5007.93 | 1376.99 | |||
| SO47031_4 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 365 | 352 | 6 | 2022-11-23 | 2591.98 | 64.80 | 2022-11-11 | 4 | 598.44 | 1 | 2591.98 | 4 | SO47031 | 2022-11-18 | 207.36 | 2393.74 | 647.99 | |||
| SO46953_9 | C650-4C32-BE | PO17603154442 | 19 | 284 | 327 | 9 | 12 | 6 | 1197.97 | 2022-11-23 | 3993.25 | 69.88 | 2022-11-11 | 17 | 486.71 | 1 | 2795.27 | 9 | SO46953 | 2022-11-18 | 223.62 | 8274.01 | 234.90 | 0.30 |
| SO65206_29 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 474 | 10 | 6 | 2024-06-23 | 167.98 | 4.20 | 2024-06-11 | 4 | 26.18 | 1 | 167.98 | 29 | SO65206 | 2024-06-18 | 13.44 | 104.71 | 41.99 | |||
| SO46959_44 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 254 | 533 | 6 | 2022-11-23 | 1287.57 | 32.19 | 2022-11-11 | 7 | 170.14 | 1 | 1287.57 | 44 | SO46959 | 2022-11-18 | 103.01 | 1191.00 | 183.94 | |||
| SO47031_27 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 364 | 352 | 6 | 2022-11-23 | 1295.99 | 32.40 | 2022-11-11 | 2 | 598.44 | 1 | 1295.99 | 27 | SO47031 | 2022-11-18 | 103.68 | 1196.87 | 647.99 | |||
| SO58958_27 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 487 | 281 | 6 | 2024-03-24 | 131.98 | 3.30 | 2024-03-12 | 4 | 20.57 | 1 | 131.98 | 27 | SO58958 | 2024-03-19 | 10.56 | 82.27 | 32.99 | |||
| SO45038_14 | 2001-401A-83 | PO18473129920 | 19 | 288 | 344 | 442 | 6 | 2022-04-25 | 4079.99 | 102.00 | 2022-04-13 | 2 | 1912.15 | 1 | 4079.99 | 14 | SO45038 | 2022-04-20 | 326.40 | 3824.31 | 2039.99 | |||
| SO50284_32 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 333 | 84 | 6 | 2023-08-23 | 939.59 | 23.49 | 2023-08-11 | 2 | 486.71 | 1 | 939.59 | 32 | SO50284 | 2023-08-18 | 75.17 | 973.41 | 469.79 | |||
| SO50284_10 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 325 | 84 | 6 | 2023-08-23 | 1409.38 | 35.23 | 2023-08-11 | 3 | 486.71 | 1 | 1409.38 | 10 | SO50284 | 2023-08-18 | 112.75 | 1460.12 | 469.79 | |||
| SO47366_52 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 445 | 155 | 6 | 2022-12-24 | 35.99 | 0.90 | 2022-12-12 | 1 | 24.75 | 1 | 35.99 | 52 | SO47366 | 2022-12-19 | 2.88 | 24.75 | 35.99 | |||
| SO44495_3 | 7929-4E62-AE | PO18270111190 | 19 | 288 | 351 | 11 | 6 | 2022-02-23 | 2024.99 | 50.62 | 2022-02-11 | 1 | 1898.09 | 1 | 2024.99 | 3 | SO44495 | 2022-02-18 | 162.00 | 1898.09 | 2024.99 | |||
| SO57120_1 | 058D-436F-BF | PO4466170177 | 19 | 291 | 225 | 352 | 6 | 2024-02-23 | 26.97 | 0.67 | 2024-02-11 | 5 | 6.92 | 1 | 26.97 | 1 | SO57120 | 2024-02-18 | 2.16 | 34.61 | 5.39 | |||
| SO44535_3 | 26EF-4A69-B0 | PO2088169831 | 19 | 288 | 342 | 136 | 6 | 2022-02-23 | 1258.38 | 31.46 | 2022-02-11 | 3 | 413.15 | 1 | 1258.38 | 3 | SO44535 | 2022-02-18 | 100.67 | 1239.44 | 419.46 | |||
| SO49467_8 | 9917-4AE9-86 | PO1798127190 | 19 | 291 | 421 | 10 | 6 | 2023-06-23 | 196.33 | 4.91 | 2023-06-11 | 1 | 145.28 | 1 | 196.33 | 8 | SO49467 | 2023-06-18 | 15.71 | 145.28 | 196.33 | |||
| SO69446_1 | E9F7-4369-85 | PO10498138449 | 19 | 291 | 475 | 316 | 6 | 2024-08-23 | 83.99 | 2.10 | 2024-08-11 | 2 | 26.18 | 1 | 83.99 | 1 | SO69446 | 2024-08-18 | 6.72 | 52.35 | 41.99 | |||
| SO47399_4 | B5FA-4CC2-8C | PO10962177551 | 19 | 284 | 364 | 685 | 6 | 2022-12-24 | 1943.98 | 48.60 | 2022-12-12 | 3 | 598.44 | 1 | 1943.98 | 4 | SO47399 | 2022-12-19 | 155.52 | 1795.31 | 647.99 | |||
| SO47380_22 | EF71-4036-91 | PO14790123967 | 19 | 291 | 410 | 497 | 6 | 2022-12-24 | 72.89 | 1.82 | 2022-12-12 | 2 | 26.97 | 1 | 72.89 | 22 | SO47380 | 2022-12-19 | 5.83 | 53.94 | 36.45 | |||
| SO51832_26 | 475C-432F-B2 | PO4466177904 | 19 | 291 | 298 | 352 | 6 | 2023-11-23 | 1619.52 | 40.49 | 2023-11-11 | 2 | 739.04 | 1 | 1619.52 | 26 | SO51832 | 2023-11-18 | 129.56 | 1478.08 | 809.76 | |||
| SO65238_28 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 488 | 281 | 6 | 2024-06-23 | 129.58 | 3.24 | 2024-06-11 | 4 | 41.57 | 1 | 129.58 | 28 | SO65238 | 2024-06-18 | 10.37 | 166.29 | 32.39 | |||
| SO46997_4 | 9714-4035-90 | PO11020181604 | 19 | 284 | 339 | 336 | 6 | 2022-11-23 | 469.79 | 11.74 | 2022-11-11 | 1 | 486.71 | 1 | 469.79 | 4 | SO46997 | 2022-11-18 | 37.58 | 486.71 | 469.79 | |||
| SO63128_11 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 570 | 64 | 6 | 2024-05-25 | 445.41 | 11.14 | 2024-05-13 | 1 | 461.44 | 1 | 445.41 | 11 | SO63128 | 2024-05-20 | 35.63 | 461.44 | 445.41 | |||
| SO46940_26 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 216 | 479 | 6 | 2022-11-23 | 40.37 | 1.01 | 2022-11-11 | 2 | 13.88 | 1 | 40.37 | 26 | SO46940 | 2022-11-18 | 3.23 | 27.76 | 20.19 | |||
| SO46959_39 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 213 | 533 | 6 | 2022-11-23 | 60.56 | 1.51 | 2022-11-11 | 3 | 13.88 | 1 | 60.56 | 39 | SO46959 | 2022-11-18 | 4.84 | 41.63 | 20.19 | |||
| SO50295_19 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 420 | 352 | 6 | 2023-08-23 | 141.62 | 3.54 | 2023-08-11 | 1 | 104.80 | 1 | 141.62 | 19 | SO50295 | 2023-08-18 | 11.33 | 104.80 | 141.62 |
Generated 2024-11-10 23:57:37.633 UTC