[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 500 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45309_12 | 4B9D-4285-B7 | PO10121162847 | 100 | 281 | 316 | 684 | 2 | 2022-05-25 | 874.79 | 21.87 | 2022-05-13 | 1 | 884.71 | 1 | 874.79 | 12 | SO45309 | 2022-05-20 | 69.98 | 884.71 | 874.79 |
SO46036_9 | DBE7-4B0A-93 | PO18386134137 | 100 | 281 | 310 | 558 | 2 | 2022-08-22 | 2146.96 | 53.67 | 2022-08-10 | 1 | 2171.29 | 1 | 2146.96 | 9 | SO46036 | 2022-08-17 | 171.76 | 2171.29 | 2146.96 |
SO44797_14 | 4297-4DF9-A8 | PO9483142524 | 100 | 281 | 235 | 54 | 2 | 2022-03-24 | 115.36 | 2.88 | 2022-03-12 | 4 | 31.72 | 1 | 115.36 | 14 | SO44797 | 2022-03-19 | 9.23 | 126.90 | 28.84 |
SO49479_21 | 12BA-4BD1-BB | PO11455112131 | 100 | 283 | 331 | 72 | 2 | 2023-06-22 | 2348.97 | 58.72 | 2023-06-10 | 5 | 486.71 | 1 | 2348.97 | 21 | SO49479 | 2023-06-17 | 187.92 | 2433.53 | 469.79 |
SO44797_7 | 4297-4DF9-A8 | PO9483142524 | 100 | 281 | 338 | 54 | 2 | 2022-03-24 | 419.46 | 10.49 | 2022-03-12 | 1 | 413.15 | 1 | 419.46 | 7 | SO44797 | 2022-03-19 | 33.56 | 413.15 | 419.46 |
SO57076_2 | 4D9A-45E4-88 | PO10121190262 | 100 | 283 | 378 | 684 | 2 | 2024-02-22 | 2932.02 | 73.30 | 2024-02-10 | 2 | 1554.95 | 1 | 2932.02 | 2 | SO57076 | 2024-02-17 | 234.56 | 3109.90 | 1466.01 |
SO43673_5 | 260F-4DCF-A1 | PO13775141242 | 100 | 281 | 326 | 618 | 2 | 2021-10-22 | 419.46 | 10.49 | 2021-10-10 | 1 | 413.15 | 1 | 419.46 | 5 | SO43673 | 2021-10-17 | 33.56 | 413.15 | 419.46 |
SO67284_8 | 8286-4B8D-89 | PO11484111023 | 100 | 283 | 525 | 594 | 2 | 2024-07-23 | 158.43 | 3.96 | 2024-07-11 | 1 | 144.59 | 1 | 158.43 | 8 | SO67284 | 2024-07-18 | 12.67 | 144.59 | 158.43 |
SO47730_10 | 4D13-42BB-90 | PO10092115748 | 100 | 272 | 470 | 252 | 2 | 2023-01-22 | 136.76 | 3.42 | 2023-01-10 | 6 | 15.67 | 1 | 136.76 | 10 | SO47730 | 2023-01-17 | 10.94 | 94.03 | 22.79 |
SO46385_29 | F727-48F0-AF | PO9483110086 | 100 | 281 | 235 | 54 | 2 | 2022-09-22 | 57.68 | 1.44 | 2022-09-10 | 2 | 31.72 | 1 | 57.68 | 29 | SO46385 | 2022-09-17 | 4.61 | 63.45 | 28.84 |
SO46994_20 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 397 | 396 | 2 | 2022-11-22 | 97.18 | 2.43 | 2022-11-10 | 4 | 17.98 | 1 | 97.18 | 20 | SO46994 | 2022-11-17 | 7.77 | 71.91 | 24.29 |
SO49084_3 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 469 | 667 | 2 | 2023-05-25 | 136.76 | 3.42 | 2023-05-13 | 6 | 15.67 | 1 | 136.76 | 3 | SO49084 | 2023-05-20 | 10.94 | 94.03 | 22.79 |
SO71949_8 | D52C-4E65-AA | PO9483195097 | 100 | 283 | 546 | 54 | 2 | 2024-09-22 | 111.76 | 2.79 | 2024-09-10 | 3 | 27.57 | 1 | 111.76 | 8 | SO71949 | 2024-09-17 | 8.94 | 82.70 | 37.25 |
SO55301_5 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 353 | 414 | 2 | 2024-01-22 | 8351.96 | 208.80 | 2024-01-10 | 6 | 1265.62 | 1 | 8351.96 | 5 | SO55301 | 2024-01-17 | 668.16 | 7593.72 | 1391.99 |
SO44293_16 | A1AE-48E7-A4 | PO13775127212 | 100 | 281 | 322 | 618 | 2 | 2022-01-22 | 838.92 | 20.97 | 2022-01-10 | 2 | 413.15 | 1 | 838.92 | 16 | SO44293 | 2022-01-17 | 67.11 | 826.29 | 419.46 |
SO47050_4 | 8424-417D-8D | PO6670168837 | 100 | 281 | 403 | 432 | 2 | 2022-11-22 | 24.29 | 0.61 | 2022-11-10 | 1 | 17.98 | 1 | 24.29 | 4 | SO47050 | 2022-11-17 | 1.94 | 17.98 | 24.29 |
SO69442_39 | 9833-459C-A2 | PO11658194725 | 100 | 283 | 525 | 233 | 2 | 2024-08-22 | 316.86 | 7.92 | 2024-08-10 | 2 | 144.59 | 1 | 316.86 | 39 | SO69442 | 2024-08-17 | 25.35 | 289.19 | 158.43 |
SO71894_15 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 214 | 539 | 2 | 2024-09-22 | 104.97 | 2.62 | 2024-09-10 | 5 | 13.09 | 1 | 104.97 | 15 | SO71894 | 2024-09-17 | 8.40 | 65.43 | 20.99 |
SO48392_4 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 273 | 54 | 2 | 2023-03-24 | 607.00 | 15.17 | 2023-03-12 | 3 | 187.16 | 1 | 607.00 | 4 | SO48392 | 2023-03-19 | 48.56 | 561.47 | 202.33 |
SO49113_21 | 4C8B-47E0-A7 | PO11658167469 | 100 | 283 | 428 | 233 | 2 | 2023-05-25 | 209.26 | 5.23 | 2023-05-13 | 1 | 185.82 | 1 | 209.26 | 21 | SO49113 | 2023-05-20 | 16.74 | 185.82 | 209.26 |
SO46666_10 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 286 | 234 | 2 | 2022-10-22 | 919.69 | 22.99 | 2022-10-10 | 5 | 170.14 | 1 | 919.69 | 10 | SO46666 | 2022-10-17 | 73.58 | 850.71 | 183.94 |
SO45309_1 | 4B9D-4285-B7 | PO10121162847 | 100 | 281 | 326 | 684 | 2 | 2022-05-25 | 838.92 | 20.97 | 2022-05-13 | 2 | 413.15 | 1 | 838.92 | 1 | SO45309 | 2022-05-20 | 67.11 | 826.29 | 419.46 |
SO51101_13 | 5853-46B4-AC | PO13775166153 | 100 | 283 | 374 | 618 | 2 | 2023-10-22 | 4398.03 | 109.95 | 2023-10-10 | 3 | 1554.95 | 1 | 4398.03 | 13 | SO51101 | 2023-10-17 | 351.84 | 4664.84 | 1466.01 |
SO47685_28 | CC2F-4D47-8C | PO11484129630 | 100 | 281 | 401 | 594 | 2 | 2023-01-22 | 459.21 | 11.48 | 2023-01-10 | 7 | 48.55 | 1 | 459.21 | 28 | SO47685 | 2023-01-17 | 36.74 | 339.82 | 65.60 |
SO67284_29 | 8286-4B8D-89 | PO11484111023 | 100 | 283 | 511 | 594 | 2 | 2024-07-23 | 1966.09 | 49.15 | 2024-07-11 | 9 | 199.38 | 1 | 1966.09 | 29 | SO67284 | 2024-07-18 | 157.29 | 1794.38 | 218.45 |
SO46633_7 | D8C9-4AB8-A4 | PO11484122930 | 100 | 281 | 354 | 594 | 2 | 2022-10-22 | 1242.85 | 31.07 | 2022-10-10 | 1 | 1117.86 | 1 | 1242.85 | 7 | SO46633 | 2022-10-17 | 99.43 | 1117.86 | 1242.85 |
SO71949_22 | D52C-4E65-AA | PO9483195097 | 100 | 283 | 488 | 54 | 2 | 2024-09-22 | 226.76 | 5.67 | 2024-09-10 | 7 | 41.57 | 1 | 226.76 | 22 | SO71949 | 2024-09-17 | 18.14 | 291.01 | 32.39 |
SO49825_14 | 2F7E-448D-B9 | PO17197161242 | 100 | 283 | 352 | 125 | 2 | 2023-07-23 | 2485.70 | 62.14 | 2023-07-11 | 2 | 1117.86 | 1 | 2485.70 | 14 | SO49825 | 2023-07-18 | 198.86 | 2235.71 | 1242.85 |
SO59075_33 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 490 | 179 | 2 | 2024-03-23 | 226.76 | 5.67 | 2024-03-11 | 7 | 41.57 | 1 | 226.76 | 33 | SO59075 | 2024-03-18 | 18.14 | 291.01 | 32.39 |
SO51112_6 | 6C36-4086-8D | PO11687117332 | 100 | 283 | 493 | 691 | 2 | 2023-10-22 | 400.10 | 10.00 | 2023-10-10 | 2 | 199.85 | 1 | 400.10 | 6 | SO51112 | 2023-10-17 | 32.01 | 399.70 | 200.05 |
Generated 2024-11-10 02:57:20.146 UTC