[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 235 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47398_17 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 339 | 461 | 6 | 2022-11-02 | 469.79 | 11.74 | 2022-10-21 | 1 | 486.71 | 1 | 469.79 | 17 | SO47398 | 2022-10-28 | 37.58 | 486.71 | 469.79 | |||
SO46360_1 | 00EC-47DF-BB | PO1885143134 | 19 | 284 | 348 | 7 | 588 | 6 | 885.93 | 2022-08-02 | 2531.24 | 41.13 | 2022-07-21 | 3 | 1898.09 | 1 | 1645.31 | 1 | SO46360 | 2022-07-28 | 131.62 | 5694.28 | 843.75 | 0.35 |
SO47366_15 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 323 | 155 | 6 | 2022-11-02 | 2348.97 | 58.72 | 2022-10-21 | 5 | 486.71 | 1 | 2348.97 | 15 | SO47366 | 2022-10-28 | 187.92 | 2433.53 | 469.79 | |||
SO61250_2 | 4A96-481D-A3 | PO4930183869 | 19 | 291 | 476 | 425 | 6 | 2024-03-03 | 83.99 | 2.10 | 2024-02-20 | 2 | 26.18 | 1 | 83.99 | 2 | SO61250 | 2024-02-27 | 6.72 | 52.35 | 41.99 | |||
SO47967_21 | DA42-41A7-BD | PO19198173391 | 19 | 291 | 367 | 653 | 6 | 2023-01-02 | 647.99 | 16.20 | 2022-12-21 | 1 | 598.44 | 1 | 647.99 | 21 | SO47967 | 2022-12-28 | 51.84 | 598.44 | 647.99 | |||
SO55245_9 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 463 | 514 | 6 | 2023-12-02 | 14.69 | 0.37 | 2023-11-20 | 1 | 9.16 | 1 | 14.69 | 9 | SO55245 | 2023-11-27 | 1.18 | 9.16 | 14.69 | |||
SO57120_38 | 058D-436F-BF | PO4466170177 | 19 | 291 | 474 | 352 | 6 | 2024-01-02 | 293.96 | 7.35 | 2023-12-21 | 7 | 26.18 | 1 | 293.96 | 38 | SO57120 | 2023-12-28 | 23.52 | 183.23 | 41.99 | |||
SO58958_33 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 568 | 281 | 6 | 2024-02-01 | 4454.10 | 111.35 | 2024-01-20 | 10 | 461.44 | 1 | 4454.10 | 33 | SO58958 | 2024-01-27 | 356.33 | 4614.45 | 445.41 | |||
SO50716_13 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 352 | 118 | 6 | 2023-08-02 | 3728.56 | 93.21 | 2023-07-21 | 3 | 1117.86 | 1 | 3728.56 | 13 | SO50716 | 2023-07-28 | 298.28 | 3353.57 | 1242.85 | |||
SO48033_24 | BC9E-4246-AC | PO1595118269 | 19 | 284 | 456 | 2 | 426 | 6 | 10.44 | 2023-01-02 | 521.93 | 12.79 | 2022-12-21 | 12 | 30.93 | 1 | 511.49 | 24 | SO48033 | 2022-12-28 | 40.92 | 371.20 | 43.49 | 0.02 |
SO58930_29 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 595 | 497 | 6 | 2024-02-01 | 338.99 | 8.47 | 2024-01-20 | 1 | 308.22 | 1 | 338.99 | 29 | SO58930 | 2024-01-27 | 27.12 | 308.22 | 338.99 | |||
SO69401_22 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 491 | 3 | 12 | 6 | 23.76 | 2024-07-02 | 475.11 | 11.28 | 2024-06-20 | 16 | 41.57 | 1 | 451.36 | 22 | SO69401 | 2024-06-27 | 36.11 | 665.16 | 29.69 | 0.05 |
SO51791_14 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 388 | 552 | 6 | 2023-10-02 | 672.29 | 16.81 | 2023-09-20 | 1 | 713.08 | 1 | 672.29 | 14 | SO51791 | 2023-09-27 | 53.78 | 713.08 | 672.29 | |||
SO49055_1 | 1FED-4D8E-86 | PO14819164751 | 19 | 284 | 468 | 462 | 6 | 2023-04-04 | 22.79 | 0.57 | 2023-03-23 | 1 | 15.67 | 1 | 22.79 | 1 | SO49055 | 2023-03-30 | 1.82 | 15.67 | 22.79 | |||
SO50265_41 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 335 | 479 | 6 | 2023-07-02 | 939.59 | 23.49 | 2023-06-20 | 2 | 486.71 | 1 | 939.59 | 41 | SO50265 | 2023-06-27 | 75.17 | 973.41 | 469.79 | |||
SO43662_12 | 2E53-4802-85 | PO18444174044 | 19 | 288 | 275 | 227 | 6 | 2021-09-01 | 356.90 | 8.92 | 2021-08-20 | 1 | 352.14 | 1 | 356.90 | 12 | SO43662 | 2021-08-27 | 28.55 | 352.14 | 356.90 | |||
SO44535_10 | 26EF-4A69-B0 | PO2088169831 | 19 | 288 | 316 | 136 | 6 | 2022-01-02 | 1749.59 | 43.74 | 2021-12-21 | 2 | 884.71 | 1 | 1749.59 | 10 | SO44535 | 2021-12-28 | 139.97 | 1769.42 | 874.79 | |||
SO57082_11 | F79A-40C3-B7 | PO1595152621 | 19 | 284 | 606 | 426 | 6 | 2024-01-02 | 647.99 | 16.20 | 2023-12-21 | 2 | 343.65 | 1 | 647.99 | 11 | SO57082 | 2023-12-28 | 51.84 | 687.30 | 323.99 | |||
SO53545_13 | 2CC7-4F36-B6 | PO14239178578 | 19 | 291 | 225 | 550 | 6 | 2023-11-02 | 21.58 | 0.54 | 2023-10-21 | 4 | 6.92 | 1 | 21.58 | 13 | SO53545 | 2023-10-28 | 1.73 | 27.69 | 5.39 | |||
SO51160_45 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 463 | 496 | 6 | 2023-09-01 | 102.86 | 2.57 | 2023-08-20 | 7 | 9.16 | 1 | 102.86 | 45 | SO51160 | 2023-08-27 | 8.23 | 64.12 | 14.69 | |||
SO51703_6 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 580 | 12 | 6 | 2023-10-02 | 10205.94 | 255.15 | 2023-09-20 | 10 | 1082.51 | 1 | 10205.94 | 6 | SO51703 | 2023-09-27 | 816.48 | 10825.10 | 1020.59 | |||
SO47037_39 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 280 | 84 | 6 | 2022-10-02 | 735.75 | 18.39 | 2022-09-20 | 4 | 170.14 | 1 | 735.75 | 39 | SO47037 | 2022-09-27 | 58.86 | 680.57 | 183.94 | |||
SO51132_1 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 418 | 227 | 6 | 2023-09-01 | 713.80 | 17.84 | 2023-08-20 | 2 | 360.94 | 1 | 713.80 | 1 | SO51132 | 2023-08-27 | 57.10 | 721.89 | 356.90 | |||
SO63136_8 | 0873-484A-AE | PO18328125904 | 19 | 284 | 477 | 552 | 6 | 2024-04-03 | 11.98 | 0.30 | 2024-03-22 | 4 | 1.87 | 1 | 11.98 | 8 | SO63136 | 2024-03-29 | 0.96 | 7.47 | 2.99 | |||
SO47668_40 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 456 | 299 | 6 | 2022-12-02 | 269.96 | 6.75 | 2022-11-20 | 6 | 30.93 | 1 | 269.96 | 40 | SO47668 | 2022-11-27 | 21.60 | 185.60 | 44.99 | |||
SO65243_10 | F88F-4FB2-85 | PO11194174051 | 19 | 284 | 493 | 48 | 6 | 2024-05-02 | 400.10 | 10.00 | 2024-04-20 | 2 | 199.85 | 1 | 400.10 | 10 | SO65243 | 2024-04-27 | 32.01 | 399.70 | 200.05 | |||
SO63141_14 | 96AB-479F-86 | PO17603143134 | 19 | 284 | 488 | 12 | 6 | 2024-04-03 | 194.36 | 4.86 | 2024-03-22 | 6 | 41.57 | 1 | 194.36 | 14 | SO63141 | 2024-03-29 | 15.55 | 249.43 | 32.39 | |||
SO46351_3 | 9218-4521-8F | PO11107115959 | 19 | 284 | 324 | 156 | 6 | 2022-08-02 | 838.92 | 20.97 | 2022-07-21 | 2 | 413.15 | 1 | 838.92 | 3 | SO46351 | 2022-07-28 | 67.11 | 826.29 | 419.46 |
Generated 2024-09-20 02:46:16.779 UTC