[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 170 > < TAKE 30 >
30 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO45556_13 | A9AB-44F3-9F | PO3190111178 | 100 | 281 | 322 | 575 | 2 | 2022-06-27 | 2097.29 | 52.43 | 2022-06-15 | 5 | 413.15 | 1 | 2097.29 | 13 | SO45556 | 2022-06-22 | 167.78 | 2065.73 | 419.46 | |||
| SO58950_24 | E67E-435E-9F | PO11455199372 | 100 | 283 | 390 | 72 | 2 | 2024-03-28 | 4706.06 | 117.65 | 2024-03-16 | 7 | 713.08 | 1 | 4706.06 | 24 | SO58950 | 2024-03-23 | 376.48 | 4991.56 | 672.29 | |||
| SO44311_1 | 1B1A-46AE-93 | PO4959115826 | 100 | 281 | 315 | 269 | 2 | 2022-01-27 | 1749.59 | 43.74 | 2022-01-15 | 2 | 884.71 | 1 | 1749.59 | 1 | SO44311 | 2022-01-22 | 139.97 | 1769.42 | 874.79 | |||
| SO46666_47 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 453 | 234 | 2 | 2022-10-27 | 35.99 | 0.90 | 2022-10-15 | 1 | 24.75 | 1 | 35.99 | 47 | SO46666 | 2022-10-22 | 2.88 | 24.75 | 35.99 | |||
| SO69440_2 | E124-4B73-BF | PO11629191677 | 100 | 283 | 588 | 396 | 2 | 2024-08-27 | 461.69 | 11.54 | 2024-08-15 | 1 | 419.78 | 1 | 461.69 | 2 | SO69440 | 2024-08-22 | 36.94 | 419.78 | 461.69 | |||
| SO47395_62 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 273 | 72 | 2 | 2022-12-28 | 1011.66 | 25.29 | 2022-12-16 | 5 | 187.16 | 1 | 1011.66 | 62 | SO47395 | 2022-12-23 | 80.93 | 935.79 | 202.33 | |||
| SO59074_28 | 1711-471C-82 | PO9483120932 | 100 | 283 | 472 | 54 | 2 | 2024-03-28 | 152.40 | 3.81 | 2024-03-16 | 4 | 23.75 | 1 | 152.40 | 28 | SO59074 | 2024-03-23 | 12.19 | 95.00 | 38.10 | |||
| SO48739_6 | D31C-4E9E-A0 | PO10092156492 | 100 | 283 | 470 | 252 | 2 | 2023-04-29 | 113.97 | 2.85 | 2023-04-17 | 5 | 15.67 | 1 | 113.97 | 6 | SO48739 | 2023-04-24 | 9.12 | 78.35 | 22.79 | |||
| SO47001_27 | DD9D-4987-9E | PO10121150577 | 100 | 281 | 373 | 684 | 2 | 2022-11-27 | 6544.69 | 163.62 | 2022-11-15 | 5 | 1320.68 | 1 | 6544.69 | 27 | SO47001 | 2022-11-22 | 523.58 | 6603.42 | 1308.94 | |||
| SO48034_7 | 995F-4D9D-A9 | PO1769135453 | 100 | 281 | 329 | 540 | 2 | 2023-02-27 | 1409.38 | 35.23 | 2023-02-15 | 3 | 486.71 | 1 | 1409.38 | 7 | SO48034 | 2023-02-22 | 112.75 | 1460.12 | 469.79 | |||
| SO59012_51 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 585 | 539 | 2 | 2024-03-28 | 1336.23 | 33.41 | 2024-03-16 | 3 | 461.44 | 1 | 1336.23 | 51 | SO59012 | 2024-03-23 | 106.90 | 1384.33 | 445.41 | |||
| SO49084_4 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 420 | 667 | 2 | 2023-05-30 | 424.85 | 10.62 | 2023-05-18 | 3 | 104.80 | 1 | 424.85 | 4 | SO49084 | 2023-05-25 | 33.99 | 314.39 | 141.62 | |||
| SO44800_6 | 3119-4CF3-BF | PO9019144492 | 100 | 281 | 351 | 576 | 2 | 2022-03-29 | 4049.99 | 101.25 | 2022-03-17 | 2 | 1898.09 | 1 | 4049.99 | 6 | SO44800 | 2022-03-24 | 324.00 | 3796.19 | 2024.99 | |||
| SO48336_53 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 224 | 2 | 72 | 2 | 1.20 | 2023-03-29 | 60.16 | 1.47 | 2023-03-17 | 12 | 5.23 | 1 | 58.96 | 53 | SO48336 | 2023-03-24 | 4.72 | 62.76 | 5.01 | 0.02 |
| SO49115_15 | 4A55-4351-88 | PO3625184218 | 100 | 283 | 369 | 666 | 2 | 2023-05-30 | 4398.03 | 109.95 | 2023-05-18 | 3 | 1518.79 | 1 | 4398.03 | 15 | SO49115 | 2023-05-25 | 351.84 | 4556.36 | 1466.01 | |||
| SO43878_2 | FC28-4F00-A9 | PO11716136854 | 100 | 281 | 344 | 144 | 2 | 2021-11-27 | 2039.99 | 51.00 | 2021-11-15 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO43878 | 2021-11-22 | 163.20 | 1912.15 | 2039.99 | |||
| SO48017_39 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 221 | 2 | 233 | 2 | 4.68 | 2023-02-27 | 234.16 | 5.74 | 2023-02-15 | 12 | 13.88 | 1 | 229.48 | 39 | SO48017 | 2023-02-22 | 18.36 | 166.54 | 19.51 | 0.02 |
| SO46620_7 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 415 | 618 | 2 | 2022-10-27 | 792.14 | 19.80 | 2022-10-15 | 4 | 146.55 | 1 | 792.14 | 7 | SO46620 | 2022-10-22 | 63.37 | 586.19 | 198.04 | |||
| SO46385_19 | F727-48F0-AF | PO9483110086 | 100 | 281 | 332 | 54 | 2 | 2022-09-27 | 2936.21 | 73.41 | 2022-09-15 | 7 | 413.15 | 1 | 2936.21 | 19 | SO46385 | 2022-09-22 | 234.90 | 2892.02 | 419.46 | |||
| SO48751_2 | 1B86-4985-89 | PO13775132235 | 100 | 283 | 331 | 618 | 2 | 2023-04-29 | 1409.38 | 35.23 | 2023-04-17 | 3 | 486.71 | 1 | 1409.38 | 2 | SO48751 | 2023-04-24 | 112.75 | 1460.12 | 469.79 | |||
| SO51778_10 | 420A-4268-A8 | PO3161175221 | 100 | 283 | 490 | 359 | 2 | 2023-11-27 | 161.97 | 4.05 | 2023-11-15 | 5 | 41.57 | 1 | 161.97 | 10 | SO51778 | 2023-11-22 | 12.96 | 207.86 | 32.39 | |||
| SO61192_1 | 238B-4E39-8F | PO10092119585 | 100 | 283 | 357 | 252 | 2 | 2024-04-28 | 2783.99 | 69.60 | 2024-04-16 | 2 | 1265.62 | 1 | 2783.99 | 1 | SO61192 | 2024-04-23 | 222.72 | 2531.24 | 1391.99 | |||
| SO50259_10 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 460 | 558 | 2 | 2023-08-27 | 323.96 | 8.10 | 2023-08-15 | 6 | 37.12 | 1 | 323.96 | 10 | SO50259 | 2023-08-22 | 25.92 | 222.73 | 53.99 | |||
| SO47055_31 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 331 | 108 | 2 | 2022-11-27 | 939.59 | 23.49 | 2022-11-15 | 2 | 486.71 | 1 | 939.59 | 31 | SO47055 | 2022-11-22 | 75.17 | 973.41 | 469.79 | |||
| SO46368_23 | BF32-47A9-90 | PO4408111909 | 100 | 281 | 334 | 143 | 2 | 2022-09-27 | 838.92 | 20.97 | 2022-09-15 | 2 | 413.15 | 1 | 838.92 | 23 | SO46368 | 2022-09-22 | 67.11 | 826.29 | 419.46 | |||
| SO53537_7 | C14C-4596-A3 | PO19894159880 | 100 | 283 | 505 | 557 | 2 | 2023-12-28 | 600.16 | 15.00 | 2023-12-16 | 3 | 199.85 | 1 | 600.16 | 7 | SO53537 | 2023-12-23 | 48.01 | 599.56 | 200.05 | |||
| SO47025_1 | 9A7F-452C-83 | PO3625180823 | 100 | 281 | 257 | 666 | 2 | 2022-11-27 | 551.81 | 13.80 | 2022-11-15 | 3 | 170.14 | 1 | 551.81 | 1 | SO47025 | 2022-11-22 | 44.15 | 510.43 | 183.94 | |||
| SO59075_40 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 574 | 179 | 2 | 2024-03-28 | 1430.44 | 35.76 | 2024-03-16 | 1 | 1481.94 | 1 | 1430.44 | 40 | SO59075 | 2024-03-23 | 114.44 | 1481.94 | 1430.44 | |||
| SO61239_21 | 6459-4F99-96 | PO3828136274 | 100 | 283 | 527 | 414 | 2 | 2024-04-28 | 316.86 | 7.92 | 2024-04-16 | 2 | 144.59 | 1 | 316.86 | 21 | SO61239 | 2024-04-23 | 25.35 | 289.19 | 158.43 | |||
| SO47395_53 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 466 | 72 | 2 | 2022-12-28 | 56.52 | 1.41 | 2022-12-16 | 4 | 9.71 | 1 | 56.52 | 53 | SO47395 | 2022-12-23 | 4.52 | 38.85 | 14.13 |
Generated 2024-11-15 02:26:16.599 UTC